Unable to Load Employees File Properly - Added Parent in Column

Vatsal30
Occasional Contributor

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?

4 ACCEPTED SOLUTIONS

Accepted Solutions
anand.shekhawat
Super Contributor

Re: Unable to Load Employees File Properly - Added Parent in Column

@ChrisHeathcote 

@Vatsal30 

 

I echo what Chris has mentioned.

Also the Employees file somewhat looks like the below

anandshekhawat_0-1624978240873.png

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

 

 

View solution in original post

ChrisHeathcote
Community Boss

Re: Unable to Load Employees File Properly - Added Parent in Column

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

 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

anand.shekhawat
Super Contributor

Re: Unable to Load Employees File Properly - Added Parent in Column

@ChrisHeathcote 

 

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

View solution in original post

anand.shekhawat
Super Contributor

Re: Unable to Load Employees File Properly - Added Parent in Column

@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

anandshekhawat_1-1625689095714.png

 

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

anandshekhawat_2-1625689285010.png

 

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

 

 

 

View solution in original post

8 REPLIES 8
anand.shekhawat
Super Contributor

Re: Unable to Load Employees File Properly - Added Parent in Column

@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

 

anandshekhawat_0-1624973848697.png

 

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

 

ChrisHeathcote
Community Boss

Re: Unable to Load Employees File Properly - Added Parent in Column

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

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
anand.shekhawat
Super Contributor

Re: Unable to Load Employees File Properly - Added Parent in Column

@ChrisHeathcote 

@Vatsal30 

 

I echo what Chris has mentioned.

Also the Employees file somewhat looks like the below

anandshekhawat_0-1624978240873.png

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

 

 

View solution in original post

ChrisHeathcote
Community Boss

Re: Unable to Load Employees File Properly - Added Parent in Column

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

 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

anand.shekhawat
Super Contributor

Re: Unable to Load Employees File Properly - Added Parent in Column

@ChrisHeathcote 

 

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

View solution in original post

Vatsal30
Occasional Contributor

Re: Unable to Load Employees File Properly - Added Parent in Column

Thank you @anand.shekhawat @ChrisHeathcote 

 

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

anand.shekhawat
Super Contributor

Re: Unable to Load Employees File Properly - Added Parent in Column

@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

anandshekhawat_1-1625689095714.png

 

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

anandshekhawat_2-1625689285010.png

 

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

 

 

 

View solution in original post

Vatsal30
Occasional Contributor

Re: Unable to Load Employees File Properly - Added Parent in Column

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