Clean Up
Cleanup Setup in 3PL Dynamics
With every posted document, sent email, or aborted session, your database grows. That makes sense. However, not all data must be saved forever in your environment. For example, posted documents only have to be stored a couple of years and aborted scan sessions can be closed and deleted almost right away. That is where cleanup setups help you out.
With these setups, you can determine what data can be deleted after a certain period. In that way, you prevent your database from becoming unnecessarily big which could bring down your applications performance. But you also prevent error messages. As too many incorrectly closed scan sessions can cause errors in your process when your employees end up in an old session. Furthermore, EDI messages containing print documents in the DI Message Table can increase your database a lot, without you knowing. Therefore, delete these data periodically with the cleanup setup.
How To
- Access the cleanup setup.
- By default, there are several predefined settings. You can activate or change these (date filter or additional table filter). You can also add an additional rule. For example, to remove one-time addresses.
- Go to job queue entries
- Open a new job queue entry 'WMS Job Queue Task - Task 13' in order to automatically delete every night all the records that meet the criteria.
- Set the task to wait and schedule the cleanup action on a day/time when there are few or no transactions. For example, at night and only on Saturdays.
- The function 'Calculate' gives the number of records which are going to be deleted
- The function 'Cleanup All' delete the records
Tip
- If the task has never been run before, the first time will take longer.
- By opening the page: Progess log, users can gain insight into the progress and signal any problems.
Explanation Cleanup Setup
These fields define the structure and properties of the "3PL Cleanup Setup" table, which is used for configuring cleanup operations in an application. Each field has a specific purpose and data type, allowing users to define and manage cleanup settings for different tables in the system.
| Field Name | Field Type | Description |
|---|---|---|
| Table No. | Integer | Represents the number of the table. If a Table is not available in the Clean Up Setup please create a ticket to add the Table |
| Table Name | Text[100] | Represents the name of the table. |
| Table Caption | Text[249] | Represents the caption or description of the table. |
| Extra Table Filter | TableFilter | Represents an additional filter that can be applied to the table. It allows specifying additional conditions to narrow down the records to be processed during cleanup operations. |
| Type | Option | Represents the type of cleanup operation to be performed on the table. It is an option field with three possible values: "Delete", "Archive", and "Compress". |
| Field Number | Integer | Represents the number of the field within the table. Where the Date(Time) filter will be applied on. |
| Filter Field | Text[80] | Represents the name of the field used as a filter during cleanup operations. |
| Date Formula | DateFormula | Represents a formula used to calculate a date value during cleanup Operations. |
| Inactive | Boolean | Represents whether the cleanup setup is inactive or not. If set to true, the cleanup setup will not be executed during cleanup operations. |
| Last Executed | DateTime | Represents the date and time when the cleanup setup was last executed. |
| Total Records Deleted | Integer | Represents the total number of records deleted during the cleanup operation. |
| Records within filter | Integer | Represents the number of records within the specified filter criteria. |
Type Explanation
| Type | Description | Supported Tables |
|---|---|---|
| Delete | Records are removed from the table. | All |
| Archive | Max. Archive Date is 3 Months. This option will transfer the records from the WMS Document Header to the WMS Posted Document Header (including Sub Tables) | WMS Document Header |
| Compress | Will remove the unused Set Entries | - Report Usage - WMS Specification Set Entry - WMS Item Ledger Entry - WMS Doc. Info Set Entry - WMS Carrier Stack Set Entry - WMS Carrier Set Entry |
Tip
You can create multiple configurations per table. For example, for the DI Message table where you filter by SND-ZPL / SND-PDF and clean it daily, and the other message types once a month.