physmed wrote on Friday, April 24, 2009:
I have tried to use the utilities in the contrib/util folder to populate the codes tables with ICD9 and HCPCS data and I keep coming up with nothing. I installed Active Perl 5.10 and the drivers that I read about and remembered from using these same utilities successfully with my Ubuntu box. Has anyone successfully used these utilities in the XP environment and if so how specifically did they do it?
Rick
anojgoel wrote on Saturday, April 25, 2009:
hi rick.
could you write a howto from your perspective and i will try to fill the gaps and correct the steps. please start from a native xampp/oemr install.
i have done this successfully in windows xp. i will have to review my notes and it will be easier for me to fill the gaps than post a complete howto.
regards
anoj
physmed wrote on Sunday, April 26, 2009:
OK Anoj here goes!
I downloaded xampp-openemr-3.0.1 and extracted the files to the C root drive as instructed. Then I downloaded Active Perl 5.10 and installed it. Then I downloaded and installed the following perl drivers DBI DBD::mysql WWW::Mechanize and HTML::TokeParser from Active State and another repository. Then I went into the folder at xampp\htdocs\openemr\contrib\util with my editor and changed the first line in the utility from #!/usr/bin/perl to #!C:/perl/bin/perl. Then I downloaded the PFALL09A.TXT file from CMS and put it into the util folder. Then I brought up a command line box and cd c:\xampp\htdocs\openemr\contrib\util so that I was in the util folder, and executed the following command: perl load_doc_fees.plx < PFALL09A.TXT and hit return. That’s when I got the following error message: DBI connect <‘dbname=openemr","…> failed:access denied for user"@’ localhost’ to database’ openemr’ at load_doc_fees.plx line 44 Access denied for user "@’ localhost’ to database ‘openemr’ at load_doc_fees.plx line 44. When I tried to use the load_icd_desc.plx utility from the command line I could see it downloading the file form the internet site and saying that it was putting them into the codes table. But when I would go to the table afterwards none of the ICD9 codes were there. I have used these utilities under Ubuntu 8.04 and they both worked flawlessly. So I am stumped at this time as to how to proceed.
Rick
anojgoel wrote on Sunday, April 26, 2009:
did you update the following
line 34 need to be your locality so that you only get your locality fees.
either uncomment line 41 and 42 and add the username and password for your mysql databse openemr
or comment out line 44 and uncomment line 46 and 47 after filling the username and password for mysql database openemr.
i have copied the code below for reference.
please post your findings.
regards
29 #######################################################################
30 # Parameters that you should customize #
31 #######################################################################
32
33 my $DBNAME = "openemr"; # database name
34 my $CARRIER = "05440"; # Tennessee
35 my $FEE_MULTIPLIER = 1.5; # fee multiplier
36
37 # You can hard-code the database user name and password (see below),
38 # or else put them into the environment with bash commands like these
39 # before running this script:
40 #
41 # export DBI_USER=username
42 # export DBI_PASS=password
43 #
44 my $dbh = DBI->connect("dbi:mysql:dbname=$DBNAME") or die $DBI::errstr;
45
46 # my $dbh = DBI->connect("dbi:mysql:dbname=$DBNAME", "username", "password")
47 # or die $DBI::errstr;
physmed wrote on Monday, April 27, 2009:
Anoj
I tried various permutations of your recommended changes and it kept coming back to the error of not being granted access to the database!
Any other suggestions! Oh and depending on the change made it came back with the error on line 41 or 42 or 44 or 46.
Rick
anojgoel wrote on Monday, April 27, 2009:
i used the second option in my setup.
comment out line 44 and uncomment line 46 and 47 after filling the username and password for mysql database openemr.
could you post your code after making these changes.
regards
physmed wrote on Monday, April 27, 2009:
Anoj
Do you mean that you want to see what I actually put in the utility software or do you want to see the error message? Or both!
Thanks
Rick
anojgoel wrote on Tuesday, April 28, 2009:
send the follwing portion from your code.
29 #######################################################################
30 # Parameters that you should customize #
31 #######################################################################
32
33 my $DBNAME = "openemr"; # database name
34 my $CARRIER = "05440"; # Tennessee
35 my $FEE_MULTIPLIER = 1.5; # fee multiplier
36
37 # You can hard-code the database user name and password (see below),
38 # or else put them into the environment with bash commands like these
39 # before running this script:
40 #
41 # export DBI_USER=username
42 # export DBI_PASS=password
43 #
44 my $dbh = DBI->connect("dbi:mysql:dbname=$DBNAME") or die $DBI::errstr;
45
46 # my $dbh = DBI->connect("dbi:mysql:dbname=$DBNAME", "rick", "rickpassword")
47 # or die $DBI::errstr;
physmed wrote on Tuesday, April 28, 2009:
#######################################################################
#######################################################################
# Parameters that you should customize #
#######################################################################
my $DBNAME = "openemr"; # database name
my $CARRIER = "05440"; # Tennessee
my $FEE_MULTIPLIER = 1.5; # fee multiplier
# You can hard-code the database user name and password (see below),
# or else put them into the environment with bash commands like these
# before running this script:
#
#export DBI_USER=username
#export DBI_PASS=password
#
#my $dbh = DBI->connect("dbi:mysql:dbname=$DBNAME") or die $DBI::errstr;
my $dbh = DBI->connect("dbi:mysql:dbname=$DBNAME", "openemr", "SOurc3_Forg3!")
or die $DBI::errstr;
#######################################################################
This is the username and password combo that is in the instructions for the xamp-openemr-3.0.1 package.
Rick