AJakote
New Contributor

Level 1 Model Building Exam Activity 4 - Roles Import Error

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!

1 ACCEPTED SOLUTION

接受的解决方案
rob_marshall
Moderator

@AJakote

Why is the line item Role a subsidiary view, meaning it has different dimensionality than the rest of the module? It shouldn't be. Please to back to that line item (Role) and make it have the same dimensionality as the rest of the line items (Applies To should have a -)

Rob

View solution in original post

4 REPLIES4
Kanishq17
Community Boss

Hi@AJakote

What is the source of your load and can you send a snip of the import mapping for role line item

AJakote
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

rob_marshall
Moderator

@AJakote

Why is the line item Role a subsidiary view, meaning it has different dimensionality than the rest of the module? It shouldn't be. Please to back to that line item (Role) and make it have the same dimensionality as the rest of the line items (Applies To should have a -)

Rob

AJakote
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