Level 1 model building #E2 List Upload

Hi,

I cannot seem to fix my employee list import. I keep getting the same error. If I select code, it will not let me import and if I select #name it will fail. The steps in a previously answered question were not clear. I also notice in my import source that display name property is missing even though I have it in my tab. How can I fix this to import the list.

Best,

New2Anaplan Screen Shot 2019-12-15 at 10.35.11 PM.png

Screen Shot 2019-12-15 at 10.27.09 PM.png Screen Shot 2019-12-15 at 10.33.42 PM.png

Accepted answers

VIGNESH.M

Hi,

We should not map List item Name to number list, Numbers list name will come from Display name properties.

#1. Remove the Employee Name mapping from column 1(#E2 Employees)

#2. Remove the formula in Display Name Properties and map Employee name to Display name.

~Vignesh M

Misbah

@mary8919

Since it is a numbered list, Keep your first mapping blank (Column 1 vs #E2 Employees) Hit backspace or delete in that mapping.(Read the warning in the red ink)

Then Check items uniquely identified by CODE in the right hand section. That should work

Thanks,

Misbah

All comments

VIGNESH.M

Hi,

We should not map List item Name to number list, Numbers list name will come from Display name properties.

#1. Remove the Employee Name mapping from column 1(#E2 Employees)

#2. Remove the formula in Display Name Properties and map Employee name to Display name.

~Vignesh M

nathan_rudman

you need to remove the first mapping, into #E2 Employees.
As it is a numbered list, you cannot import a name, which is what this is.

Misbah

@mary8919

Since it is a numbered list, Keep your first mapping blank (Column 1 vs #E2 Employees) Hit backspace or delete in that mapping.(Read the warning in the red ink)

Then Check items uniquely identified by CODE in the right hand section. That should work

Thanks,

Misbah

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…