Locking data in a module after import

Hi All,

We have a requirement where the client wants to fix data in a module after an import so as to prevent accidental override of data if another user run the import process in the same module.

Is there a way to implement this locking of data.

Regards,

Prateek

Accepted answers

All comments

[Deleted User]

There may be a more 'official' way to do this but here is how I've accomplished this. Create a new line item in the module you are importing into. Once you have the data imported, do a straight reference formula in the new line item pointing at the original (where your imported data resides) . Once you have entered the reference formula and all data has populated, simply delete the formula itself. The data will now stay static and not update as there is no longer a formula.

ChrisWeiss

Hi Prateek,

You're right that this is a challenging request, without implementing a strong business process to prevent overwriting the data (perhaps through dashboard instruction text).

Another option would be to enable Workflow for that list, so that after the import is run for the first time the user marks the data as Completed, which then turns each completed list item to Read Only data. Of course the typical Workflow considerations still apply, so maybe not the best solution, but definitely something to consider when it comes to locking only a subset of data within what should be a read/write module.

Good luck!

s.jansenidw

You can also try to build a staging module and a final module.

The staging module will only send data to the final module when a boolean (lock load) is ticked, in that way you can control when you want to update the data.

leo_tadjudin_1

@Prateek_S someone just posted a Job Aid that might be useful to give that impression of locking. This is assuming the "locking" is required only for specific line items.

https://community.anaplan.com/t5/Anaplan-Platform/Job-Aid-Copy-Current-Plan-to-Original-Plan-Using-Actions/m-p/22319#M396

Another way is to play with access right if the "locking" is required on module level. The original import could be done into a module which is given WRITE access only for Model Admin and READ for all users.

Hope it helps.

Thanks,

Leo

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385