Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This page is for users who want to export data using the 

Insert excerpt
_excel_export
_excel_export
nopaneltrue
 button.

...

FieldDescription
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.

Tip

Be aware of how many records will be downloaded if you choose to export all items. In some cases streams or database tables contain millions of records. Downloading many records can take a long time. Please be sure that you want to do this before proceeding.

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 the records to one file. The number of records is limited to the value set in System Configuration → System Tuning section → Maximum Download Size.

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:

Use Excel Template

The field is available 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.

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.

...