Forum OpenACS Q&A: Re: SQL-Modelling Costs and Invoices

Collapse
Posted by Torben Brosten on
export from/to?

Some data is coming from excel worksheets (such as 1 worksheet per sale), so have had to build tables. In another case, from filemakerpro, and in another case from postgresql using the psql COPY..TO  All cases have been formated as tab-delimited tables, and processed with the sql-ledger generic import tool linked from the SL conversion[1] page.  I'm working to manually import the rest using psql COPY..FROM (being careful to populate keys etc.)

1. http://sql-ledger.org/cgi-bin/nav.pl?page=misc/conversions.html&title=Conversions

cheers,

Torben