I was having so many problems, I ultimately setup a new database. I imported all my customers and products into the new database and wrote a perl script to extract each invoice from the SQL database, then the script used the web interface to one by one enter all the invoices and payments into the new database.
It was a crude way to do it, but it was the simplest way I could figure to maintain data integrity and still have all my records. (only dealing with 400 invoices, 1500 line items and 450 payments or so)
The last thing I did was change the start index number for any new invoices so I could quickly tell if I was dealing with something from the old version/database versus new just in case their is a discrepancy.
Recent Comments