Since the start of the new millennium I've used SQL-Ledger/Ledger-123 for my business bookkeeping. There are too many inaccuracies and other issues that are no longer being addressed so I want to move all the data (on a year-by-year basis, at least from 2009) to GnuCash.
The problems include the only user-visible export capability on the menu is for 'payments' from a few asset accounts; the database back end (PostgreSQL-9.6.1 in my installation) has all the tables, but there are no referential integrities (e.g., foreign keys) in the schema; so all the joins must be in the multiple perl files. I have the entire database backed up (do this each Friday) so the table structure and all data are available, but I've no idea how to trace a transaction from one account to another (there are ids for each row), but it's likely to not be straight-forward; little in the program is. What I would appreciate is having someone proficient in perl assemble a schema from the code. I use only a small portion of the application (which was designed as a product manufacturing system) so there are probably not too many perl modules involved. I could provide a row count from each table is that's helpful. I'm open to any and all suggestions and advice. Carpe weekend, Rich _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
