Unable to load special characters using .CSV file

I am unable to load special characters in Anaplan using an import where file is the source.

Kindly note the following:

1) Import is setup with text encoding set as UTF-8

2) The format of file that is being loaded is .CSV

Following is the text i am trying to import and the text that is getting loaded in Anaplan:

To Import	After import
Tést is yet fÃ¼r away.	T�st is yet für away.

Please help..!!

Accepted answers

All comments

JaredDolich

@Shraddha0706

You may need to normalize those characters.

Start by reading the entire Anaplan technical spec on special characters here. Not too long - has great links.

Normalization - Unicode equivalence. Just be weary of characters that are not supported.

Also, you can contact your business partner. They will have direct access to the technical team at Anaplan. I suspect your question isn't the first time it's been asked.

harshitha.narayan

Hello @Shraddha0706 ,

I would suggest you to cleanse the file first.

For example if your initial file is a Excel file, apply CLEAN formula on those cells and convert / save it in "Unicode text" file format and try to import this file into the module.

See if that works.

Thanks,

harshitha

M.Kierepka

Hi @Shraddha0706,

You are picking wrong option when saving CSV in Excel. You should pick "CSV UTF-8 (comma delimited)", which is 5th from the top on your screenshot. Instead, you are saving it as just "CSV (comma delimited)", 5th from the bottom, which is being saved in user-dependent ANSI encoding, and that's why when imported to Anaplan, it does not map to UTF-8.

Shraddha0706

Hi @M.Kierepka,

Thank you for your solution. This has solved our issue.

Appertiate your help..!!

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385