User Stories
Scenario: As a developer for an existing set of OpenMRS implementations with legacy concepts already being used in the field, I want to start using OCL & the Dictionary Manager tools to manage our concepts ASAP, but I need to be able to use my legacy concepts so that
...
we can use OCL with no impact to our current forms and reports.
Steps
As learned by the UgandaEMR team at the 2022 UCSF/OpenMRS Mombasa Hackathon:
Step1: Get your SQL payload
Get a SQL dump from your EMR: Use this SQL Script: Note: This runs the script in a docker container. You will need docker installed, as the script starts up a docker container.
Code Block | ||||
---|---|---|---|---|
| ||||
mysqldump -u root -p"$MYSQL_ROOT_PASSWORD" \
concepts concept concept_answer concept_attribute concept_attribute_type concept_class \
concept_complex concept_datatype concept_description concept_map_type \
concept_name concept_name_tag concept_name_tag_map concept_numeric \
concept_reference_map concept_reference_source concept_reference_term concept_reference_term_map concept_set \
concept_stop_word > pih-concepts-db-20210503.sql |
Step 2: Get your JSON payload
Step 3:
Step 4: Bulk Import
Use the OCL Bulk Import JSON was bulk imported into the PIH source on OCL using the OCL app's bulk import feature.
qa: https://app.qa.openconceptlab.org/
staging: https://app.staging.openconceptlab.org/#/
Workflow
Widget Connector | ||
---|---|---|
|
...
Technical steps for PIH example: Migrating to OCL: PIH Use Case
CIEL | ocl_omrs Dictionary Conversion Script (converts DB dump into OCL import file) | OCL Bulk Import | OCL TermBrowser | DM WebApp | OCL Subscription Module | OMRS EMR | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
OMRS Nuance | (created b/c Bulk Import doesn't support OMRS SQL - script converts from OMRS model and OMRS DB to OCL model) | Export your existing content (use SQL script here) | |||||||||||||
Sort Weight | Being created in version of OMRS that doesn't have sort weight on concept answers Burke to work with Andy | Sort Weight on Concept Answers is not consistently populated, and frequently does not match the expected value. So either this isn't getting imported correctly into OCL, isn't getting exported correctly from OCL, or isn't getting imported correctly in the subscription module | Add column for CSV format "sort_weight" and apply to correct mapping | Add support for importing sort_weight
| |||||||||||
Matching Sources | The ocl_omrs script hardcodes the OpenMRS and OCL versions of these names (e.g., "SNOMED CT" in OpenMRS is "SNOMED-CT" in OCL) | The subscription module creates new concept sources if needed, and has no way to match up against existing concept sources if they are named slightly differently. (No validation step.) For whatever reason, in our existing system we have "SNOMED CT" whereas in OCL this is "SNOMED-CT", so these are all getting associated with a different source. Also all of the expected "PIH" mappings are imported as "PIH-temp" mappings, which makes the diffs hard to use to find actual differences. OCL Module should prompt user: "I'm about to create a new source. Is this what you want? Or, pick one to map to/use." | |||||||||||||
2 Yes Concepts | Where are the 2 yes's coming from? To investigate... | ||||||||||||||
Different Concept Total | PIH experience: Before the import there were 5713 concepts in the dictionary, and afterwards there were 5884 concepts. I will try to dig into this different | ||||||||||||||
Need codes | Respect new map type called "Code": https://talk.openmrs.org/t/building-conventions-for-concept-ids-in-ocl/34809 | Respect new map type called "Code": https://talk.openmrs.org/t/building-conventions-for-concept-ids-in-ocl/34809 |
...