SQLite Administrator

zdragon · Post by **zdragon** » 22.02.2006, 12:34

Hi! I copied the SQLite administrator, and would to import a csv file to my DB tables.

the files contain text qualifiers. like (").:
"12345678","00000000","Some text"
"12345678","00000000","another text"
"98765432","00000000","and again new text"

so I created 1 table with 3 fileds . 2 numeric and 1 varchar
and I used Data importer tool from administrator.
and after import opperation, the values in first two columns weren't displayed.
if I edit the table and change the fileds to be varchar .. and values are displayed..

How can I force to import a character value to be numeric as in my case?

Orbmu2k · Post by **Orbmu2k** » 23.02.2006, 08:30

Hi zdragon,

ive tested with your testdata and it works fine for me.

i have tryed the FieldTypes "INTEGER" and "NUMERIC" for the first two columns.

Wich FieldType has you tryed ?

zdragon · Post by **zdragon** » 23.02.2006, 15:14

have you had csv fiel with data enclose in the quotation marks?

Orbmu2k · Post by **Orbmu2k** » 23.02.2006, 15:22

//Edited...

I have taken the test data you've been posting first. But it doesn't matter...the quotation marks will be removed before importation anyway. Only the data between the separators will be imported.

zdragon · Post by **zdragon** » 24.02.2006, 13:33

ok. get an emptuy database and it's ok, .. I think the check box (clear table before import) on import Data dialog doesn't work properly.. because when I made changes I already got data imported as varchar, then I changed the column type to numeric, and normaly the values weren't displayed, then perform once again an import opperaton and tick "Clear table before import".. then I got empty columns..

also . the import opperation is very slow,
it takes about 20 min for 16k rows..

the same table is importer much more faster in MS Access DB ..

Tnx.

aslo, when importing is finished no message are displayed .. just a progress bar iz completed, but who knows if the import is just finished or have to finish in a while..

Orbmu2k · Post by **Orbmu2k** » 24.02.2006, 13:51

in the test session yesterday, i always had clear table checkbox checked ... if the checkbox is checked, only a "delete from table" statement is executed before import.

You got right, the speed of the import is very slowly.
But I have imported 100k rows in 5min on a P4 3,2 HT

The import feature is just a quick implementation, only a "nice to have" feature.
If you often import external data its better to code your own import, based on your special data structure or any datasource.