Level 1 Model Building Exam Activity 4 - Roles Import Error

Options
AJakote
AJakote Member, ALL USERS Posts: 3 New Contributor

Hi there,

 

I've been stuck on the import into the SYS08 Employee Details Module (Activity 4). When I run the import, I get the error below:

AJakote_0-1643985402437.png

I think this is what's preventing me from sourcing the right answer for Question 5, since the mapping on activity 5 works well for me. 

 

Here's how I set up the Roles list:

AJakote_1-1643985445708.png

 and 

AJakote_2-1643985459173.png

I've added "Role" as a List line item on the module, and the information populates only partially. After the import, I see data only for "staff members" .

AJakote_3-1643985594373.png

Where did I go wrong here?

 

Thanks in advance!

 

Comments

  • AJakote
    AJakote Member, ALL USERS Posts: 3 New Contributor

    Hi there,

     

    I hope I understood correctly the "source of load" as the source file of import for Activity 4 - which is this text file: 

    AJakote_0-1643987562095.png

    When I'm running the import, this is my mapping:

    AJakote_3-1643987650001.pngAJakote_4-1643987664031.png

    AJakote_5-1643987677085.png

    Another weird thing is that the "Leave Date" formatting is blank when I set the format:

    AJakote_6-1643987716315.png

     

    As to the role, it's mapped in the following way on the SYS08 module:

    AJakote_2-1643987613497.png

     

  • AJakote
    AJakote Member, ALL USERS Posts: 3 New Contributor

    I didn't even observe this was missing - the import worked like a charm now! Inserting a snipped of the solution down here:

    AJakote_0-1643988527262.png