Target tab

This tab is where the output parameters for the export are defined:

  • Output Folder: The folder to place the newly-created export file in
  • Filename Format: The naming template for the newly-created file. A number of variables can be used to allow filenames to be created with dates etc. in them:
    • <CLIENT> The name of the current client
    • <DATE> The current date in yyyyMMdd format
    • <DATE-{days}> The current date minus {days} parameter in yyyyMMdd format
    • <DATE:{days}:{format}> The current date plus/minus {days} property and converted to {format} layout
    • <EXPORTEDCOUNT> The number of records actually exported in this export
    • <DD> The current day
    • <HH> or <HOUR> The current hour
    • <MM> The current month as number
    • <MMM> The current month as short 3 char name
    • <NN> or <MINUTE> The current minute
    • <ROWCOUNT> The number of records eligible for this export
    • <RUNNUMBER> The next run number – generated by counting number of times export has been run
    • <RUNNUMBER-{period}{length}> The next run number – generated by counting number of times export has been run in the {period} and formatted to be {length} characters long padded with 0.
      {period} can be :
      • D – per day
      • W – per week
      • M – per month
      • Y – per year
      • A - All
    • <PROJECT> The name of the current project
    • <TIME> The current time in HHmm format
    • <USERID> The user id (numeric) of the user performing the export
    • <USERLOGON> The user (login) name of the user performing the export
    • <USERNAME> Same as USERNAME
    • <YYYY> The current year as 4 digit number

    Example: An example filename format would be: EXPORT_<DATE-1>.TXT
    This would create the filename EXPORT_20110523.TXT if the export was run on the 24th May 2011.

  • Format: The type of file to be created. The support for the DevExpress XL Export Library eliminates the need to have Excel installed for exporting to .xls or .xlsx formats.

  • Delimiter: The delimiter to be used between columns for delimited exports for the Delimited Format.
  • Text Qualifier: The character that should be used to enclose text fields in delimited exports
  • Encoding: Select the required text encoding
  • Newline Character: Select the special character signifying the end of the lines
  • Overwrite destination file (checkbox): Should any existing file named the same be overwritten
  • Create empty file (checkbox): Should an empty file be produced if no records meet the export selection criteria
  • First Row as Header (checkbox): Should the column names be exported as the first row