Getting rid of SQL-Ledger

[system]

mike-h30 wrote on Thursday, November 06, 2008:

Rod,

I was able to finally get a CVS copy of OpenEMR via a terminal.  It was easier than configuring a front end client.  I summarized what I did below for others to see if interested.  These directions were written assuming one is using a Linux desktop and already has CVS installed.   CVS was installed by default for my distro ( OpenSuse 11.0, KDE 4.1.2).

1.)   Verify that CVS is installed on your distribution.

2. )  Open a terminal and type the following at command prompt:

             cvs -d:pserver:anonymous@openemr.cvs.sourceforge.net:/cvsroot/openemr login"

             i.e. -  mike@linux-25y0:~> cvs -d:pserver:anonymous@openemr.cvs.sourceforge.net:/cvsroot/openemr login

3.)  Next you will be prompted for a password.  No need to enter one for anonymous access.  Just hit enter and you will see:

             Logging in to :pserver:anonymous@openemr.cvs.sourceforge.net:2401/cvsroot/openemr
             CVS password:

4.)   A successful login will not display any error messages and you will be back at a command prompt.

5.)   At the command prompt type the following and hit enter: 

             cvs -d:pserver:anonymous@openemr.cvs.sourceforge.net:/cvsroot/openemr checkout openemr

             i.e. -  mike@linux-25y0:~> cvs -d:pserver:anonymous@openemr.cvs.sourceforge.net:/cvsroot/openemr checkout openemr

6.)   A copy of the current CVS "openemr" directory will now be in your "home" directory.

             i.e. - /home/mike/openemr

[system]

omo66 wrote on Saturday, November 08, 2008:

I noted that the backup link is no longer working since I added the A/R support.
see this error message:

Dumping OpenEMR database …
Dumping phpGACL database …
Dumping SQL-Ledger database …
“PGPASSWORD=‘sql-ledger-password’ pg_dump -U ‘sql-ledger’ -h localhost --format=c -f /tmp/openemr_web_backup/emr_backup/sql-ledger.sql ‘openemr’” returned 1:

[system]

mike-h30 wrote on Sunday, November 09, 2008:

I checked out openemr CVS files today (11-08-08) to begin testing and also get the same error:

Dumping OpenEMR database …
Dumping SQL-Ledger database …
“PGPASSWORD=‘secret’ pg_dump -U ‘sql-ledger’ -h localhost --format=c -f /tmp/openemr_web_backup/emr_backup/sql-ledger.sql ‘sql-ledger’” returned 127:

[system]

omo66 wrote on Sunday, November 09, 2008:

Prepay and checkout options are gone from pop up window?

At some point Rod made some changes, now both Prepay and checkout are gone from pop up window.

was that part of the process?

I noticed also: when using the pop up payment window that all boxes are filled out with the $ due amount.  If the front desk saved without cleaning uo p thoses boxes for each visit, then this account balance will zero instead of due $ xxx.

any ideas?

[system]

omo66 wrote on Monday, November 10, 2008:

Clarifications:

Prepay and checkout are still working.

They appear only if you had the following line as true in globals.php

// Set this to true if you want the drug database and support for in-house
// prescription dispensing.
$GLOBALS[‘inhouse_pharmacy’] = true;

[system]

sunsetsystems wrote on Monday, November 10, 2008:

This is a configuration issue.  See $STMT_PRINT_CMD in custom/statement.inc.php.

Rod
www.sunsetsystems.com

[system]

sunsetsystems wrote on Monday, November 10, 2008:

I checked in a fix to interface/main/backup.php for this.

Rod
www.sunsetsystems.com

[system]

mike-h30 wrote on Tuesday, November 11, 2008:

Backup was successful!! ( with fix in interface/main/backup.php)

-Mike

[system]

omo66 wrote on Monday, November 24, 2008:

one more bug found in EOB.
Inside EOB Posting Invoice after clicking on invoice and making write off the balance turns zero .
Going back to EOB posting search:
The EOB Posting search does not update the balance to zero.

?
Thanks

[system]

sunsetsystems wrote on Friday, November 28, 2008:

There is no automatic refreshing of the search window, if that’s what you mean.  Perhaps there should be, but you can do it manually.

Rod
www.sunsetsystems.com

[system]

gutiersa wrote on Monday, December 15, 2008:

I have a new installation of openemr from cvs downloaded on 11-5-2008.
I imported my mysql and postgres databases and are trying to convert it using openemr/sl_convert.php.
But after processing two rows of data from the ar table in postgres it goes into an infinite loop at:

  while ($i = stripos($row[‘intnotes’], ‘Statement sent ‘, $i) !== false) {
    $i += 15;
    $last_stmt_date = "’" . substr($row[‘intnotes’], $i, 10) . "’";
    ++$stmt_count;

$i stays forever at 16, then I get an time exceeded error

What to do? I would like to test the new openemr without sql-ledger but am having no luck.

[system]

sunsetsystems wrote on Monday, December 15, 2008:

What version of PHP?  Looks like stripos() only works with PHP5.  If that’s what you have, then I guess you’ll need to do some debugging (like find out what’s in $row[‘intnotes’]).

Rod
www.sunsetsystems.com

[system]

gutiersa wrote on Tuesday, December 16, 2008:

I have a new installation of openemr from cvs downloaded on 11-5-2008.
I imported my mysql and postgres databases and are trying to convert it using openemr/sl_convert.php.
But after processing two rows of data from the ar table in postgres it goes into an infinite loop at:

  while ($i = stripos($row[‘intnotes’], ‘Statement sent ‘, $i) !== false) {
    $i += 15;
    $last_stmt_date = "’" . substr($row[‘intnotes’], $i, 10) . "’";
    ++$stmt_count;

$i stays forever at 16, then I get an time exceeded error

What to do? I would like to test the new openemr without sql-ledger but am having no luck.

[system]

gutiersa wrote on Tuesday, December 16, 2008:

I think I just reposted my prev post, sorry about that
yes I have php5 from xampp in a windows vista laptop (my testing environment)
I will try to debug

[system]

gutiersa wrote on Tuesday, December 16, 2008:

here is the info:

intnotes    (string:79) Statement sent 2008-05-02\n\nStatement sent 2008-05-02\n\nStatement sent 2008-05-02   

[system]

sunsetsystems wrote on Tuesday, December 16, 2008:

I think I see a bug.  Try changing that while statement to:

  while (($i = stripos($row[‘intnotes’], 'Statement sent ', $i)) !== false) {

Rod
www.sunsetsystems.com

[system]

gutiersa wrote on Tuesday, December 16, 2008:

much much better, now it added 7 pages  (180+ rows ) worth of data to ar_activity table in my openemr database.
how ever i’m still getting the following errors:

Co-pay of $20 in the encounter was not found in SQL-Ledger invoice 2.5397.

Fatal error: Maximum execution time of 60 seconds exceeded in C:\xampp\htdocs\openemr\library\sql.inc on line 32

What does the first mean?

Where do I increase the execution time.

[system]

sunsetsystems wrote on Tuesday, December 16, 2008:

The Co-pay message means exactly what it says.  It’s just something to check.  Probably what happened is the co-pay was entered after the original billing run, so it never got into SQL-Ledger.

The max execution time can be changed in php.ini, wherever that is located on your system.  You’ll need to restart the web server after changing it.

Rod
www.sunsetsystems.com

[system]

gutiersa wrote on Wednesday, December 17, 2008:

that worked great.

here is my report:

OpenEMR Conversion from SQL-Ledger

Co-pay of $20 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $60 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $60 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $20 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $20 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $15 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $20 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $10 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $30 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $25 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $25 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $15 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $25 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $25 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $10 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $20 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $20 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $20 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $15 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $10 in the encounter was not found in SQL-Ledger invoice ###.######.
Co-pay of $50 in the encounter was not found in SQL-Ledger invoice ###.######.

8769 SQL-Ledger invoices were processed.
15577 payments and adjustments were posted.

I had to keep running it because I had to keep extending the max_execution_time and max_input_time in php.ini.
altogether it took about 45 to 50 min to process the above number of invoices.

On another note, should I worry about the warning messages above?
after all if the co-pays did not make it into sql-ledger, it should not matter because the idea is to not use sql-ledger any more, right? Now they should all be in openemr! No?

[system]

sunsetsystems wrote on Wednesday, December 17, 2008:

Wow, that’s a long time to process that many transactions!

Yes the co-pays should be in OpenEMR.  However you may have dunned some patients for amounts that were already paid.

Regardless, I would definitely do some spot-checking of a few claims… after all, we are testing!

Rod
www.sunsetsystems.com