maniemoore wrote on Tuesday, January 25, 2011:
Dear house,
am currently running a new openemr 3.2 on centos 5.5. I need to know if it’s possible to upload old patients(up to 5,000 patients name and contact) data on excel sheet.
Manuel
juggernautsei wrote on Wednesday, January 26, 2011:
Manuel,
It would be difficult to use an excel spread sheet. The better way to do it is to create an SQL statement and then use the phpmyadmin to import your patients into the OpenEMR database.
Are you familiar with SQL statements?
Sherwin
www.openmedpractice.com
maniemoore wrote on Wednesday, January 26, 2011:
Am a newbie trying to work things around. Could you pls tell me the statements to use in order to do this.
Thanks
juggernautsei wrote on Wednesday, January 26, 2011:
Manuel,
You will need to construct an INSERT into statement. Here is a web site that can teach you how to construct such a statement.
http://www.1keydata.com/sql/sqlinsert.html
You will need to convert the excel file to a CVS file first then insert the sql to the file.
If you are still struggling contact me off the board a sgaddis(@)jse.net.
Sherwin
www.openmedpractice.com