Table not updating with timport

Post Reply
mjacobson
Posts: 204
Joined: Fri Feb 08, 2002 3:35 pm

Table not updating with timport

Post by mjacobson »

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.
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

Table not updating with timport

Post by mark »

Yes, command line timport will insert the records. If -D is working as expected there must be some issue with the database. Perhaps the table is locked? Watch the database with ltest before and during the timport run. Is timport using cpu?
Post Reply