topic How do i import special characters? in DemandTools

How do i import special characters?

egilgras — Wed, 11 Dec 2024 13:50:26 GMT

We have customers all over the world and many of them have special characters in names, adresses etc. Ie ÄÅÆ etc. When i import them they turn out corrupted in the preview and in the final import to SF. Example "Göteborg" becomes "GÃ¶teborg". How can i maintain my special characters? Replacing them with english characters is not an option, we need to spell these names correctly. Usin Demandtools Elements Import

Re: How do i import special characters?

Pugs_Validity — Fri, 13 Dec 2024 17:14:29 GMT

Hey @egilgras - We were unable to replicate this issue at first but upon further research and testing, I believe we likely found the issue here. This appears to be an issue with Salesforce, if someone uploads a .CSV with special foreign language characters, its need to be in a CSV UTF-8 format for Salesforce to be able to import properly.

Re: How do i import special characters?

egilgras — Mon, 16 Dec 2024 07:50:23 GMT

Oh that makes sense, will give it a shot 🙂 Thank you!