Changelog

Prev Next

If Pipeline Pilot 2021 is installed on your Pipeline Pilot server, an additionnal configuration step may be performed. Open the Pipeline Pilot server administration page, navigate to Setup > Server Configuration in the left panel. For the "SSL/TLS Security Level" setting, choose the "Older" option and press the "Save" button.

Important changes have been made in TIBCO Spotfire® release 10.3 and later on how authorized users trust data functions. We strongly recommend that you read the official documentation and follow the Spotfire guidelines if you are concerned.

New in 6.1.0

(2025/01)

Discngine Molecule Renderer

The molecules can be displayed into Spotfire using the Discngine Molecule Renderer (see dedicated changelog).

A dedicated license key is required for the renderer. It needs to be set in the preferences. Please contact us at support@discngine.com to get it.

Client Automation

Enhancements

  • Compatible version with Spotfire Connector for Ideation 1.0.26.
  • Compatible version with LiveDesign Connector for Spotfire 4.1.0.

Fixes

No document property specific to the Connector is created anymore except in the mashup context where they are required. Additionally the personalized view feature of Spotfire is unactivated when opening a document through the Connector in mashup context.

Some JavaScript API methods and the associated Pipeline Pilot components have been fixed:

  • the custom IronPython script of a table plot is executed after that the complete creation and configuration of this table plot is ended
  • when chaining data transformations with other column treatments, such as adding a calculated column or hierarchy, the data transformations are executed first, like in the Spotfire data flow
  • the color, tooltip and legend features of the marker layer of map chart are working when the shape of the marker layer is set to pie

The global properties WebPlayerUrl and StartupDocumentPath of the Pipeline Pilot package are not required anymore except in the mashup context.

New in 6.0.209

(2024/07)

Pipeline Pilot Data Functions

Enhancements

The sorting on the Table view is case insensitive and handle numbers. The sorting pop-up is closed automatically after a sorting change.

Fixes

Several Pipeline Pilot data functions using a data table as input can be launched at the same time.

The case of the Pipeline Pilot path of a data function matches exactly what is set in Pipeline Pilot, no matter the case which is used in the XMLDBRoot Spotfire preference.

Client Automation

The deprecated components from the version 4 of the Connector will be removed from the collection in version 6.2. If some or your protocols are still using these deprecated components, you should update them. To help you to find the concerned protocols, you can use the "Find Usage of Deprecated Components" protocol.

Enhancements

The components from the Visualizations and Data Transformations folders have been improved to work without a data table reference in input. In this case the active data table is used.

To homogenize the behavior of the panels available in Analyst and Web Player, these panels are now automatically opened after opening or saving a document.

Fixes

The Pivot Data and Add Data Function from Library components have been fixed to work without some optional parameters.

Some fixes have been implemented for the Web Player panels:

  • It is possible to run a Pipeline Pilot protocol containing only an "Open Document" component.
  • It is possible to run a Pipeline Pilot protocol opening successively several documents using the "Open Document" component and to execute actions after the second opening, provided that all "Open Document" are set "On Page Load".
  • It is possible to close the panel on the active page before saving the Spotfire document using the panelsVisibilities argument of the save method.

Known issues

Opening a document not linked to Discngine Connector in the Web Player results in the creation of a customized view for the property list (Discngine Connector creates certain properties required for its proper operation). This may cause the property view in the Web Player to be out of sync with the Analyst.
A fix will be provided with release 6.1, preventing the creation of personalized view in the Web Player for documents not linked to Discngine Connector.

Sketcher

Known issues

If you upgrade from 6.0.0 to 6.0.209 you may encounter issues to set the Sketcher preferences: if you set the Sketcher preferences for a specific group when having the 6.0.0 version installed, you may fail to change the value of these preferences once upgraded to 6.0.209 version. Two approaches can be used to resolve this:

  • Delete the group(s) for which you set the preference in version 6.0.0 and recreate them. You will be able to set the preferences values as usual after this.
  • Delete the preferences of the version 6.0.0 from the Spotfire database. You can use a statement like the following: DELETE FROM PREFERENCE_KEYS WHERE CATEGORY_NAME = 'DiscngineSketcher' AND CLASS_TYPE = '2.0###Configuration'. Note that this is an example and you may need to adapt it to your database structure.

New in 6.0.0

(2024/05)

Pipeline Pilot Data Functions

New Features

The Pipeline Pilot data functions are now administrated seamlessly from Analyst and Web Player using a panel available under Discngine > Pipeline Pilot data functions. The old window is still available under Discngine > Legacy > Pipeline Pilot data functions. All the features and improvements detailed below are refering to the panel.

It is possible to search and delete data functions in the Spotfire Library and Pipeline Pilot views in addition to the Table view.
A button "Refresh" is available for all data functions. It allows to make sure that the protocol path associated with the library item fits with the GUID (identifier in Pipeline Pilot). It also allows to update the input and output parameters of the data function without having to register it again if they changed on Pipeline Pilot side.
A new example data function is provided in the package, which takes a molecule as input (see Sketcher section below).

Enhancements

When registering and running a data function, the GUID of the corresponding Pipeline Pilot protocol is used to uniquely identify the protocol instead of its path and thus, data functions work even when the protocol have been renamed or moved. If the GUID does not exist anymore, the path is used as a backup solution. In this case, to fix it, it is possible to use the "Refresh" button (see New Features section above).

The error handling has been improved to give more information to the user when trying to register a protocol that is not configured correctly.
A warning is raised when trying to register a data function at a path that already contains one with the same name to avoid to overwrite it by mistake.

Sketcher

A new Sketcher module is now available with the Connector under Discngine > Sketcher. The Discngine Sketcher panel enables users to draw molecules and reactions and export them into Spotfire document properties as CTAB and RXN. Then these document properties can be used as input parameters for data functions. See the sketcher panel overview for more details.

Client Automation

New Features

A SWAPP menu is available under Discngine > SWAPP in Analyst to ease the usage of the SWAPP and another application.
A SWAPP and Web panel menu are available under Discngine > SWAPP [Beta] and Discngine > Web panel [Beta] in Web Player to harmonize the user experience between Analyst and Web Player and allow users to benefit from the SWAPP in a fully integrated way with Spotfire.

Related breaking changes

In order to allow the usage of the panel in the Web Player, some breaking changes have been implemented:

  • all the JavaScript methods of the SpotfireDocument object are asynchronous
  • a parameter Single Execution have been added on some Pipeline Pilot components such as the "SWAPP HTML Fragment" or "Apply Document Editor Changes" (see How to migrate 5.x to 6.x Pipeline Pilot protocols)

Known issues

The panels which are newly available in the Web Player currently have some limitations:

  • It is not possible to run a Pipeline Pilot protocol containing only an "Open Document" component
  • It is not possible to execute actions after an "Open Document" component which is set "On Demand"
  • It is not possible to close the panel in the active page in a Pipeline Pilot protocol if some steps are remaining
  • It is not possible to close the panel in the active page if there is an event listener

Opening a document not linked to Discngine Connector in the Web Player results in the creation of a customized view for the property list (Discngine Connector creates certain properties required for its proper operation). This may cause the property view in the Web Player to be out of sync with the Analyst.
A fix will be provided with release 6.1, preventing the creation of personalized view in the Web Player for documents not linked to Discngine Connector.

New

New in 5.12.572

(2025/01)

Fixes

SWAPP always loads correctly (fix the known issues of the 5.12.565 version).

New in 5.12.565

(2024/10)

Fixes

No document property specific to the Connector is created anymore except in the mashup context where they are required. Additionally the personalized view feature of Spotfire is unactivated when opening a document through the Connector in mashup context.

Know issues

When loading the SWAPP in mashup context, an error message may be raised, preventing to load Spotfire and requesting a refresh of the web browser to disappear.

New in 5.12.177

(2023/12)

Pipeline Pilot Data Functions

Fixes

Fix wrong required value displayed in the Pipeline Pilot Data Functions [Beta] tool.

Client Automation

Fixes

Fix ability to openDocument multiple times one after all from JavaScript API.

New in 5.12.64

(2023/10)

Pipeline Pilot Data Functions

Enhancements

Improve performances of the Pipeline Pilot view and error handling for the beta panel.

Client Automation

Fixes

Fix GetColumns method on externalInterface.

Client Automation - SWAPP

Fixes

  • Fix poor performance of the SWAPP in Spotfire Analyst when opening a document with a lot of datatable and many data columns.

New in 5.12.0

(2023/09)

Pipeline Pilot Data Functions

New Features

The Pipeline Pilot data functions can be administrated from the Web Player as well as from the Analyst using a panel, available under Discngine > Pipeline Pilot data functions [Beta].

Client Automation

Fixes

The method openDocument has been fixed to always call the provided callback parameter, even at the first call of the method.

The marking subscription has been fixed to work in Analyst in a saved document and in Web Player for the same subscription. The method onMarkingChanged is now fully functional.

Parameters containing single quotes used to create issues. They are now correctly escaped and can be used without futher change.

New in 5.11

(2023/04)

Client Automation

New Features

Map Chart visualization layers
The JavaScript API and the Pipeline Pilot collection have been extended to allow to create map charts and configure their layers. For now the following layer types are available: map layer, feature layer and marker layer.

Map Chart Layers

Add data tables and columns
The Pipeline Pilot components Add Data Table from Library (and associated method loadDataTableFromLibrary) and Add Data Table from URL have been added to add data tables coming respectively from the Spotfire library and from a file URL in a Spotfire document.
The Pipeline Pilot components Add Calculated Column and Add Hierarchy have been added to add respectively a calulated column and a hierarchy to a data table.

SWAPP library search
When opening a Spotfire document from the library in the SWAPP in Web Player, it is now possible to dynamically search for document using the same syntax than in Spotfire (see official documentation for details).

Discngine Menu

A new Discngine menu is available in the Spotfire toolbar. The Discngine Client Automation submenu and its shortcuts can be now found under Discngine > Web panel (Analyst only).

Discngine Menu

Fixes

The Add Filter component has been fixed to take values into account when the filter type is "List Box Filter", "Check Box Filter" or "Range Filter".
The Add Data Table Relation component and corresponding method have been fixed to work even when the relation already exists thanks to a new option allowing to choose the behavior in this case.

Pipeline Pilot Data Functions

New Features

Discngine Menu

A new Discngine menu is available in the Spotfire toolbar. The Pipeline Pilot Data Function and Pipeline Pilot Data Function Login tools can be now found under Discngine > Pipeline Pilot data functions (Analyst only) and Discngine > Help > Pipeline Pilot login (Web Player only).

Enhancements

The performances have been improved for the loading of the data functions list in the table view of the Pipeline Pilot data functions administration tool.

New in 5.10.15

(2023/01)

Client Automation

SWAPP

Loosen SpotfireMessageHandler origin. Now using wildcard to allow result frame to navigate to different domains.

Bugfix

Fix issue in SpotfireMessageHandler when unsubscribing event listeners.

New in 5.10.0

(2022/12)

Client Automation

New Features

TIBCO Spotfire Data Table input for the SWAPP

When sending a data table as input of a protocol, it is possible to choose to send all rows, marked rows only or filtered rows only.
It is also possible to choose the subset of columns to send as data table through the "Select columns" button.

Data table input

If a TIBCO Spotfire Column input is linked to a TIBCO Spotfire Data Table input, then the row selection of the data table will be applied to the column, and this column will be added to the subset of sent columns.

When changing the selected data table, all these selections are reset.

SWAPP home page

You now have the possibility to use a Pipeline Pilot protocol to generate the content of the Home Page.
See the tutorial for more details.

Page component

The addPage method and the associated Page component have been extended to allow:

  • to set the visisbility of panels in the created/edited pages (when set as visible, these panels will always be docked)
  • to set a custom layout instead of a tile mode layout in order to have more freedom in the organization of the visualizations within the page

SpotfireDocumentProxy and SpotfireMessageHandler

When using the spotfireDocument, you might want to share it across two different iframes. However, if the main frame and the child frame hosted on two different domains, the spotfireDocument object cannot be shared between them.
To overcome this problem, you can use the Web message API to allow the two frames to communicate. This can be cumbersome, so to help with that we have implemented two new classes: SpotfireMessageHandler and SpotfireDocumentProxy. See the tutorial to learn how to use this new feature.

Fixes

Security Fixes :

  • migration in .Net framework 4.8.1 (LTS) instead of 4.5.1 (obsolete)
  • migration in log4net 2.0.15 instead of 2.0.8 (security issue in 2.0.8 version)

New in 5.9.10

(2022/11)

SWAPP

You now have the possibility to use a Pipeline Pilot protocol to generate the content of the Home Page.
See the tutorial for more details.

New in 5.9.9

(2022/10)

Client Automation

New features

New input types for the SWAPP

The input type "Collapsible Group Field" has been added to improve the user experience for protocols having a large list of parameters. When registering a protocol, you can decide if the collapsible group field is collapsed or opened by default.

Collapsible Group Field

The input type "TIBCO Spotfire Document Property" allows to select a document property from the opened Spotfire document, and to send its name, value or both as a parameter of a Pipeline Pilot protocol. If the "Both" option is selected, the name and value of the document property need to be splitted inside the protocol by the package global property SWAPPDelimiter ("!!_!!" by default).

TIBCO Spotfire Document Property

Optional preference for temporary folder

A new optional preference named "TempFolder" allows Spotfire administrators to specify which temporary folder is used to upload files from a Spotfire document.

TempFolder

By default this preference is empty, then the default temporary folders will be used in Analyst and Web Player.
By default in Analyst, it is on the local computer of the user. By default in Web Player, it is the default temporary folder of the Web Player service account.

If the value is not empty, we highly recommend to set this value to a shared network folder with read/write access for all users using the Connector and for the Spotfire Web Player service account. In that case, Spotfire administrators need to add this path in the configuration file of the Web Player service as an "AllowedFilePaths".

Fixes

The SWAPP has been fixed to avoid issues when parameters are part of a group and some wrong retrieval of default values.

Breaking Change

To take advantage of the latest features and security improvements, the SWAPP dependencies have been updated.
Hence the SWAPP is not compatible with Internet Explorer anymore.
This means that to be able to use the SWAPP, the DiscngineWebPanel preference UseWebViewFeature needs to be set to True.

New in 5.8.49

(2022/08)

Client Automation

Fixes

Performance improvements

Better management of to_delete table from Analyst

Experimental features

Webview2 (Chromium embedded) in Client Automation Panel for Analyst migrate to version 103

New in 5.8.2

(2022/07)

Client Automation

New features

Data transformations

A new method addDataTransformations has been added to the SpotfireDocumentEditor to allow to add data transformations on a given data table in a single transformations group.

A set of Pipeline Pilot components has been added to allow to add each type of supported data transformation from Pipeline Pilot.

Data transformations components

Data functions

A new method addDataFunction has been added to the SpotfireDocumentEditor to add and execute a data function registered in the library in the current document.
The method getDataFunctionFromLibraryAsync has been added to the SpotfireDocument to retrieve the definition of a data function registered in the Spotfire Library. This method can be used to know the exact names and types of data function parameters. To list data functions in the library, you can use the getLibraryContentAsync method (see below).

A Pipeline Pilot component Add Data Function from Library has been added to the collection to allow users to insert and execute a data function registered in the library in a Spotfire document from Pipeline Pilot.

Execute JavaScript component

This component executes a custom JavaScript which can use the Discngine Client Automation JavaScript API.
This allows the user to benefit from all Discngine API methods in Pipeline Pilot (Client Automation or SWAPP context) even if the corresponding components do not exist yet.

SpotfireDocument methods

New methods have been added to the SpotfireDocument:

  • The getLibraryContentAsync method retrieves the content of a folder in the Spotfire Library.
  • The executePythonScriptAndGetValue method executes a python script on the document asynchronously and retrieve the result in a promise.
  • The closeDocument method allows the user to close the current document.

Chromium engine in Web Panel - beta

A new Chromium based engine (Beta Version) has been added for the Web Panel in Analyst to replace legacy browser control which was based on Internet Explorer engine.
This option is available for Spotfire 11.4+ versions. To activate it, go to Preferences > DiscngineWebPanel > Configuration, and set UseWebViewFeature to True.

Following that, the WebPanel will run on an Edge-like browser. You will be able to benefit from modern web APIs and developper tools.

Enhancements

When using the SWAPP to add data into an existing data table, the original data does not need to be frozen anymore.

Pipeline Pilot Data Functions & Calculated Columns

Enhancements

You can now edit the description of the Pipeline Pilot Data Functions.

The Pipeline Pilot Calculated Columns have been improved to be more flexible and allow empty values.
It is also now possible to know which type is expected as output of the calculated column using the global property "ExpectedTypeName" within the Pipeline Pilot protocol.

Hotfix 5.7-HF001

Fix a bug in the SWAPP where opening some saved protocols was making the application crash.

New in 5.7

Client Automation

saveAsync method

New method to allow saving a document and asynchronously act when done.

New "empty.dxp" and option in SpotfireDocument

From TIBCO Spotfire® 11.4, you can use parallel loading of data. This was causing infinite load.
The part0 zip now contains an updated "empty.dxp" doc which can be used in 11.4 and before.
By default it will be emptied on load, but you can avoid that using the new emptyDocumentOnOpen option.

Data Function

Bug fix: empty cells

When using string arrays as input, empty cells where causing errors. This has been fixed.

Hotfix 5.6-HF001

Fix the compatibility with BIOVIA Pipeline Pilot server 2021 for the modules "Client Automation & SWAPP" and "Pipeline Pilot Data Functions".

New in 5.6

SWAPP

New input type: REST API Resource

A new input type REST API Resource has been added to the SWAPP. It can be used with paremeters of type String, Number or Arrays of String or Number.
With this input type, you can populate the options using an array of values returned from a REST API endpoint.
Furthermore, other parameters of the same protocol form can be specified as dependency.
When those dependencies' values will change, a new call to the API Endpoint will be triggered, passing along the dependencies' values.

The final display can be a select dropdown, a multiple checkbox input for arrays or a group of radio buttons for single values.

Read the tutorial to learn how to implement it using a Pipeline Pilot
protocol as API Resource.

REST API Resource

New option for Molecule Input: MarvinJS

Until now, only Ketcher and Biovia Draw (in Analyst or IE) were available as molecule Sketcher.
You can now also use MarvinJS, provided it is deployed on your Pipeline Pilot server. To do so, simply specify the relative path to the editor in the Pipeline Pilot Global Properties.

Simplified Menu

The three settings in the SWAPP Menu (Register a protocol, Edit the menu, Toggle Synchronisation) have been merged in a single "Settings" button.
When registering a new protocol, you can now navigate back a step, for example to select another protocol, without having to close the window.

SWAPP Settings

XMLDB Root option

A new Global Option SWAPPProtocolsRoot has been added and can be defined in Pipeline Pilot's Global Properties.
It allows configuring the root folder when browsing the Pipeline Pilot's XMLDB from the SWAPP.

This is especially usefull if all the protocols you want to register in the SWAPP are located in the same folder in Pipeline Pilot.
Specifying this folder, only its protocols and subfolders will be listed when registering a new protocol in the SWAPP.

SWAPP Protocols Root

New in 5.5

Client Automation & SWAPP module

Legend

The Legend properties are now accessible for each visualization, using the JavaScript API or the Pipeline Pilot visualization components:

Legend parameters

The modification of legend item parameters is done via an array in which the legend item is simply referenced by its name (e.g. 'Data table' or 'Color by').

New Pipeline Pilot component: Open Document

You can now open an existing document in your Pipeline Pilot protocol, then modify it by adding data tables, pages, visualizations, ...

The component 'Open Document', available in the Discngine/TIBCO Spotfire Connector/Client Automation/Document/ folder, allows you to open document from the library, or from a local folder if you are not using the Web Player, possibly applying a configuration block, and trigger the execution of a function once the document is successfully opened. The opening of the document is either done when the page is loaded (using the Pipeline Pilot startup functions), or is added to the body of the web page, or is embedded in a function that can be called on demand.

Open Document component

Refer to the 'Discngine/TIBCO Spotfire Enabled Protocols/Client Automation/Miscellaneous Examples/Open an existing document and modify it' protocol example to see an application of this component:

Open Document example

Force the range of scale axis

WARNING:
The data type of the min and max range parameters were Double in Pipeline Pilot, it is now string in order to accept more data types (DateTime particularly), so if you set visualization components with double or integer range values in some protocols, you will have to specify the data type 'Integer' or 'Real' to force the formatting.

Minor changes

Client Automation & SWAPP module

Limit data using expression

This property was already available when using the JavaScript API, but was not exposed in the Pipeline Pilot components. It is now the case for all the visualization components:

Limit data using expression

Bug fixes

  • Client Automation & SWAPP module:
    • When configuring a visualization, it was not possible to set the Fixed color mode for markers without defining a color rule.

New in 5.4

The Connector 5.4 is compatible with the new TIBCO Spotfire® 10.10 LTS.

Client Automation & SWAPP module

IronPython scripting

With IronPython scripts it is possible to configure and automate a lot of different aspects of a TIBCO Spotfire® analysis and add behaviors to it. All the Spotfire Analyst API is accessible from IronPython scripts. In TIBCO Spotfire® an IronPython script can be added to several places in the analysis. Scripts can be executed from action controls in the Text Area, from the Graphical Table or the KPI Chart or be triggered by Document Property changes.

For this version 5.4 of the Connector, efforts have been made to generalize the use of IronPython scripts in Pipeline Pilot protocols. These scripts can be added at the visualization level using the dedicated parameter of the visualization component, or at the protocol level using either the Add Custom Script component or the Execute IronPython Script component.

Note that IronPython scripts executed from a Pipeline Pilot protocol do not need to be trusted in TIBCO Spotfire®, and the user does not need the Author Scripts license.

At the visualization level

All the visualization types are now available as Pipeline Pilot components. They do not expose all the Spotfire properties, but they all have a Custom Script parameter that allows you to complete the visualization setup with an IronPython script.

Visualization components - Custom script parameter

So, if the property you need is not yet exposed as a parameter of the visualization component, just write the IronPython script in this 'Custom Script' parameter. For example, if you want to define error bars for your visualization like this:

Spotfire Error bars properties

Simply write the following script in the 'Custom Script' parameter of the component of your visualization:

dataviz.YAxis.ErrorBars.Enabled = True
dataviz.YAxis.ErrorBars.UpperExpression = "StdErr([LogD])"
dataviz.YAxis.ErrorBars.FixedColor = Color.Red
dataviz.YAxis.ErrorBars.ShowEndCaps = True

Custom Script example - Pipeline Pilot protocol

At the protocol level

You may also need to run a script at the protocol level, for example to apply the same change to multiple visualizations, or to manipulate objects other than visualizations like data tables, document properties, ...

To do this, you will use the component Execute IronPython Script in which you will have access to all the objects in the document (pages, visualizations, data tables, document properties, ...).

Specifically, you can also use the Add Custom Script component, in which you are able to easily reference the last data table, the last page and the last visualization created.

A few example protocols have been added to the Connector collection to make it easier for you to get to work with these features:

Example protocols

Helpful links for writing IronPython scripts

IronPython scripting in TIBCO Spotfire® does not necessarily require a lot of python skills, however it does involve using their API. Here are a few links that you may find helpful:

Minor changes

Client Automation & SWAPP module

Coloring in visualizations

Coloring properties have been added for part of the visualization components:

Coloring parameters

A new example protocol showing the coloring of a scatter plot is available in TIBCO Spotfire Enabled Protocols/Client Automation/Miscellaneous Examples.

Bug fixes

  • Client Automation & SWAPP module:
    • The 'HTML TIBCO Spotfire® Viewer' component has been fixed: it did not take into account the 'On Success Function' and 'On Error Function' parameters of the 'Apply Document Editor Changes' components present in the flow.
    • In the Web Player, when you switched the Edit mode (Viewing/Editing), the visualizations were redrawn.
    • Pipeline Pilot icons were provided in the collection to distinguish TIBCO Spotfire® specific components from deprecated Connector 4.x components from other components of the collection. But this icon customization was not really stable, so we chose to limit it to icons for deprecated Connector 4.x components and to the classical Discngine icons.
  • Data Functions module:
    • An error blocked the opening of a document containing columns calculated by a Pipeline Pilot protocol when the TIBCO Spotfire® Analyst client was launched at the same time (i.e. when the Analyst client was launched by double-clicking on the DXP file). There are now no more blocking errors, but the data table needs to be refreshed for these columns to be calculated. A notification will inform you about this.

New in 5.3

Data Functions module

Pipeline Pilot Calculated Columns - beta

In this new version 5.3 we have extended the TIBCO Spotfire® Calculated Columns concept to use the Pipeline Pilot protocols as new column calculation engines. It is supplied with the Data Functions module.

We provide four generic functions (one per data type), taking as argument the Pipeline Pilot protocol path and all the required data (records and parameters):

Add calculated column

More information can be found in this guide.

Client Automation & SWAPP module

TIBCO Spotfire® Filters handling

We also have integrated Pipeline Pilot components allowing you to manipulate the filters in your TIBCO Spotfire® documents.

Filter components

In the Add Filter component, all the filter types and their parameters are available, except the hierarchy filter. The components Reset Filter and Set Filter Visible are applicable irrespective of the type of filter.

Known limitation: depending on the number of decimal digits displayed for the filtered column, there may be differences between the value displayed in the TIBCO Spotfire® data table and the value to be set (due to rounding).

Execute IronPython Script component: new parameters

The Execute IronPython Script component allows you to add a custom IronPython script in your protocol, for instance because you need a feature not yet implemented in the Connector collection.

This component already existed in previous versions, but in this new version 5.3 we have improved it by adding two parameters: One Call per Record and Add Script at the end.

Execute IronPython Script component

One Call per Record: when the component is piped into a multi-record branch, it can generate either one call for each record or one call for all.

Add Script at the end: this parameter defines where the IronPython Script will be added in the call stack. It is only meant to be used in very specific cases and should likely be left unchanged.

Minor changes

Client Automation & SWAPP module: new Tools menu options

In the TIBCO Spotfire Analyst client (Tools > Client Automation), you can now either create a new document containing the Client Automation panel (Create new document option), add the Client Automation panel to an open document (Display panel option), or reset the panel URL to the home page (Reset to home page option):

Client Automation menu

Bug fixes in the JavaScript API

  • When using spotfireDocumentEditor.setDocumentProperty on an existing property, the property was removed before being added again. Now this function only modifies the value, without touching the property, which makes it possible to keep the possible links with scripts, in Text Areas, ...
  • When the SpotfireDocumentEditor was modified, the active page layout was set to Vertical, aligning all visualizations vertically, instead of keeping the layout defined by the user.
  • The function getRunStdOut always returned undefined.

Documentation

New in 5.2

TIBCO Spotfire® Library Upload REST API integration

Available from TIBCO Spotfire® version 10.2, the Library REST API lets external applications upload Spotfire Binary Data Format (SBDF) files to the Spotfire library. In this new version 5.2 of the Connector we have integrated the use of this REST API into the Pipeline Pilot collection. In this way, you can now write SBDF files from your Pipeline Pilot protocol directly to the TIBCO Spotfire® library:

Library Upload REST API

You will find in our installation guide all the necessary information to configure the use of this REST API. The official documentation is available here.

TIBCO Spotfire® Automation Services REST API integration

Until this new version of the Connector, the only solution to execute Automation Services Jobs from a Pipeline Pilot protocol was to use the Client Job Sender tool provided by TIBCO Spotfire®. The main disadvantage of this solution is that the Client Job Sender tool can only be used by a Pipeline Pilot hosted on a Windows server.

From TIBCO Spotfire® version 7.13 a REST API is available to trigger Automation Services jobs from an external application. We have therefore integrated the use of this REST API into the Pipeline Pilot collection of the Connector 5.2, creating the new component "Automation Services/Run Job with REST API":

Automation Services REST API

The protocols developed with this component are therefore compatible with Pipeline Pilot servers other than Windows, another significant advantage of this new solution is that it is easier to configure and more secure.

You will find in our installation guide all the necessary information to configure the use of this REST API. The official documentation is available here.

New in the SWAPP

Protocol shortcut link

A new section "Shortcut link" is now available in the SWAPP when running a protocol. From there you can generate a link to the current protocol that will allow you to reload the form with the exact same parameters you have when clicking the "Get Shortcut Link" button. This can be useful if you have a protocol that you always want to use with the same parameters, or if you want to share the filled form with a colleague. Furthermore, ticking the "Auto Submit" option will trigger the submit of the form as soon as the page loads from the link.

SWAPP Protocol shortcut link

File(s) to upload as input

A new input type has been added which allows you to give the user the ability to upload file to Pipeline Pilot. The uploaded file(s) will be placed in $(JobDir)/temp/$(FileName). Optionally you can define a list of allowed extensions.

SWAPP File input

Real-time Synchronisation

Real-time Synchronisation (see below) has been implemented in the SWAPP and can be toggled on/off to match your needs.

Templates

A template is a TIBCO Spotfire® document (DXP file) from which we have removed the records of all the data tables. We provide in this new version two components allowing you to manipulate the templates: "Client Automation/Save Template" and "Client Automation/Apply Template".

Template components

With the "Save Template" component, you can save a DXP from your current analysis. The DXP will be identical to your analysis, except that the data tables are empty.

With the "Apply Template" component, you can apply a saved template on your current analysis. In this way, the data tables of this analysis are exported and re-injected into the template, and you will have your data with all the parameters of the template (pages, visualizations, ...).

New Pipeline Pilot icons

In order to better distinguish the difference between the components coming from Connector 4.1 and those coming from Connector 5+, we have added new Pipeline Pilot icons in 5.2.

New icons in 5.2

Once the new collection is installed, all your protocols will contain components that display the Component 4.1 icon. We therefore also provide in the collection a protocol to update the icons in your protocols already developed with the Connector 5+. This protocol is available here: Utilities/Change warning icons to v5 icons.

Minor changes

New

New in visualizations

In the JavaScript API and the Pipeline Pilot collection:

  • Pie Chart: size by properties added.
  • Heat Map: creation of the visualization, x-axis, y-axis, cell values and trellis properties added.

Modified

  • SpotfireDocument.markRowsAsync: now exposes the operation to use when combining this selection with previously set selections.
  • SpotfireDocument.openDocument: can now open a document from a local file; only available if you use the TIBCO Spotfire® Analyst client.
  • "Web Panel" properties and preferences are renamed by "Client Automation".

Bug fixes

  • Fix the versionning of TIBCO Spotfire® extensions (.dll files) in order to keep the backward compatibility with saved DXP files after the upgrade of the Connector.
  • Include correct permissions for the Pipeline Pilot collection provided in the package (for Linux servers).

Documentation

New in 5.1

Client Automation home page

We now provide with the Pipeline Pilot collection a protocol that generates a home page for
the Client Automation. It will give you access to the SWAPP, as well as to the examples
and tutorials available.

This home page also lists the protocols saved on the Pipeline Pilot server in the folder
Protocols/Discngine/TIBCO Spotfire Enabled Protocols/Client Automation/, so feel free to add
your development protocols to test them in the Web Player or Analyst.

Client Automation home page

Real Time Synchronization

For those who are already familiar with the Connector 4.x, this feature was integrated to the Connector 4.0 and improved for the Connector 4.1. It has been revamped in this new release 5.1 to integrate with the new JavaScript API.

When developing Pipeline Pilot workflows for TIBCO Spotfire®, developers can now activate the "Real Time Synchronization". Thanks to this feature, it is easier to share data tables between Pipeline Pilot and TIBCO Spotfire®: the upload and persistence processes are automated, and you can focus on the required data without sending data back and forth when they already have been sent.

On a technical note, the Real Time Synchronization takes care of tracking changes in your Data Tables and updates the caches on Pipeline Pilot based on your settings (whether you use a manual trigger or the form submission). The caches are scoped to the user and the session.

Real Time Synchronization

This feature is available on demand through the Real Time Synchronization parameter of the HTML TIBCO Spotfire Viewer component. A tutorial is available at the following location:
Protocols/TIBCO Spotfire Enabled Protocols/Client Automation/Real Time Synchronization/Real Time Synchronization Examples Home.

The Real Time Synchronization has also been implemented on the SWAPP and can be toggled in the menu bar. Note that it is active by default.

Real Time Synchronization Collection

Pipeline Pilot Data Function with multiple files as results

Previously, to have multiple data tables generated by data functions in your TIBCO document, you had to store as many data functions as data tables and call them separately. This required a lot of manual intervention. Moreover, it was far from optimal in terms of performance because the "Pipeline Pilot Data Function" tool was called as many times as there were data tables to load, while some steps could be shared.

There is now a way to define the expected results files in the protocol and therefore to have a data function with multiple data tables as results.

Here is an example of how to configure a protocol with 3 output data tables:

Multi file results in a protocol

As you can see, you just need to add the file name as the output property. The file name (without the extension) will be used to name the data table in TIBCO Spotfire®.

Improvement of the Pipeline Pilot reporting in the SWAPP

You can now use the Pipeline Pilot components from the Reporting collection that redirect to
another protocol. This allows you for example to develop a sequence of protocols, each
redirecting to the next, and execute them via the SWAPP.

New Pipeline Pilot Visualization components

The existing components have been improved. In addition, the Box Plot and the Pie Chart components have been added.

Pipeline Pilot Visualization components

New in 5.0.1

This minor new version offers some minor bug fixes, improves the components of the Pipeline Pilot collection, and provides a quick start protocol to easily start with the collection.

New in 5.0 - Release Candidate

The Connector 5.0 is a major new version. The Client Automation, new name of the Discngine Web Panel, has been completely
redesigned. The Pipeline Pilot Data Functions and the Automation Services Tasks have
been improved in a minor way.

The very big change for this version is that the Connector 5.0 is compatible with TIBCO Spotfire® Analyst and TIBCO Spotfire® Web Player. Thus, the same Pipeline Pilot protocol can be executed either in the Analyst or in the Web Player.

Architecture overview

This huge advantage requires modifying existing Pipeline Pilot protocols to replace Connector 4.1 components with Connector 5.0 components. Indeed, the Pipeline Pilot collection has also been entirely redesigned, and the collection 4.1 is now deprecated (components and example protocols) although backwards compatibility with the Connector 4.1 is ensured. Protocols developed in 4.1 will continue to work using Web Panel 4.1 embedded into the 5.0, but they will not be compatible with both Analyst and Web Player.

Client Automation

All is new for this product in the Connector 5.0: new TIBCO Spotfire® extensions, new JavaScript API, new Pipeline Pilot collections, and even new name!
All is new, but as said before, the Connector 4.1 is included into the Connector 5.0, so the backwards compatibility is ensured.

SWAPP - Spotfire Web Application for Pipeline Pilot

We provide also with this new version 5.0 the SWAPP, a standalone web application designed to be used in the Web Panel and developped in collaboration with one of the top Pharmaceutical Companies. This application allows you to register Pipeline Pilot protocols and run them seamlessly as web forms from TIBCO Spotfire® Analyst or Web Player.

SWAPP Form

Pipeline Pilot Data Functions

Improvement of the Data Function registration

The connection with the Pipeline Pilot server is now manageable in the "Register Data Function" view. A status bar on the bottom of the screen informs you about your connection status. Also, "Login" and "Logout" buttons have been added in the screen, and the registering is not available until you are logged in.

Register Pipeline Pilot Data Functions

Pipeline Pilot Automation Services Tasks

For this new release, efforts regarding Automation Services tasks have been focused on improving visualization tasks. Indeed, label properties have been added for Scatter Plots and Bar Charts, and you can now also add Pie Charts, Line Charts, Box Plots and Heat Maps.

Here is the list of all Pipeline Pilot tasks now available:

Automation Services Tasks