Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
cd $RELEASE/schema/sqlserver/migration/X.Y
sqlcmd -S myServer\myInstance -U myUsername -P myPassword -d myDatabase -i migrate_schema_from_x_y_z_to_X_Y_Z.sql

Re-start Tomcat

Migrate the Email Accounts

The Email Sender and Fetcher accounts were previously configured in XML files. From 5.9 they are configured via the GUI.

The migration process is manual. If you have configured email accounts prior to5.9, you must re-enter the Email Account settings into the new configuration forms:

Email Sender
  1. Make a backup copy of the phixflow-datasource.xml file.
  2. Open the phixflow-datasource.xml file.
  3. Note the port, host, username, password and javaMailProperties values.
  4. Delete the mailSender bean from the phixflow.datasource.xml file.
  5. In PhixFlow go to AdminManage Email Accounts and add a new account.
  6. Tick the Outbound flag, type the account name and enter values from the step 2. The Properties have format: property.name=value. Each property should be entered in new line. Tick Enabled.

 

Info

You can test the configuration by entering a test email address and sending a test email by clicking the Test Configuration button.

 

Email Fetcher
  1. Make a backup copy of the phixflow-email.xml file.
  2. Open the phixflow-email.xml file.
  3. Note the enabled, port, host, protocol, username and password values.
  4. Delete the phixflow-email.xml file.
  5. In PhixFlow go to AdminManage Email Accounts and add a new account.
  6. Leave the Outbound flag unticked, type the account name and Enter values from the step 2. If you leave the Pooling Interval blank, the pollingInterval value configured in the server.properties file will be used.

 

Info

You can test the configuration by clicking the Test Configuration button.

 

Complete

The upgrade is now complete.

...

(This release contains more changes which affect the URL. See Upgrade Notes for details)As there are new functionalities which can be accessed by manipulating the application URL it is important to remember about the sequence of using new URL attributes:

  1. design=true and design=false must be typed right after the default PhixFlow URL and be prefixed by the ‘?’ character.
  2. #ApplicationName/MenuName must be typed at the end of the full PhixFlow URL.

 E.g.

Assume in these examples that the default PhixFlow URL is  www.phixflowexample.com

Design / App Mode

A new button is available under the User menu (top right corner). It allows switching between a Design and App mode. 

...

Fixed bug with the alphabetic lists sorting on the Oracle database.

Upgrade Instructions

 

 

 

...

Email sender:

  1. Make a backup copy of the phixflow-datasource.xml file.
  2. Open the phixflow-datasource.xml file.
  3. Note the port, host, username, password and javaMailProperties values.
  4. Delete the mailSender bean from the phixflow.datasource.xml file.
  5. In PhixFlow go to AdminManage Email Accounts and add a new account.
  6. Tick the Outbound flag, type the account name and enter values from the step 2. The Properties have format: property.name=value. Each property should be entered in new line. Tick Enabled.

    Info

    You can test the configuration by entering a test email address and sending a test email by clicking the Test Configuration button.

 

Email fetcher:

...

.

...

Leave the Outbound flag unticked, type the account name and Enter values from the step 2. If you leave the Pooling Interval blank, the pollingInterval value configured in the server.properties file will be used.

Info

You can test the configuration by clicking the Test Configuration button.

...

As there are new functionalities which can be accessed by manipulating the application URL it is important to remember about the sequence of using new URL attributes:

Note

Assume that the default PhixFlow URL is  www.phixflowexample.com

  1. design=true and design=false must be typed right after the default PhixFlow URL and be prefixed by the ‘?’ character.
  2. #ApplicationName/MenuName must be typed at the end of the full PhixFlow URL.

 

...