Level 1 Exam - Model Building Activity 4 importing data into SYS08 Employee Details Module

Options

Hi Team,

I need your help on this data importing.

SravanKumar_0-1635390259991.png

I have downloaded the Employe Details by Role.txt file but, I see the data is not being mapped correctly into the SYS08 Employee details module.

 

Downloaded CSV format :

SravanKumar_1-1635390394960.png

 

SravanKumar_3-1635391894678.png

 

SravanKumar_4-1635391958762.png

I have tried by converting CSV to txt format. Still the data is not being mapped properly while importing.

SravanKumar_5-1635392188068.png

 

 

Comments

  • @SravanKumar 

    Don't convert the given files to any other format, unless and until you are told to do so. Upload the downloaded file in the existing format only.

     

    Referring to your screenshot kindly map the E2 Employees to Code. Map the Leave Date and start Start date by clicking on the boolean as shown below.

    anandshekhawat_0-1635401796343.png

     

    and then try to import the file. You will get it imported

     

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

  • @SravanKumar 

    Update the file options before you try and map the dimensions.

    Look at what is being used to separate the columns in the txt file and select this option before proceeding to mapping.

  • @anand.shekhawat it worked fine. Thank you very much.

  • Don't we have to create a line item Role and then import the data. I stuck at the moment on that.

  • Same I am stuck on that only
  • Do we need to add line item before importing?