Overview

Data import allows data exported from one system to be imported into another system, for example to populate an application which has been transferredUse the Import Data window to load table data that has been exported from a different PhixFlow instance. For example, when you import a new application to your production instance, you may want to populate it with the latest data from a different application.

Before importing data, you must ensure:

• the

• table

Importing

To Import Data:

Image Removed Administration

• (s) already exist in the target PhixFlow instance

• the tables are empty. PhixFlow cannot import data into a table that already contains some data. 

  Tip
  In this case, we recommend using Configuration Export to export the tables themselves and then import them into the target instance; see Export Configuration.

  
  

How to Import Data

To import a zip file of table data that has been exported from another PhixFlow instance:

1. Click the 

   Insert excerpt
   _administration _administration nopanel true

    icon,  in the top right of the PhixFlow header bar.
2. Select Import → DataThe .
3. PhixFlow opens a file manager window, where you can browse for the zip file.
4. PhixFlow opens the Import Data window opens.
5. Click the (...) ellipses button.
6. Navigate to the data file you wish to import and click Open, showing your selected file.
   To choose a different file, click Select to reopen the file manager window.
7. Click Import Data.
8. Once If you exported the file is uploaded, using a password prompt will appear. If the data has been encrypted the password must be entered else no data will be imported. If no password was provided on export then no password is required for import.

1. to encrypt the data, PhixFlow asks for the password now.
   You must enter the password to import the data.
2. PhixFlow imports the data and populates the tables

Troubleshooting Data Import

Data Import Failing Immediately

Check the System Console for error messages related to problems writing to the temp or upload directories.

Resolution

1. Click the Image Removed Administration

   Insert excerpt
   _administration _administration nopanel true

    icon, in the top right of the PhixFlow header bar.
2. Select Select System → Configuration.
3. Navigate to In the System Directories section.Ensure your Temp and Upload directories are populated.If they are then contact your system administrator and ensure these directories have suitable permissions for PhixFlow to write to, add directories to: 
   • Temporary File Location
   • File Upload Directory 

If locations for these directories are already set, contact your administrator and ask for PhixFlow to have permission to write to them.

Data Not Appearing in the Tables

The import will skip any streams which cannot be imported as they already contain data. These will be reported in the log file. Check the System Console's error message this will usually indicate the issue.

Resolution

Check the System Console for error messages related to tables that already contain data. PhixFlow skips these as it can only import into empty tables.

Resolution

• Either remove data from the affected tables

• then run the import again.
• Or use Export Configuration to export the tables themselves and then import these.

Learn More

• Export Table Data
• Export Configuration
• Exporting Data from an Analysis Model
• Importing Data
• Using the Download Area
• Configuring the Download Area

Some options may still refer to streams and stream sets.