Import Patient Data from Office Ally

sdjustinj wrote on Saturday, August 27, 2016:

I have all of my client demographic info and I would like to import it. I see the new docuements section but I need to know the mapping of the .CVS file headers sot that open emr will know where to import them. It uploads the file but in the Approve import section nothing is listed. Can someone shead some light on this? Thanks.

cverk wrote on Tuesday, August 30, 2016:

When I went through that a few years back we put a few patients into a fresh install of OpenEmr manually and then downloaded a CSV file from phpmyadmin to look at the order of the data, using a spreadsheet to move the outside data files into that order. Then you can use phpmyadmin to import the whole file all at once.

sdjustinj wrote on Tuesday, August 30, 2016:

I did that several times all of my headers are right but they are not propogating in the program for some reson. I am importing into patient_data in the SQL database I also included things that are NULL and it wont go. I am at a loss here. :frowning:

cverk wrote on Wednesday, August 31, 2016:

I’m not one of the programmer guys, but you could maybe try running the mysql_upgrade.php file from localhost to see if it will find them. Also helpful sometimes is to stop and restart apache and mysql.