Import Issues with date and time format in CSV

Ha Linh
Ha Linh
in Integrations and extensibility

Hi everyone, I am trying to import data from CSV file. However, whenever I try to modify the data and save the file with CSV format the Date and time format in CSV automatically changed to its original format. Our Anaplan models cannot recognize the original CSV format, so I have to re-input it.

Can anyone help me to solve this problem without re-inputting the date format?

 

Thank you.

Warren

Tagged:

Answers

  • anirudh
    anirudh

    @Ha Linh 

     

    It is possible to customise the time mapping in Anaplan import actions.This way you do not have to edit the csv file each time.

     

    If importing into a module lookout for this option:

    anirudh_0-1587100623483.png

     

    And if importing into a list, lookout for this option

    anirudh_1-1587100672517.png

     

    Check that box and edit the mapping to suit your requirement

    anirudh_2-1587100706112.png

     

     

    Let me know if you need more help

     

    Regards,

    Anirudh

     

  • Ha Linh
    Ha Linh

    @anirudh Thank you very much!!!

Categories