On Tue, Sep 23, 2014 at 9:34 AM, Louis <lbml...@hethcote.com> wrote:
>
> I have a fairly messed up database with my 1.3.x lsmb. It has data going
> back to 1997 which has been migrated from QuickBooks to SQL-Ledger to
> LedgerSMB 1.2 to LedgerSMB 1.3 (which exposed many of these issues).
>
> Rather than trying to upgrade the data in-place, I suspect it would be
> better to export from 1.3 and import into 1.4 to help get a cleaner
> database.
>
> It may also be useful to roll up the detail from say, 1997 to 12/31/2009.
>
> Are there tools available for this, am I looking at a consulting gig, or
> maybe writing it for myself?
>
There aren't current tools. I could do some consulting to export/import if
you need it.
As for writing it yourself, I don't think it would be too difficult. There
are some important questions to ask before going into it though:
1. Do you have inventory? If so, how do you want to value the inventory
for import purposes? For example you could export/import each item at
current value. You could import current onhand at current average cost,
etc.
2. Besides inventory, customers, vendors, parts, and balances, what else
do you need to import?
I would be happy to provide a basic overview of how I would go about such a
process on the -devel list. Chances are the tools used are likely to be
SQL, the PostgreSQL COPY statement, a spreadsheet of your choice, and
pg_dump. I think for the most part, it is likely to be relatively easy.
>
> Sign me as, "beginning to sweat"
>
> Louis
>
>
> ------------------------------------------------------------------------------
> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>
> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
> _______________________________________________
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
