Export - Import upgrade 1.3.43 1.4.1

[Louis <..hidden..>]

Ok, I'll gird my loins and give it a go.



> 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.

We have inventory in the form of used and rare books. Each book is unique 
and cost will be the original purchase price, which can be $0.


> 2.  Besides inventory, customers, vendors, parts, and balances, what 
> else do you need to import?

Import:

2014 transactions

vendors with transactions since 2010-01-01
customers with transactions since 2010-01-01


Re-enter, re-create:

COA to get rid of accounts unused in the last few years.

Sales taxes (Colorado is always messy)

I think that would do it.


> 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.


I suspect, as is often the case, the hard part will be making up my mind.

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-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel