...

Currently the latest concept dictionary is saved in the CIEL dropbox. To get access to this folder you should email Andrew Kanter at CIEL (andrew.kanter@columbia.edu or ask2164@cumc.columbia.edu). The dictionary is distributed as a SQL export from a particular version of OpenMRS. The SQL is designed to REPLACE all the concept* tables in an OpenMRS implementation. Within the dropbox are a number of zip files with the prefix OpenMRS_concepts_xx.xx.xx_yyyymmdd which includes the version number of openmrs as xx.xx.xx. You can use the 1.6.x versions for all versions of 1.6. The same is true for 1.9, with 1.9.x covering 1.9.7. There also is a 1.7.3 and 1.8.3 version in the dropbox and now 2.0, 2.1, 2.2 also in the dropbox.

Download and unzip the .sql file. Be sure to read the README file about changing properties files and connection string before importing.

It is also possible to view a recent version of the CIEL/MVP dictionary at maternalconceptlabopenconceptlab.comorg. This website allows you to search the dictionary using names, mapping codes or list contents. You can then use the metadatasharing module to import a subset of the codes unto your dictionary (see below). However, the current method of overwriting the tables is the only way to do this for a large number of entries and to ensure that you are remaining in synch with the editorially-controlled CIEL dictionarybeing replaced with a more usable OCL for OpenMRS module.

Translating the concept dictionary

...

There are several ways to get translations of the concept dictionary (and these are documented on the OpenMRS wiki as well at Terminology Service Bureau). The best way to ensure that concepts are properly translated is to work directly with Dr. Kanter's team and the TSB to include them in the dictionary. In the case of the initial Spanish translations, these were done by looking at where there was a SAME-AS map to a SNOMED CT concept and then using the SNOMED CT term in Spanish.

Importing the dictionary using the SQL overwrite method

Whether you have a new installation or are updating an already existing implementation, you should do the following.

1. Check to make sure you have the correct dictionary for the OpenMRS version that you are using. If you have a different version, email Andy to get the right one.
2. Make a backup of your current database (if you're updating the dictionary via MySQL dump. In your server type "mysqldump -uUSERNAME -p --port=PORTNUMBER --host=HOST DATABASENAME > FILENAME.sql" 

   example: mysqldump -uopenmrs -p --port=3316 --host=127.0.0.1 openmrs > dump.sql

   1. USERNAME is a user name for MySQL that has privileges to the OpenMRS database
   2. DATABASENAME is the name of your database, usually openmrs
   3. FILENAME is whatever you want the export file to be
3. Be sure that mysql has been configured for large packets. If in doubt, check that the MAX_ALLOWED_PACKET variable in the my.ini file is set to a high number like 128M.
4. When prompted for a password, use the password from openmrs-runtime.properties. Note if using the standalone version use: openmrs-standlone-runtime.properties
5. Then import the updated concept dictionary that you have by typing "mysql -uUSERNAME -p --port=PORTNUMBER --host=HOST DATABASENAME < DICTIONARYFILENAME.sql"
    example: mysql  -u openmrs -p --port=3318 --host=127.0.0.1 openmrs < openmrs_concepts_2.0_20170703.sql
   
   1. USERNAME is a user name for MySQL that has privileges to the OpenMRS database
   2. DATABASENAME is the name of your database, usually openmrs
   3. FILENAME is the name of the sql file that contains the concept dictionary you received
6. If you are running OpenMRS Platform 1.11.x and above, and the CIEL SQL file does NOT include "Update global_property set `property_value` = "" where `property` = "search.indexVersion";" (This is usually included)
   
   1. Please go to Administration - Maintenance - Search Index - Rebuild Search Index.

Keeping multiple OpenMRS instances with the same dictionary

To update the concept dictionary for multiple OpenMRS instances you will have to do them one by one (unless you are using the Sync Module). This can be both time consuming and you can have problems with the different concept dictionaries, so you should do this only when you need to have the latest versionThe preferred method for doing this is to use the OCL for OpenMRS method and the Subscription module.

Getting local concepts to be added

The CIEL/MVP dictionary will probably not contain all of the concepts that you need, so you will have to add concepts to you your local OpenMRS instance.  However, you should get these concepts to be entered into the CIEL/MVP dictionary. This will ensure that the dictionary is consistent, properly mapped and can be used by others. Do not add local concepts to your forms if you intend to replace them with approved concepts from the international dictionary.  The easiest way to do this is to send an email to akanter@eiask2164@cumc.columbia.edu with a spreadsheet of the concepts requested, or that need changes.:

1.  This spreadsheet should have at least the following columns:
   1. Concept name in English
   2. Concept definition (paragraph) in English
   3. Concept datatype
   4. Concept class
   5. Concept maps (to ICD-10, SNOMED, etc. if you know them)
   6. Concept names in other languages, concept definition in other languages
2. If the concept is similar to an existing concept, please include the concept it is similar to. 
3. If the concept is part of a set, or part of a question-answer pair, please note this

Things that need to be written

1. Strategy for when you update a concept dictionary with the latest version how you remap the local concepts to either the ones that have been incorporated in the MVP/CIEL dictionary or keeping them locally
2. How the translation was done into Spanish and if we (eHS) could do it
3. Check to make sure that using mysql dump is the best way to get latest version of dictionary into your OpenMRS instance