How do I import lab data into OSCAR EMR

Posted on 2011-10-09
Medium Priority
Last Modified: 2012-05-12
I have installed Oscar EMR  (elctronic medical record) for my patients. It is an open source software. I could not find a way to import lab (patient blood work) data into the my database directly from the lab.
Question by:khalidsuhail

Expert Comment

ID: 36939013

maybe you should explain it more clearer... how do you want it to be achieve?
will be doing a program to serve as a middle ware?

or you just want single set from export to import to the new system?
if so yes... then what is the database of "lab system"?

you can simply do clone all the data types and tables names...

or what do you really want to achieve :)?
LVL 24

Accepted Solution

johanntagle earned 2000 total points
ID: 36941679
Based on your chosen zones I guess your lab data is in filemaker pro and the Oscar EMR uses MySQL?  You will need to study the Oscar EMR schema, then determine how your lab data maps out to it.  It's very possible the data will have to be mapped out to multiple tables.  If so you will need to create a script for this.  But if you are lucky enough that it only maps to one table in MySQL, then export the Filemaker data to a delimited file (preferably tab delimited) then use mysqlimport or load data infile.  See http://www.thegeekstuff.com/2008/10/import-and-upload-data-to-mysql-tables-using-mysqlimport/, among other pages on the web.

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month13 days, 9 hours left to enroll

750 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question