Datamapper XML - Read tags - Invalid format in letters

OL Connect Professional
1

I have an excel sheet I need to read records from.
I know I can mount it as a DSN, but in this case I just used the a datamapper with the excel sheet as input.

I get a fine XML out of the datamapper.
Problem is when I put tags from the XML fil into Variables with “Set job Info and variables” i messes up the Danish letters ÆØÅ

I have tried to use the tranlater plugin, but still it messet it up.
image

image

XML from datamapper attached.

It is properly a XML data format quistion, I could use JSON as output form datamapper, I just don’t know how to split a JSON file into single records - there is no plugin for that.

Thanks in advance
Datamapper.xml (2.0 KB)

2

A picture is worth a thousand words…and I feel lazy :wink:

image
image757×889 32.4 KB

1 Like
3

Thanks it is working.
Tried a lot of combinations, just not this one.
:slight_smile: