aperezcrespo wrote on Sunday, March 04, 2007:
Hi
Does anyone have a listing with descriptions of all the tables and fields/rows used in OEMR? I have a request for migrating a mess load of data from a MSaccess database to OpenEMR. The client would like it if they didn’t have to manually reenter each patient name, address etc all over again.
Thanks
Alfonso
okhra wrote on Sunday, March 04, 2007:
If you have access to openemr, use mysql client to login to your mysql server, and select ‘openemr’ as the database,then execute the commands : show tables; show columns for <table-name>;…
- okhra
andres_paglayan wrote on Sunday, March 04, 2007:
A good way is to install phpmyadmin or use the built in phpmyadmin in admistration -> database,
most fields are self descriptive, then map the old app to openemr,
aperezcrespo wrote on Monday, March 05, 2007:
Ok
Now for the silly questions…
Their data has lots of old billed encounters. The MSAccess app only allowed them to enter just enough patient info to bill (Yes it is a simple medical billing app). The client would like to know if all this info could be migrated and transfered into SQL-Ledger?
sunsetsystems wrote on Monday, March 05, 2007:
I expect so, but somebody would have to do some programming. It would be pretty easy if you can export the data to some simple text-only format (CSV or whatever).
andres_paglayan wrote on Monday, March 05, 2007:
I think you need to do some planning first,
like lay flat all the info in both sides,
a data mapping reference,
such as
old app openemr
client.id --> patients.pid
and so on for each field in the old app,
then check wich ones are left blank in openemr and sql-ledger
and whether or not that miss can break data or not,