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

Unit_upload_148917.csv

i attached a screenshot are you able to see?

thanks

Piyaa

Unit_upload_148917.csv

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).

Unit_upload_148917.csv

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

Unit_upload_148917.csv

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

Unit_upload_148917.csv

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

how do i fix that?

thanks

P

Unit_upload_148917.csv

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

Unit_upload_148917.csv

@Misbah

That’s great, That worked thank you!
P

Unit_upload_148917.csv

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…