[sqlite] datetime result help

On 2015-07-31 03:37 PM, jose isaias cabrera wrote: > > How much I owe you? :-) The holidays was the next question. ;P > Thanks. This will help me understand CTE much deeper/better. Thanks. > The help is a pleasure, but those CTEs were hacked together to solve the date-time conundrum you've

[sqlite] CSV excel import

On 2015-08-01 05:42 PM, Jean-Christophe Deschamps wrote: > > At 16:36 01/08/2015, Igor wrote: > >> There are many real problems with CSV - no need to make up imaginary >> ones. > `--- > Indeed and I'm surprised noone mentionned this from the very start of > this thread: Nulls. There is no

[sqlite] CSV excel import

At 16:36 01/08/2015, Igor wrote: >There are many real problems with CSV - no need to make up imaginary ones. `--- Indeed and I'm surprised noone mentionned this from the very start of this thread: Nulls. There is no real provision in the RFC to represent Null, or distinguish Null from an

[sqlite] CSV excel import

On 1 Aug 2015, at 4:42pm, Jean-Christophe Deschamps wrote: > Indeed and I'm surprised noone mentionned this from the very start of this > thread: Nulls. There is no real provision in the RFC to represent Null, or > distinguish Null from an empty string. Just to deambiguate that, the first is

[sqlite] CSV excel import

On 1 Aug 2015, at 3:25pm, Bernardo Sulzbach wrote: >> P.S. As Simon noted, it seems to be defined here: >> > >> I was probably referring to the first sentence of chapter 2: "While there >> are various specifications and implementations for the CSV

[sqlite] datetime result help

"R.Smith" wrote... > > On 2015-07-31 03:37 PM, jose isaias cabrera wrote: >> >> How much I owe you? :-) The holidays was the next question. ;P Thanks. >> This will help me understand CTE much deeper/better. Thanks. >> > > The help is a pleasure, but those CTEs were hacked together to solve the

[sqlite] CSV excel import

+1 for the use of R for this task. I use the below if the file is in XLSX format: library(sqldf) library(openxlsx) df <- read.xlsx("mytable.xlsx", sheet=1, startRow=1, colNames=TRUE) db <- dbConnect(SQLite(), "mydatabase.db") dbWriteTable(db, "mytable", df) On Sat, Aug 1, 2015 at 8:13 AM, Gabor

[sqlite] CSV excel import

Or use read.csv() followed by dbWriteTable from package RSQLite. Or read.DIF() as the case may be (the DIF format for spreadsheets being simpler than XLS). Today, Gabor Grothendieck wrote: > > Here is how to do it in R. Download, install and start R and then > paste the following code into R.

[sqlite] CSV excel import

On 8/1/2015 12:38 PM, R.Smith wrote: > if I have this csv line, what values must the parser end up with?: > > 1, "2", "3" 4, 5 "6", 7 This is not a valid line of CSV, at least not as specified in RFC 4180. Therefore, RFC 4180-conforming parsers may differ in their interpretation of this line.

[sqlite] CSV excel import

> On 1 Aug 2015, at 2:09am, Bernardo Sulzbach > wrote: > >> =CONCATENATE("INSERT INTO myTable VALUES (",a1,","a2");") > > This is so neat. Supposing you are not migrating from a spreadsheet > because it got too big (millions of rows will take a time for this to > finish) and that your data

[sqlite] CSV excel import

Scott is right in the myriads of combination in handling csv/text file. Check out "Text File Reader for SQLite" at https://github.com/elau1004/TFR4SQLite/wiki Hope it meet some or all the needs dealing with importing text file. Since it is implemented as virtual table, one need to select the

[sqlite] CSV excel import

Along the lines virtual table, check out "Text File Reader for SQLite" at https://github.com/elau1004/TFR4SQLite/wiki Hope it meet some or all the needs dealing with importing text. file Since it is virtual table, one need to select the text and insert it into a table. -Original

[sqlite] FTS5 Porter extra arguments not passed through

On 07/31/2015 03:48 AM, Ralf Junker wrote: > As per the documentation, extra arguments to the Porter stemmer are > handed on to the underlying tokenizer: > > http://www.sqlite.org/docsrc/artifact/9eca0ea509ae3e4d?ln=544-546 > > Example syntax a few lines below: > >

[sqlite] CSV excel import

Toimport a text into a sqlite: this link could be useful: http://www.gaia-gis.it/gaia-sins/spatialite-tutorial-2.3.1.html CREATE VIRTUAL TABLE books USING VirtualText(books.txt, CP1252, 1, COMMA, DOUBLEQUOTE, ','); Regards, A. 2015-08-01 11:43 GMT+02:00 Andrea Peri : > Hi, > to import from

[sqlite] CSV excel import

Hi, to import from excel and from csv I use the spatialite extension for sqlite. With that extension, I import directly an excel table, and to import the csv, using that extension is possibile tohave a virtual table for text and csv. https://www.gaia-gis.it/fossil/libspatialite/index In the same

[sqlite] CSV excel import

> P.S. As Simon noted, it seems to be defined here: > > I was probably referring to the first sentence of chapter 2: "While there are > various specifications and implementations for the CSV format" OK for that document existing and all, but just a quotes:

[sqlite] CSV excel import

On 30-7-2015 20:31, Sylvain Pointeau wrote: > On Thu, Jul 30, 2015 at 8:17 PM, Luuk wrote: > >> On 30-7-2015 20:07, Richard Hipp wrote: >> >>> On 7/30/15, Sylvain Pointeau wrote: >>> An Excel-to-SQLite converter utility sounds like it would be a great >>> open-source project. Why don't you

[sqlite] CSV excel import

On 8/1/2015 10:25 AM, Bernardo Sulzbach wrote: >> P.S. As Simon noted, it seems to be defined here: >> > >> I was probably referring to the first sentence of chapter 2: "While there >> are various specifications and implementations for the CSV format" > > OK

[sqlite] CSV excel import

Here is how to do it in R. Download, install and start R and then paste the following code into R. Uncomment the first line (the line starting with a hash) if you don't already have sqldf installed. This not only installs sqldf but also the RSQLite driver and SQLite itself. The code assumes

[sqlite] Can you enable Recursive Triggers via the connection string?

I hope this is the right address to send my questions to. I found this mailing list on the SQLite.org site under the ?Support? section. In short, can you enable Recursive Triggers via the connection string? I?ve read in some places that you can specify PRAGMA statements on

[sqlite] CSV excel import

Python with either xlrd or openpyxl. Why use a multiplicity when one programming environment will do? > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of Bernardo Sulzbach > Sent: Friday,

[sqlite] fts5 module does not build from the 3.8.11 release's source tarball

On 07/31/2015 09:51 PM, Hinrichsen, John wrote: > Update: > > I don't have a problem compiling under centos 7 (gcc 4.8.3), but with > centos 6 (gcc 4.4.7) I do get this error. > > fts5_main.c:30: error: redefinition of typedef 'Fts5Global' > fts5Int.h:83: note: previous declaration of 'Fts5Global'