Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Christine Cook]

Hi all

This is my first post and I am a user not a programmer.  We have a xmlport that has been written to import orders to NAV16.  A lot of data we receive is accented, any ideas how the import can be changed to correct those accents?

thanks

Christine

——————————
Christine Cook
Procurement International Ltd
Wokingham
——————————

[Ian Ray]

Hi,

You may want TextEncoding property. 
XMLports default to MS-DOS encoding.

If you have access, open development environment, go to the relevant XMLport, select “File” from the top menu and “Export,” give the xmlport a name and save (this is to import again in case anything goes wrong).

While still selecting the relevant xmlport, right-click and select “design,” choose a new line at the bottom with blank Node Name, right-click and select “properties,” change TextEncoding to something other than MS-DOS (UTF8, UTF16, or Windows).

Close out of the design window, leave “compiled” checked and select “OK” to save.

Finally, export a copy of the modifed xmlport to send your partner for their records.

This page explains text encoding:
https://msdn.microsoft.com/en-us/library/dn271702(v=nav.90).aspx

I should note that this will preserve the characters rather than change them. If you import as MS-DOS, characters outside of the language set will import garbled. As far as I know, to change the characters to a specific set, you will have to change the xmlport code. There are some solutions in this thread involving deleting unwanted characters through code:
https://dynamicsuser.net/nav/f/developers/50363/delete-all-the-special-characters-from-a-string

——————————
Ian Ray
Cypress Grove
Arcata CA
——————————
——————————————-