Data Integration Module (DIM) Product Guides
Creating SQL Update Data Transformations
Overview The standard SQL Data Transformation used in a DIM Project is an Insert SQL transaction. SQL Update transactions are also supported for cases when a company needs to update existing information in their SQL Database. This feature is only ...
Outputting "Per Job" CSV Files in a DIM Project
The DIM Project Manager allows you to output a new CSV file with every Job (Form) processed by using one of the following Field2Base Internal Values in the Output filename. referenceNumber - the unique identifier for each form draft submitted to ...
Limiting Job Downloads Start Date in the DIM Service
Overview The Data Integration Module Service defaults to downloading the entire sent history for the Form defined in the Project. Similar to limiting Download Batch Sizes, this feature is only available by editing the Project (.XML) file directly ...
Limiting Download Batch Sizes in the DIM Service
Overview The Data Integration Module Service defaults to downloading all possible Jobs in a single batch for the Form defined in the Project. The default size is to download every Form ever sent by the Company. Similar to limiting Job Downloads by ...
Data Integration Module (DIM) Filenames and Folder Structure
Overview The Field2Base Data Integration Module interacts with your local Computer system. This article highlights the actual executables that may cause security alerts as well as outlines the folder structure of the application. Application ...
Additional Project Options Not Available in the DIM Project Manager
Overview The Field2Base Data Integration Module does have some Project features that can be added by directly editing the Project XML file with a Text Editor. Most of these features are advanced or not often used options and were not included in the ...
Using Conditions in DIM Projects
Overview The Data Integration Module Project Manager allows the User to create Conditions on CSV and SQL Data Transformations that will decide whether or not to Output the processed data of a Job. These Conditions can be setup on each Row (CSV) or ...
Data Integration Module (DIM) Sample Project Walkthrough Guide (SQL Output)
Overview This document walks through the setup of a SQL database output Sample Project in the Field2Base Data Integration Module (DIM) software. Reference Files & Folder Setup Note: This document assumes you have already installed the latest version ...
Keywords Available for DIM Projects
{referenceNumber} - to get REF# in F2B system for a Form {WorkflowDocumentURL} - the direct URL of this form {FormProcessTime} - to get the timestamp for when DIM processes a form {InternalFormId} - get Dispatch ID for the form in the local DIM ...
Data Integration Module (DIM) User Guide
Overview The Field2Base Data Integration Module allows you to automatically download data from your Sent Forms to your backend systems. The DIM provides transformation of your Form Data into a variety of formats including CSV and SQL. The DIM Sample ...
Data Integration Module (DIM) Sample Project Walkthrough Guide (CSV Output)
Overview This document walks through the setup of a CSV output Sample Project in the Field2Base Data Integration Module (DIM) software. Reference Files & Folder Setup Note: This document assumes you have already installed the latest version of the ...