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 toolbars where you can use the
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
- From stream views
PhixFlow displays data from a stream in a stream view. Stream views can be a table (grid) or a chart and they have a toolbar in the top right. Stream views are often included in dashboards or in application screens.have a toolbar in the top right.; see Stream View. - From a database table
Either from an analysis model or from the repository, open the properties tab for a datasource. To open a list of the available database tables, in the toolbar, click
→ Archive Log tabdatasource properties →Insert excerpt _datasource_show_consoletables _consoledatasource_show_tables nopanel true
; see Datasource and Database Table. - From the system console
To open the console, in the task bar at the bottom of the PhixFlow window, click
, then select the Archive Log tab; see System ConsoleInsert excerpt _datasource_show_tablesconsole _datasource_show_tablesconsole nopanel true
To export the data displayed in the from a stream view, database table or archive log, click the toolbar button
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
PhixFlow opens a window with the following options. Select the data that you want to export and the file format you require, Microsoft Excel or a CSV (comma separated) file.
Basic Settings
Icons on this property tab:
...
...
Downloads the data to a CSV file. This is the best option for large amounts of data.
...
Downloads the data to an Excel file.
| 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. Alternatively, select Export All Items.
If you download selected items, PhixFlow sets a limit of 500 records. | |||||
| Maximum Records Per File | When If you want to download a large number ofexport many records ( e.g.more than 50,000) PhixFlow can split the results into several files and "zip" these together before downloading. This field specifies. If Items to Download is Export All Items, and there are many records, specify the maximum number of records to place in any one file.to export to a file. PhixFlow splits the records into several files and zips them together ready for downloading. 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 isavailable for stream views that have a limit to the number of records you may export. It is read-only. PhixFlow displays the maximum number of records that you can download from this stream view. If you select more records than the limit, the extra records will be ignored. 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 visibleavailable if the backing Stream Viewstream view has a template configured. This field indicatesSpecify whether PhixFlow should use the Excel template associated with the Stream View. (Note that this template is set up on the Stream View form).stream view. If selected, PhixFlow will format the output file according to the formats definedPhixFlow formats the data using the predefined layout in the Excel spreadsheet. For information about setting up and Excel template, see Stream View form. | |||||
| Downloads Click to export the data to a CSV file. This is the best option for large amounts of data. | |||||
| Downloads Click to export the data to a Microsoft Excel file. |
...