bibabutze
7th April 2009, 15:19
Hi experts,

i have to export text data from baan into another erp software which uses HTML to display text.

Is there a direct way to export text Data from BAAN into HTML.
If not, export to a simple txt, csv file also would be fine.

The only thing i know, is that the text data is stored in
table tttxt010 and tttxt003.

cu BIBA

_Ralph_
7th April 2009, 17:02
You can do a program that read the text and write it on a file.. use text.to.buf() to handle the text and refers to Directory and file operations on the manual to work with the file.

bibabutze
8th April 2009, 08:52
do you have an example for this script?

mels.de.zeeuw
8th April 2009, 10:33
Try using the qptool command

For example is you want to extract data from table tttxt010 in company 926, use the following command:
qptool -c 926 -q "select * from tttxt010"