XML import

Christian_Wandborg

Hi,

While importing an XML-file using an XML-port, I’m facing trouble because my XML-file contains an element with a string length of 1033 characters. Sometimes the element contains even more depending on the file at hand.

Actually I don’t need to import the element, but my import fails because of the string length.

Any suggestions please?

mohana_cse06

What error message you are getting?
if you dont need to import it you can reduce the string before importing the XML(COPYSTR)

Christian_Wandborg

Well, I may not be using COPYSTR right, but here is my code on the "Description - Import::OnAfterAssignVariable()"

InOrdDocLine.Prod_Description := COPYSTR(Temp_Description, 1, 20);
InOrdDocLine.MODIFY;

(InOrdDocLine reffering to my receiving table and Prod_Description reffering to table field)

mohana_cse06

Christian Wandborg wrote:

Well, I may not be using COPYSTR right, but here is my code on the "Description - Import::OnAfterAssignVariable()"

Use it in Import::OnBeforeInsertRecord() of receiving table

Christian_Wandborg

Not quite enough...I get the message:

The value "..." has a length 1033, which exceeds the max size of the destination type Text.

mohana_cse06

As per your screenshot, the table name is Product.
so use

Product.Description := COPYSTR(Product.Description,1,20);

Christian_Wandborg

My receiving table is InOrdDocLine declared as a variable in my XML-port.

Using 'Product.Description := COPYSTR(Product.Description,1,20);' generates an error that the variable 'Product' does not exist,

and 'InOrdDocLine.Prod_Description := COPYSTR(Temp_Description, 1, 20);' fails generating no error message.

Anyway, is there a way to completely bypass the element? As mentioned I really don't need to import it. It just fails because of the string length.

mohana_cse06

Set Temp_Description to blank in OnBeforeInsertrecord.

Christian_Wandborg

Of course... Thank you