Level 1 Model Building 7.2.3 Activity: Importing Numbered List SYS08

briiseli
Occasional Contributor

Level 1 Model Building 7.2.3 Activity: Importing Numbered List SYS08

Hi, I am having trouble importing the Data - file Employees.csv - for SYS08 Employee Details module. The data is not looking like it should and I have tried to map it multiple ways. It is a numbered list and they give that as a hint, but still not making sense to me. Can someone please help?

1 ACCEPTED SOLUTION

Accepted Solutions
rob_marshall
Moderator

Re: Level 1 Model Building 7.2.3 Activity: Importing Numbered List SYS08

12 REPLIES 12
JaredDolich
Moderator

Re: Level 1 Model Building 7.2.3 Activity: Importing Numbered List SYS08

@briiseli 

Great question and a popular one at that! You're probably really close to the answer. Because this is a numbered list, you need to make sure the mapping is correct for the employee ID. Since Anaplan assigned it's own internal number to the list item, you're only option for mapping is the employee CODE. Anaplan doesn't know the actual name because you're using a display name. Try mapping to Employee Code and for the start and end dates make sure you edit the date format to reflect the same in the import file.

SYS08-001.png


Jared Dolich
briiseli
Occasional Contributor

Re: Level 1 Model Building 7.2.3 Activity: Importing Numbered List SYS08

Thank you, I am still very confused. There is not an option to choose the all the values. how do I do this mapping? Here is the screenshot:

briiseli_0-1629415139654.png

 

rob_marshall
Moderator

Re: Level 1 Model Building 7.2.3 Activity: Importing Numbered List SYS08

@briiseli 

 

Click the third tab at the top highlighted in green.

briiseli
Occasional Contributor

Re: Level 1 Model Building 7.2.3 Activity: Importing Numbered List SYS08

Thanks, very sorry but still lost. i went to that tab, hit match button but never got the thing to look like you had it. I hit import anyway, and got this output. I need a bit of handholding and couldn't find explicit training to help.

briiseli_0-1629415549079.png

 

rob_marshall
Moderator

Re: Level 1 Model Building 7.2.3 Activity: Importing Numbered List SYS08

@briiseli 

 

Before you run it, you will need to map the values.  Open the action, click on the third tab that is green.  Once everything is mapped, then you click OK or Run.

briiseli
Occasional Contributor

Re: Level 1 Model Building 7.2.3 Activity: Importing Numbered List SYS08

None of the items in the third tab under source are labeled in green. 

briiseli
Occasional Contributor

Re: Level 1 Model Building 7.2.3 Activity: Importing Numbered List SYS08

and the tab itself is not green. 

rob_marshall
Moderator

Re: Level 1 Model Building 7.2.3 Activity: Importing Numbered List SYS08

briiseli
Occasional Contributor

Re: Level 1 Model Building 7.2.3 Activity: Importing Numbered List SYS08

One strange thing is Name and Country are blue font not green font, and so don't come through and are missing in the import. But I did the rest ok.