Create CSV Report actions write the contents
of a Table dataset to a CSV file in Unicode format. Each report generated
by the action is stored in a folder underneath the LiveCompare user data
directory. If the Create CSV Report action’s Fixed parameter is set
to ‘false’, its reports are stored in the following time-stamped directory:
<LiveCompare user data dir>\public\Reports\<Workspace
Name>\<Report Name>_YYYYMMDD_HHMMSS
If the Create CSV Report action’s Fixed parameter
is set to ‘true’, its reports are stored in the following directory, which
does not include a time stamp:
<LiveCompare user data dir>\public\Reports\<Workspace
Name>\<Report Name>
Action Property
Description
Delimiter (optional)
A String parameter which stores the field delimiter to use when generating the report file. The default value is ‘\t’ (tab). Set this parameter to ‘,’ (comma) to produce a comma-delimited report file.
Encoding
A String parameter which stores the UTF encoding to be used for the resulting report file. This parameter may be set to either UTF8 or UTF16. If this parameter is not set, UTF16 is used as the default value.
Fixed
A Boolean
parameter which indicates whether the Create CSV Report action will
generate fixed location reports. If this parameter is set to ‘true’, the
action stores its report in the <Report Name> directory; this directory will be removed and then recreated each time the
action is run. If the Fixed parameter is set to ‘false’, a new report
will be generated in its own time-stamped directory each time the action
is run.
Each fixed location report in a workspace should
normally have a different value for its Report Name parameter. This
will ensure that each workflow’s Report URL dataset points to the expected
report.
Report Name
A String parameter
which stores the name used for the generated report. If the Fixed parameter
is set to ‘false’, the generated report name includes a timestamp indicating
when the report was created.
Report URL
A String dataset
which is set to contain the URL of the generated report file.
Source
A Table dataset
containing the data that will be written to the CSV report file.
Text Qualifier (optional)
A String parameter which stores the qualifier used to identify text fields in the report file. The default value is " (double quotes).
Generated CSV reports may be opened by double-clicking
the Report URL dataset, or choosing ‘View Details’ from the dataset’s
context menu. In order to download each report, your web browser must
have the following security settings specified for the ‘Intranet’ and
‘Local Intranet’ zones:
Setting
Value
Automatic prompting for file downloads
Enable
File download
Enable
These settings can be found in the ‘Downloads’
section of Internet Explorer’s ‘Security Settings’ dialog.
When downloading CSV reports, the ‘File Download’
dialog may display the report filename with an .xls extension, although
the report has CSV format. If you need to save a local copy of the report,
click ‘Open’ to open the report in Excel, then use the ‘Save As…’ option
to save the report in the required format.
Generated CSV reports may also be accessed
from a workspace’s Reports folder in the LiveCompare hierarchy. Choose
‘Reload Children’ from the folder’s context menu to list any newly-generated
reports.
Example:
To examine the details
for a Create CSV Report action, double-click the action node, or select
‘View Details’ from the node’s context menu. The Details screen displays
the number of records read from the Source table, the number of records
written to the report and the time taken for the action to complete.