Extract data from OpenEMR

Management and Administration
#1

Hi,

Situation: I am looking for a way to extract patient data from OpenEMR.
Question: Is it possible to extract patient data using MIRTH connect?. If it is possible, then how to link MIRTH with OpenEMR?
can anyone please help.

Thank You.
Regards- Noor

#2

hi @Noor, might want to play around with the API to see if it gets you going in a good direction, Integration Engine

1 Like
#3

Thanks for the reply Stephen, Is there any way to extract the data from OpenEMR.

#4

if you follow the API guide further down you will see GET requests which will extract data

here’s a popular app that can help get you started

1 Like
#5

Thank you Stephen. I will definitely look into that.

#6

Hi Stephen, One last question. Are there any other ways other than using API.

Thank you

Regards- Noor

#7

sure, Mirth has been used for hl7 data, like this post describes

1 Like
#8

Hello Noor

You can able to extract the patient medical records using CCDA (Consolidated Clinical Document Architecture) -created by HL7 to exchange standardized data between healthcare providers.

You can also import CCDA file into openemr to load patients from other vendors.

Thank You
ViSolve-051

1 Like
#9

Hello Noor-
Of course there’s the old-fashioned method of running queries against the EMR’s MySql database.
You’ll need to install phpMyAdmin, since it doesn’t come bundled with the EMR any more, or adminer, which is simple but quite capable.
Install instructions on the relevant websites.
It will take a bit of work to find all the table JOINs necessary for complex queries but isn’t too hard if you have SQL-competent people at hand.

1 Like
#10

@Noor,
Another old fashioned way is - if you have access to the MySQL server, login to the server, run mysql application on the server and query the data base
-ViSolve001

1 Like