Difference between revisions of "Import Standard Tables"

From OpenEMR Project Wiki
Line 5: Line 5:
:*Go to Administration->Other->'External Data Loads'
:*Go to Administration->Other->'External Data Loads'
:*Click ICD9
:*Click ICD9
:*Follow the instructions
:*Follow the instructions (click the '?' for detailed instructions)
:::*''If you get the following sql error after you click INSTALL ("Error: The used command is not allowed with this MySQL version"), then you can instead upload the code set by downloading [http://www.open-emr.org/data/icd9-openemr-1.zip this file] and importing at Administration->Database->Import. (Warning: Only do this if you get an error using the standard import mechanism.)''
:::*''If you get the following sql error after you click INSTALL ("Error: The used command is not allowed with this MySQL version"), then you can instead upload the code set by downloading [http://www.open-emr.org/data/icd9-openemr-1.zip this file] and importing at Administration->Database->Import. (Warning: Only do this if you get an error using the standard import mechanism.)''
:*ICD9 diagnosis (and service) codes can be activated at Administration->Lists->Code Types
:*ICD9 diagnosis (and service) codes can be activated at Administration->Lists->Code Types
Line 15: Line 15:
:*Go to Administration->Other->'External Data Loads'
:*Go to Administration->Other->'External Data Loads'
:*Click ICD10
:*Click ICD10
:*Follow the instructions
:*Follow the instructions (click the '?' for detailed instructions)
:::*''If you get the following sql error after you click INSTALL ("Error: The used command is not allowed with this MySQL version"), then you can instead upload the code set by downloading [http://www.open-emr.org/data/icd10-openemr-1.zip this file] and importing at Administration->Database->Import. (Warning: Only do this if you get an error using the standard import mechanism.)''
:::*''If you get the following sql error after you click INSTALL ("Error: The used command is not allowed with this MySQL version"), then you can instead upload the code set by downloading [http://www.open-emr.org/data/icd10-openemr-1.zip this file] and importing at Administration->Database->Import. (Warning: Only do this if you get an error using the standard import mechanism.)''
:*ICD10 diagnosis (and service) codes can be activated at Administration->Lists->Code Types
:*ICD10 diagnosis (and service) codes can be activated at Administration->Lists->Code Types
Line 25: Line 25:
:*Go to Administration->Other->'External Data Loads'
:*Go to Administration->Other->'External Data Loads'
:*Click SNOMED
:*Click SNOMED
:*Follow the instructions
:*Follow the instructions (click the '?' for detailed instructions)
:*SNOMED diagnosis codes can be activated at Administration->Lists->Code Types
:*SNOMED diagnosis codes can be activated at Administration->Lists->Code Types
::*''Note that in the future version of OpenEMR 4.1.2, in addition to the diagnosis codes, there is also a general SNOMED Clinical Terms code type that can be activated here, which can be used to map items in Administration->lists with SNOMED terms''
::*''Note that in the future version of OpenEMR 4.1.2, in addition to the diagnosis codes, there is also a general SNOMED Clinical Terms code type that can be activated here, which can be used to map items in Administration->lists with SNOMED terms''
Line 34: Line 34:
:*Go to Administration->Other->'External Data Loads'
:*Go to Administration->Other->'External Data Loads'
:*Click RXNORM
:*Click RXNORM
:*Follow the instructions
:*Follow the instructions (click the '?' for detailed instructions)


[[Category:User Guide 4.1.1]][[Category:User Guide]]
[[Category:User Guide 4.1.1]][[Category:User Guide]]

Revision as of 21:12, 10 January 2013

Overview

The ICD9, ICD10, SNOMED and RxNorm standardized data sets can be easily imported (and upgraded) into OpenEMR. See below for specific instructions. (Note this feature is available in OpenEMR version 4.1.1 and higher.)

Import/Upgrade and activate ICD9

  • Go to Administration->Other->'External Data Loads'
  • Click ICD9
  • Follow the instructions (click the '?' for detailed instructions)
  • If you get the following sql error after you click INSTALL ("Error: The used command is not allowed with this MySQL version"), then you can instead upload the code set by downloading this file and importing at Administration->Database->Import. (Warning: Only do this if you get an error using the standard import mechanism.)
  • ICD9 diagnosis (and service) codes can be activated at Administration->Lists->Code Types
  • Toggle on Active in row where Key is ICD9
  • Set External to 'ICD9 Diagnosis' in row where Key is ICD9
  • Codes can be customized at Administration->Services

Import/Upgrade and activate ICD10

  • Go to Administration->Other->'External Data Loads'
  • Click ICD10
  • Follow the instructions (click the '?' for detailed instructions)
  • If you get the following sql error after you click INSTALL ("Error: The used command is not allowed with this MySQL version"), then you can instead upload the code set by downloading this file and importing at Administration->Database->Import. (Warning: Only do this if you get an error using the standard import mechanism.)
  • ICD10 diagnosis (and service) codes can be activated at Administration->Lists->Code Types
  • Toggle on Active in row where Key is ICD10 (if want to actively use ICD10 codes)
  • Set External to 'ICD10 Diagnosis' in row where Key is ICD10
  • Codes can be customized at Administration->Services

Import/Upgrade and activate SNOMED

  • Go to Administration->Other->'External Data Loads'
  • Click SNOMED
  • Follow the instructions (click the '?' for detailed instructions)
  • SNOMED diagnosis codes can be activated at Administration->Lists->Code Types
  • Note that in the future version of OpenEMR 4.1.2, in addition to the diagnosis codes, there is also a general SNOMED Clinical Terms code type that can be activated here, which can be used to map items in Administration->lists with SNOMED terms
  • Codes can be customized at Administration->Services
  • Note that in the future version of OpenEMR 4.1.2, you can also install the SNOMED US Extension Pack after you install the SNOMED International Pack. You first install the International pack, then remove it from the contrib/snomed directory. Then you place the US extension pack in the contrib/snomed directory and install it.

Import/Upgrade RxNorm

  • Go to Administration->Other->'External Data Loads'
  • Click RXNORM
  • Follow the instructions (click the '?' for detailed instructions)