Difference between revisions of "Simple Exports"

From Vital Soft Wiki
Jump to: navigation, search
>Johno
>Johno
(Where is the file created?)
Line 43: Line 43:
 
:* If the '''OutputFileName''' includes a path, the file is created in that location.
 
:* 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, is one is specified, on the same row as the report definition.
:* Use the FileCreatePath, if one is specified, on the PDFConfig page.
+
:* Use the FileCreatePath, if one is specified, on the [[DocumentDistribution.xls#Frequency_Sheets:PDFConfig|PDFConfig]] page.
 
:* If no path is specified, use the same directory as the Vital Signs application file (usually ''vitalsigns/CUNAME'')
 
:* If no path is specified, use the same directory as the Vital Signs application file (usually ''vitalsigns/CUNAME'')

Revision as of 21:58, 4 December 2015

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)