Adding files like cpt, icd etc

Management and Administration
1

anojgoel wrote on Tuesday, February 03, 2009:

is there a stepwise guide on how to add files.

i see some utilities but have no idea how to use them in xampp (XP install)

is there any benefit of adding the file PFS National Payment Amount File from http://www.cms.hhs.gov/physicianfeesched/pfsnpaf/itemdetail.asp?filterType=none&filterByDID=-99&sortByDID=2&sortOrder=ascending&itemID=CMS1217859&intNumPerPage=2000 to openemr.
if this is not the correct file for state of MO, please point me to correct link.

i have limited CPT and ICD codes to use and probably can get by manual additions as i need them but would like to know about how to use these utilities

thank you.

2

cfapress wrote on Tuesday, February 03, 2009:

Hi Anoj,

I’d never seen the PFS National Payment Amount File. Very interesting. Correct me if I’m wrong, it looks like a list of standard payments amounts for various Medicare services. OpenEMR is used globally, this particular file is USA specific. But I don’t see any reason why such information should not be available to be imported into OpenEMR. Perhaps somebody could write a brief script for importing the data. In fact, I might end up doing that since our Agency offers services paid for through Medicare.

Your first question, regarding ICD9 and CPT4 codes, is tricky with Windows. The scripts you will find in openemr/contrib/util are Perl programs. You will need to install Perl for Windows which can involve a whole host of other software. Start by visiting the Perl web site:
http://www.perl.org/
Once you’ve got Perl installed, and likely Cygwin too, you will need some additional Perl libraries to run the scripts in the contrib folder. Those libraries come through CPAN. I believe there are CPAN utilities that come with Perl.

Good luck and come on back with questions.
Jason

3

anojgoel wrote on Wednesday, February 04, 2009:

jason

i have perl added to xampp install

http://localhost/perl/perl.pl

OK

and http://localhost/perl/modperl.pl

PERL 5.010000 + mod_perl/2.0.4

Directory for MOD PERL => […] \xampp\htdocs\modperl => http://localhost/perl/modperl.pl

Directory for PERL ASP => […] \xampp\htdocs\perlasp => http://localhost/asp/loop.asp

Available drivers are:
ADO
AnyData
CSV
Chart
DBM
ExampleP
Excel
File
Gofer
LDAP
MVS_FTPSQL
Mimer
ODBC
Oracle
PgPP
Proxy
SQLRelay
SQLite
Sponge
Sprite
Template
TemplateSS
XBase
mysql
mysqlPP

let me know if you have any ideas how to proceed from here. does importing ICD etc create another database in mysql or add tables to openemr database?

please look and check if the PFS file is in correct format to be imported and works in linux before i try adding it under windows.

next would be

can ICD file as a palm database (.pdb file) be imported in openemr as is?

thanks

anoj

4

cfapress wrote on Wednesday, February 04, 2009:

Hi Anoj,

The CPT4 and ICD9 codes are stored within the OpenEMR database in the ‘codes’ table. So when the script, load_icd_desc.plx, is run it will wipe out all ICD9 codes from that table and recreate them all. The CPT4 import is less destructive.

Something to note if you look at the codes table through phpMyAdmin:
code type 1 = CPT4
code type 2 = ICD9
code type 3 = HCPCS

I suggest you edit the load_icd_desc.plx to suit your installation. You will need to change the the DBI->connect lines to something like this, with your DBName, username, and password matching the OpenEMR database connection parameters:

my $dbh = DBI->connect("dbi:mysql:dbname=$DBNAME", "username", "password")
   or die $DBI::errstr if ($DBNAME);

The Perl code has some good comments in there so you should be able to sort it out. Also, you might find that your Perl installation is missing a CPAN module or two. You’ll see an error message on your command line when you try to run the perl script.

I’m not working with a WinXP installation so I’m not the best person to answer these questions but I’ll do my best to help.

Jason