7.2.3 Activity: Import Data into Employee Details Module

jacksonmeridian · July 2022

When importing data into the SYS08 Employee Details module, my end results looks like the second photo when the goal is the first. I have imputed the correct mapping, and manually mapped the employee detail line items as well as changed the date format to YYYYMMDD. I'm not sure what the error is, I keep getting the error message in the last two screenshots.

JaredDolich · July 2022

@jacksonmeridian

For SYS08 you will need to format the start and end dates as MM/DD/YYYY.

Davidhavugiman · May 2023

Has anyone ever succeeded in performing this activity? I have tried several times but still now I don't understand where I am going wrong.

tincythomas · June 2023

Hey Davidhavugiman,

Please refer the below screenshots to import data,

Step 1: Change the format of code in excel sheet. save

Screenshot 2023-06-02 at 1.48.05 PM.png

Step 2: Import csv file to module. match code to E2 employee# and column headers to SYS08 Employee Details Line Items. then edit the date format for start date and leave date. refer below screenshots.

Screenshot 2023-06-02 at 1.53.40 PM.png

Screenshot 2023-06-02 at 1.49.40 PM.png

Screenshot 2023-06-02 at 1.55.19 PM.png

Then Run Import.

Hope this will help you to import the data to module. Let me know if you have any other doubts.

Thanks,

Tincy