Error when importing a csv file into a module

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.

Accepted answers

All comments

Misbah

@CommunityMember131297

When you open the exported file the dates that you see is not Y-M formatted, instead it is D-M format.

Go to the Excel, right click on the cell, format cells and then change the format of the dates. Change it back to Y-M or M-Y format , save the file and then upload.

Hope that helps

Misbah

CommunityMember131297

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.

kavinkumar

@CommunityMember131297,

Try the option 'Match Names' instead custom mapping.

Regards,
Kavin.

CommunityMember131297

Hey Kavin,

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

Misbah

@CommunityMember131297

Unfortunately it will not work, whatever you change on the time mapping tab.

CSV files whenever opened will change the format of time. Txt files are better in handling such scenarios but have their own disadvantages such as playing with the data with ease. I would assume end users are loading the files to upload the data.

Exporting files and importing the same files are not the recommended ways . I would like to draw you attention to one of the Powerful and Coolest feature of Anaplan Excel Add -in. It is called "Send and Refresh" in Read- Write Connection. What it does is that it allows you to export the module/saved view to excel and then end users can amend the data and push it back to the model by one click.

Please go thru this.

https://help.anaplan.com/anapedia/Content/Extensions_and_Addins/Excel_Add-in/Data/Send-and-refresh-a-read-write-connection.htm

Happy Planning

Misbah

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…