Import Long text from XML nodes into NAV

Hi,

I want to import an xml, which has Node data size more than 1024 characters. If I use a variable of type Text (BigText) in the XMLPort and then use CREATEOUTSTREAM to assign this text value to a BLOB field in NAV table, then the format (white space, next line etc.) of then line gets distorted.

And instead of using Text/Bigtext, if I use the BLOB field in the XMLPort then it gives error

“The length of the text string exceedst the size of the string buffer.”

I am using NAV2009 R2.

What are other possibilities? Please help.

Guys, Anyone has any idea to solve this issue?

On the xmlport, select TextType as BigText, and then use the method GETSUBTEXT to store the value to text fields or variable.