How do I import lab data into OSCAR EMR

Posted on 2011-10-09
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
    LVL 4

    Expert Comment


    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

    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, among other pages on the web.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (…
    Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now