importing data into list item

Takamasa

Hi!

I'm taking a lesson list's course which is before 102 and have a question about Central Library(list import).

I imported the data of Employees.csv, following the guide, but unlike the guide, error occurred.

So next I filled in all source blank like photo, then I imported successfully.

Why error occurred regardless of doing same way as the guide?

central 2.PNG central 3.PNG central 4.PNG

Accepted answers

SandeepB

Hi @Takamasa ,

Your imports are failing because of the date format in the property or model time settings. Please review the same and load it again.

Anaplan date import.PNG

Also, you can specify which format of the date you trying to load.

Hope this helps.

Thanks,

Sandeep

bram.kurstjens

Hi Takamasa,

Your first import where you map against name is correct, however Anaplan does not seem to recognize the date format you are importing. You can select the boolean next to start date and leave date (Custom Date Mapping) and then select the right mapping (M-D-Y). See screenshots below:

Once you have mapped them both correctly, you can run the import.

KR,

Bram Kurstjens

anirudh

Hi Takamasa,

You do not need to fill in the Code when importing by Name. So the blank is not what is causing the issue here. Please check the Custom Date Mapping checkbox for both Start Date and End Date and use the MMDDYYY M-D-Y mapping.
Regards,
Anirudh

bram.kurstjens

Just a quick heads up, the format Takamasa is using is M/D/YYYY, M/DD/YYYY, MM/D/YYYY and MM/DD/YYYY. The fixed format MMDDYYYY will not work for that as it will try to match it with each character as a string. The M/D/Y format as explained in the grey box will be able to deal with single or double digit months/days/years.

All comments

SandeepB

Hi @Takamasa ,

Your imports are failing because of the date format in the property or model time settings. Please review the same and load it again.

Anaplan date import.PNG

Also, you can specify which format of the date you trying to load.

Hope this helps.

Thanks,

Sandeep

bram.kurstjens

Hi Takamasa,

Once you have mapped them both correctly, you can run the import.

KR,

Bram Kurstjens

anirudh

Takamasa

Thank you so much. I did it!

bram.kurstjens

anirudh

Thanks, edited my reply to reflect this!

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…