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!

Upload_setting_35222.JPG

Error_message_35222.JPG

Data_view_35222.JPG

Accepted answers

kjacokes

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.

All comments

kjacokes

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

jsdeguzman

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!

Time_view_35227.JPG

Details_view_35227.JPG

kjacokes

Hmm, all looks good. Can you post a screenshot of your Line Item mappings?

jsdeguzman

Hi, @kjacokes

Here:

Line_Item_Mapping_35229.JPG

Building_Mapping_35229.JPG

Sales_Type_Mapping_35229.JPG

kjacokes

Everything you've done looks correct to me.

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.

CommunityMember128217

i am also facing the same issue,invalid line identifier for custom currency list/column while loading into module.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
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…