Exporters provide the instructions for outputting the event data.
Transformation functionality provides three types of exporters for exporting .vsl files, log files, XML files, and ODBC data as .vsl files, text files, or delimited text files that can be used by DataWarehouse loading routines, auditing agencies, or other targets.
To define an exporter
Open Transform.cfg in data workbench. See To edit the Insight Transform.cfg file.
Right-click Exporters, then click Add New.
Select one of the following options:
For the ExportVSLFile option, all of the extended fields in the input file and all user-defined fields of the form cs(header) are always written to the VSL output file. If you overwrite an existing extended field, the new value is written to the output file, even if the field is blank.
Edit the Exporters parameters in the configuration file using the following table as a guide:
For ExportTextFile only. The format of each output line, consisting of field name escapes (expressed as %fieldname%) and any other desired fixed text. The format should include a line separator, typically [CR] [LF].
A literal percent sign (%) can be embedded in the format string by escaping the character as shown here: %%
An example of an entry for the Data Format parameter is %x-timestring% %x-trackingid%[CR][LF].
|Fields||For ExportDelimitedTextFile only. Names of the fields to be output.|
Optional. For ExportDelimitedTextFile only. Character that is used to separate the fields in the output file.
The software can not escape delimiters that are included in the data's values. As a result, Adobe does not recommend using commas as delimiters.
If you hold down the Ctrl key and right-click within the Delimiter parameter, an Insert menu appears. This menu contains a list of special characters that often are used as delimiters.
|Line Separator||Optional. For ExportDelimitedTextFile only. The character(s) used to separate lines in the output files. The default value is [CR] [LF].|
Optional. Identifier for the exporter. This name appears in the Detailed Status interface.
For information about the Detailed Status interface, see the Data Workbench User Guide.
|Comments||Optional. Notes about the exporter.|
Path where output files are to be stored. The path is relative to the data workbench server installation folder.
Note: The data workbench server that stores output data is processing server #0 in the profile.cfg file.
|File Rotation Period||
Optional. The frequency at which data is exported to the output file. Each output file contains data related to a specific time period called the rotation period. All time calculations are in GMT: One day starts at midnight GMT and ends the following day at midnight GMT, even if the data written to the file includes a field which has been transformed to local time.
Available values are as follows:
The default file rotation period is DAY.
|File Name Format||
Optional. The format of the output file name.
Each log entry can be stored in a file whose name is derived from the start time of the rotation period, and optionally, from values of fields in the rows that it contains. The fields to use in the file name are embedded as field name escapes (expressed as %fieldname%).
The file name components related to the rotation period are embedded in the format string using the following escape sequences:
The default file name format is %yyyy%%mm%%dd%-%x-mask%.txt
|Execute at Rollover||
Optional. When each file is finalized, an external (Windows) command can be executed. The command line is derived from the final file name by substituting the following escape sequences into this parameter:
By default, this parameter is empty (no command is executed).
Optional. The amount of memory in bytes used for buffering the exporter's output. The default value is 10,000,000 bytes.
Note: If you have many output files that are open at the same time, you may want to increase this value, but you may decrease the amount of memory available for use by other components of the system. Decreasing this value, however, may slow down the export process. For assistance, contact Adobe.
|Open Files Limit||
Optional. The maximum number of files that may be open at the same time for output from the exporter. If this number is exceeded, an error is recorded in the event log and the data workbench server stops running. The default value is 1000.
After you have defined your exporter (and made changes to other parameters) in the Transform.cfg file, save the file locally and save it to the appropriate profile on the data workbench server machine.