Unable to load special characters using .CSV file

Options
Shraddha0706
Shraddha0706 Member, ALL USERS, Partner Posts: 3 New Contributor
in Extensibility

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

Shraddha0706_0-1663530439904.png

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

Shraddha0706_1-1663530481608.png

 

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

To ImportAfter import
Tést is yet für away. 

T�st is yet für away.

 

Please help..!!

Tagged:

Comments

  • JaredDolich
    JaredDolich Member, ALL USERS, GroupMember, Partner, User Group Leader, Certified Master Anaplanner, Community Member, Certified Model Builder Posts: 8

    @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@sony.com
    harshitha.narayan@sony.com Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Contributor

    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 

Categories