XmlPort and HTML - Special Entity Codes

activ8activ8 Member Posts: 25
Hallo,

I made an xmlport that exports some contact data.

When i open the xml it looks like this.

<body>
<No>K10121</No>
<Name>STEVENS W & CIE - new customer</Name>
<SearchName>STEVENS W & CIE - NEW CUSTOMER</SearchName>
<Name2/>
<Address>somewhere over the rainbow</Address>
<Address2/>
</body>

so as you can see navision changes the & to &
(Normal the name is : STEVENS W & CIE - new customer)

So what's the problem ?

Well i made a second xmlport which imports the contact data in navision.
What happens, navision gives an overflow error because it counts & as 5 characters.

Anybody any idea how to solve this ?
Maybe it's just a property i have to change.
Or do i have to use cdata ?

thanks,

Comments

  • cmuellercmueller Member Posts: 12
    Hallo activ8,

    you can specify by a property in the XML-Port, in which format the XML-Port import or export the data.

    The property is called Format/Evaluate and you find it an the first free line in the XML-Port-Designer.

    (BTW : &amp is a kind to mask special characters. When you open your XML-File with a internet browser, you see the rigth character.)

    Regards
    Christian
  • ara3nara3n Member Posts: 9,256
    you can also use a text variable and on the triggers do the assignment


    Description - Export::OnBeforePassField()


    Description_2 - Import::OnAfterAssignField()
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.