Modelbuilding 1 question 7.2.3 importing employees

Somehow I can't get the employees imported,  in SYS08 Can anyone explain how to do it, I do not know what to use as mapping. I tried this:

MTromp_1-1612888335374.png

 But it returns failures on start date, leave date and other columns

Then I tried manual mapping, which partly worked but still it won't fill all the columns:

MTromp_0-1612888201699.png

 

Does anybody have an idea why it will not load?

 

The error message does not give me any clue 

 

 

 

Answers

  • @MTromp 

    Oh, so, so close.

    Import employees using "CODE" not name.

    The reason is that this is a numbered list and Anaplan doesn't know how to identify an employee by the "display name". You have only but one choice and that's to use the employee code. Give that a try!

    You got this!

  • Hi, 

     

    I tried that yesterday as well, actually it was my first try, but it still gives me the following error message: 

    MTromp_0-1612954436418.png

    And it does not import anything accept for current salary.....

     

    I compared the employee list and the module setup to the original version, but can't find any differences in the setup of the list or module.

     

    Kind regards, Mandy

  • @MTromp 

    Yep, we'll need to format the dates too before loading. Anaplan needs a little help on how to interpret the date format.

    Employees006.png

  • Hi,

     

    I did change that to in the beginning, but still issues:

     

    MTromp_0-1613127031330.png

    Code, name, department etc. is not filled because of these issues. 

    MTromp_1-1613127182956.png

     

    My list SYS08 E2 Employees# is a numbered list, it is filled with the codes and information to match it. But somehow the list and the module won't match.

     

    I can match manually, but it still won't fill the codes, so I feel somehow in this code resides is the error, but I have checked the list setup and the module setup but can't find the issue.

     

    Mandy

     

     

  • Hey @MTromp Mandy

    You got this. You're REALLY, REALLY close. Make sure your mapping the employee to CODE not to Display name. If that doesn't work, send a screenshot of your mapping screen. Let's get you to the finish line!!

    Should look like this:

    Employees008.png