I hae been trying to search even the simplest ICD9 codes to put in my patients charts and yet when i search anything it always hows no results for the search. Are the codes in the program? Do I have to activate something?
There’s a utility contrib/util/load_icd9_desc.plx that loads them. However I think it may be broken right now due to recent changes to the web site www.icd9data.com which is where it gets the data from. I hope to have a bit of time in the next 1-2 weeks to fix it, if nobody else gets to it first.
You can choose to download the file from the CVS repository. Look for the (download) link next to the newest revision, at the top of the list. Then you simply copy the downloaded file into your OpenEMR installation to replace the old one.
anyone successfully update the link? i edited the load_icd9_desc.plx and even update to the latest patch and still can not get it to load any ICD at all.
I’ve been trying to use it as well. It’s odd, the script runs, you can see it collecting the data from the website, but no data is actually inserted into the codes table in the DB. Might have to output to a file then try to import into MySQL.
Brady’s right as usual, I just grabbed the most recent version from CVS & it worked perfectly. Just in time to deploy a new server for a client, Thanks!
Hi, I have been having the same problem. I’ve followed the instructions on this thread, but they have not worked for me. The latest file in the repository is this one, if I’m not mistaken:
//Revision 1.5.2.2 - (view) (download) (annotate) -
Fri Oct 23 20:36:00 2009 UTC (6 weeks, 6 days ago) by bradymiller
Branch: rel-310
Changes since 1.5.2.1: +1 -1 lines
Diff to previous 1.5.2.1 , to branch point 1.5 , to next main 1.7
patch for web site change from markob100//
I downloaded it but could not replace the existing “loadicd9desc.plx” with the script as I am denied permission to edit the file.
However, I opened the file as root and was able to edit it. Likewise with database name, username and password as instructed in this thread.
I then ran the script from the terminal, and observed it obtaining all the diagnostic codes successfully from the website.
But I still the Code Finder is not populated when trying to enter a diagnosis in Issues. I notice when I look at the “loadicd9desc.plx” file that it has been edited successfully when logged in as root, but not when logged in as myself. Does this explain why it’s not working? What can I do?
If you delete the original script as root & then copy the new version in from CVS as root, you should then be able to run the new version. There are a couple of variables to export from the command line (DB user & password, I ran it as the MySQL root user, but be very careful if you choose to do it that way!), & then you should be able to run the perl script successfully & populate the DB table.
Please read your note as though you had no idea what the writer was talking about, and ask what you should watch out for. That is a form of instruction shorthand which forces potential users to both make mistakes and become frustrated. If the user is a newbie, they may decide to go elsewhere, and we do not want them doing that. So please in future be specific about steps, and especially any problems. Thanks.
That said - what OS are you using? If you look at the ICD9 code posting by this thread you can see I am trying to make it work seamlessly (with no success so far) in windows, in hopes that we can have a simple batch file which will run it if the latest PLX file (which is replaced by the patches when we know of them) is compatible with the icd9data.com website.
If you know how to make the xampp distribution version run them, and how to insert the needed libraries as shown in the PLX file, please let me know so I can get that operating. Thanks.
Joe,
That’s my bad, sorry. Consequence of being at work for 30+ hours straight & wanting to try to help someone & finally go home @ the same time. I don’t consider myself to be any sort of OpenEMR expert but I do support & administer quite a few production systems that run 24/7 & if anybody ever wants my real-world input I’ll do the best I can to help. If someone wants a step by step CLI how-to I’ll be glad to write one up when I have some free time.
I haven’t yet taken the plunge into trying OpenEMR on a Windows server, Ubuntu Server (6.0.6 & 8.0.4 LTS versions) has been pretty good to me so far & the small-to-medium size clients we service rarely have the extra $$$ to fork over for a server version copy of Windows. That being said, I would like to experiment with OEMR on Windows in the interests of being able to implement it if necessary, someone’s bound to ask that ? sooner or later. My specific experience with the ICD9 scripts comes down to 2 points of interest.
1. If the script is run using the ‘openemr’ MySQL user account, it runs, but no data is actually input to the table. Run as root & it’s fine. I don’t really see a downside to this, I was just trying to warn rdh61 to be careful when performing any MySQL operations as root, a few incorrect keystrokes can do a lot of damage when you’re operating as the superuser.
2. I think this may be something related to the way Perl is implemented on Ubuntu Server, but if I run the script with the variables embedded, I get Perl compilation errors & the script aborts. Exporting the needed values from the CLI allows the script to run properly. . I’m not sure if the Perl/Windows/XAMPP problems are something similarly related to DB permissions or a Perl execution problem.