XMLport crashing when importing a MT940 file

(0) Share

Report

Posted on by Community Member

Hello everyone

We are trying to import a Bank Statement file (MT940) into Navision. We do this all the time, but the files from this particular Bank contain 2 characters, that crash the import - SOH (ASCII 1) and ETX (ASCII 10).

Never mind that these characters are not supposed to be in a MT940 file, unfortunately we cant change that.

The XMLport crashes immediately after the PreXMLport code is done (error message below for SOH character). Is there some way to set up the XMLport to ignore these characters (changing the TextEncoding property didn't help)? Manually removing these characters works fine, but that is a last resort

1817.Error.jpg

The import is done manually.

Thanks

Armin

*This post is locked for comments

All responses (4)

Answers (0)

Suggested answer

Yogesh Kulkarni_ 1,762 on at

Like (0)

Report

RE: XMLport crashing when importing a MT940 file

Yes, this is definitely with the special characters in data.

As suggested by Ahmed, you can first clean the data and pass on the data to the XMLPort for importing.

-Yogesh Kulkarni
Please verify, if you find answer helpful.
Rashed 3,765 on at

Like (0)

Report

RE: XMLport crashing when importing a MT940 file

There isn't much you can do with the xmlport. I suggest to create new function code before passing the file to xlmport and remove those characters from the file.
PachaDie 50 on at

Like (0)

Report

RE: XMLport crashing when importing a MT940 file

Hi Lenquist, Please check XMLPort properties:

Encoding <UTF-16>

XMLVersionNo <1.0>

vs. first line in your file.

Regards,

Diego
Suggested answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: XMLport crashing when importing a MT940 file

Check the data in file , There might be some special characters in data