The Export Template Designer’s Options tab contains a series of properties that define the format of an exported file based upon the export template.
The following properties can be configured:
•Usage: see The Export Template Designer and NoSQL Databases.
•Resolution Level: selected using a dropdown, which displays all existing resolution levels. Resolution level is mandatory and is accompanied by the text: ‘Defines table from and key level at which data retrieved when exporting data’.
Note that, if the current RPI client has been configured with one or more auxiliary databases, you can choose an auxiliary database resolution level. The export template can then be used when exporting selection rules with auxiliary resolution levels. You cannot use an auxiliary export template in an interaction.
If system configuration setting EnableOrgNodeConfigUserControl is set to true, and there exist any resolution levels to which you do not have access, a View restricted items button is shown at the bottom of the dropdown.
Note that restricting access to specific resolution levels is carried out in the Resolution Levels configuration interface, in which you can link a resolution level to one or more organization nodes.
If your user account is linked to an organization node user group that matches a resolution level’s linked organization node, you will have access to that resolution level. If a resolution level is associated with more than one organization node, a user need be associated with only one of the nodes to access the resolution level. If a resolution level is associated with a descendent node from an organization hierarchy, a user associated with an ancestor node may access the resolution level.
For more information, please see the Configuration Workbench documentation.
When you click the button, it is selected, and its text set to Hide restricted items. A list of restricted resolution levels is displayed at the bottom of the chooser.
You can select a restricted resolution level; however, on its display at the export template, it is accompanied by a warning indicator. A tooltip is shown when you hover over the warning icon.
Restricted Items are hidden again on redisplay of the chooser. If no restricted resolution levels exist, the Restricted Items button is not shown.
If system configuration setting EnableOrgNodeConfigUserControl is set to false, Restricted Items are not shown, and access to all resolution levels is freely available, irrespective of any linked organization nodes.
•Export Format: this property allows you to define the template’s basic export format. It is set using the following fields:
o Export Format: a drop-down list, which exposes the following values:
§ Delimited (the default)
§ Fixed width
§ JSON
o Delimiter: displayed when Delimited is selected. A dropdown field, it exposes the following values:
§ Comma
§ Pipe
§ Space
§ Tab
§ Custom
o Custom Delimiter: displayed when Delimiter is set to ‘Custom’. A text field, it is limited to a single character only. Its default is blank.
o JSON Format: displayed when Delimiter is set to ‘JSON’. A dropdown field, it allows you to define to type of JSON to be written at export execution. It exposes the following values:
§ Object List: the default value. When selected, output files will contain a series of JSON objects, one per line. Note that objects are not separated by newline characters when appending records to an existing file.
§ Array: when selected, output files will contain a JSON array.
When Export Format is set to ‘JSON’:
o Field Wrapping is disabled and set to 'None'.
o Wrap All Fields and Header Row are not shown.
•Field Wrapping: this dropdown allows you to define whether and how to wrap values in the export file in quotes. It exposes the values None (the default), Single quote and Double quote. This property is not available for fixed-width export templates.
•Wrap All Fields In Quotes: this checkbox, disabled if Field wrapping is set to None, allows you to control whether all, or just string, fields are to be wrapped in the selected quote type. This property is not available for fixed-width export templates.
•Header Row: a drop-down list, constrained to values ‘Include header row’ and ‘Don't include header row’. Default is Include header row. Header row is accompanied by the text: ‘Defines whether to include header row in output’.
•Unique ID: a drop-down list, constrained to values ‘Include unique ID’ and ‘Don't include unique ID’. Default is Don't include unique ID. If a unique ID is required, an additional column (RowCounter) is added to the output and populated with an incrementing integer value (preceded by zeroes, to a maximum of 9 characters in length). Unique ID is accompanied by the text: ‘Defines whether to include unique ID column in output’.
•Deduplication: note that this field is only of relevance when the export template is being used during selection rule export. It is used when a selection rule's output contains multiple rows per resolution level deduplication key and describes how duplicate rows are to be eliminated in such a situation. It is populated using a drop-down list, which is constrained to the values ‘Don't deduplicate’, ‘Use random sampling’, ‘Sample ascending using’ and ‘Sample descending using’.
If Sample ascending using or Sample descending using is selected, you may specify an attribute by which to deduplicate. You can browse for an attribute or select a recently-used one. You can also drag an attribute from the toolbox and drop it directly onto Deduplication. Exists in table and parameter attributes are not supported in this context.
Deduplication’s default value is Don't deduplicate. The field is accompanied by the text: ‘Defines how duplicate records are to be handled’.
•Sample Export: another drop-down list, constrained to values ‘Output initial rows’ and ‘Output evenly-distributed rows’. Default is Output initial rows. Sample export is accompanied by the text: ‘Defines basis upon which sample export generated’.
•Sample Export size: this mandatory property specifies the number of rows to be output in an export sample file when using the current export template. It defaults to 20 and supports a minimum value of 1. It controls the maximum number of rows to be output in a sample file when executing an export activity based on the export template, or a data extract offer using a channel configured with the export template.
•Date Format: allows you to specify the format of any date attributes output within a file based on the export template. Date format is set using a drop-down field that exposes the following values:
o Custom format
o Long date
o Long date and long time
o Long date and short time
o Long time
o Month day
o Short date (default)
o Short date and long time
o Short date and short time
o Short time
o Sortable
o Year month
If Use custom format is selected, it is mandatory to supply a custom format. The maximum custom format length is 100 characters.
•Example Output Format: provided to illustrate the selected date format value. The example output format uses the local culture selected on your client application machine to determine the precise format to use – for example, if your client application’s culture is set to US English, an example of the US version of Long date will be displayed (‘Monday, July 05, 2010’).
When a custom format is specified, the example is displayed dynamically as the format is entered.
Date format is accompanied by the explanatory text: 'Defines how dates will be formatted in the output'.
The field is read only and set to Sortable if using a JSON Export format.
•Text Encoding: a dropdown allows you to specify the type of text encoding to be used by the export template. The following options are available:
o UTF8 (the default)
o Unicode
o UTF7
o UTF32
o ASCII
o Big Endian Unicode
o Custom encoding
If Custom encoding is selected, you must specify a custom text encoding string in the field supplied.
•Non-Printable Characters: this setting allows you to define whether any non-printable control characters are to be removed from the output. A dropdown field, it exposes values ‘Don’t’ remove them’ and ‘Remove them’. If set to the latter, any non-printable characters are removed at export file generation.
Note that control characters are formatting and other non-printing characters, such as ACK, BEL, CR, FF, LF, and VT. T The Unicode standard assigns code points from \U0000 to \U001F, \U007F, and from \U0080 to \U009F to control characters.
•Custom Header: this dropdown allows you to define whether an extra custom header row will be included at the top of any files generated using the export template. If set to ‘Include’, a property to the right allows you to design the custom format using the Design Custom Header dialog. Having specified a custom header, it is displayed as the button text.
The Design Custom Header dialog contains the following:
o Toolbar: exposing the following options:
§ Add a new Text Part: invocation of this option displays a context menu, which exposes the following:
Selection of a context menu option adds a text part of the selected type to the Text Parts list.
§ Move the selected Text Part up: this option is available at text parts other than the first in the list. Clicking it moves the selected text part up one position in the list.
§ Move the selected Text Part down: this option is available at text parts other than the last in the list. Clicking it moves the selected text part down one position in the list.
§ Remove the selected Text Part: invocation of this option removes the selected text part without display of an ‘Are You Sure?’ dialog.
o Text Parts list: any text parts added to the list are shown. For each, the following are displayed:
§ Ordinal number: read-only
§ Text part type: read-only
§ If a String: a text field is displayed, and provision of a value therein is mandatory. The maximum permissible length of a provided value is 100 characters.
§ If Date part: a dropdown facilitates selection of a specific date part to show.
§ If File name: [File name]
§ If Record count: [Record count]
o Example: this section displays a read-only representation of the specified text parts, which are shown as follows:
§ String: displayed as entered.
§ Date part: the current date/time is displayed in accordance with the selected date part type.
§ If File name: [File name]
§ If Record count: [Record count]
o Close: clicking this button removes the dialog from display. Any changes made therein are persisted automatically. Note that clicking off the dialog has the same effect.