I tried this, actually, that was the same thing I tried before and got the "Not enough space" problem. Please see item 5 of the conversation above. Here it is, what I tried,
<sandr "<=/?rs:data>" "" $data><$data=$ret>
<timport row "xml
field DOCID varchar(255) xml/z:row@DOCID
field AUTHOR varchar(255) xml/z:row@AUTHOR
field DOCTEXT blob xml/z:row@DOCTEXT" $data>
interestingly I kinda figured out the problem is having the DOCTEXT with the blob there. The error I get is,
DOCID: CRD000000001_MSG
<!-- 011 skimport:18: Not enough space -->
If I take out the line ,
field DOCTEXT blob xml/z:row@DOCTEXT
from the schema it works.
It seems to work with using a varchar in the place of blob of the schema, like
field DOCTEXT varchar xml/z:row@DOCTEXT
instead of
field DOCTEXT blob xml/z:row@DOCTEXT
But do you think I will miss any data if I do this?
There's no real difference between varchar and blob in timport. They only control how texis ultimately stores the data on disk. Since timport in vortex never stores any data it doesn't matter. Use whichever works for you.