Skip to content

A Python script to migrate our patient database from CakePHP to OpenMRS. Here be dragons.

License

Notifications You must be signed in to change notification settings

uamuzibora/fly_south

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

37 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

fly_south

A Python migration script for Uamuzi Bora from our CakePHP app to OpenMRS 1.9.0.

Background

When switching platforms from our in-house developed EMR to OpenMRS, we needed to migrate our existing database containing ~7,100 patients with ~300,000 observations to OpenMRS' schema.

Solution

fly_south is a rudimentary Python script that imports all patients and selected observations from our existing PostgreSQL database into our new schema in OpenMRS.

It uses Gunnar's excellent db.py, a Python database abstraction module for MySQL and PostgreSQL.

Further Use

Due to the niche use-case of this script, it's unlikely to be of much use elsewhere in its present form, but if you're trying to import data from an existing EMR into OpenMRS, it may illustrate one approach to a solution.

Disclaimer & License

  • tl;dr: Use at your own risk!
  • You are free to use fly_south in any way you see fit, as long as you respect the terms of the license.
  • Apache License, Version 2.0 - see the LICENSE file for further details.
  • This is some rather ugly code; it was written in a hurry to meet a deadline.

About

A Python script to migrate our patient database from CakePHP to OpenMRS. Here be dragons.

Resources

License

Stars

Watchers

Forks

Packages

No packages published