These release notes are for PhixFlow 5.9.2.

This release is for Oracle and SQL Server only.

Contents

Installation / Upgrade

To install a new PhixFlow instance, follow the standard installation instructions.

To upgrade an existing PhixFlow instance, follow the Standard Upgrade Instructions plus the special instructions for all intermediate releases.

This release has no special instructions.

Features / Improvements

Collectors

Excel File Collectors

The Data Range expression can now return a list of ranges, in which case the collector would read records from each range in turn. If the range expression returns a single range the collector will read records from that range, and it it returns null it will read all records from the first worksheet.

The range expression can refer to a new internal variable (_worksheets) which is set to a list of the worksheets in the excel file.

These changes are intended to allow the file collector to validate the contents of the file and to read data from multiple worksheets.

Views

Pivot Views

Improved validation when configuring pivot views.

Bug Fixes

Configuration Export/Import

When importing a configuration file containing macros, those macros were not always immediately available for use (e.g. in Stream Attribute expressions).

Importing a stream failed if the target system contained an earlier version of the same stream and the new version contained at least 2 new attributes.

Views

Pivot Views

Pivot views sometimes generated invalid column labels.