Versions Compared

Key

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

...

Contents

Table of Contents
maxLevel3

Features / Improvements

Applications

...

(This release contains more changes which affect the URL. See Upgrade Notes for details)

Design / App Mode

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

Design mode allows the user to see design functions of PhixFlow, the toolbar on the left in particular. 

App mode hides configuration features of PhixFlow. 

The default mode of the user can be set through the user editor. 

Users need to have a permission in order to use the design mode. If the user has no permission to use the design mode, the app mode is launched. 

The selected mode can be specified also through the URL, by adding a "design=true/false" attribute. A list of attributes should be prefixed with a '?' character. For example: 

(This release contains more changes which affect the URL. See Upgrade Notes for details)

Dashboards

Resizing Dashboards

...

The restrictions on changing the properties and/or attributes of existing streams are now based on whether the stream actually contains data records rather than whether the stream has any stream sets. This means that it is now possible to roll back a stream without deleting stream sets, then change any stream property or attribute property.

Collectors / Exporters

Excel File Exporter

DATE and DATETIME columns are now exported to Excel in the same format as they appear on the Stream View.

Scripting

Internal Variables

...

Indexes and primary keys on core tables have been reviewed and deleted / added where appropriate.

Improvements

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

Design mode allows the user to see design functions of PhixFlow, the toolbar on the left in particular. 

App mode hides configuration features of PhixFlow. 

The default mode of the user can be set through the user editor. 

Users need to have a permission in order to use the design mode. If the user has no permission to use the design mode, the app mode is launched. 

The selected mode can be specified also through the URL, by adding a "design=true/false" attribute. A list of attributes should be prefixed with a '?' character. For example: 

  • www.phixflowexample.com - a default user's mode will be launched. 
  • www.phixflowexample.com?design=true - a design mode will be launched (if the user is permitted) 
  • www.phixflowexample.com?design=false - an app mode will be launched

    Note

    (This release contains more changes which affect the URL. See Upgrade Notes for details)

The restrictions on changing the properties and/or attributes of existing streams are now based on whether the stream actually contains data records rather than whether the stream has any stream sets. This means that it is now possible to roll back a stream without deleting stream sets, then change any stream property or attribute property.

DATE and DATETIME columns are being exported to Excel in the same format as they appear on the Stream View.

It is now possible to configure a 'pivot table' stream view in which values in a nominated value attribute are broken out into one of many view columns based on the value in a nominated pivot attribute. 

The pivot view columns can be

  • all values in the view data
  • the result of an expression (which can in turn refer to a lookup pipe on the source stream)

The latter method allows more control over the order of columns and the ability to present columns even if no data values are present.

Pivot column headers can be derived automatically from data values using date/time and number formats on the view attributes, or from label attributes.

 

 

 

...

Bug Fixes

Graphical User Interface

Fixed bug with possible GUI locking while having some configuration windows opened.

Dashboards

Correction to 5.5 to 5.6 migration script for Oracle based instances. Default Dashboard filters are now being restored during the upgrade.

Dashboard object background filters now set driving-driven links correctly.

Views

Fixed bug with the not populated filter list on the view configuration screen.

Filters

Fixed bug with a stream filter with an 'is in' condition generating invalid sql if the list of values on the right-hand side of the condition is zero-length.

Streams

Stream Publishing always checks for existing data before applying changes.

Stream Publishing no longer incorrectly identifies all integer stream attributes as changed and if the stream is marked as having no data.

...

Corrected possible issue with the handling of failed streamsets generated by a different instance of PhixFlow.

Fixed bug with rollback on self-updating stream selecting all streamsets.

Collectors & Exporters

Fixed bug with CSV and Excel file collectors failing if there were more columns in a file than expected.

Fixed bug with

...

exporting floating point numbers to Excel.

Actions

Fixed a floating digit issue during the update action.

...

Fixed bug with failing model import.

...

Fixed bug with ifNull function not returning list properly.

...

concatenateList casts single values to lists.

...

Fixed bug with the not populated filter list on the view configuration screen.

...

Fixed bug with exporting floating numbers to Excel.

...

Fixed bug with the user updating error while the user has some passwords archived more than a year ago.

...

Refresh on Completion

Whether a stream action caused its invoking view to refresh on completion or not was changed at release 5.6.0. In earlier releases it was implicit, and from 5.6.0 onwards a refresh had to be explicitly requested by adding the action to the list of view refresh actions.

The migration scripts from 5.5.1 to 5.6.0 attempted to create the necessary view refresh actions, but failed in the case where a view referenced the same action more than once. This problem is fixed in the 5.6.0 migration scripts in this release.

Export / Import

Fixed bug with

...

failing model import.

Scripting

Fixed bug with ifNull function not returning list properly.

concatenateList now correctly casts single values to lists.

Logging

The System Logging Configuration window shows the 'Log Exporter Statements' tick box correctly.

...

User Administration

Fixed bug with the user updating error while the user has some passwords archived more than a year ago.

Fixed bug with the visible password length of other users

...

Other

Fixed bug with

...

the alphabetic lists sorting on the Oracle database.

Upgrade Instructions

 

 

 

Upgrade Notes
Anchor
emailMigration
emailMigration
Email configuration migration 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:

  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.

Anchor
urlChanges
urlChanges
URL format changes

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.

 

  • www.phixflowexample.com – PhixFlow without any defined Application in a mode specified as default for the logged in user.
  • www.phixflowexample.com?design=true – PhixFlow without any defined Application in the Design Mode
  • www.phixflowexample.com?design=fals – PhixFlow without any defined Application in the App Mode
  • www.phixflowexample.com#App1App1 application with a default menu in a mode specified as default for the logged in user.
  • www.phixflowexample.com#App1/Menu1App1 application with the Menu1 in a mode specified as default for the logged in user.
  • www.phixflowexample.com?design=true#App1 – App1 application with a default menu in the Design Mode
  • www.phixflowexample.com?design=false#App1App1 application with a default menu in the App Mode
  • www.phixflowexample.com?design=true#App1/Menu1App1 application with the Menu1 in the Design Mode
  • www.phixflowexample.com?design=false#App1/Menu1App1 application with the Menu1 in the App Mode