nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Level 1 activity 7.2.3 importing and mapping data

fabiof71

I keep getting errors when trying to load Employees data.

All gets loaded correctly.

Only exception is Start Date and End Date fields where I get an error as per attached

Errors_Employyes loading.png

Can it be due to local date format? I am UK based…

Thanks

Accepted answers

SriNitya

Does it have to have "Time" in the heading in order for Anaplan recognizing the field as time related? My issue is otherwise I do not see a tab created in the import file to map the fields "Start Date" and "Leave date".. → No it is not required.
Refer the article shared by Tiffany, it helps you understand in detail on Time format map while import.

All comments

Tiffany.Rice

When importing into a date field if the source file doesn't have the default date format you may need to select an alternate pattern within the mapping tab of the import. In your instance the file seems to display the date as YYYYMMDD, as such you will need to select that pattern format.

https://help.anaplan.com/map-the-timescale-in-a-module-import-0acf8ae5-b032-45fd-b785-6b1acc1e5934

fabiof71

Thank you Tiffany.

Note that in the Module I have these two mapped as "Date" format.

SriNitya

Quick Links

Can you help?

Unanswered questions

Recommended Design for Determining Whether a Source Combination Exists in a Target List
Hello Anaplanners, I'm looking for advice on the best modeling approach for a DCA use case. Scenario I have an input module called "CC-Account Activation". It is dimensioned by: Cost Center (CC) Account Users can select an Activate? boolean to indicate that a Cost Center / Account combination should be activated. I have a…
Anaplan XL Forms Error
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…