One question regarding level 1 - Activity 7.2.3 : Import Data into Employee Details Module

Hello there,

I meet one issue when I import data into employee details module for level 1, activity 7.2.3.

The result can be seen from screenshot (refer to Result.PNG). Here we can see that Name, Country, Start Date and Leave date columns were not imported at all. The imported report can be seen from screenshot (Import result.PNG). Have no clue why the start date and leave date were invalid data as import mapping were set up correctly (refer to Import mapping.PNG) as well as data format (refer to Blueprint view.PNG).

Could you give me some guidance on how to solve this issue?

Many thanks in advance.

Result_80113.PNG

Import_result_80113.PNG

Import_mapping_80113.PNG

Blueprint_view_80113.PNG

Accepted answers

JaredDolich

@keyyun627

Oh, so close! So close!

In your import results you got a message saying country and name were not mapped.

Recheck you mapping and import again. Just make sure country and name are mapped. You got this!

keyyun627

@JaredDolich

Hi Jared,

Many thanks for the tips. It is solved now. 😉

All comments

JaredDolich

@keyyun627

You're so so close. It's not that intuitive but you do need to map the dates to the right format.

As for the country make sure there's not formula in the line item. Then you'll be able to map the CSV to the right line item in the Target module.

keyyun627

@JaredDolich

Hi Jared,

Many thanks for your tips. The start date/Leave date work now after following your indication.

However, Name column and Country column were still not updated after import (refer to Name and Country.PNG). The import completed report can be seen from screenshot Import Completed report.PNG.

For Name column, what I found pretty wired is that E2 Employee mapping was not correct (refer to Employee name mapping.PNG). In fact, to avoid any duplication of number in the E2 Employee (number list), I also recreated the list E2 Employee in case but the result is the same.

For Country column, I ensured that there is no formula in the line item (refer to Country.PNG).

I am wondering if you have some idea what caused these errors?

Many thanks in advance.

Name_and_Country_80254.PNG

Import_Completed_report_80254.PNG

Employee_name_mapping_80254.PNG

Country_80254.PNG

JaredDolich

@keyyun627

Oh, so close! So close!

In your import results you got a message saying country and name were not mapped.

Recheck you mapping and import again. Just make sure country and name are mapped. You got this!

keyyun627

@JaredDolich

Hi Jared,

Many thanks for the tips. It is solved now. 😉

JosephA

Having some serious difficulty

see attached for my import failure report

abhinandan

Hi Team,

I am facing issue in this activity , Can you please confirm my steps if I am going right for the mapping.

Also for E2 emp mapping tab why its not mapping automatically ?

E2_Mappings_101379.PNG

Line_Items_Mapping_101379.PNG

Mapping_101379.PNG

JaredDolich

@abhinandan

Your .csv file has been modified. You'll need to re-download the employee.csv file so the employee codes have the preceding zeroes. For example, "009", not "9". Once you get the employee.csv file try importing the data again. I think you'll see it maps perfectly! You got this!

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…