Error in Importing
Hi, guys!
I always have this problem when I am importing my data in Anaplan. I tried all the methods I know but I can't solve this problem. I am trying to upload this data to my budget version but to no avail.
Hope you can give some assistance!
Thank you for the help!
Best Answer
-
Everything you've done looks correct to me.
The next step I take in these instances is to re-create the import from scratch. Upload a brand new file (give it a unique name) and make sure the file is in plain .txt format. Re-map everything. If you're still getting an error, I would take that file and remove all but one column, and attempt the import again. If that works, I would add one column at a time until you come to the column where you're getting the error.
One other thing to keep an eye on is the time scale applicability and range in your model. Make sure that if you're loading monthly data to a line item, that the line item "Applies to" months, and that the months associated with the data you're loading are included in your model's time scale (e.g. if you're loading FY18 data, your time scale supports FY18).
Most of these suggestions are stating the obvious OR recommending you check things you've likely already checked, but it's an obligatory step when trying to troubleshoot things virtually / not live.
Let me know if you're still having trouble and we can hop on a quick phone call.
2
Answers
-
Hi @jsdeguzman,
Can you post a screenshot of the "Time" and "Project Scheme" tabs in your import definition, so we can see the mapping logic there?
Also, if you could post the "Details" section of the error message (assuming there is some information in that tab) that may help us track down what's going on here.
If I had to hazard a guess, the "Time" tab is expecting mapping logic to help it interpret the format of your dates.
Cheers,
Kevin
0 -
Hi, @kjacokes! Thanks for your quick reply.
Here are my views. I have already tried experimenting on the time tab in the import view, but nothing seems to solve my problem.
Thank you for your help!
0 -
Hmm, all looks good. Can you post a screenshot of your Line Item mappings?
0 -
i am also facing the same issue,invalid line identifier for custom currency list/column while loading into module.
0