Hi to all.
First a brief background, I am an MD, ENT Specialist, who happens to administer his own Linux Network and have some experience with MySQL and database management. I received a database dump from my previous vendor, Medios, a company based in Miami, Fl. which is no longer going to provide services as of September this year, so I decided to migrate to OpenEMR.
So far, I have been able to successfully migrate the Demographic data, and it is working well on OpenEMR. The company provided me with .xlsx files and a ccda zip file. One of the files contains all the .pdf files which are the ones which are of interest to me. The structure includes the “id” which could imported into the “pubpid” field, fname , lname , DOB, a text description of the .pdf file and the pdf files themselves.
Here is a sample. The demographic is in another .xlxs file.
id lname fname DOB description file
2222 Doe John 2021-01-01 office visit 0001.pdf
in this case “id” would be the “pubpid”, I think.
Is it possible to incorporate this data? and if so, ideas?
My data consists of some 34000 plus records, so manual entry
would of out the question.
I noticed the the Documents table has a field named “url” which points to the location for the pdf files so I would think the actual files go into that directory and the other data into the base table.
It also seems that when you upload a pdf file into the system, it gets encrypted and placed in that directory.
Many thanks in advance.