How to prevent automatic record deletion in the import set table

[Yuki21]

Is there a way to prevent records in the import set table from being deleted?

By default, the cleanup schedule removes it every 7 days.

Instead of not deleting records in all import set tables, I want to prevent records from being deleted in specific import set tables.

[Maik Skoddow]

Hi @Yuki 

I didn't find a way to prevent specific tables to be excluded from data cleanup, but the overall configuration for the cleanup job can be found and configured as follows:

Let me know if you have any further questions.

Kind regards
Maik

[Yuki21]

It was already the same setting.
Please let me know if your perception is different.

[Hitoshi Ozawa · Accepted solution]

WARNING: making a mistake customizing a cleanup script may delete tables/records that was not intended. Take a backup and conduct tests to make sure to avoid unexpected behaviors. I take no responsibility for any lost.

The class that's actually cleaning up the tables is Scriplet Include named "ImportSetCleaner".

I haven't tested this and not 100% sure but there's a function "_getScriptedImportSetTables() that seems be querying the sys_db_object table to get import set table names to delete.

Customizing "ImportSetCleaner" class to skip tables that needs to be retained may solve the problem.

I won't directly modify the ImportSetCleaner class but clone it.

The job using this class is "Import Set Deleter" (System Import Sets >L Scheduled Cleanup". Change "var ic = new ImportSetCleaner();" to point to the customized class.

[Hitoshi Ozawa]

This section seems to be selecting files to process.