XML Export &

Maik_Swiss

Hi everybody.


I have a small problem. When exporting a xml file & is shown as &

I know this is XML-format but for the import to the other solution i need the & only.


Any help out there?

thx in advanced

Maik

MBerger

The ampersand is an illegal character in an XML file and should always be converted to &
So the program you are importing in is the problem here.

einsTeIn.NET

Yeah, I think it's a bug in your import solution, because it doesn't deal right with XML format.

Maik_Swiss

the problem is, i have no chance to alter the import solution.

So i need a way to export without amp; from Navision.


Current solution is to rename the & to & with a text editor, but thats not a good solution.


Any other idea`s?

ta5

Hello
Imo it is correct to export as & because & is a special character for xml. The importing solution should be able to deal with it because it is xml standard.
Regards
Thomas

Maik_Swiss

I try to explain some more.


NAV exports a & with amp; thats ok when you need it as text.

I have the problem that we need the & as Line break.

Example what i need:

<ORDER_SUPPLEMENT ORDER_ID="12-345678" ID="AA1" VALUE="1, Test Fahrzeug Test Lastwagen 4 x 4 3261 - Text Text Text Text Text Text Text Text!" CLIENT_MUST_FILL="0"/>

the red part is the line break code.

and this is what NAV exports:

<ORDER_SUPPLEMENT ORDER_ID="12-345678" ID="AA1" VALUE="1, Test Fahrzeug Test Lastwagen 4 x 4&#xD;&#xA;3261 - Text Text Text Text &#xD;&#xA;Text Text Text Text!" CLIENT_MUST_FILL="0"/>


Regards
Maik

ta5

Hm, can you use another character for the line break? Or do you have the possibility to change the xml structure to have all lines in their own element?
Thomas

Maik_Swiss

i cant alter the import code - so no chance to take another character for the line break


all lines in an own element didnt work, because i need to fill one field (ID-AA1)

einsTeIn.NET

As far as I can see this part

VALUE="1, Test Fahrzeug Test Lastwagen 4 x 4
3261 - Text Text Text Text 
Text Text Text Text!"

is a normal XML attribute. I don't understand why an ampersand should be the character for a line break. It is XML standard that ampersand is substituted by &. So, I would contact the provider of your import solution and tell him that there's a bug. Otherwise he shouldn't use "pseudo" XML format for his interface.