Difference between revisions of "Load ICD9 Codes"

From OpenEMR Project Wiki
m (6 revisions: Load_ICD9_Codes)
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
__TOC__
==LINUX INSTRUCTIONS==
==LINUX INSTRUCTIONS==
#Modify the load_icd_desc.plx file:
#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)
#*Place database name at line 36 (get this from the openemr/library/sqlconf.php file)
#Comment out line 45 and 46
#*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 )
#*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 )
#Execute the script:
#Execute the script:
<pre>perl /var/www/openemr/contrib/util/load_icd_desc.plx</pre>
<pre>perl /var/www/openemr/contrib/util/load_icd_desc.plx</pre>


==WINDOWS INSTRUCTIONS==
==WINDOWS INSTRUCTIONS==
#Modify the load_icd_desc.plx file:
#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)
#*Place database name at line 36 (get this from the openemr/library/sqlconf.php file)
#Comment out line 45 and 46
#*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 )
#*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 )
#Install ActivePerl (if not already installed, (it defaults to C:\Perl directory, which is fine)):
#Install ActivePerl (if not already installed, (it defaults to C:\Perl directory, which is fine)):
#Configure ActivePerl and run the script (via two below commands):
#Configure ActivePerl and run the script (via two below commands):
<pre>C:\Perl\bin\ppm install DBD-MySQL
<pre>C:\Perl\bin\ppm install DBD-MySQL
C:\Perl\bin\perl c:\xampp\htdocs\openemr\contrib\load_icd_desc.plx</pre>
C:\Perl\bin\perl c:\xampp\htdocs\openemr\contrib\load_icd_desc.plx</pre>

Latest revision as of 21:53, 21 April 2012

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