TIMPORT problem with blob field

sourceuno · Post by **sourceuno** » Wed Aug 08, 2001 12:54 pm

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?

Post by **John** » Wed Aug 08, 2001 1:16 pm

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?

sourceuno · Post by **sourceuno** » Wed Aug 08, 2001 2:07 pm

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

Post by **John** » Wed Aug 08, 2001 4:17 pm

Tried with your schema, and it worked. Do you have unquoted newlines or separators in the text?

sourceuno · Post by **sourceuno** » Wed Aug 08, 2001 6:24 pm

There might be unquoted newlines in the Body field. How would I go about quoting those? With sandr?

Post by **John** » Wed Aug 08, 2001 10:51 pm

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"|...