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 (Java
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 (Java, C++, etc). The adv
- Original Message -
> From: "Jean-Denis Muys"
> To: "General Discussion of SQLite Database"
> Sent: Wednesday, September 09, 2009 6:09 AM
> Subject: Re: [sqlite] Importing data into SQLite - text files are not
> really portable
>
>
>>
>
patibility reasons.
- Original Message -
From: "Jean-Denis Muys"
To: "General Discussion of SQLite Database"
Sent: Wednesday, September 09, 2009 6:09 AM
Subject: Re: [sqlite] Importing data into SQLite - text files are not
really portable
>
> On 9/8/09 22:24 , vari
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 w
t; From: sqlite-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 sep
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.
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,
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
qlite-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 in
: "Kavita Raghunathan"
To: "General Discussion of SQLite Database"
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. Must have been my original csv file.
I was using mac based excel and I&
t;
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 wrote:
> Timothy and all,
> When I try to import a .csv, I get a segmentation fault:
> 1) First I set .seperator to
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 difference between what you did and what I
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 wit
SQLite Database"
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 wrote:
> Timothy and all,
> When I try to import a .csv, I get a segmentation fault:
> 1)
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 how it worked for me.
$ cat data
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?
___
of SQLite Database"
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 you have to make sure that your data fields in the SQLite database
m
You can use http://www.sqliteexpert.com/
its not expensive
cheers
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
> ? I have a bunch of entities and attribut
> 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
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 in the CSV file. That's been my experience.
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 attributes in an excel spreadsheet
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 (Java, C++, etc). The advant
23 matches
Mail list logo
