Simple Exports

Summary

The simple export can be used to export the contents of a single chart or table to an Excel or CSV file. This type of report is equivalent to selecting Export on a chart while running Vital Signs interactively.

• A single selection is allowed
• File level banding is supported
• Excel is not required to be installed on the server.
• Default export is to an Excel xls file.

Export to xls files is limited to 65K rows

• If the file extension is csv a comma delimited (csv) file will be created.

There is no row limit when exporting to csv files

Setting Up a Simple Excel Export in DocumentDistribution

Add an entry to the DocumentDistribution file with the following fields:

DocumentName	Name of the Vital Signs Application (qvw file)
ExportType	Export
Definition	QlikView Object ID
OutputFileName	Name of the Excel or CSV file to be created (*)
FileExistsAction	Purge
Selection	Optional: Name of the selection
Banding	Optional: Name of the Banding Field
PrinterName	This field is ignored for simple exports.
EmailList	List of email recipients, separated by a semi-colon.
FileCreatePath	Default path to create the file, if no path specified in the filename.
EmailLinkPath	The path to include in an email instead of attaching the actual file.

(*) If a valid extension is not specified, a ".xls" extension will be added to the filename.

Where is the file created?

There are several ways to specify a path for the export file. The following possibilities are checked until a path can be determined:

• If the OutputFileName includes a path, the file is created in that location.
• Use the FileCreatePath, is one is specified, on the same row as the report definition.
• Use the FileCreatePath, if one is specified, on the PDFConfig page.
• If no path is specified, use the same directory as the Vital Signs application file (usually vitalsigns/CUNAME)