Import data lists

Hi,

I'm trying to import a data list, I have put all the correct details and the file imports successfully, but then in the anaplan list, nothing appears.

There are 400 entries and 0 come through.

Thanks

Piyaa

Import_148832.PNG

Tags

Importing and Exporting Data

Data Integration

Accepted answers

You see that first mapping box P5 Unit , keep that blank - Do not map that one . We don't map first one when Numbered lists are involved.

I would also recommend you to go back and check the video tutorial on Numbered lists.

Thanks

Misbah

Miz Logix

All comments

Screenshot of an import mapping and the file would help debug this

Misbah

Miz Logix

i attached a screenshot are you able to see?

thanks

Piyaa

That's not the mapping. Mapping is when you edit the import and first window that pops up is mapping

Also share the file template(Only column headers would do).

This is the mapping page and the upload attached

Thanks

P

Unit_upload_148917.csv

forgot to @ you. so this upload goes through but nothing is imported and it says it's successfully imported

thanks

P

Its a numbered list and you can not map it on Name #. You will have to map it on Code.

Try changing it to Code and keep the Name blank and re run the import.

Thanks,

Misbah

when i map it on code, i get this error.

how do i fix that?

thanks

P

You see that first mapping box P5 Unit , keep that blank - Do not map that one . We don't map first one when Numbered lists are involved.

I would also recommend you to go back and check the video tutorial on Numbered lists.

Thanks

Misbah

Miz Logix

@Misbah

That’s great, That worked thank you!
P

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…