Exporting CSV from Anaplan, incorrect date displays in Excel

hendersonmj
hendersonmj
in Integrations and extensibility

When exporting information into Excel by month it brings the dates through as text, ex  “Jan 18” = January 2018 and in Excel appears as “Jan 18” . Conversely when we export CSV files the “Jan 18” is converted to a date format with the wrong year “Jan 18” in Anaplan but = 1/18/19 in the CSV file. Is there a solution for this? (January 2019, will export from Jan 19 to 1/19/19 fyi)

Tagged:

Answers

  • rob_marshall
    rob_marshall

    Mike,

     

    When data is exported to a CSV file from Anaplan, dates are actually being exported.  If these are not showing properly, I would look into your regional settings on your computer.

     

    I found this on google for a Mac:  https://resrequest.helpspot.com/index.php?pg=kb.page&id=277

     

    I found this on google for Windows: https://www.google.com/search?ei=XHdTXJjyOo7ktQWOlrX4Bg&q=excel+regional+settings+windows+10&oq=excel+regional+settings+windows&gs_l=psy-ab.3.0.0j0i22i30l2.1766.2788..4460...0.0..0.61.410.7......0....1..gws-wiz.......0i71.uZNU28iCe5E

     

    Hope this helps and let us know if you are still having this issue.

     

    Rob

  • nathan.fowler
    nathan.fowler

    You can create an export/import process within Anaplan. Ideally we always want to plan within Anaplan but I have created export/import process. The date format changes when we export to csv. 

     

    • Export
      • File Type: CSV
      • Layout: Grid
      • Omit Summary
      • Include Empty
      • Action Name: Export [What you want to export] template
      • Process Name: EXPORT: [What you want to export] template
    • Import
      • Action Name: Import [What you want to import]
      • Process Name: IMPORT: [What you want to import] 
      • Time: Periods Y-M

    FYI, you'll probably get a date error when you set up the action. However, once you run the process end to end the data loads with no errors. This is pretty finicky and you may experience some errors. 

  • KartikJain
    KartikJain

    Hi, my company operates globally with users from various time zones and formats. When our European users import a template with time periods from Anaplan, their excel reads the date incorrectly in the csv file leading to errors when uploading back the template. It's unreasonable to expect them to change their system setting every time they need to make an export/import into Anaplan using time periods. Can we please find a solution to this issue rather than resorting to fake time periods? @DavidT

  • DavidT
    DavidT

    @KartikJain appreciate your comment, and wholehearted support from me. @rupert_tagnipes is there an update on this one?

Categories