How to import Bulk Data into open emr, via JSON or CSV files

Management and Administration
,
1

Hi,
We are using openEMR platform, and currently we are looking for adding bulk patient information into openEMR. We found the details only for adding single patient record, It would be great if someone suggest us a way to import bulk data into openEMR using JSON or CSV format.

2

@InfraPradeep

Currently the feature is not available in OpenEMR. If you have data in csv or excel file, you can write an script to extract the details from the file and make an corresponding insert to the tables. We suggest that script will make your work simpler.

Thanks,
ViSolve

3

Thanks for your quick response. we will try that solution and get back here if we run into any issues.

Thanks,
Pradeep.S

4

I have written several scripts recently that import patient data from a .csv file. If you are still having issues, I can offer my services to you.

5

Thanks Daniel, for your help. I was able to generate the file and am able to add data. Thanks everyone for your help.

2 Likes
6

Dear all,
I also have a csv of patient demographic file that I would like to use to import bulk patients. My concern is the uuid in the Table: patient_data. If I manually add a patient in phpMyAdmin it does not generate uuid and if I manually add a uuid it does not have a hyperlink.

Appreciate any help.

Version Number: v6.0.0

7

You would need someone to write an import script for you. I can do that. Feel free to PM me and we can discuss compensation since it will take between 4 - 6 hours of writing the script and testing it.

8

I found the script example_patient_data.sql that did what I am looking to do but non of the patients has uuid, what is this column is used for?

Best

9

After you import your patients via csv or whatever mechanism. Run sql_upgrade.php just as if you have done an upgrade. It will go through and create those UUIDs.

Or just ignore that field as it is used mostly for APIs and will be created if the UUID is needed when used.

2 Likes
10

Greetings @InfraPradeep, my name is Peter and i have also been looking out for a solution to be able to “add bulk patients” to the OpenEMR. Please, can you share your solution (the script) with me?

Looking forward to hearing from you.

Best regards.
Peter

11

Greetings @InfraPradeep, my name is manohar and i have also been looking out for a solution to be able to “add bulk patients” to the OpenEMR. Please, can you share your solution (the script) with me?

Looking forward to hearing from you.

Best regards.
Manohar

12

hey Daniel can you help me for providing script

13

Greetings @InfraPradeep, my name is Sayid and we have also been looking out for a solution to be able to “add bulk patients” to the OpenEMR. We recently started using the platform. Please, can you share your solution (the script) with us? We run a very small mother child health center clinic free of charge in a small impoverished village in Africa.

Looking forward to hearing from you.

Best regards.
Peter

14

We have not come across a generic solution probably because there are multiple scenarios and formats of existing data. So if the volume is large, you end up writing a script that does data transformation and then call the standard EMR services. This is a must if your source data includes information that must be spread over several tables.

If the clinic is small, highly recommend using standard process and enter data manually when patient comes in for next visit. Apart from good practice opportunity, it improves the quality of data.

Best.