Difference between revisions of "Simple Exports"
>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 | + | 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 | + | | 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. |
| − | + | |- | |
| − | : (*) | + | | 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)
