7.2.3 Activity: Import Data into Employee Details Module

abhinandan
Contributor

7.2.3 Activity: Import Data into Employee Details Module

Hi Team,

 

In the Level 1 Model Builder activity  7.2.3 Activity: Import Data into Employee Details Module , do we have to manually map mappings for E2 Employees between source and target items ? Is there any way for the mappings of E2 Employees ?

 

Please help as it is very lengthy process to do the manual mappings for 111 emp.

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

Re: 7.2.3 Activity: Import Data into Employee Details Module

@abhinandan 

@Misbah and @andre.lie are correct. You should use Code. Re-download the employee.csv file and do not edit it in Excel. Sometimes if you open the .csv and resave it, Excel will interpret "009" as "9" and it won't map correctly. Try again! You've got this.


Jared Dolich

View solution in original post

6 REPLIES 6
andre.lie
Certified Master Anaplanner

Re: 7.2.3 Activity: Import Data into Employee Details Module

@abhinandan , we don't need to map them manually.  You can use employee code instead of name.

abhinandan
Contributor

Re: 7.2.3 Activity: Import Data into Employee Details Module

Hi Thanks for the reply. 

 

I tried with code also, but even with code , mappings for E2 are not getting mapped automatically. PFA screenshot for the same.

 

It will accept and work as per the image attached for employees ?

Misbah
Moderator

Re: 7.2.3 Activity: Import Data into Employee Details Module

@abhinandan 

 

Since Employees is a numbered list it has to be mapped to Code as suggested by @andre.lie . However codes need to be exactly matching between the Source and Target. See if this helps

 

Misbah_0-1615883557732.png

Check if you have codes matching between Data Hub and Spoke Model, it can "001"  or Just "1" but it has to be same and matching at both these places

 

abhinandan
Contributor

Re: 7.2.3 Activity: Import Data into Employee Details Module

Hi Misbah,

 

Thanks for your inputs.

However I am not able to map all the 2 digit numbers for employees (code 1 to code 99), from 100 onwards its getting mapped automatically. So for 99 employees its getting failed and for rest 12 emp data is getting loaded.

 

How to map codes for first 99 employees ?

 

PFA Emp mapping , Line items mapping, Error and Output of model. Kindly help !

JaredDolich
Moderator

Re: 7.2.3 Activity: Import Data into Employee Details Module

@abhinandan 

@Misbah and @andre.lie are correct. You should use Code. Re-download the employee.csv file and do not edit it in Excel. Sometimes if you open the .csv and resave it, Excel will interpret "009" as "9" and it won't map correctly. Try again! You've got this.


Jared Dolich

View solution in original post

DaanishSoomar
Certified Master Anaplanner

Re: 7.2.3 Activity: Import Data into Employee Details Module

Yes @JaredDolich mentioned,

 

Having consistent code syntax will help your data flow through. You are indeed very close!