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 ',';" Of course it's having an issue with the ID field. This may be a dumb question to SQL savvy folks out there (which I am not), but how do I tell SQL to generate that ID field for itself for indexng/sorting purposes? I have been told that this field should not be manually manipulated. Do I need to leave a blank field for it (as it is the first field) in the CSV file, and/or do I need to put into it some special contents that would trigger SQL to generate this field? Or something else? Assistance will be appreciated. Sincerely and respectfully, Dave ------------------------------------------------------------------------------ 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
