Column Headers causing Invalid date error

Options
MehdiCH
MehdiCH Member, ALL USERS, Partner, Certified Model Builder Posts: 4 New Contributor
in Extensibility

Hello,

 

I am currently working on a project that requiers the end-user to export a  module, change the data, then import the exported file in the same module. However, since i'm using numbered lists, i need both the code and display name in the exported file ( code to import the data back, display name for the user). But by doing this, the template of the file will always have columns that are not needed for the import, and that anaplan will treat as invalid dates, causing the following Error message :" Invalid date or timescale identifier header" to appear for each line.

Is there a way to work around this ? Putting the time-scale in a single column is very inconvevient for the user 

 

Thanks in advance and have a great day ! Anaplan Error.png

Tagged:

Comments

  • MehdiCH
    MehdiCH Member, ALL USERS, Partner, Certified Model Builder Posts: 4 New Contributor

    Hi  Aakash,

     

    Thanks for the answer, how would the staging module look exactly ? If we take the example of the "country\Accounts" ive put in my original question ? adding line items called "Country Display name" and "Account display name" will not do the trick since the error still comes from the invalid timescale.

    Do i need to add 2 extra dimensions to my staging module ? : ie , fake Country and Account lists, based on the display names of the original lists ?

     

    Thanks in advance

Categories