Next >> << Prev  

14.1. Data File Parameters Form


The Data File Parameters form is where you specify additional parameters related to the data file (e.g. format details, new or blank line handling, etc). It's accessible from any group or job by clicking the File Parameters link.

Data File Parameters Form  

The bottom part of the form (shown in red) is slightly different for exports and loads.

Group/Job Name: Shows the name of the group or job for which you are currently viewing/editing the data file parameters. This field is read only.

Number of Columns: This field shows the number of columns in a data file.

  • For exports, it's read only and shows the number of columns to be generated in the data file. It's calculated automatically after you run an export.
  • For loads, it shows the number of columns to be expected in the data file. It's populated automatically when you lookup a data file in the Column Definitions Form. If you don't have access to the data file when creating a load group or job, you can enter the number of columns manually. In that case the data file columns will be automatically name Column1, Column2, etc.

Worksheet Name: This field is only available if the data file format is Excel. It contains the name of the worksheet to read or create in the Excel file.

Header Row: Indicate if the data file contains a header row.

  • For exports, if the box is checked, the data file is generated with the first row containing the column names.
  • For loads, if the box is checked, the data file column names are read from the first row in the data file.

Character Encoding: Indicate the encoding of the data file. Values supported are ANSI (default), UTF8 and Unicode.

Columns Separator: Character(s) used to separate columns in a "Text with separator" data file. The default is the vertical bar ( | ) aka pipe character.

Comment Char(s): Character(s) used to specify a comment line in the data file. Lines beginning with these character(s) are ignored when a data file is read.

Quote Char(s): Indicate whether the quote character is single quote or double quotes.

Bottom Area for Exports

New Line Handling: Indicate how to handle new line characters encountered in exported data.
You can use any of the 3 options:

  • None: No particular handling is done
  • Automatic: New line characters (CR + LF) are automatically replaced by LF. This prevents exported field with new line characters to generate 2 lines in the data file.
  • Automatic: New line characters (CR + LF) are replaced by custom characters. You can choose between CR or LF or any custom set of characters.

Append to Existing File: If this box is checked, DMT tries to append exported data at the end of an existing data file. If the data file doesn't exist, it's created. If the data file already exists, exported data is added at the end of it.

Note: To append data at the end of an existing data file, it's recommended to use a data group rather than this check box.

Bottom Area for Loads

Blank Line Handling: Indicate how to handle blank lines encountered while reading a data file.
You can use any of the 3 options:

  • Skip Line (default): The line is skipped and no warning or error is generated.
  • Skip Line + Warning: The line is skipped and a warning is generated.
  • Skip Line + Error: The line is skipped and an error is generated.