Overview

Use the Data Export window to export data from selected tables, applications or packages.

To export data you must have the Export Table Data privilege, which allows you to export data from tables, packages and applications. You do not need the privilege to view the data in order to export it.

You may want to export data from tables in PhixFlow to then:

• archive or review data files
• import the data into another system
• import the data into another PhixFlow instance where the tables already exist.
  In this case, we recommend using Configuration Export to export the tables themselves; see Export Configuration.

How to Export Data

You can choose what data to export from the Export Data window.

1. Click the 

   Insert excerpt
   _administration _administration nopanel true

    icon, in the top right of the PhixFlow header bar.
2. Click Select Export → Data,
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 Tables in that Application or Package.
4. Specify the export rule if required, see Export Rule below.
5. If a 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.
6. The Compress tick box on the export 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 recordsets is specified these will be the most recent from the Table.
   2. Date Range
      1. The date range will select recordsets with a to date within the selected range. Data Export will export both OK and Incomplete recordsets. 

1. .

2. PhixFlow opens the Export Data window where you can specify what to export:

   Field	Description
   Please drag tables, applications or packages to export	Drag the items from the repository into the box. Select: either individual tables or an application or package to include data from all the tables that belong to the application or package.
   Export Rule	When you drag items into the box, PhixFlow lists them under an Export Rule  Image Added Select one of: All Data Recordsets  Date Range For a package or application, the same rule applies to all the tables in the application or package. For tables, you can: either specify one rule for all the tables or specify a different rule for different tables.
   Number of	Available when Export Rule is Recordsets. Enter the number of most recent recordsets you want to include.
   From To	Available when Export Rule is Date Range. Enter or select the date range of the data you want to export. PhixFlow includes incomplete recordsets in the export. Image Added
   Password	Optionally, enter a password that PhixFlow will use to encrypt the export file.  Note Remember this password. You need to provide it when you open the zip archive or import it to another system or PhixFlow instance.
   Compress	PhixFlow creates a zip archive of the data containing a set of XML files for each table included in the export. Insert excerpt _check_box_tick _check_box_tick nopanel true  to compress the export file. Insert excerpt _check_box_untick _check_box_untick nopanel true  to create a zip without additional compression.

   
   

3. Click Export Data. PhixFlow generates a zip archive and saves it to your computer's download folder.
   The zip archive contains a set of XML files for each table included in the export.

Learn More

• Export Configuration
• Exporting Data from an Analysis Model
• Importing Data
• Import Configuration