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

12_ [COMPLETE GUIDE] Uphold Support Number
At Uphold customer support ⭐+1-888-355-2348 accounts may be temporarily disabled or restricted for various reasons. Raise a concern on priority basis at Uphold support ⭐+1-888-355-2348 if you notice any suspected malicious activity, or a problem during account recovery. To contact Uphold support directly at…
New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
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…