• Release History
  • Documentation
  • Back to www.mscrm-addons.com
  • Release History
  • Documentation
  • Back to www.mscrm-addons.com
home/Knowledge Base/DocumentsCorePack(DCP)/How to purge temporary data files

How to purge temporary data files

1276 views 1 Updated on March 14, 2023

Every time a document is created in Microsoft Dynamics CRM, a corresponding temp is created by the system. This step consumes a lot of database storage. This article provides step by step instructions on how to

A) find the correct temporary data files and how to
B) create a workflow that purges the temporary data files automatically

A) How to find the correct temporary data files

Step 1: Click on the [Advanced find]-button in order to open the Advanced find.

Open_advanced_find
Figure 1: Open Advanced Find

Step 2: Open the Drop-Down-Menu next to the Look for:-field and select
MSCRM-ADDONS.com User/Temp Settings.
Click on the blue and underlined Select-fields in order to modify your search options equal to figure 2. Please notice that these are OR-criteria. 

Figure 2: Specify criteria

Please select the following criteria (combine with OR-statement):

Name begins with AM_Doc
Name Equals DCPConcatenatedDocument
Name Equals SharePoint Doc converted
Name Equals SharePoint Template
Name Equals DCPSaveToSharePoint
Name Equals DCP API AttachToEmail
Value Begins With print:?id=
Value Begins With fetch:<fetch
Value Begins With <DSSetting

Step 3: Click on the [Results]-button in the Advanced Find-tab and…

Click_on_results
Figure 3: Get results

Step 4: … be prepared to receive your results. Now you have two options. You can manage your temp data manually every day (which could be a little exhausting) or you create a workflow (which is explained below in part B)).

B) How to create a workflow that purges the temporary data files automatically

Step 1: Open the Microsoft Dynamics CRM Settings and click on Data Management in the extension.

Workflow_Settings_1
Workflow_Data_management_2
Figure 4: Open Data Management

Step 2: Please click on Bulk Record Deletion in the next window that opens.

Figure 5: Open Bulk Record Deletion

Step 3: Click on the [New]-button in the left upper corner.

Workflow_New_4
Figure 6: Create new bulk record deletion

Step 4: The workflow wizard window opens. Click on the [Next]-button in order to proceed:

Workflow_Wizard_5
Figure 7: Workflow wizard

The wizard helps you to define your deletion criteria for your workflow. Open the Drop-Down-Menu next to the Look for-field and select
MSCRM-ADDONS.com User/Temp Settings.
Click on the blue and underlined Select-fields in order to modify your search options. Please select the same criteria you have selected in Step 2.
Please select the following criteria:

Name begins with AM_Doc
Name Equals DCPConcatenatedDocument
Name Equals SharePoint Doc converted
Name Equals SharePoint Template
Name Equals DCPSaveToSharePoint
Name Equals DCP API AttachToEmail
Value Begins With print:?id=
Value Begins With fetch:<fetch
Value Begins With <DSSetting

Step 5: You can select your preferred scheduling and notification options in the next window. Decide when and how often the workflow should start, name it appropriately and set a notification (optional). Click on the [Next]-button in order to proceed.  

Workflow_wizard_erg_neu

Figure 8: Select preferred scheduling and notification options

Step 6: The next window provides you with an overview of your settings. If you agree, click on the [Submit]-button. Congratulations! You have just created a workflow! Smile

If you want to change your settings, simply click on the [Back]– or the [Cancel]-button in order to cancel the workflow.

Screenshot_1

Figure 9: Finalize workflow

9_bearbeitet
Figure 10: Modify workflow

Step 7: To modify your created workflows, simply set the My Bulk Deletion System Jobs in the [VIEW:] and find all your workflows listed.


Clicking on NEW will create a new workflow.
Clicking on PRINT will print the list.
Clicking on EXPORT TO EXCEL will export the selected data to Excel.
And clicking on the MORE ACTIONS dropdown menu provides you – surprisingly – with more actions like those shown above. You can set a view as the default view, modify the recurrence and cancel, resume, postpone, or pause your workflow.

Additional: How to delete the MSCRM-ADDONS.com Debug records

Setup another Bulk Deletion Job, this time for the MSCRM-ADDONS.com Debug entity:

Data Management - Bulk Record Deletion
Figure 11: Data Management – Bulk Record Deletion

  

Again, the wizard helps you to define your deletion criteria for your workflow. Open the Drop-Down-Menu next to the “Look for”-field and select MSCRM-ADDONS.com Debug.

This time you do not have to set up any special parameters as the Debug table does not contain any sensitive data. Set up the scheduling options again and submit your workflow, like you can see it below.

Select Options
Figure 12: Select Options
Additional: How to delete the MSCRM-ADDONS.com  AutoMerge-Working-Items

Setup another Bulk Deletion Job, this time for the MSCRM-ADDONS.com AutoMergeWorkingItems entity:

Again, the wizard helps you to define your deletion criteria for your workflow. Open the Drop-Down-Menu next to the “Look for”-field and select MSCRM-ADDONS.com AutoMergeWorkingItems.

Setup the following parameters:

Status: Equals  =  Inactive
CreatedOn: Older Than X Days  =  7

Figure 13: AutoMerge-Working-Items-Wizard

Set up the scheduling options again and submit your workflow, like you can see it below.

Figure 14: Select Options

 

That’s it! We appreciate your feedback! Please share your thoughts by sending an email to office@mscrm-addons.com.

Was this helpful?

1 Yes  1 No
Related Articles
  • Template Management in DocumentsCorePack 
  • “Undefined”-labels in Chrome 114 and higher
  • Generate large documents using the Multipart-feature of DocumentsCorePack 
  • How to automate the E-signature process via Power Automate
  • Technical Description: The AutoMergeWorkingItem (AMWI) 
  • Dataverse Online OData v2.0 endpoint removal for custom “ExportToWord” Button
Latest Articles
  • Template Management in DocumentsCorePack 
  • “Undefined”-labels in Chrome 114 and higher
  • Integrating JSON data into documents
  • Generate large documents using the Multipart-feature of DocumentsCorePack 
  • Recap: DynamicsMinds Conference 2023
Popular Articles
  • DocumentsCorePack Template Designer – Getting Started
  • Where do I find the Unique Organization name in Microsoft Dynamics 365?
  • Step-by-Step: How to configure a One-Click-Action
  • mscrm-addons.com Application Access for Dynamics 365 (App Access) – DocumentsCorePack
  • DocumentsCorePack Online Service Configuration
Top Rated Articles
  • IMPORTANT information for Dynamics 365 online customers using DocumentsCorePack and/or AttachmentExtractor
  • How to activate the DocumentsCorePack connector for PowerApps & Microsoft Flow
  • Step-by-Step: How to configure a One-Click-Action
  • “Undefined”-labels in Chrome 114 and higher
  • “Blocked by Conditional access” error in Azure Active Directory
Categories
  • *News and General Infos* 52
  • Webinars 36
  • Template Designer(DCP 181
  • DocumentsCorePack(DCP 198
  • TelephoneIntegration (TI 65
  • AttachmentExtractor (AE 62
  • PowerSearch (PS 48
  • ActivityTools (AT 59
  • SmartBar (SB 53
  • GroupCalendar (GC 46
Our Vision

“We see it as our purpose to provide products that simplify and speed up our customers’ Microsoft Dynamics 365 experience.”

Knowledgebase
LogIn
mscrm-addons.com
  • Products
  • Online Shop
  • Downloads
  • My Account
About Us
  • About Us
  • Case Studies
  • Newsletter
  • Partner Program
  • Contact
Support
  • Support
  • Terms & Conditions
  • Documentation
  • Webinars
  • Legal Documents
  • Impressum
  • © 2022 www.mscrm-addons.com. All Rights Reserved.