Tracking import date

Hello,

I'm having a little difficulty with something in Anaplan. I want to set up a system (module) where every time the end user try to import a new file in a page, we can note down the date it happened. We have different files, and I'd like to keep track of the last date data was brought in for each file separately.

i want to know only the date

Can we make this work in Anaplan?

Thanks!

Accepted answers

All comments

Dikshant

you need to have an todays date variable setup in Anaplan via automation. Set it up using cloud works or any third party integration tool if you're already using one.

Then based on it, create a new variable called, lastFileLoad Date and import the todays date into this lastFileLoad line item whenever user upload a file. You your process will have 2 action, 1st action to load the file via CSV and 2nd action to import todays date into lastFileLoad Date line item.

Let me know if you've questions regarding the same. I can draw it out and explain the approach better.

ILYAS

@Dikshant thank you for your answer but i didnt quite understand how to do it honestly.

i dont have a third party and i'm only planned to do it using import in modules using lines items.

do you know any approach to do it via this way?

A drawing would be helpful thank you 😃

Dikshant

Sure, I will draw it out and explain, but one challenge is that since you do not have any integration tool (Cloud works), or third party) you would not be able to store todays date in Anaplan via automation.

Correct me if there is any sort of automations you're using then that would be better but an alternative solution could be you need to give an extra columns to the user (Submitted Date) and user have to fill in that column manually, so that you can track the date user uploaded the data.

If there was an automation you are using we can automate this step and user don't have to enter the date manually and we can figure it by creating one extra action.

Let me know your thoughts on the same.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…