Porting Data From SQL Server to Open-EMR

Management and Administration
#1

Hello everyone and thanks for your help in advance. I am a new user of Open-EMR and am want to port data out of an existing emr with a SQL Server backend. I have full access to the entire database, so extracting data is not a problem. I need to know how to import data into the Open-EMR installation. Also, since I have no experience using MySql, I wanted to now if there was some type of GUI that can be accessed to be able to view the data table structure and have a better idea of how to map the import. Any help would be appreciated.

#2

hi @hmclaughlin, sure there’s phpmyadmin (admin->other->database) inside of openemr v5.0.0, here’s a nice wiki that was added recently, https://www.open-emr.org/wiki/index.php/OpenEMR_Complete_Installation_Tutorial#10._Importing_Patient_Data_into_OpenEMRhttps://www.open-emr.org/wiki/index.php/OpenEMR_Complete_Installation_Tutorial#10._Importing_Patient_Data_into_OpenEMR thanks @vrjula

#3

Thanks for the response. If I am reading the wiki correctly, it appears that you need to create a dummy patient, then export the patient, then try to create a CSV file that matches exactly, with a lot of trial and error. However, since the MySQL database resides on the server, there must be some way to access/view the database in order to be able see the table layouts. Also, since this is an open-source project, the database schemas must be available somewhere for developers to work. Do I need to become a developer to access this?

Thanks again.

#4

@hmclaughlin, yes, the first part of my reply, not necessary to be a developer

#5

Thanks again for your response. I’ve found the phpMyAdmin portion and I see there is a navigator for all of the tables, so I’m starting to get a faint idea of what I’m doing. A couple of immediate questions come to mind. First, is there any additional documentation of how the screens relate to tables or some type of document that describes the purpose of each table. For example, where are patient vitals stored? Second, lets say I wanted to import a couple of years worth of patient vitals from another EHR. Will the date the vitals were taken be preserved (I assume there is some type of datestamp on each column). Finally, is CSV, table by table the only way to import data?

Thanks again for the help.

#6

https://www.open-emr.org/wiki/index.php/Database_Structure

yes, you are right about the timestamp

although not familiar with it believe you can use ccda to import, so if you’re other ehr can export ccda then…

#7

Thanks again for the response. Sorry again to bother, but I am not seeing a table for holding vitals, i.e. height, weight, Temperature, blood pressure, etc. What am I missing?

#8

oh sorry @hmclaughlin, assumed it was on there instead only found this

form_* - Most “encounter forms” (other EHR systems call these “templates”) implement a table whose name is “form_” followed by the name of the form.

it’s form_vitals