Re: Export - Import upgrade 1.3.43 1.4.1

On Thu, Oct 2, 2014 at 2:23 PM, Louis <..hidden..> wrote:

On Mon, 29 Sep 2014, Chris Travers wrote:

2. Entities tables (customers/vendors) can be dumped and reloaded as is:
entity, company, person, entity_credit_account, location, eca_to_contact, eca_to_location, users

A goal of an export/import is to clean up such items as the control_code and the various id columns, and to limit the import to current relevant records.

Are you thinking that one does a pg_dump of the tables and then edit them for consistancy prior to loading them into the new db?

You could do that. Another trick is to do COPY table TO file WITH CSV;

Then that makes it easy to edit the data in a spreadsheet of your choice. Then after db creation you can:

COPY table FROM file WITH csv;

And if the schema has changed, you can specify a column list.

Best Wishes,
Chris Travers

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

Best Wishes,

Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.

http://www.efficito.com/learn_more