Import Stream Data

Overview

Data import allows data exported from one system to be imported into another system, for example to populate an application which has been transferred.

Before importing data, the target table must exist on the system and must not already contain any data. The table can be imported using the configuration export/import process should it be needed

Importing

To Import Data:

1. Click the  Administration 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  Administration icon, in the top right of the PhixFlow header bar.
2. Select System → Configuration.
3. Navigate to the System Directories section.
4. Ensure your Temp and Upload directories are populated.
   1. If they are then contact your system administrator and ensure these directories have suitable permissions for PhixFlow to write to.

The data does not appear?

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

1. You will need to remove data from the affected tables if you wish to replace it with the imported data.