please help to solve 7.2.3 Activity: Import Data into Employee Details Module

Olga2023

i tried to import the data from the file

mapping:

1)column 2:Code to E2 Employees;

2)(Column Headers) to SYS08 Employee Details

E2 employees#: Shall i choose match on names or codes?

3. SYS08 Employee Details Line Items:

Shall i also choose Match on names or codes?

and for Start Date and Leave Date we need to correct the format

what format shall i use? Y-M-D? or D-M-Y? or Y/M/D?

final results for SYS08.png

SYS 08 employee details 3.png

SYS 08 results.png

step 1 lesson 7.png

Accepted answers

All comments

Venki9902

Hi @Olga2023 ,

To answer your question:
1.Yes use the code to import the data as E2 Employee# is numbered list it always best practice to use code.
2.As per your screenshot start date and the end date has YYYYMMDD, did you use the format?

Choose map items manually and select commision% also and seems you created active? line item in your module, create and try to upload the data again?

Hope this helps :).

Regards,
Venkatesh

Olga2023

thank you so much!

it looks like it worked but i still have some fails. may be because of the Department which i included in mapping,

employee details mapping 2.png

results last one.png

but i tried to put ignore for Department, still 111 fails for Leave Date.

Venki9902

Hi @Olga2023 ,

Thats good to hear.
As I can see for active? you have mapped the enddate due to which it is failing.
Try to create one more line item in the module and name it as Active? then map the same.

Hope this helps :)

Regards,
Venkatesh

Olga2023

thank you so much!

Quick Links

Can you help?

Unanswered questions

How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
How to use Client ID and Client Secret for API request directly?
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…