[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Importing Data
- Subject: Re: Importing Data
- From: Chris Travers <..hidden..>
- Date: Tue, 4 Oct 2011 12:44:06 -0700
On Tue, Oct 4, 2011 at 12:30 PM, Dave Babb <..hidden..> 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