This page is for users who want to export data using the
button.Insert excerpt _excel_export _excel_export nopanel true
...
- 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; 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
; see Datasource and Database Table.Insert excerpt _datasource_show_tables _datasource_show_tables nopanel true - From the list of users
From the repository, right-click on
, then select Show Detailed ListInsert excerpt _user_repo _user_repo nopanel true - From the system console
To open the console, in the task bar at the bottom of the PhixFlow window, click
; see System Console. You can export data from the:Insert excerpt _console _console nopanel true - Task Logs tab →Messages section
- Imported/Exported Files tab
- Email Messages tab
- Archive Log tab.
To export data from a stream view, database table or archive logto a file, click the toolbar button
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
...
| 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 | If you want to export many records (more than 50,000), specify how many records are exported to one file. If Items to Download is Export All Items, and there are many records, specify the maximum number of records 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 the records in to one file, up . The number of records is limited to the default system-wide limit value set in System Configuration → System Tuning section → Maximum Download Size. | ||
| Maximum Download Limit | This field is available for stream views that have if there is 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 :
| ||
| Use Excel Template | The field is available if for stream data, where the backing stream view has a template configured. Specify whether PhixFlow should use the Excel template associated with the stream view. If selected, PhixFlow formats the data using the predefined layout in the Excel spreadsheet. For information about setting up and Excel template, see Stream View form. | ||
| Click to export the data to a CSV file. This is the best option for large amounts of data. | ||
| Click to export the data to a Microsoft Excel file. |
...