...
...
| Insert excerpt | ||||||||
|---|---|---|---|---|---|---|---|---|
|
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.
Click the
icon, in the top right of the PhixFlow header bar.Insert excerpt _administration _administration nopanel true Select Export → Data.
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
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.
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.
to compress the export file.Insert excerpt _check_box_tick _check_box_tick nopanel true
to create a zip without additional compression.Insert excerpt _check_box_untick _check_box_untick nopanel true 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
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|