Page 1 of 1
TIMPORT problem with blob field
Posted: Wed Aug 08, 2001 12:54 pm
by sourceuno
I'm using the new Texis 64bit version for NT. I want to export my data into a csv. The csv contains a blob field that seems to have trouble being imported back into Texis using TIMPORT. When I check the blob field in the Texis table, it's empty. Also the fields after the blob field aren't being imported correctly. Do I need to do something special to TIMPORT a blob field from the csv?
TIMPORT problem with blob field
Posted: Wed Aug 08, 2001 1:16 pm
by John
There shouldn't need to be anything special that needs to be done. We were able to TIMPORT blob fields without issue with that version of Texis. What does your schema file look like?
TIMPORT problem with blob field
Posted: Wed Aug 08, 2001 2:07 pm
by sourceuno
Here's my schema file:
database /BoardDB
droptable tech
table tech
noid
keepfirst
csv |
# name type tag default_val
field id counter 1
field forumid varchar(15) 2
field ThreadID varchar(10) 3
field SiteURL varchar(80) 4
field Visited date 5
field Dlsecs int 6
field Url varchar(80) 7
field Title varchar(80) 8
field Body blob 9
field LastPost date 10
field Replies int 11
field yearrangebegin int 12
field yearrangeend int 13
field SiteType varchar(20) 14
field Active int 15
field Metadata blob 16
TIMPORT problem with blob field
Posted: Wed Aug 08, 2001 4:17 pm
by John
Tried with your schema, and it worked. Do you have unquoted newlines or separators in the text?
TIMPORT problem with blob field
Posted: Wed Aug 08, 2001 6:24 pm
by sourceuno
There might be unquoted newlines in the Body field. How would I go about quoting those? With sandr?
TIMPORT problem with blob field
Posted: Wed Aug 08, 2001 10:51 pm
by John
How are you generating the CSV? It should be fairly easy to put double-quotes around the entire field as it is being output in Vortex without resorting to sandr.
...|"$Title"|"$Body"|...