Re: [sqlite] [Importing CSV] Empty colums != NULL?

For other newbies' benefit: Yes, indeed, importing empty columns doesn't set them to NULL. UPDATE Shops SET "contact:postcode" = NULL WHERE "contact:postcode" = ""; UPDATE Shops SET "addr:postcode" = NULL WHERE "addr:postcode" = ""; SELECT name, IFNULL("contact:postcode","addr:postcode") zipcode

[sqlite] [Importing CSV] Empty colums != NULL?

Hello, I imported data from a CSV file. Some of the columns are empty, so I expected them to be set to NULL, but it looks like it's not how SQLite handles them internally: = sqlite> .schema CREATE TABLE Shops( "id" TEXT, "name" TEXT, "contact:postcode" TEXT, "contact:city" TEXT,

Re: [sqlite] importing csv

Dear Alan: I have implemente an application that I name as ExcelToSQLite and his counterpart SQLiteToExcel. If you want, I can sent to you. Your Ing. Héctor F. Fiandor Rosario ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] sqlite importing csv

many thanks again for the replies and sorry I was amiss in not stating that it was sqlite3 DXCC.db, I was using the .db suffix but to no avail, however the problem has been that I was not getting it into the right folder to enter the import command. Thanks Bill you hit it on the nose,

Re: [sqlite] sqlite importing csv

ght clicking on the folder, then select "Open command window here". This is an alternative to cd-ing to the folder from a default starting location. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Alan Sent: Thursda

Re: [sqlite] sqlite importing csv

nglists.sqlite.org> > Subject: Re: [sqlite] sqlite importing csv > > By the way I have a folder C:\jt65Logger that contains all the databases etc > to > do with the project. > > > ___ > sqlite-users mailing li

Re: [sqlite] sqlite importing csv

On 2016/08/25 9:35 AM, Alan wrote: Simon, I entered what you asaked and no, that file is in the users\John directory so I guess that the cmd sqlite3 DXCC is not shifting the focus to the directory that the DXCC database is in and i would need to be using some other set of commands to

Re: [sqlite] sqlite importing csv

By the way I have a folder C:\jt65Logger that contains all the databases etc to do with the project. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite importing csv

Simon, I entered what you asaked and no, that file is in the users\John directory so I guess that the cmd sqlite3 DXCC is not shifting the focus to the directory that the DXCC database is in and i would need to be using some other set of commands to make that happen Alan On 25-Aug-16

Re: [sqlite] sqlite importing csv

after clicking on the command it is in C:\users\john after typing sqlite3 DXCCit shows sqlite> if I then enter cd it shows ...> On 25-Aug-16 18:01, Simon Slavin wrote: On 25 Aug 2016, at 6:59am, Alan wrote: I right Clicked on start and selected the windows

Re: [sqlite] sqlite importing csv

[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: Thursday, 25 August, 2016 01:02 To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] sqlite importing csv On 25 Aug 2016, at 6:59am, Alan <zl...@clear.net.nz> wrote

Re: [sqlite] sqlite importing csv

On 25 Aug 2016, at 6:59am, Alan wrote: > I right Clicked on start and selected the windows cmd, and as I understand > it at the moment > > by typing sqlite3 DXCC then it should be sitting in the directory or folder > that the DXCC database is in I don't think this is

Re: [sqlite] sqlite importing csv

I have created a directory for the project I am working on, and the Database and the csv file both reside in that directory. I right Clicked on start and selected the windows cmd, and as I understand it at the moment by typing sqlite3 DXCC then it should be sitting in the directory or

Re: [sqlite] sqlite importing csv

On 25 Aug 2016, at 4:03am, Alan wrote: > attempt to import a short test Excel table > of two columns with about 4 records in it, the main one I was trying to > import had the same trouble > with, it had over 300 records in it with two columns. Issue this command: sqlite3

Re: [sqlite] sqlite importing csv

On Aug 24, 2016 10:25 PM, "Alan" wrote: > > forgot to reply to one of the questions. > > I am using version 3.13.0.0 and it is 64 bit > > I am running Windows 10 Pro > > computer is intel I3 3.5Ghz with 8Gb RAM. > > As my friend has no problem loading the same csv file with

Re: [sqlite] sqlite importing csv

forgot to reply to one of the questions. I am using version 3.13.0.0 and it is 64 bit I am running Windows 10 Pro computer is intel I3 3.5Ghz with 8Gb RAM. As my friend has no problem loading the same csv file with his Windows7 computer I am guessing that it may be to do with running

Re: [sqlite] sqlite importing csv

HI Guys really appreciate all your replies.What I am doing at present is to attempt to import a short test Excel table of two columns with about 4 records in it, the main one I was trying to import had the same trouble with, it had over 300 records in it with two columns. the test one has

Re: [sqlite] importing csv

Alan, if you are new to sqlite3 then let me give you a little heads up on something that tripped me up a couple of times in early days. I am assuming you are the command line sqlite3 interface which will require you to set the separator for data imports. .separator , ...is likely what you want

Re: [sqlite] importing csv

Windows requires that you escape the \ in the path, effectively doubling them up. Regards. Brian P Curley On Aug 24, 2016 8:24 PM, "Simon Slavin" wrote: > I hope someone else can help. > > Does that table already exist in the database file ? > > Is the first line of the

Re: [sqlite] importing csv

I hope someone else can help. Does that table already exist in the database file ? Is the first line of the csv file a line of data or a line of column names ? Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] importing csv

Hi Simon, firstly both the database and the csv files are in ther same folder. I have gone into Windows cmd typed sqlite3 DXCC(database) .mode csv .separator , .import anr.csv DXE(DXCC table) I have also tried putting in the full path to the csv file and unfortunately the same result.

Re: [sqlite] importing csv

On 24 Aug 2016, at 11:04pm, Alan wrote: > Firstly I am very new to sqlite, but I have a problem when trying to > > import a .csv file into a database, getting "cannot open (file).csv" > > I am using Windows10 and wondering if anyone else has had this problem. The program

[sqlite] importing csv

Firstly I am very new to sqlite, but I have a problem when trying to import a .csv file into a database, getting "cannot open (file).csv" I am using Windows10 and wondering if anyone else has had this problem. A friend has been able to import exactly the same csv file but he is using

[sqlite] Importing CSV empty strings as nulls?

Question: I wished to import a CSV file representing nulls as empty strings (nothing between the commas). I observed that the .import command by default imports those as empty strings. A minimalistic example: Let's create a table T with a single column (c) and a file containing only one new

[sqlite] Importing CSV file

Hi, I think I'm getting a bunch of attached fields. Everything is added to the same line, without separators. I've seen it when I read it. I've used: .mode csv table1 .import data.csv table1 .save Data.dat Kind regards, Miguel Fernandes ___

Re: [sqlite] importing CSV with a random empty line at the end

Thanks for the report. Fixed on trunk, here: https://www.sqlite.org/src/info/fc918f7d33 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] importing CSV with a random empty line at the end

Hello, I've taken the time to investigate the problem: only the last parameter is not correctly bound to NULL. May I suggest a patch: --- shell_.c 2014-06-15 14:22:39.0 +0200 +++ shell.c 2014-06-15 14:23:11.0 +0200 @@ -2553,7 +2553,7 @@ "filling the

Re: [sqlite] importing CSV with a random empty line at the end

gwenn, thanks for this. I did not understand what you saw, and then I realized my shell exe was probably too old. I downloaded the new exe and this solves the problem just fine! thanks for your help. gert 2014-06-02 19:03 GMT+02:00 gwenn : > Hello, > I doesn't fail for me

Re: [sqlite] importing CSV with a random empty line at the end

Hello, I doesn't fail for me (it may depend on the constraints on the target table) but the behaviour is unexpected: $ echo "1|test > " > empty.csv $ sqlite3 SQLite version 3.8.4.3 2014-04-03 16:53:12 sqlite> create table test(opt text, data text not null); sqlite> .import empty.csv test

[sqlite] importing CSV with a random empty line at the end

All, I received 100.000 UTF-8 files (average size 50kb) "ready for import" in an SQLite db. 90% of them go fine, but some files have an empty line at the very end of the fine (so an extra EOL before the EOF). Of course, the import fails... Is there an easy way to get rid of that extra empty

Re: [sqlite] Importing CSV File Into Table

r 13, 2012 9:23 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Importing CSV File Into Table > > Hello > > TJM> I am trying to import some data from a csv file to an existing > TJM> table called MasterChargeList. But this is failing with the err

Re: [sqlite] Importing CSV File Into Table

Tilsley, Jerry M. wrote: > sqlite> .import /csv/iv_codes.csv MasterChargeList; > Error: no such table: MasterChargeList; The internal commands of the sqlite3 command-line tool that begin with a period are not delimited with a semicolon, so the semicolon that you have entered is interpreted as

Re: [sqlite] Importing CSV File Into Table

Hello TJM> I am trying to import some data from a csv file to an existing table TJM> called MasterChargeList. But this is failing with the error that the TJM> table does not exist. This is on SQLite 3.6.4 (required to use this TJM> version). See below for details: TJM> sqlite> .import

[sqlite] Importing CSV File Into Table

All, I am trying to import some data from a csv file to an existing table called MasterChargeList. But this is failing with the error that the table does not exist. This is on SQLite 3.6.4 (required to use this version). See below for details: sqlite> .mode csv sqlite> .schema CREATE TABLE

Re: [sqlite] importing CSV data on command-line?

> > I have got to stop working until 3:00am. Your suggestion points to what I > did not verify. The original CSV is much richer with double quoting some > values. The following shows that setting the separator as I was within the > shell does not do what I was expecting: > > I made one that I

Re: [sqlite] importing CSV data on command-line?

On Fri, Oct 14, 2011 at 7:37 AM, Simon Davies wrote: > On 14 October 2011 15:17, James Hartley wrote: > > When attempting to import CSV data, the shell balks... > > and look at what the separator is set to in the .show output... > I have got to

Re: [sqlite] importing CSV data on command-line?

On 14 October 2011 15:17, James Hartley wrote: > When attempting to import CSV data, the shell balks at the command-line but > is otherwise fine when all is done interactively.  I suspect user error, but > I just don't see it. Any insight shared would be greatly appreciated.

[sqlite] importing CSV data on command-line?

When attempting to import CSV data, the shell balks at the command-line but is otherwise fine when all is done interactively. I suspect user error, but I just don't see it. Any insight shared would be greatly appreciated. Thanks. $ ls create_table.sql src.csv $ cat create_table.sql src.csv

Re: [sqlite] Importing csv to SQLite

Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 09/13/2010 04:06 PM, BareFeetWare wrote: >> All this talk of replacing multiple commas with pipes, then replacing pipes >> and so on, though clever and helpful is problematic, cumbersome and even >> comical for a

Re: [sqlite] Importing csv to SQLite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/13/2010 04:06 PM, BareFeetWare wrote: > All this talk of replacing multiple commas with pipes, then replacing pipes > and so on, though clever and helpful is problematic, cumbersome and even > comical for a mature product like SQLite. SQLite

Re: [sqlite] Importing csv to SQLite

BareFeetWare wrote: > All this talk of replacing multiple commas with pipes, then replacing pipes > and so on, though clever and helpful is problematic, cumbersome and even > comical for a mature product like SQLite. > > On 13/09/2010, at 9:53 PM, Simon Slavin wrote: > >> This is true. You

Re: [sqlite] Importing csv to SQLite

All this talk of replacing multiple commas with pipes, then replacing pipes and so on, though clever and helpful is problematic, cumbersome and even comical for a mature product like SQLite. On 13/09/2010, at 9:53 PM, Simon Slavin wrote: > This is true. You are right. You might argue that

Re: [sqlite] Importing csv to SQLite

Rich Shepard wrote: On Mon, 13 Sep 2010, Mithun Nair wrote: When i try importing it into a SQLite table, i get some errors like "expected 2 columns of data but found 1". Later i found that importing a comma separated file into SQlite wont work because a comma is considered as a delimiter by

Re: [sqlite] Importing csv to SQLite

On Mon, 13 Sep 2010, Mithun Nair wrote: > When i try importing it into a SQLite table, i get some errors like > "expected 2 columns of data but found 1". Later i found that importing a > comma separated file into SQlite wont work because a comma is considered > as a delimiter by the the SQLite

Re: [sqlite] Importing csv to SQLite

On 13 Sep 2010, at 11:53am, Mithun Nair wrote: > Its a comma separated file. > When i try importing it into a SQLite table, i get some errors like "expected > 2 columns of data but found 1". Later i found that importing a comma > separated file into SQlite wont work because a comma is

[sqlite] Importing csv to SQLite

Hello everyone, I had a small doubt regarding importing CSV files into SQLite. I have this simple text file with a couple of columns and a few records. Its a comma separated file. When i try importing it into a SQLite table, i get some errors like "expected 2 columns of data but found

[sqlite] importing csv files into a sqlite db?

Let's say I have many csv files (25, to be exact) and want to create a sqlite database out of them? How do I do that? Furthermore, in addition to the 25 text files of data, there are 25 corresponding sql files that define the tables, so does this mean those would have to be rewritten in sqlite?

[sqlite] importing csv files?

anyway to import csv files in sqlite3? .import does not quite work, leaves the quotes in.