import file error

Aditya1993

Hi Anaplan Community,

Below is a screenshot of the error I receive every time when I try to run a process with and excel file upload. what is more concerning is, if the same file has been uploaded by different user then system works fine? Please let me know how to tackle this issue.

Import_Fail_147072.PNG

Accepted answers

KirillKuznetsov

@Aditya1993

You and your colleague have to google "change regional settings in windows/iOS" and follow it's steps. Then compare what you and you colleague have and try to adjust your settings

The settings screen should look something like that in MS

All comments

KirillKuznetsov

@Aditya1993hello

Thanks for mentionning that it works for another user.

This may be caused by regional settings difference in you PC and other user's one. Please compare your file and the file which your colleague saves before the upload. The delimeters can be different - "," and ".".

Also make sure that the column headers are prefectly the same for you and other user.

JJANIK

@Aditya1993 one more check you can make: please take a look at user settings, could also be the case that selective access is different between user profiles (it happens while I'm testing someone's access for example), causing some of the automated mappings to be dropped.

Aditya1993

@JJANIK I've Workspace admin with Full access but still face the issue, I guess the main issue is in my Excel setting but don't know how to deal with it.

KirillKuznetsov

@Aditya1993

You and your colleague have to google "change regional settings in windows/iOS" and follow it's steps. Then compare what you and you colleague have and try to adjust your settings

The settings screen should look something like that in MS

Quick Links

Can you help?

Unanswered questions

RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…