Level 1 activity 7.2.3 importing and mapping data

fabiof71
fabiof71
in Academy Discussions

I keep getting errors when trying to load Employees data.

All gets loaded correctly.

Only exception is Start Date and End Date fields where I get an error as per attached

Errors_Employyes loading.png

Can it be due to local date format? I am UK based…

Thanks

Answers

  • Tiffany.Rice
    Tiffany.Rice

    When importing into a date field if the source file doesn't have the default date format you may need to select an alternate pattern within the mapping tab of the import. In your instance the file seems to display the date as YYYYMMDD, as such you will need to select that pattern format.

    https://help.anaplan.com/map-the-timescale-in-a-module-import-0acf8ae5-b032-45fd-b785-6b1acc1e5934

  • fabiof71
    fabiof71

    Thank you Tiffany.

    Does it have to have "Time" in the heading in order for Anaplan recognizing the field as time related? My issue is otherwise I do not see a tab created in the import file to map the fields "Start Date" and "Leave date"..

    Note that in the Module I have these two mapped as "Date" format.

  • SriNitya
    SriNitya
    edited January 25

    Does it have to have "Time" in the heading in order for Anaplan recognizing the field as time related? My issue is otherwise I do not see a tab created in the import file to map the fields "Start Date" and "Leave date".. → No it is not required.
    Refer the article shared by Tiffany, it helps you understand in detail on Time format map while import.

Categories