in which mysql table are the patient medical data stored? How can I import preexisting patient data?

Tags: #<Tag:0x00007f5ff87d2800> #<Tag:0x00007f5ff87d26c0> #<Tag:0x00007f5ff87d25f8>

Hello Community! I want to implement OpenMRS for a small private doctor’s office and I have to import the existing patient data in the mysql database. Therefore I wanted to take a look at the patient tables. I can see the patients I have created, but I cant find the medical information I have inputted. Can someone tell me in which table this information is located?

And is there a simple way to import existing data into OpenMRS? The data I have has specialized medical findings I have to apply to OpenMRS as well.

Any help would be highly appreciated!

Did you get a chance to look at this? Data Model - Documentation - OpenMRS Wiki

And this? Encounters and observations - Documentation - OpenMRS Wiki

Concept Dictionary Basics - Documentation - OpenMRS Wiki

1 Like

Thank you! That is exactly what I was looking for! Is there a guide to import foreign patient data into OpenMRS as well?

Is this of help? Spreadsheet Import Module - Documentation - OpenMRS Wiki

I think it is of sort what I am looking for, but is there a version of this module which is compatible with newer versions of OpenMRS? Or is it best just to use OpenMRS versions 1.9 or lower if I want to import patient data?

Better to upgrade that module to support the latest release of the platform.