Data Integration Module (DIM)
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 ...
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 ...
Troubleshooting the Data Integration Module (DIM)
Troubleshooting Installation Issues User Account Privileges If you encounter any Permission related issues when installing the Data Integration Module, you will need to check and make sure that you have Administrator rights so that the Program AND ...
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 ...
DIM 6.5 Install Guide
Integration Suite Editions There are two available editions of the Field2Base Integration Suite, the Server Edition and the Designer Edition. Each edition has a 32 Bit and a 64 Bit version. We recommend using the 64 Bit for increased memory ...
DIM 6.5 Upgrade Guide
Overview This article will guide you through upgrading your Field2Base Data Integration Module (DIM) software to version 6.5. Future upgrades will be available directly through the Data Integration Module Administrator. Backup Existing Database Files ...
DIM Reset Guide
Overview This document will familiarize you with the process behind resetting your installation of the Field2Base Data Integration Module (DIM). You may want to reset the DIM if you wish to recapture all data starting from a specific point in time ...
DIM Custom Plugin Reference Guide
Overview The Data Integration Module (DIM) allows Users to create custom Plugins that can directly interface with the Data Integration Service and Projects. This document describes how to setup and use Plugins with the DIM. DIM Processing Overview ...
DIM Image Plugin Set Up Guide
Overview This document will outline the process for setting up the Image Plugin created by Field2Base for use with the Data Integration Module (DIM). The Image Plugin allows a Customer running the DIM to generate Image files (JPG, PNG, etc.) from ...
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 ...
DIM PDF Plugin Setup
Overview The PDF Plugin allows customers running the Data Integration Manager (DIM) to save PDF files of Sent Forms to a specified file location. There are limited customize-able options for this plugin. The following options are available: The ...
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 ...
DIM Migration Guide
Overview This article provides the information necessary to migrate the Field2Base Data Integration Module (DIM) over from one server to another. Please refer to the DIM Install Guide for the initial installation of the Field2Base DIM. Once that's ...