DigEraseCleanup Workflow

This workflow cleanup all unreferenced files from a table. With this workflows those files can be deleted directly or move to another location. Moved files can be automatically deleted at a later time (like a paper bin / trash folder). Unreferenced files are files stored in the directory of a DigaSystem Table without an media entry in the content database.

The workflow is usually configured via a Workflow Scheduler which takes care of instantiating a workflow based on a schedule. Please see Configuring Workflow Scheduler for more information.

Important: Please us this workflow first in “TestOnly” mode and make a analysis what files have been deleted by your configuration. It is also requested to have backups for your media files and database to secure the consistency of data. Use this workflow once a day to ovoid additional fast data loss.

Minimum Versions: (Release 2024.3.0)

DPE: Best: 2.13.56.0, Minimum 2.13.42.0 (used by api/entryIds)
WorkflowServer: Best: 2.13.11.0, Minimum 2.3.22.0 (used by DbGetTableInfo, DbGetTableInfos, HttpGet)

Workflow arguments

Name

Type

Description

DeleteEmptySubFolders

System.Boolean

In some cases media files are stored in sub-folders for a table media directory. For example like \\ServerName\DatabaseName\TableName\Subfolder\myFile.txt.
Once a media file was deleted/moved and there are no other files stored inside of that SubFolder the Workflow can also delete this folder. Default: True

ExtensionsToUse

System.String

Defined extensions by a comma separated list will be used for delete or move cleanups. The filter is case insensitive.
Example: .wav,.mus,.mp3,.dbe,.dbx

ExtensionsToIgnore

System.String

Defined extensions by a comma separated list will be ignored for delete or move cleanups. The filter is case insensitive.
Example: .wav,.mus,.mp3,.dbe,.dbx

MovedFilesDeleteDays

System.Int32

When files have been moved to a “trash folder” the trash folders will be deleted after the defined days. Default: -1
With -1 the folder will not deleted by the workflow.

MoveFilesTo

System.String

Define here the folder if files should be moved instead of deleted by the workflow. The files will be stored in Subfolders by the Folder Naming “WorkflowName_DatabaseName_TableName_DateTime”.
Default: C:\Temp\DigErase
Hint: Use a Server Directory with enough space.

MaxFilesToHandle

System.Int32

The maximum of files will be moved / deleted per table
Default: 50
Important: start with low numbers to ovoid data loss.

ReportFolder

System.String

Define here the folder where the workflow should store report files. The workflow creates 3 different files for every defined table. Default: C:\Temp\DigErase

*FilesDelta.txt = shows the delta between the files found in the folder and the media entries found for a table. => Unreferenced files

*MediaDelta.txt = shows the delta between the media entries of all entries of a table and the files found in the sound directory of a table. => Referenced Files where missing in the file folders

*FileJobs.txt = shows all files have been moved or deleted by the workflow including the last change date from the original file.

TestOnly

System.Boolean

Simulates deletion. Default: True

TableIds

System.String

TableIds for which the workflow has been created.

Verbose

System.Boolean

More logging

Workflow Overview of the steps been done