Ok, maybe it isn't worth upgrading all the data...

[..hidden..]

I have a 1.2.19 that I am running in parallel with 1.3.7. On a relatively 
simple AP transaction I get an SQL error:

Error!


INSERT INTO acc_trans (trans_id, chart_id, amount,
transdate, project_id, invoice_id)
VALUES (?, ?, ?, ?, ?, ?)
ERROR: insert or update on table "acc_trans" violates foreign key 
constraint "acc_trans_chart_id_fkey"
DETAIL: Key (chart_id)=(10103) is not present in table "account".

I've been trying to drag my data from 1997-present which was converted 
from QuickBooks to SQL-Ledger and then from SQL-Ledger to LedgerSMB. It is 
obvious by now that there are too many quirks to catch all of them when I 
do the 1.2 to 1.3 upgrade (which I have easily done more than 25 times).


Is there a procedure for a starting over with just the balances and 
inventory (these are rare books with acquisitions back to 1997).

I can keep 1.2 around for as long as I need to for the IRS.

QuirkBooks->Dieter->LedgerSMB is maybe just too ambitious.

Semi despairing and seeking ideas,

Louis