Re: [sqlite] [3.5.4] Fails importing CSV file

2008-02-05 Thread Gilles
Dennis At 11:01 04/02/2008 -0700, Dennis Cote wrote: >You will need to do your import in two steps. First import into a temp >table without the integer primary key column. Thanks a bunch for the explanation and the how-to. The accented characters are displayed funny when SELECTed in the DOS com

Re: [sqlite] [3.5.4] Fails importing CSV file

2008-02-04 Thread John Machin
Gilles wrote: > At 22:47 04/02/2008 +1100, John Machin wrote: > >> Well, obviously(?) you are closer to success with "\t" than with '\t'. >> You probably have an extra unseen TAB. It won't like that NULL. >> > > Thanks, but no matter what I try, it doesn't work: > - just two columns, assu

Re: [sqlite] [3.5.4] Fails importing CSV file

2008-02-04 Thread Dennis Cote
Gilles wrote: > At 22:47 04/02/2008 +1100, John Machin wrote: >> Well, obviously(?) you are closer to success with "\t" than with '\t'. >> You probably have an extra unseen TAB. It won't like that NULL. > > Thanks, but no matter what I try, it doesn't work: > - just two columns, assuming it will

Re: [sqlite] [3.5.4] Fails importing CSV file

2008-02-04 Thread Gilles
At 22:47 04/02/2008 +1100, John Machin wrote: >Well, obviously(?) you are closer to success with "\t" than with '\t'. >You probably have an extra unseen TAB. It won't like that NULL. Thanks, but no matter what I try, it doesn't work: - just two columns, assuming it will just increment the primar

Re: [sqlite] [3.5.4] Fails importing CSV file

2008-02-04 Thread John Machin
Gilles wrote: > At 02:27 04/02/2008 +0100, Gilles wrote: > >> Thanks for the tip, but I tried that too, with no success: >> > > I tried both: > > sqlite> .separator "\t" > sqlite> .import test.csv customer > test.csv line 1: expected 3 columns of data but found 4 > > sqlite> .separator '\t'

Re: [sqlite] [3.5.4] Fails importing CSV file

2008-02-03 Thread Gilles
At 02:27 04/02/2008 +0100, Gilles wrote: >Thanks for the tip, but I tried that too, with no success: I tried both: sqlite> .separator "\t" sqlite> .import test.csv customer test.csv line 1: expected 3 columns of data but found 4 sqlite> .separator '\t' sqlite> .import test.csv customer test.csv

Re: [sqlite] [3.5.4] Fails importing CSV file

2008-02-03 Thread Gilles
At 23:42 03/02/2008 +, Robert Wishlaw wrote: >Instead of > >.separator "\t" > >try > >.separator '\t' Thanks for the tip, but I tried that too, with no success: # cat test.csv NULL123-4567John Doe (Note: I just replaced 09 with to show you) # sqlite3 db.sqlite SQLite version 3.5.4 Enter ".h