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 → Data
3. The Import Data window opens.
4. Click the (...) ellipses button.
5. Navigate to the data file you wish to import and click Open.
6. Click Import Data.
7. Once the file is uploaded, 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.

Troubleshooting 

Data Import Failing Immediately

This is typically caused by the upload directory not being setup correctly in the system configuration. Check the System Console's error message this will usually indicate the issue.

Resolution

1. Click the Image Removed Administration
2. Select

   Insert excerpt
   _import _import nopanel true

   then

   Insert excerpt
   _import_data _import_data nopanel true

3. PhixFlow opens the Import Data window and a file manager window, where you can browse for the zip file
   1. To choose a different file, click Select to reopen the file manager window
4. If you exported the file using a password to encrypt the data, the password must be entered
5. Click Import Data and PhixFlow imports the data and populates the tables

Image Added

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 

   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 Application Data
• Export Configuration
• Filtering and Sorting Data
• Importing Data
• Using the Download Area
• Configuring the Download Area