ICD9 Procedure Codes

Day-to-Day Users
1

curtmunsey wrote on Sunday, February 20, 2011:

Hi Everyone,
I am using openemr v4.0 on Linux and I am trying to load the ICD9 Procedure Codes. From looking on icd9data.com I found those codes are published under http://www.icd9data.com/2008/Volume3/default.htm so I changed the start URL in the icd load script from default to the above.

The script errors out with “Error GETing http://www.icd9data.comhttp://www.icd9data.com/2008/Volume3/00-00/default.htm: Can’t connect to www.icd9data.comhttp::80 (Bad hostname ‘www.icd9data.comhttp:’) at ./load_icd_desc.plx line 75”

It looks like the GET function is getting a bad URL as “http:” appended to the domain name. How can I fix it?

Totally appreciate your help :slight_smile:

Thanks,
Curt

2

tmccormi wrote on Sunday, February 20, 2011:

The icd9 files are now shipped with an sql file containing the icd9 data.   You can just import the file using mysql command or the Admin->Other->Database (phyMyAdmin)

The file is located in openemr/sql/icd9-codes-insert.sql

-Tony

3

curtmunsey wrote on Wednesday, February 23, 2011:

Tony, you are a life saver…. Thanks Man!

4

anonymous wrote on Saturday, May 28, 2011:

One BIG Thank you!!!!!!!!!!!!!!!!!!!!! Tony.

5

robertovasquez wrote on Friday, September 26, 2014:

Can someone advice me if the icd9 data in openemr/sql/icd9-codes-insert.sql is updated?

6

cmswest wrote on Friday, September 26, 2014:

hi Roberto, have you tried to update the codes through administration->other->external data loads?

i believe that sql script is deprecated

7

robertovasquez wrote on Monday, September 29, 2014:

Hi Stephen
Yes I had load ICD9 data ussing external data loads. running the script is more simple. That is why I asked the forum.
Now I know icd9-codes-insert.sql is deprecated.
Thanks