We are looking at migrating data from several EMR systems (not openmrs) into openmrs. A solution people have proposed was to do SQL scripts that makes direct connections to openmrs DB especially for openmrs to openmrs migrations. We have tried this and figured that the data quality post-migration is not very good. The solution we came up with is to create a utility that writes to openmrs via the web APIs, then create standard datasets that the EMRs will follow in extracting data for migration. We want to find out if there are existing solutions that can do this or something similar we can adapt? @dkayiwa @lamurie
Did you get a chance to look at this? https://wiki.openmrs.org/display/docs/Spreadsheet+Import+Module