| Insert excerpt | ||||||||
|---|---|---|---|---|---|---|---|---|
|
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 toolbars where you can use the
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
- From views
PhixFlow displays data from a table in a view. Views can be a table (grid) or a chart and they have a toolbar in the top right. Views are often included in status dashboards or in application screens; see View. - From a database
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
, clickInsert excerpt _administration _administration nopanel true
; 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 to a file, click the toolbar button
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
PhixFlow opens a window where you can select the data that you want to export and the file format you require, Microsoft Excel or a CSV (comma separated) file.
Download Data Options Window
| Field | Description | ||
|---|---|---|---|
| Items to Download | Select an option:
| ||
| Maximum Records Per File | If Items to Download is Export All Items, and there are many records, optionally specify the number of records to export to a file. PhixFlow splits the records into several files and zips them together ready for downloading. PhixFlow uses the system maximum to determine the number of records to save to each file if you:
The system maximum is set in System Configuration → System Tuning section → Maximum Records Per Download File. | ||
| Maximum Download Limit | This field is available 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. If you select more records than the limit, the extra records will be ignored. The limit is set for all sources of data in System Configuration → System Tuning → Default Download File Limit. You can override this limit, either to reduce or increase it, for specific tables. Use the properties in the Table properties → Download Limits section. | ||
| Use Excel Template | The field is available for table data, where the backing view has a template configured. Specify whether PhixFlow should use the Excel template associated with the view. If selected, PhixFlow formats the data using the predefined layout in the Excel spreadsheet. For information about setting up and Excel template, see View. | ||
| 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. |
Logging
PhixFlow logs the username along with the time the export started and the number of data records or records being exported.