Difference between revisions of "Load ICD9 Codes"

From OpenEMR Project Wiki
(Created page with '==LINUX INSTRUCTIONS== - Modify the 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 - U…')
 
Line 1: Line 1:
==LINUX INSTRUCTIONS==
==LINUX INSTRUCTIONS==
- Modify the load_icd_desc.plx file:
#Modify the 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 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>

Revision as of 08:10, 12 March 2010

LINUX INSTRUCTIONS

  1. Modify the load_icd_desc.plx file:
  2. Place database name at line 36 (get this from the openemr/library/sqlconf.php file)
  3. Comment out line 45 and 46
  4. 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 )
  5. Execute the script:
perl /var/www/openemr/contrib/util/load_icd_desc.plx

WINDOWS INSTRUCTIONS

  1. Modify the load_icd_desc.plx file:
  2. Place database name at line 36 (get this from the openemr/library/sqlconf.php file)
  3. Comment out line 45 and 46
  4. 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 )
  5. Install ActivePerl (if not already installed, (it defaults to C:\Perl directory, which is fine)):
  6. 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