CarlosC
7th May 2007, 13:06
hi,
I´ve got the next problem.
I would like to export data from Baan to XML....this is my code

A Query.....and
Selectdo
xml_mainnode = xmlNewNode("LOTE", XML_ELEMENT, xml_fileid)
retVal = xmlNewDataElement("NUMERO", tfcmg403.btno,xml_mainnode)
retVal = xmlNewDataElement("BANCO", tfcmg403.bank, xml_mainnode)
retVal = xmlNewDataElement("IMPORTE", tfcmg403.amt,xml_mainnode)
retVal = xmlNewDataElement("DOCUMENTO", tfcmg403.refr, xml_mainnode)
endselect
seq.open("mixml2.xls", "a" )
xmlWritePretty(fd, xml_fileid, 0 )
seq.close(file.ptr)
file.ptr = 0
retVal = xmlDelete(xml_fileid, 0)

The when the file "mixm2.xls" generated is large, never is completed
correctly...

I need HELP!!!

CarlosC
7th May 2007, 14:09
I was in an error
works!!

mr_suleyman
7th May 2007, 16:04
BaanXML parser is very weak tool for complex XML. I dealed with it , but same thing also happened for me. For small sized file everything is ok but for large and complex file it doesn't work. To solve the problem I used Java Xml parser. I parse the file from java and inserted nodes into baan table. You can do all of those operaitons on Baan.


G.LUCK !