Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Revert changes

...

...

...

...

...

...

Table of Contents

...

Summary

This is a page to collect notes about migrating data from existing EMRs to OpenMRS. Please add your own experiences and ideas. When we have enough material, we can turn this into a more formal guide.

...

You can write software scripts that use the OpenMRS API or web services

Migration Steps

A migration includes these steps, in any order. Most likely you will iterate through the steps several times as your OpenMRS implementation takes shape.

...

Outline of next sections:

Providers 

Bare minimum to create a Person is a gender 

If Outpatient table lists the provider, make one provider for each name

If not, create a "Staff" person - maybe one per ward (Outpatient Staff, ICU Staff)

Patient Info

Bare minimum to create a Patient is an identifier and a gender

...

If your database is very normalized, you have to put the pieces together again before import. Ex:  the BloodTypeLab table uses a foreign key on the BloodTypeConstants table (A neg, B pos, etc) . When you run the import script, the obs needs to say "A neg", and not the ID number of the row in BloodTypeConstants. 


Resources

Data Migration

Spreadsheet Import Module

Spreadsheet Import Module Version 2