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; } } }

Why isn't Anaplan populating the data?

sydneygouani

I am importing a file but Anaplan isnt populating the "Time Stamp" line item. Anaplan is mapping correctly and the import has no errors.

What am I missing?

Screenshot 2023-08-11 150254.png

Screenshot 2023-08-11 150521.png

Screenshot 2023-08-11 150738.png

Screenshot 2023-08-11 150813.png

Accepted answers

TristanS

@empressjewel Pardon I wasn't clear. I meant add a filter to the view. So follow instructions below:

In your module, click on the filter funnel (top middle highlighted in yellow). The Filter pop up window should then display,
Click on the + sign (highlighted right side in yellow) in the Tab for "OppProductID"
Add condition for Time Stamp" with condition "IS NOT Blank"

Then check if it returns anything

All comments

Tiffany.Rice

@empressjewel - have you tried the "Custom Mapping" in the import dialogue? This allows you to define the pattern of the date fields and you will be able to affirm the mapping is working when you see the date successfully display in green text (successful translation between the file into Anaplan date format).

sydneygouani

@Tiffany.Rice I just tried custom mapping and it didn't work. It mapped with no errors but the data still did not populate. See attached.

Screenshot 2023-08-11 180730.png

Screenshot 2023-08-11 180855.png

Tiffany.Rice

Color me stumped. The only other points I would say to consider -

Do you have any security restrictions (selective access or Dynamic Cell Access driver)? Doesn't look like it but always a good thing to check.
Double check the file you are loading. .csv files can be temperamental, if you open the file and save it can change formatting.

TristanS

@empressjewel can you try applying a filter on DAT05 Salesforece Bookings against "Time Stamp" with condition "IS NOT Blank" and see if it returns anything.

sydneygouani

@TristanS I didn't return anything

Screenshot 2023-08-14 104529.png

TristanS

@empressjewel Pardon I wasn't clear. I meant add a filter to the view. So follow instructions below:

In your module, click on the filter funnel (top middle highlighted in yellow). The Filter pop up window should then display,
Click on the + sign (highlighted right side in yellow) in the Tab for "OppProductID"
Add condition for Time Stamp" with condition "IS NOT Blank"

Then check if it returns anything

sydneygouani

@TristanS it worked! Thank you

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan Toolkit: side panel for model details, exports and model lock tracking
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
How to handle an Entity Structure change effective from January 2026 in Anaplan Consolidation & Repo
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
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…