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]

Hello,

Regards to this Import Issue, I imported Employees.CSV file successfully. The data populated in Target is as shown in the image attached here. Code field is also populated with Employee Name. Is that correct? How can I retain code 001 002? 

Thanks!

[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!