importation of data into openmrs

[Julius Kisenyi]

hello my names are kisenyi julius. am new to OPENMRS.  we want to migrate from epi info to  openmrs. we can export data from epi info into access and excel spreassheets. but we have failed to import those sheets into openmrs. please help, its urgent.

[Tobin Greensweig]

it takes a some more in depth knowledge of the openmrs data model but two years ago we found that the best way to import our data was to use python scripts and plug the data directly into the database. i've attached one such script that you can work from.

today it might be better to use groovy since you have access to the openmrs api and there is less room for error.

tobin

On Fri, Jun 21, 2013 at 11:18 PM, Julius Kisenyi <juli...@gmail.com> wrote:

hello my names are kisenyi julius. am new to OPENMRS.  we want to migrate from epi info to  openmrs. we can export data from epi info into access and excel spreassheets. but we have failed to import those sheets into openmrs. please help, its urgent.

--
OpenMRS Implementers: http://go.openmrs.org/implementers
Post: implem...@openmrs.org
Unsubscribe: implementers...@openmrs.org
Manage your OpenMRS subscriptions at https://id.openmrs.org/
 
 

--
Tobin

[Rowan Seymour]

If you are using MS Access for the underlying database, then you might find it useful to look at the IQChart import module (http://emr.moh.gov.rw/wiki/display/dev/IQChart+Import) used by the Rwanda Ministry of Health

OpenMRS does have a spreadsheet import module (https://wiki.openmrs.org/display/docs/Spreadsheet+Import+Module+Version+2) but we developed the IQChart import module because we found that the data needed quite a bit of transformation as it was being imported into OpenMRS and that was easier to accomplish via a custom module.

-Rowan

Rowan Seymour
tel: +250 783835665

[Julius Kisenyi]

thanks rowan. 

i tried to download IQChart module but it was deleted from the location. the spreadsheet import module is a great option but their is no comprehensive tutorial about it usage. can you please give me detailed tutorial or usage guidelines. 

thanks 

julius

[Rowan Seymour]

Source code for the IQChart module is at https://github.com/rwandamoh-emr/openmrs-module-iqchartimport. If you go that route you'll need to develop a custom module but you could use that module as a starting point perhaps.

Documentation for the spreadsheet module is at https://wiki.openmrs.org/display/docs/Spreadsheet+Import+Module+Version+2

[Julius Kisenyi]

thanks Rowan 

when designing the import template using the spreadsheet import module,

i have a problem of with selecting the right option under Data section. please help

julius

[Friedman, Roger (CDC/CGH/DGHA) (CTR)]

Julius, if you have MS Access skills, you can open your Epi Info DB in Access.  You can use ODBC to import the OpenMRS table definitions (and metadata like concepts) and then write MS Access procedures to create the data in the OpenMRS tables.  Note that you should NOT try to use ODBC to load the data into MySQL or Postgres, it always goes bad after some number of records.  One you have your OpenMRS tables looking like you want them, generate a text file of SQL INSERT statements from your data to put  into the DB using the terminal application for the DB.