Hello all,
I'm helping a friend who's moving her practice in the next few weeks. I don't know exact details of AC version numbers because I'm not directly involved, retired, and just helping out if I can as the official computer expert with significant experience in programming and some database work.
Note -- when I mention "export" and "import" buttons, they are found on pages I watched her navigate to while running AC. Pages like assessment, current condition.
She is wanting to get copies of all her templates from the current AC system so they can be uploaded to the new AC system. The I'm guessing the current AC system was never configured properly because the simple "export" button only creates a file that goes to a "hard coded" location that is inaccessible. She has 942 templates, so re-entering them in the new system by hand is a near impossible task.
The contractor/tech for the currrent office did give her a file -- it is an XML file which appears to be a table dump directly out of SQL-Server, because the first part is the table schema and the remainder of the file looks like the individual rows of the table.
Problem is this XML file she was given is not the right format to use as a template import file with the "import" button. I suspect the file has the necessary data, it just needs to be reformatted. I have the template name, location, text, provider name data, date edited etc in this file.
If I had an example of a template XML file, with just two entries generated with the "export" button, I believe it would be enough to confirm this is a simple reformatting problem, or it may not be possible.
If there's anyone who'd like to generate and share that little two entry template file I'd be very appreciative. If I succeed at this I'll be happy to share my little Perl script to do the reformatting in case it may be of use for anyone else.
Thanks for any help, or tips.
Jeff