Overview

Use 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(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 icon, in the top right of the PhixFlow header bar.
2. Select Import → Data.
3. PhixFlow opens a
4. Select

   Insert excerpt
   _import _import nopanel true

   then

   Insert excerpt
   _import_data _import_data nopanel true

5. PhixFlow opens the Import Data window and a file manager window, where you can browse for the zip file.
   PhixFlow opens the Import Data window, showing your selected file.
   
   1. To choose a different file, click Select to reopen the file manager window
   .
   1. Click Import Data.
   2. If you exported the file using a password to encrypt the data, PhixFlow asks for the password now.
      You must enter the password to import the data.PhixFlow must be entered
   3. 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 System → Configuration.
   3. In the System Directories section, 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

   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 Application Data
   • Export Configuration
   • Exporting Data from an Analysis Model
   • Importing Data
   • Using the Download Area
   • Configuring the Download Area