Data staging list and module - Manage Inactive items not included in import file

MohammedTanveer

I'm currently working on a development where I need to update and validate data through an import process. Here's the scenario:

I have a module that tracks active locations, and data is imported into this module from a file. Initially, there are 10 active locations included in the file and imported successfully. However, in the subsequent import file, only 9 locations are present because one location has been closed and is no longer included in the file.

The closed location, which is no longer in the file, still remains in the module with an active status. The challenge I'm facing is that any location not present in the latest import file (e.g., due to closure) can be identified and updated in the module to inactive without deleting the list item specifically.

What’s the recommended approach to handle this type of scenario?

rob_marshall

@MohammedTanveer

Add a new column to the import file (name it Active Locations) with a hardcoded True as the value. In the module, create a boolean line item named Active Locations. Create an action that clears this boolean (turns all values to false). Create a Process with the first action clears the Active location value (turning it to false) and then loads the data. If you need to delete the closed locations, you can do that where all Active Locations is equal to FALSE.