Re: [sqlite] Importing data into SQLite

T wrote: > > You can use the sqlite binary to import data from a CSV file - if you do it > that way you have to make sure that your data fields in the SQLite database > match exactly in order the data in the CSV file. That's been my experience. > The other way is to do it programmatically

Re: [sqlite] Importing data into SQLite

://www.nabble.com/Importing-data-into-SQLite-tp25224025p25538942.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Importing data into sqlite

Hi All, I'm still investigating the most effective way to import the db into sqlite that we are using as our embedded database. Of the following options, which one do you think works best, and is most extensible and future-proof? 1) Make a tab/csv delimited file with database, and install it

Re: [sqlite] Importing data into SQLite - text files are not really portable

> > - Original Message - > From: "Jean-Denis Muys" <jdm...@kleegroup.com> > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Sent: Wednesday, September 09, 2009 6:09 AM > Subject: Re: [sqlite] Importing data into

Re: [sqlite] Importing data into SQLite - text files are not really portable

reasons. - Original Message - From: "Jean-Denis Muys" <jdm...@kleegroup.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Wednesday, September 09, 2009 6:09 AM Subject: Re: [sqlite] Importing data into SQLite - text files are not

Re: [sqlite] Importing data into SQLite - text files are not really portable

On 9/8/09 22:24 , various people wrote: > Unfortunately, the 3 main families of small computer operating systems > have 3 different definitions of what a text file is... > > DOS/Windows (PC): lines are terminated with CR+LF > Unix: lines are terminated with LF > Macintosh: lines are terminated

Re: [sqlite] Importing data into SQLite - text files are not really portable

s-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kavita Raghunathan > Sent: Tuesday, September 08, 2009 2:14 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Importing data into SQLite > > FYI: Mac excel does not separate rows with \r,

Re: [sqlite] Importing data into SQLite

On 8 Sep 2009, at 9:48pm, Robert Citek wrote: > Just a guess, but you may be running into issues with the end-of-line > character as they are different under linux (\n), Mac (\r), and > Windows/DOS (\r\n). > > Linux has a tool to convert Windows/DOS end-of-lines to linux-style > called dos2unix.

Re: [sqlite] Importing data into SQLite

Just a guess, but you may be running into issues with the end-of-line character as they are different under linux (\n), Mac (\r), and Windows/DOS (\r\n). Linux has a tool to convert Windows/DOS end-of-lines to linux-style called dos2unix. There may be one for Mac, too, but I'm not sure. If not,

Re: [sqlite] Importing data into SQLite - text files are not really portable

On Tue, 8 Sep 2009, Ribeiro, Glauber wrote: > Unfortunately, the 3 main families of small computer operating systems > have 3 different definitions of what a text file is... > > This causes no end of trouble when moving text files between these kinds > of systems. I've never worked with a Mac

Re: [sqlite] Importing data into SQLite - text files are not really portable

-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kavita Raghunathan Sent: Tuesday, September 08, 2009 2:14 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Importing data into SQLite FYI: Mac excel does not separate rows with \r, but inserts a ^M instead

Re: [sqlite] Importing data into SQLite

: "Kavita Raghunathan" <kavita.raghunat...@skyfiber.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Tuesday, September 8, 2009 11:47:38 AM GMT -08:00 US/Canada Pacific Subject: Re: [sqlite] Importing data into SQLite Yes, this works. Mus

Re: [sqlite] Importing data into SQLite

ion of SQLite Database" <sqlite-users@sqlite.org> Sent: Monday, September 7, 2009 9:08:41 AM GMT -08:00 US/Canada Pacific Subject: Re: [sqlite] Importing data into SQLite On Sun, Sep 6, 2009 at 9:32 PM, Kavita Raghunathan<kavita.raghunat...@skyfiber.com> wrote: > Timothy and a

Re: [sqlite] Importing data into SQLite

Sounds good. Let us know how things go. P.S. one thing to try may be to use dos2unix to convert any text files created in the Windows/DOS world to unix-format text files. Regards, - Robert On Mon, Sep 7, 2009 at 7:22 PM, Kavita Raghunathan wrote: > The

Re: [sqlite] Importing data into SQLite

On 8 Sep 2009, at 1:22am, Kavita Raghunathan wrote: > I'm using the latest version downloaded last week: amalgamate 3-6-17. > > Robert, > The difference between what you did and what I did was perhaps that > I had excel make the .csv file, and maybe the excel version had > something > to do

Re: [sqlite] Importing data into SQLite

Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Monday, September 7, 2009 11:08:41 AM GMT -06:00 US/Canada Central Subject: Re: [sqlite] Importing data into SQLite On Sun, Sep 6, 2009 at 9:32 PM, Kavita Raghunathan<kavita.raghunat...@skyfiber.com> wrote: > Timot

Re: [sqlite] Importing data into SQLite

On Sun, Sep 6, 2009 at 9:32 PM, Kavita Raghunathan wrote: > Timothy and all, > When I try to import a .csv, I get a segmentation fault: > 1) First I set .seperator to , > 2) Then I type .import > 3) I see "Segmentation fault" > > Any ideas ? Here's an example of

Re: [sqlite] Importing data into SQLite

On Sep 7, 2009, at 9:32 AM, Kavita Raghunathan wrote: > Timothy and all, > When I try to import a .csv, I get a segmentation fault: > 1) First I set .seperator to , > 2) Then I type .import > 3) I see "Segmentation fault" Which version of SQLite is this happening with?

Re: [sqlite] Importing data into SQLite

diary.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Monday, August 31, 2009 9:11:32 AM GMT -06:00 US/Canada Central Subject: Re: [sqlite] Importing data into SQLite You can use the sqlite binary to import data from a CSV file - if you do it that way y

Re: [sqlite] Importing data into SQLite

rg:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Importing-data-into-SQLite-tp25224025p25235055.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list s

Re: [sqlite] Importing data into SQLite

> I'm evaluating SQLite to be used as a small embedded database in a linux > environment for Skyfiber Inc. What is the best way to import data into it > ? I have a bunch of entities and attributes in an excel spreadsheet. Could > I import CSV ? What should be the columns (where can I read about

Re: [sqlite] Importing data into SQLite

nt: Monday, August 31, 2009 7:11:32 AM GMT -08:00 US/Canada Pacific Subject: Re: [sqlite] Importing data into SQLite You can use the sqlite binary to import data from a CSV file - if you do it that way you have to make sure that your data fields in the SQLite database match exactly in order the data

Re: [sqlite] Importing data into SQLite

On Mon, Aug 31, 2009 at 10:02 AM, Kavita Raghunathan wrote: > Hi, > I'm evaluating SQLite to be used as a small embedded database in > a linux environment for Skyfiber Inc. What is the best way to import data > into it ? .import > I have a bunch of entities and

Re: [sqlite] Importing data into SQLite

...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kavita Raghunathan Sent: Monday, August 31, 2009 10:02 AM To: sqlite-users@sqlite.org Subject: [sqlite] Importing data into SQLite Hi, I'm evaluating SQLite to be used as a small embedded database in a linux environment for Skyfiber Inc

[sqlite] Importing data into SQLite

Hi, I'm evaluating SQLite to be used as a small embedded database in a linux environment for Skyfiber Inc. What is the best way to import data into it ? I have a bunch of entities and attributes in an excel spreadsheet. Could I import CSV ? What should be the columns (where can I read about

Re: [sqlite] importing data to sqlite from stdin

> Hi there, > This Talend you mentioned caught my eye. Can one use this tool as a > general database browser tool. > Palmer > >> Date: Mon, 29 Jun 2009 08:56:58 -0700 >> From: g...@talend.com >> To: sqlite-users@sqlite.org >> Subject: Re: [sqlite] importing data to sq

Re: [sqlite] importing data to sqlite from stdin

Hi there, This Talend you mentioned caught my eye. Can one use this tool as a general database browser tool. Palmer > Date: Mon, 29 Jun 2009 08:56:58 -0700 > From: g...@talend.com > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] importing data to sqlite from stdin > >

Re: [sqlite] importing data to sqlite from stdin

select count(*) from foo; ' > 100 > > Regards, > - Robert > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context:

[sqlite] importing data to sqlite from stdin

On occasion I have had a need to import large amounts of data from standard input via a pipe. Here's an example of how to import from a pipe using sqlite3 on Ubuntu: $ { grep -v '^#'