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

A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385