Versions Compared

Key

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

Overview

The ability to export data is controlled by the "Export Stream Data" permission. Users with this permission can export all data from streams, packages and applications even if they would not otherwise have the correct access permissions to view the data.

The

...

Data Export pane can be used to export data from selected Streams, Applications or Packages.

...

Data Export

  1. Click the 
    Insert excerpt
    _administration
    _administration
    nopaneltrue
     icon, in the top right of the PhixFlow header bar.
  2. Click ExportData,
  3. Select the required tables or application for export by dragging them from the repository to the export pane.

...

    1. Tables can be selected individually or an Application or Package may be dragged onto the pane to export data from all

...

    1. Tables in that Application or Package.

...

  1. Specify the export rule if required, see Export Rule below.
  2. If a

...

  1. Password is specified on the export pane then all data will be encrypted, and the password will be required for import. If a password is not specified then all data will be exported unencrypted.

...

  1. The

...

  1. Compress tick box on the export

...

  1. pane can be used to compress the exported data files.
    1. If this is not ticked the data will be exported as an uncompressed zip archive.

This process can be used to export data from Streams to import into another system. For import the Streams must already exist on the target system so a Configuration Export may be required to create the Streams before data can be imported.

Export Rule

When

...

items are dragged onto the export pane, they will appear under an Export Rule. This determines which

...

Recordsets are exported from those

...

items. The default option is to export all

...

data.

To edit the rule,

...

  1. Select the required value from the dropdown.
    1. Number of Recordsets
      1. If a number of

...

      1. recordsets is specified these will be the most recent

...

      1. from the

...

      1. Table.
    1. Date Range
      1. The date range will select

...

      1. recordsets with a to date within the selected range.

...

      1. Data Export will

...

      1. export both OK and

...

      1. Incomplete recordsets. 

A different rule can be added for each

...

table or one rule may be used for all

...

tables in the export. When exporting a package or application the same rule will apply to the whole package.