Level 1 Model Building SYS08 Employee Details Import Issue

[RobinSilk]

We are asked to import Emloyees.csv into SYS08 Employee Details and I am unable to get the names in the list to match on the names in the employees list that I already have in. I checked and I have the data type as "Text" listed within the SYS08 module, and the .csv has the data in that column listed as "General". I also tried changing that to "Text"; neither work. I can do it manually but it will take a long time.

Is there something I'm missing or should consider?

[ganasri]

I Got the answer for the above question. After adding formula to the Code, it will populate code value.

[saiprasad]

are you saying to re download and import in E2 employee# list or in the SYS08 employee details module ? I tried to redownload and uploaded in the SYS08 employee details module without opening the file ,this method is not working

[DianaP]

I am also having an issue with Employee Details upload, see my upload screens below. The upload includes errors. Please help I am not sure what I am doing wrong.

[Tiffany.Rice]

@DianaP

Appears it may be a mapping issue on the Start Date line item, likely you need to update the Custom Mapping on that field so that the format in the import is set to match the file. See screenshot below to illustrate.

[DianaP]

That worked perfectly!! - Thanks!

[KARASAGE]

Hi guys,

I am tryin to pass my L1 Model building and have the same problem the code of the E2 employee list doesn't match the CSV SYS08 Employee Details .

In the list you will see that I have a code 1 and When I open the CSV i also have the code 1 but when I import teh csv on anaplan it becomes 001 and I don't understand why ?

Can someone help me please ?

[yangxx]

Thanks, I have issues to import the start date and leave date too. I think custom mapping for start date & end date is the resolution to my issue, but I can't find the custom mapping when I import.

Below are my screenshots. Will anyone help? Thanks.

below is the error screenshots:

[Zhanat]

Thank you very much! It really helped and worked perfect!

[bowlingwebwildflower]

Thanks, the second one works!

[Niraj.B]

Hi,

I think there is an issue with instructions:

It should have been made clear in the L1 course that for SYS08 you are expected to populate values A,B,C. Values D,E come via a formula.

Fields like Active? should be ignored - No one mentions this

Infact the formulas should have come up first and then data import.

Also there is no where in the instructions that you have to do custom date mapping

I spent roughly an hour trying to figure out where am I going wrong. Luckily I across this thread and I see I am not the only one.