Clicking on any form showing Stream Data (either a grid or chart) will open the form described here and allow options to be selected before downloading the associated data as an Excel file This page is for users who want to export data using the
button.Insert excerpt _excel_export _excel_export nopanel true
Overview
There are several places where you can use the
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
- stream views
PhixFlow displays data from a stream in a stream view. Stream views can be a table (grid) or a chart. Stream views are often included in dashboards or in application screens.have a toolbar in the top right.
→ Archive Log tabInsert excerpt _console _console nopanel true - datasource properties →
Insert excerpt _datasource_show_tables _datasource_show_tables nopanel true
To export the data displayed in the stream view, click the toolbar button
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
PhixFlow opens a window with the following options. Select data that you want to export and the file format you require, Microsoft Excel or a CSV (comma separated) file. This option is also available for Log entries and Datasource 'Show Tables' view.
Basic Settings
Icons on this property tab:
...
| Field | Description |
|---|---|
| Items to Download | If there are selected items on the grid, this field allows you to specify whether just the selected items should be downloaded or whether all items implied by the filter should be downloaded. Please be aware that if you choose to download all items, on some grids this might mean that PhixFlow would begin downloading a very large number of items e.g. millions of records. This may take quite some time so please be sure that you want to do this before proceeding. If you choose to download just selected items, PhixFlow will set a limit of 500 records. |
| Maximum Records Per File | When you want to download a large number of records (e.g. more than 50,000) PhixFlow can split the results into several files and "zip" these together before downloading. This field specifies the maximum number of records to place in any one file. If left blank, PhixFlow will export as many records in one file up to the default system-wide limit set in the System Configuration; see the System Tuning section, Maximum Download Size. |
| Maximum Download Limit | Read only. This field is only visible if there is a limit to the number of records you may export from this stream. The limit is set in the System Configuration; see the System Tuning section, Default Stream View Download Limit. If you select more records than the limit, the extra records will be ignored. |
| Use Excel Template | The field is only visible if the backing Stream View has a template configured. This field indicates whether PhixFlow should use the Excel template associated with the Stream View. (Note that this template is set up on the Stream View form). If selected, PhixFlow will format the output file according to the formats defined in the Excel spreadsheet. |
| Downloads the data to a CSV file. This is the best option for large amounts of data. |
| Downloads the data to a Microsoft Excel file. |
