Hi David; On Tue, Oct 4, 2011 at 12:30 PM, Dave Babb <[email protected]> wrote: > I am not an SQL savvy individual. As I am moving test data from a QuickBooks > generated CSV file that has been reordered to match the table structure of a > given entity within LedgerSMB, I have need of generating that ID field when I > do so. > > The line I'm using to import data from the properly organized CSV file is: > > "ACI=# copy employee from > '/home/dcbdbis/Documents/ACI-CSV-Files/ReorganizedEmployee.csv' with delimiter > as ',';" > you can specify the fields to import after the table name like: copy employee (employeenumber, .....) FROM
Other fields would then be filled in with defaults. If you'd like detailed help this could end up diving into the db schema pretty heavily, I'd suggest we pick this one up on the -devel list. Best Wishes, Chris Travers ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
