Re: [sqlite] Problems uploading CSV into sqlite3 DB

2014-09-09 Thread Simon Slavin
On 10 Sep 2014, at 3:45am, Carlos A. Gorricho (HGSAS) wrote: > The problem was a field with a very long blank string, something like 40 > space-characters. Was this value correctly delimited with quotes, or was it just 40 spaces between two commas separating the

[sqlite] Problems uploading CSV into sqlite3 DB

2014-09-09 Thread Carlos A. Gorricho (HGSAS)
Dear all, A brief update on how I managed to solve the problem...thank you all for you remarks and comments, since these were instrumental in the solution. Indeed sqlite versions had to do a lot with the problem, where 3.8 can handle csv imports, not without some glitches. I had to go in circles

Re: [sqlite] Problems uploading CSV into sqlite3 DB

2014-09-05 Thread RSmith
Humour us and paste the first 4 lines or so of your CSV text here On 2014/09/05 04:17, Carlos A. Gorricho (HGSAS) wrote: So, any ideas on how to solve this issue will be more than welcome. I have tried several shortcuts...none works. Latest was to install an Ubuntu 14.04 Virtual Machine

Re: [sqlite] Problems uploading CSV into sqlite3 DB

2014-09-04 Thread David Empson
I get similar results on OS X 10.9.4 if I try to use the version of SQLite supplied with the operating system (3.7.13) to import a CSV. The simple ".mode csv" and ".import tab1" method works if I run the copy of SQLite 3.8.5 I built myself from the source code, or if I use the Mac OS X

Re: [sqlite] Problems uploading CSV into sqlite3 DB

2014-09-04 Thread Nelson, Erik - 2
Carlos A. Gorricho (HGSAS) wrote on Friday, September 05, 2014 4:17 AM >So, any ideas on how to solve this issue will be more than welcome. I have >tried several shortcuts...none works. >Latest was to install an Ubuntu 14.04 Virtual Machine on my Mac, via Parallels >software. > Maybe line

Re: [sqlite] Problems uploading CSV into sqlite3 DB

2014-09-04 Thread Carlos A. Gorricho (HGSAS)
So, any ideas on how to solve this issue will be more than welcome. I have tried several shortcuts...none works. Latest was to install an Ubuntu 14.04 Virtual Machine on my Mac, via Parallels software. Downloaded sqlite de Linux way: $ sudo apt-get install sqlite3 Ran the CSV .import protocol

Re: [sqlite] Problems uploading CSV into sqlite3 DB

2014-09-03 Thread Carlos A. Gorricho (HGSAS)
​When I start sqlite double clicking the icon in the Mac Applications folder: Last login: Wed Sep 3 10:13:32 on ttys000 HEPTAGON-GROUP-SAS:~ carlosgorricho$ /Applications/sqlite3 ; exit; SQLite version 3.8.5 2014-06-04 14:06:34 Enter ".help" for usage hints. Connected to a *transient

Re: [sqlite] Problems uploading CSV into sqlite3 DB

2014-09-03 Thread Simon Slavin
On 3 Sep 2014, at 1:51pm, Richard Hipp wrote: > What version of SQLite is installed? Or rather, when you start the shell tool 'sqlite3' what version does it report itself as ? Simon. ___ sqlite-users mailing list