Import Character Error

Hi All,

I have an input module with some line items formatted as a drop down lists.

My drop down list looks like this for each column

When I export this as a csv file, it comes out with a "Â" character beside the "£ numbers" this way below.

When I run an import using this same file to re-import to the input module. It works but fail for the (AG column) saying list item can not be located.

I'm wondering is it because of the "Â" character and if so why does it have no problem for column "AE" AND "AF" but has issue with column "AG"?.

Any suggestion on what to do or work around will be really helpful, thanks.

Accepted answers

TimothyThomas

Hi @innocent ,

Good question, we have run into the same issue when exporting/importing employee data from non English speaking countries. One easy way we've gotten around this has been using the export file type "CSV for Excel" rather than the regular CSV export, which is just one option below on the dropdown.

I'll attach the difference in how these 2 export here, and you can see when this other option is chosen it no longer attaches the "Â" before the GBP symbol. Let me know if this does the trick for you or not!

All comments

TimothyThomas

Hi @innocent ,

Monpero

Hi @TimothyThomas this did the trick, it worked!, thanks a lot for the help. It's funny how this little errors can be hard to figure out.

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
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.…