Unable to Load Employees File Properly - Added Parent in Column

Hi Team,

I'm at Lesson # 4. (4.8.2 Activity: Import Data into E2 Employees# List).

I've uploaded the Employee File and added one extra Column for Parent and for the first 56 Employees I've marked the "Sales" as a Parent and for the Rest 56 Employees I've marked "Production" as a Parent in Parent Column.

However, when I check in the Workspace, there are Some Numbers created in it.

Can anyone please guide on it?

Employee_Result_-_Post_Upload_112830.PNG

Employee_Result_-_Post_Upload_-_2_112830.PNG

Accepted answers

anand.shekhawat

@ChrisAHeathcote

@Vatsal30

I echo what Chris has mentioned.

Also the Employees file somewhat looks like the below

While importing the data , we can keep the parent as Dept Code, Display Name as Column 1 Employees and keep the first row empty as suggested earlier. The import will work perfectly.

I hope it helps

~Anand

ChrisAHeathcote

@anand.shekhawat

@Vatsal30

If you open the CSV before saving it the employee code column changes as all the leading zeros are removed.

Then when you come to map this column to the employee list they often do not match.

This will happen if for whatever reason you did not open the CSV when creating the list and the leading zeros were kept.

To Anaplan a code 001 is not the same as 1.

anand.shekhawat

@ChrisAHeathcote

Yes I also did the same Chris, and I have the Codes as 001 and not 1 in my Model. We often face this issue where excel removes the Zeros at the left . So to avoid such instances I generally use .txt files in real time scenarios for handling such kind of data.

~Anand

anand.shekhawat

@Vatsal30

If you have created a display name property, then that property should appear at the bottom in the below snip (taken from your uploaded files) under Property in List section

But in one of your snips(shown below) you have shown the Display Name Property assigned in the list.

One of the above snips that you have shared is incorrect for sure. If I assume that your second snip is correct then kindly upload the file again by mapping the 'Column 1: Employee' to Display Name while keeping the rest of the mapping same as 1st snip above. I am 100% sure, you will see the names in place of the #numbers.

~Anand

All comments

anand.shekhawat

@Vatsal30

The files made available during the Anaplan trainings are ready to upload into the model. You are not required to add any extra column in the csv file provided.

Now lets come to your issue where you are seeing some #numbers in the list. This is because you have not set the 'Display Name' in the 'Display Name Property' in the list. To add the display name property go the General Lists and then select the Display Name.

Below is the screenshot for your reference

While uploading the Employees list, take care of the mapping and map the employee names to the Display name property and keep the First row empty while mapping.

I hope it helps

~Anand

ChrisAHeathcote

@Vatsal30

A common problem when importing employee data is that the code of the employee# list and the code contained in the csv do not match and the import then fails.

Try using the csv you used to create the employee# list. The files are identical but this one will have the correct codes for each employee.

You should not have to manually enter the parent or check the subset property. This should all be achieved via imports.

anand.shekhawat

@ChrisAHeathcote

@Vatsal30

I echo what Chris has mentioned.

Also the Employees file somewhat looks like the below

While importing the data , we can keep the parent as Dept Code, Display Name as Column 1 Employees and keep the first row empty as suggested earlier. The import will work perfectly.

I hope it helps

~Anand

ChrisAHeathcote

@anand.shekhawat

@Vatsal30

If you open the CSV before saving it the employee code column changes as all the leading zeros are removed.

Then when you come to map this column to the employee list they often do not match.

This will happen if for whatever reason you did not open the CSV when creating the list and the leading zeros were kept.

To Anaplan a code 001 is not the same as 1.

anand.shekhawat

@ChrisAHeathcote

~Anand

Vatsal30

Thank you @anand.shekhawat @ChrisAHeathcote

I'm still not able to Load the "Name of the Employee".

I could Upload the File I downloaded as it is. However, I can see only "Auto Generated Numbers" instead of the Names of Employees.

For your ready reference I'm attaching the SS while I did the Import. And also, a File I imported to Import the Employees Name Under the Departments.

Your Help in this would be highly appreciated.

@noelle_murphy Can you also please help me in this?

Because of this I cannot do the Activity "7.2.3 Activity: Import Data into Employee Details Module" of Lesson # 7 - Importing into Modules.

Thank you in advance,

Vatsal

Employee_Update_-_Import_SS_113584.PNG

Employee_Update_-_Import_SS_-_2_113584.PNG

Employees_113584.csv

Result_SS_-2_-_Employee_Update_-_Import_113584.PNG

Result_SS_-3_-_Employee_Update_-_Import_113584.PNG

Result_SS_-5_-_Employee_Update_-_Import_113584.PNG

Result_SS_-4_-_Employee_Update_-_Import_113584.PNG

Result_SS_-_Employee_Update_-_Import_113584.PNG

Display_Name_in_Property_is_there_113584.PNG

anand.shekhawat

@Vatsal30

If you have created a display name property, then that property should appear at the bottom in the below snip (taken from your uploaded files) under Property in List section

But in one of your snips(shown below) you have shown the Display Name Property assigned in the list.

~Anand

Vatsal30

Thanks @anand.shekhawat

The Snips was correct.

What I did was, I removed the "Display Name" from Property and refreshed it and then again added the "Display Name" in Property and Refreshed it again.

Then I uploaded the File and it worked.

Don't know, this was a weird problem. But it is solved now.

---------------------------------------------------

However, I'm unable to get the data while uploading the File in the "SYS08 Employee Details - Vatsal" Model.

It throws the attached Error and I'm not able to Get the Data in Model "7.2.3 Activity: Import Data into Employee Details Module".

@noelle_murphy - Can you also please look into this and help me in this?

1) Importing for Model (Lesson . 7) 7.2.3 Activity Import Data into Employee Details Module.PNG

2) Importing for Model (Lesson . 7) 7.2.3 Activity Import Data into Employee Details Module.PNG

3) ERROR - while Importing for Model (Lesson . 7) 7.2.3 Activity Import Data into Employee Details Module.PNG

3)_ERROR_-__while_Importing_for_Model__(Lesson__113698.PNG

1)_Importing_for_Model__(Lesson__113698.PNG

2)_Importing_for_Model__(Lesson__113698.PNG

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?