Error when importing a csv file into a module

Options
CommunityMember131297
CommunityMember131297 Member, ALL USERS Posts: 3 New Contributor
in Extensibility

I am facing an issue with exporting and importing a csv file. So I have a file that I am exporting with data for 12 months (Dates are formatted as Y-M, (i.e. 19-Jul) in the exported csv file). Then when I try and import the same file using custom mapping (Y-M) for Time, I get a failure dump and an error which reads: Import into module failed. "The column headers in the file you are attempting to import do not match the import definition. . . Expected 2 or 4-digit year in date/period"


Any help would be appreciated.

Tagged:

Comments

  • CommunityMember131297
    CommunityMember131297 Member, ALL USERS Posts: 3 New Contributor

    Ah I see that; however, there will be multiple users uploading multiple files using the export and import created so manually updating the date format in excel is not an option. Is there any way to get the export to export the time in the desired Y-M format instead of D-M.

  • CommunityMember131297
    CommunityMember131297 Member, ALL USERS Posts: 3 New Contributor

    Hey Kavin,

     

    I tried your suggestion; however, I got the error "Invalid date or timescale identifier".

Categories