Difference between revisions of "Simple Exports"

From Vital Soft Wiki
Jump to: navigation, search
>Johno
m (Johno moved page Simple Excel Exports to Simple Exports)
>Johno
(Where is the file created?)
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
= Summary =
 
= Summary =
The simple Excel export can be used to export the contents of a single chart or table to an Excel file.  This type of report is equivalent to selecting ''Export to Excel'' on a chart while running Vital Signs interactively.
+
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
 
* A single selection is allowed
 
* '''File''' level banding is supported
 
* '''File''' level banding is supported
 
* Excel is '''not''' required to be installed on the server.
 
* 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 ==
 
== Setting Up a Simple Excel Export in DocumentDistribution ==
Line 15: Line 19:
 
     | Definition || '''QlikView [[QlikView Object ID|Object ID]]'''
 
     | Definition || '''QlikView [[QlikView Object ID|Object ID]]'''
 
     |-
 
     |-
     | OutputFileName || Name of the Excel file to be created (*)
+
     | OutputFileName || Name of the Excel or CSV file to be created (*)
 
     |-
 
     |-
 
     | FileExistsAction || Purge
 
     | FileExistsAction || Purge
Line 23: Line 27:
 
     | Banding  || Optional: Name of the [[#Report Banding|Banding Field]]
 
     | Banding  || Optional: Name of the [[#Report Banding|Banding Field]]
 
     |-
 
     |-
     | PrinterName || This field is ignored for QlikView PDF reports
+
     | PrinterName || This field is ignored for simple exports.
 
     |-
 
     |-
     | EmailList || List of email recipients, separated by a semi-colon   
+
     | EmailList || List of email recipients, separated by a semi-colon.
    |}
+
    |-
: (*) By default, the file is created in the same directory as the Vital Signs application file (usually ''vitalsigns/CUNAME'')
+
    | 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 [[DocumentDistribution.xls#PDFconfig Sheet|PDFConfig]] page.
 +
:* If no path is specified, use the same directory as the Vital Signs application file (usually ''vitalsigns/CUNAME'')

Latest revision as of 22:00, 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)