Importing demo and transaction Data

zhhealthcare wrote on Sunday, May 02, 2010:

Hi Guys
We are beginning to write a routine that will help in easy import of demo and transaction data from other databases(after they are moved to a predefined csv format).  Before we do so we were wondering if any of you have written anything of this nature yet?  Else we will be happy to write it and post here for review.

Thanks and regards
Sam

tmccormi wrote on Monday, May 03, 2010:

I have a few variants on that.  Mine uses XML as the base format.  Rod wrote the original versions that included a batch load with the ability to edit the record(s) on screen before commit, it was in 3.1 release as custom/import_medics.php  and it uses a hand rolled XML import function.   I have a newer version that is strictly batch/command line load for automated imports that uses the built in simpleXML function for parsing.   Be easy enough to convert the parser to CSV using fgetcsv().

Happy to post it on my website and let you steal code from it.  It covers demographics, history, customized encounter forms and billing data.  Let me know if you’re interested.

-Tony

bradymiller wrote on Wednesday, May 05, 2010:

Tony,

Would be great if you posted this explanation and a link to your script(s) here:
http://www.openmedsoftware.org/wiki/OpenEMR_Database_Conversion_Tools

thanks,
brady

tmccormi wrote on Wednesday, May 05, 2010:

Done.  Sadly the wiki says it will take zip files, but it really only takes PDF files … so that’s what I posted.
-Tony