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

Concatenated List for to store Archiving data
Hi Anaplanners, I’m working with a calculation module (Module A) that is dimensioned by a concatenated list, Time, and Native Versions. In this module, I am performing a subtraction using values from another module (Module B), which is dimensioned by Native Versions and a different concatenated list. The two concatenated…
Moving Sum for Formula driven number format line items
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a…
User Selective Access
I have a selective access cost center list in a flat format that contains multiple hierarchy levels. I need to assign more than one cost center parent to a single user. While this can be done manually, I would like to know if there is a way to import this through a CSV file instead. Could you please confirm if this is…