I have a csv file that is delimited with a "|". I have a database with one table named documentsize. My timport schema is:
database /webroot/texis/jake/db
table documentsize
csv |
multiple
keepfirst
# name type tag default
field Url VARCHAR(255) 1 UNKNOWN
field bytes INTEGER 2 -1
The documentsize table is created as:
documentsize(id COUNTER,Url VARCHAR(255),bytes INTEGER)
Some data in the file is:
http://somesite.com/|24567
http://somesite.com/?id=43252|54325
When I run timport from the command line:
timport -s /webroot/texis/jake/timportSchema.txt /webroot/texis/jake/input.txt
I get the following output:
200 Reading schema /webroot/texis/jake/timportSchema.txt
200 Connecting to server
200 Opening database /webroot/texis/jake/db
200 Verifying schema
200 Loading data
After 10 minutes I still don't have any data loaded into the table and I don't understand why. If I run timport with the -D flag I get:
200 Reading schema /webroot/texis/jake/timportSchema.txt
200 Loading data
300 Row 1
301 0 documentsize.id=counter
301 160 documentsize.Url="http://somesite.com/"
301 5 documentsize.bytes="24567"
300 Row 2
301 0 documentsize.id=counter
301 160 documentsize.Url="http://somesite.com/?id=43252"
301 5 documentsize.bytes="54325"
So it looks like I am getting the values out of my file but they are not getting inserted into the database. I thought this was automatically done with the command line timport.
database /webroot/texis/jake/db
table documentsize
csv |
multiple
keepfirst
# name type tag default
field Url VARCHAR(255) 1 UNKNOWN
field bytes INTEGER 2 -1
The documentsize table is created as:
documentsize(id COUNTER,Url VARCHAR(255),bytes INTEGER)
Some data in the file is:
http://somesite.com/|24567
http://somesite.com/?id=43252|54325
When I run timport from the command line:
timport -s /webroot/texis/jake/timportSchema.txt /webroot/texis/jake/input.txt
I get the following output:
200 Reading schema /webroot/texis/jake/timportSchema.txt
200 Connecting to server
200 Opening database /webroot/texis/jake/db
200 Verifying schema
200 Loading data
After 10 minutes I still don't have any data loaded into the table and I don't understand why. If I run timport with the -D flag I get:
200 Reading schema /webroot/texis/jake/timportSchema.txt
200 Loading data
300 Row 1
301 0 documentsize.id=counter
301 160 documentsize.Url="http://somesite.com/"
301 5 documentsize.bytes="24567"
300 Row 2
301 0 documentsize.id=counter
301 160 documentsize.Url="http://somesite.com/?id=43252"
301 5 documentsize.bytes="54325"
So it looks like I am getting the values out of my file but they are not getting inserted into the database. I thought this was automatically done with the command line timport.