nm07 wrote on Tuesday, June 11, 2013:
Hi,
I am new to OpenEmr. I am a student and I am setting up the OpenEmr Software for a Company. I have to integrate the OMOP database (http://omop.org/OSIM2 --> OSIM2_10M_MSLR_MEDDRA_2 --> 1.25 --> Any Exposure) into the OpenEmr database architecture. I do not have much experience with database. Can someone guide me through it? How I should approach this etc.
nm07 wrote on Tuesday, June 11, 2013:
Can someone please help me with this?
yehster wrote on Tuesday, June 11, 2013:
You should start by figuring out more specific goals beyond just “integrate OMOP.”
nm07 wrote on Wednesday, June 12, 2013:
Ok.
There is this EMR data set (the OMOP data set I was talking about) available online which I have to use to test the OpenEMR software.
The OMOP and OpenEMR systems have different architectures. I am not sure how to integrate this database with a different architecture into the OpenEMR database.
yehster wrote on Wednesday, June 12, 2013:
Patient information is stored in the patient_data table while drugs, allergies and other pieces of information that exists in OSIM2 might map into the lists table in OpenEMR.
If you haven’t spent any time doing manual data entry in OpenEMR, I suggest that you start there and familiarize yourself with how that works first. Determine what portions of OpenEMR correspond to the data in OSIM2 that you care about.
nm07 wrote on Wednesday, June 12, 2013:
Ok. That helps. Thanks a lot.
cverk wrote on Wednesday, June 12, 2013:
I put in some information manually as noted and then used phpmyadmin to export it as a comma seperated value file (csv). You can look at that file as text to see in what order data pieces are stored. You can then use excel to organized your outside data in the same order and export it as csv. Then use phpmyadmin to import the csv file into mysql.