Jason at cfapress re: load_doc_fees utility

Management and Administration
1

physmed wrote on Monday, August 25, 2008:

Is anyone still using this utility?  I used it last year and it worked fine but now when I try to use it to populate the CPT codes in my test machine nothing gets put ito the codes or prices tables.  The correct codes get put in when I use the HCPCS and ICD9 utilities so I am wondering what is up with the CPT utility!  My test box is running Ubuntu Server 8.04 with the CVS version of 2.9.0.  Any help would be greatly appreciated.

Thanks

Rick

2

cfapress wrote on Monday, September 08, 2008:

Hi Rick,

I’m not the maintainer for that utility. But I can try to help you. I haven’t encountered any troubles with the utility when I explicitly followed the instructions about a year ago.

Do you get any error messages at all?

jason

3

physmed wrote on Monday, September 08, 2008:

Thanks Jason

The only reason that I flagged you was because you are logged in as applying 2 bug fixes to this utility several months ago.  Anyway no I am not geting any error messages and I can watch as it seems to be working to put data into the codes and prices tables like it is supposed to.  No I have been able to use the ICD9, FDA, and HCPCS utilities without a problem with all of the tables being populated properly so I am at a loss as to why the CPT codes and RVS pricing are not in there after using that particular utility.  And I did go looking for the data in other tables of the data base but could not find them.

It is probably something that I am not doing that should be done but the other utilities run right out of the box without modificaton so I don’t know what is up with this one.

Any help would be greatly appreciated so that I can properly evaluate this version on my Ubuntu server 8.04 test box.

Rick

4

cfapress wrote on Tuesday, September 09, 2008:

Here are two things to check in the code of the utility:

1) Check your carrier code to make sure it’s correct for your location. I believe you can find your carrier code somewhere online. Not sure where, sorry.

2) Check to see if the $dbh->do($query) lines are commented out. Are they preceeded by hash marks (#)?? If so, then they are commented out and not executed when the script is run.

Number 2 is probably the case. Apparently in my infinite wisdom (hahaha) I checked in some code changes with the ‘DO’ commands commented out. Oops!!

I’ll make the correction and check-in the changes to CVS but you can hand edit the code yourself too.

Thanks for finding this bug. It’s been undetected for many months.

Jason

5

physmed wrote on Wednesday, September 10, 2008:

Thanks Jason

I was able to get to my test machine today and after I uncommented those lines it worked like a charm.

Rick

6

rabbai wrote on Monday, January 26, 2009:

Hello,

I am interested in this. I Just started Using OpenEMR about 2 weeks ago and I havent had any problems so far. The issue is i would like to load the codes. I would like to know where the utilities are on the system. Thanks

7

physmed wrote on Monday, January 26, 2009:

Hi

The utilities that you are looking for are openemr/contrib/util and have comments in the files that can be looked at using a text editor that will describe how to use these Perl based programs.

Hope this helps.

Rick