Hi @ICAPEthiopia & @OHRI, how are things going w.r.t. the Smartcare ET → OpenMRS DB data migration planning? @burke and I were trying to remember if you needed any additional resources or support from us on this topic at this moment.
@burke & @dkayiwa are there any data migration resources we should share here? (For a non-OMRS system to OMRS) @jennifer are you able to share the migration resources you collected when we were supporting the Rwanda platform upgrade?
(ICYMI: We are no longer planning to use the FHIR API for initial data migration, which was our original idea as mentioned here.)
@grace, perhaps we could arrange a hands-on meeting with devs from @ICAPEthiopia & @OHRI along with @dkayiwa (and/or @ibacher if avail) to work through the data mapping for migration? @paul mentioned that he would be eager to help and to attend such a meeting.
I’m imagining we could help match existing data to the OpenMRS data model similar to what we started in the “OpenMRS Model” worksheet of the gap analysis spreadsheet or, if the Ethiopia team has already begun that mapping process (which ideally would map each object & its properties to OpenMRS equivalents).
@dagimm what do you think? Do you want to get started on this work now? i.e. Are you interested in a hands-on meeting like Burke describes, and if so, should we set up a hands-on meeting now or later, like in Aug?
IIRC I think there was a team member you were considering allocating to this work in general … or I might be getting mixed up w/ reporting.
Sounds great @dagimm. Turns out there’s a lot of people who are offering to help by sharing their own similar experiences as well (w/ non-OMRS to OMRS system migration). But the first session can be a focused hands-on technical one with just a few people.
Do any of these 3 times on Thursday work for you? (And also @dkayiwa and @eudson if you could please fill this out too. @ibacher if you could possibly join that would be cool too.)
3 time options that work for Burke here:
Later, we could have a second session, and invite additional engineers who have gone through similar experiences before. Some examples brought to my attention today are:
Haiti: ITECH’s iSanteEMR change to an OpenMRS-based EMR, and that was even a free text system
Kenya: Palladium’s massive migration of tons of data from IQ-CARE (non-OMRS) to KenyaEMR (OMRS) and they even published about it - they are a good resource being a recent experience at national level scale
Botswana: Intellisoft is actively migrating data in Botswana from a proprietary system called PIMS to OpenMRS-database BotswanaEMR
We confirmed that we are not using the FHIR API for this data migration, we will pursue traditional data migration approach. Though for reference Burke shared this general mapping list of FHIR Resources to the OpenMRS Data Model.
1. First Goal: Clear mappings of datastructures in SmartCare to data structures in OpenMRS.
So next, we need something like this spreadsheet that maps the Smartcare model to OpenMRS resources. @burke and @paul to spend 1-2 hrs together and see how much mapping they can get through. (e.g. they estimate the patient resource section will take ~1hr to get through.)
Later, could build an abstract that mirrors the platform we’ll be sending data into, and a module that will send the data there. (Also here are some reference concepts Dagim shared.)
2. Data Moving Strategy
Eg will we use REST API? Or…?
@dkayiwa are there any particular tools you recommend to import into OpenMRS? However we did agree that we can decide this better once we see how the mappings are working.
3. Learning from Others
After we’ve given Paul & Burke a chance to get back to us, we will look into setting up a wider community call to learn from other orgs who have done a Non-OMRS to OMRS data migration (as mentioned here).
@dagimm so Burke and Paul have reached a point where they have some questions about the SmartCare datamodel - I reached out to their EA and they only have 3 slots available next week. Could any of these work for you? Doodle
Can someone summarize the content migration status for me? What is the current status in mapping to CIEL or other standards? I see from this thread that the current work is mostly focused on the data model, but wanted to be sure I was not missing something… thanks.
Good questions Andy.
So back in ~June at the Ethiohri hackathon, @wamz spent the 2 weeks reviewing the concepts needed for Ethiopia’s main 3 HIV forms with ICAP-Ethiopia BA leads @desalegnl & @asresut. He onboarded them to OCL online and CIEL, and encouraged them to map to the OHRI-recommended CIEL concepts as much as possible (i.e. the CIEL concepts included in OHRI’s collections). Where a relevant CIEL concept wasn’t available they either used a custom OHRI-provided concept or made their own. (@wamz is this all correct?)
FYI @paul - Dagim and I have been following up with Morgan to find a time that will work for you, Burke, and Dagim together. So expect a calendar invite for this within the next ~3 weeks (we tried for this week but didn’t work for a number of reasons).