Load ICD9 Codes

From OpenEMR Project Wiki

LINUX INSTRUCTIONS

  1. Modify the openemr/contrib/util/load_icd_desc.plx file:
    • Place database name at line 36 (get this from the openemr/library/sqlconf.php file)
    • Comment out line 45 and 46
    • Uncomment line 48 and 49, and substitute the your sql username and database for username and password in this line (line 48). (get these from theopenemr/library/sqlconf.php file )
  2. Execute the script:
perl /var/www/openemr/contrib/util/load_icd_desc.plx


WINDOWS INSTRUCTIONS

  1. Modify the c:\xampp\htdocs\openemr\contrib\load_icd_desc.plx file:
    • Place database name at line 36 (get this from the openemr/library/sqlconf.php file)
    • Comment out line 45 and 46
    • Uncomment line 48 and 49, and substitute the your sql username and database for username and password in this line (line 48). (get these from theopenemr/library/sqlconf.php file )
  2. Install ActivePerl (if not already installed, (it defaults to C:\Perl directory, which is fine)):
  3. Configure ActivePerl and run the script (via two below commands):
C:\Perl\bin\ppm install DBD-MySQL
C:\Perl\bin\perl c:\xampp\htdocs\openemr\contrib\load_icd_desc.plx