Importing data into SYS08

Options

How to map Employees data into SYS08 because I am getting error, I am attaching pictures, only current salary n commission % are mapped.

IMG_20211006_131518.jpg

IMG_20211006_131601.jpg

IMG_20211006_131618.jpg

Best Answer

  • anand.shekhawat
    Options

    @amruthasai7979 

    The mapping seems correct.

    Navigate to Employees tab and check if all the Employees are getting mapped correctly. 

    Navigate to Employee Details Line Items and check if all the items are mapped correctly, if not than map them manually.

    Also focus on Start Date and Leave Date. Make sure you map it correctly by clicking on Edit. 

    anandshekhawat_0-1633511466540.png

    You will be able to import it correctly.

     

    ~Anand

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

Answers

  • 16335118571524825593089401250585.jpg

    Sir I think some problem with time mapping

  • 16335124518444828519390089839028.jpg

    I have edited time format and also I have manually sir. Now it got mapped. Thank you very much sir. 

  • @amruthasai7979 

     

    Yes, you need to map the dates. Select YYYYMMDD from the second table and you would see that the dates are getting mapped correctly (Currently ignored in the screenshot).

     

    ~Anand 

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

  • Yes sir, I have edited it to YYYYMMDD
  • Hi,

    You need to correct the date format to map them with your Anaplan module time dimension. Secondly, check if you have mapped the required column headers or not? Maybe you need to manually map line items which are left out.

    Hope this helps.

  • Hi,
    Thank you for responding, yes now it is done correctly.
  • That's great. Keep learning!