Outputting "Per Job" CSV Files in a DIM Project

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.
  1. referenceNumber - the unique identifier for each form draft submitted to Field2Base
  2. InternalFormId - the unique incrementing number assigned to Forms as they are downloaded
  3. FormProcessTime - the timestamp (which uses the Local Timezone) when the Form began processing
Note: Using these Internal Values guarantees a unique CSV Output filename for every Job processed since only one Job is “in process” at any one time.  Regions Values can be used (i.e. {Page1@Region1), but are unlikely to guarantee a unique output file every time (unless uniqueness is guaranteed elsewhere in your system).

To Add a Unique Filename:
  1. Click on the CSV Data Transform button.
  2. Enter the Output Path.
  3. Enter the Filename and include {InternalFormId} or {FormProcessTime} in the Filename.
  4. Enter the Number of Columns or Column Headers.
  5. Click OK.

    • Related Articles

    • 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 ...
    • 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 ...
    • 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 ...
    • 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 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 ...