I am helping impirt of data base from Medisoft to openemr. Has anyone done that? I wouls appreciate if someone who has gone through the steps help me out.
While on this, I was looking at Insurance data related tables. I am not able to find the address of insurance companies in any of the insurance related tables in the root. Where do I find them? While most of the table have the address listed under the same table like for instance paient_data why insurance_companies does not contain the address fields…Am I missing something here?
We actually just finished an import project for a client from Medisoft v14 to OpenEMR v3.1.0. The insurance data is located in the MWINS table within the Advantage Database for Medisoft. The address information for the insurance companies is located in the addresses table and the phone contact information is in the phone_numbers table within the MySQL database for OpenEMR.
For this client we imported the Patient Demographics and Insurance Information without tying the two together since they had a low budget. But it’s possible to tie all the information together upon import.
To explain how to do this is beyond email as it would probably be a whole manual. If you do not know how to navigate through the Medisoft Database and/or the OpenEMR database I suggest you hire a support company to do this for you.
Thanks Chris. Do you know of a company who can do this? I have already got the patient demographics , Insurance data, provder data and calims details. For instance if I take Insurance data from Medisoft I got a single database with all fields viz. Name, addree, EMC Payor Number etc… But split the data into three parts into Name ( Insurance _companies Table), Addresses ( Address Table by liking to the foriegn ID created under insurance_companies) and Phone number ( Phone_numbers table) . Is this the way it goes. FOr other parameters like facilities, patient data etc…we have the address and phone numbers in the same table.
We do these sort of projects as well as other companies located at www.oemr.org under commercial support. If you are interested you can contact me, I believe we have spoken before a while back.
Yes, you pretty much have the concept down… just make sure you do your homework and work out a proper schema mapping so that you know how you are going to plan it out if you are going to do it yourself.
Thanks Chris. I imported the name of the insurance company into the table but for some reason it did not auto generate the id. I made a sample entry with an id and gave the nest id in the address table and realted to the foreign id. Eg. Assinged id = 1 for AARP and inserted the company details in the insurance_companies. Then clicked on addressses table assigned id =2 entered the address and relted that to foreign id=1. After doing this when I log in to the site I do not see the insurance company under Admin -> Practice. Am I doing something wrong.
Dont bother about the problem I mentioned related to the company not appearing under Admin->practice. It was my mistake. I put the foreign ID wrongly….lol…typo error.
I’m a new to OpenEMR and currently use Medisoft. I would like to know if you can help me import the data from Medisoft to Open EMR? This will save me so much time. My email: van0035@yahoo.com if you can let me know in detail. Thanks in advance
I’ve done this myself. But I use a mixture of manual steps and scripts. Medisoft has separate databases/tables for each provider in use so there was a lot of redundant (but not quite the same) patient data that had to be merged and cleaned up.
-Tony
Guys
We have been able to do this very efficiently and transferred a few Medisoft databases. Unfortunately the software we use is proprietor y i.e bought it from a vendor and cannot be shared. We would have to charge for this: sorry.
What we do is, use this software to convert to a software that we were using previously and then convert that to OpenEMR. It works great: transactions and data. All in a days work.
Thanks
Sam
Thank you Sam. I hope no one is offended by dollars and cents talk. I suppose it could be construed as advertising, but I suspect there are others browsing here who need more information on the feasibility of transferring from commercial software.
Jack
Based on experience with mograting data from Medisoft it is possible. I have helped a couple of friends to migrate. Please feel free to get in touch with me and I can guide you. sraj49@gmail.com
