Versions Compared

Old Version 8

changes.mady.by.user Fiona Sargeant

Saved on

compared with

New Version 9

changes.mady.by.user Fiona Sargeant

Saved on

Key

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

Clicking Image Removed 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 or a CSV (comma separated) file. This option is also available for Log entries and Datasource 'Show Tables' view.

Icons on this property tab:

...

Image Removed

...

Downloads the data to a CSV file. This is the best option for large amounts of data.

...

Image Removed

...

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

Insert excerpt
_excel_export
_excel_export
nopaneltrue
 button.

Overview

There are several toolbars where you can use the 

Insert excerpt
_excel_export
_excel_export
nopaneltrue
 button to export data as a Microsoft Excel or CSV (Comma Separated Variable) file.

  • 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  
    Insert excerpt
    _datasource_show_tables
    _datasource_show_tables
    nopaneltrue
    ; 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 
    Insert excerpt
    _console
    _console
    nopaneltrue
    , then select the Archive Log tab; see System Console

To export data from a stream view, database table or archive log, click the toolbar button 

Insert excerpt
_excel_export
_excel_export
nopaneltrue
.

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. 

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

.Please be aware that

.

Alternatively, select Export All Items.

Tip

Be aware of how many records will be downloaded if you choose to

download

export all items

, on some grids this might mean that PhixFlow would begin downloading a very large number of items e.g.

. In some cases streams or database tables contain millions of records.

This may take quite some time so please

Downloading many records can take a long time. Please be sure that you want to do this before proceeding.

If you

choose to

download

just

selected items, PhixFlow

will set

sets a limit of 500 records.

Maximum Records Per FileWhen

If you want to

download a large number of

export 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 the  System Configuration; see the System Tuning section, Maximum Download Size.

Maximum Download LimitRead only.

This field is

only visible if there is

available 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 visible

available if the backing

Stream View

stream view has a template configured.

This field indicates

Specify 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

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.

Image Added

Click to export the data to a CSV file. This is the best option for large amounts of data.

Image Added

Click to export the data to a Microsoft Excel file.