Summary
This Connector allows Spotfire® users to import data from CSV and Excel Files located on Microsoft SharePoint Online using Azure AD Token Authentication.
More details about custom connectors can be found in this article.
Release v24
Published: August 2023
This zip file contains versions 10.3.24.0 and 11.5.24.0 and 12.0.24.0 of the
"Custom Connector for Spotfire® to Read Files from Microsoft SharePoint Online"
v10.3.*.* is for Spotfire® 10.3 through 11.4
v11.5.*.* is for Spotfire® 11.5 through 11.8
v12.0.*.* is for Spotfire® 12.0 and newer
The build date is August 22nd 2023.
Fixed: Some previous versions of the 12.x build would not deploy onto Linux based Web Players and Automation Services.
Only updated build process - no code changes.
*******************************************************************************************
August 1st 2023. Build Number: 10.3.23.0 and 11.5.23.0 and 12.0.23.0
Fixed: Issue where one has a Type Row but some columns do not have types. An error would occur
when the data selection page was trying to load the table schema.
Empty types default to String Type.
*******************************************************************************************
July 17th 2023. Build Number: 10.3.22.0, 11.5.22.0 and 12.0.22.0
Fixed: Issues with column name rows when there are multiple ignored rows. Column headers
could get in a state in which one had duplicate names in the column names header row.
Fixed: The Connector did not respect the locale settings for numbers such that numbers in which
commas (,) were used as decimal separators where not correctly displayed in the resulting
analysis file.
*******************************************************************************************
May 18th 2023. Build Number 10.3.21.0, 11.5.21.0 and 12.0.21.0
Fixed: In previous versions, when columns were added to the file, the data was moved over
but column names were not. Now, if columns are added or removed from an existing
file and a user reloads the data without modifying the schema, the data is correctly loaded.
Missing columns have no data and a message is given that the user can edit the data source schema
to update the columns. For new columns, a user can update the data schema but no message is given
because it is impossible to tell the difference between a new column and one which the user
elected not to load.
New: Column Name Rows and Type Rows are now automatically detected.
New: The user can now browse the selected SharePoint sites for files in addition to searching.
New: When determining empty rows for Excel files, the user has the option for the
characters "#N/A" to equal an empty cell. The Excel NA() formula becomes "#N/A".
*******************************************************************************************
March 17th 2023. Build Number 10.3.20.0, 11.5.20.0 and 12.0.20.0
Fixed: Now supports reading data from Excel Macro files (xlsm).
Fixed: Issue with duplicate sites returned from Microsoft Graph API
*******************************************************************************************
February 23rd 2023. Build Number 10.3.19.0, 11.5.19.0 and 12.0.19.0
Fixed: Numeric Real columns were becoming SingleReal columns in Spotfire thus rounding and truncating values.
Breaking Change: Existing tables with SingleReal columns can only be updated by replacing the table with the
same table using the Replace Data steps.
Fixed: Columns with duplicate names were lost when imported. Duplicate names now have (#) appended to them.
Note: Columns must stay in the same position if the data is updated.
Fixed: Errors when importing files with captilized extensions, e.g. XLSX instead of xlsx.
*******************************************************************************************
December 6th 2022. Build Number 10.3.18.0, 11.5.18.0 and 12.0.18.0
New: File Search allows files other than just CSV and Excel to be found and used
New: Delimiter character can be specified to be other than comma when opening CSV files
New: The site selection page has been reworked to avoid issues associated with searching
when users have a large number of sites. Users can search for sites using wildcards
and also add sites manually if needed.
Users create a list of sites to search which is persisted across sessions. Within
the list, sites can be checked or unchecked for use when searching for files. The
file search page now indicates how many sites are being searched to allow users to
understand what impact this might have on search times.
Fixed: Backward compatability issue opening DXP files created with previous release
*******************************************************************************************
October 11th 2022. Build Number 10.3.17.0, 11.5.17.0 and 12.0.17.0
Fixed: Error thrown when opening a saved document with Excel Sheet name or Column Name
containing non-ASCII characters.
*******************************************************************************************
September 7th 2022. Build Number 10.3.16.0, 11.5.16.0 and 12.0.16.0
Breaking Change: When upgrading to Spotfire 12, existing users must re-create any encrypted
Preferences. Only existing users are affected by this change which is
required to enable Linux support.
New: The Connector can now be deployed on Web Player on Linux with Spotfire 12
Changed: Version numbering changed from x.y.0.z to x.y.z.0 to comply with corporate standards
Changed the label behavior on the login page to remove "Click" label after user has logged in.
*******************************************************************************************
February 17th 2022. Build Number 10.3.0.14 and 11.5.0.14
Fixed: Now brings back all sites and files even if results are paged by SharePoint API.
Enhancements: Improved information about selected file in File Selection dialog.
Improved information about the selected sheet in data table properties views in Spotfire.
While searching for files on SharePoint improved speed and added ability to limit
text search to filename or filename and metadata (closest to the previous versions).
Clicking on column headers in File selection grid will sort the column - toggles from ascending to descending.
*******************************************************************************************
December 21st 2021. Build Number 10.3.0.12 and 11.5.0.13
Fixed: Error when installing the Connector on Spotfire 11.6
*******************************************************************************************
November 23rd 2021. Build Number 10.3.0.12 and 11.5.0.12
Fixed:
- Issues with SharePoint Sites not showing up in the list of Sites
- Issues with users not being able to add sites
- Searching for documents with an empty search string caused a security exception
New:
- Added the ability to Filter the SharePoint Site list for users with large numbers of Sites
*******************************************************************************************
August 2nd 2021. Build Number 10.3.0.11
- Rewrote how refresh tokens are obtained. Changed to use synchronous calls instead of asynchrnous task.
Trying to avoid deadlock when many threads running.
- Updated Sheet Selection page to only read entire file one time and hold in memory for other sheets.
*******************************************************************************************
July 14th 2021. Build Number 10.3.0.9
- Rewrote how HTTP responses from SharePoint are processed to hopefully handle error message
that is occurring after opening a lot of files in one analysis
*******************************************************************************************
July 7th 2021. Build Number 10.3.0.9
Breaking Change: If previously using Spotfire preferences to configure client id and secret,
they have been replaced with a Configuration preference that can be obtained
using the Tools->SharePoint Online File (Custom) Configuration Tool Dialog.
- Added additional logging to hopefully help track down error occurring.
*******************************************************************************************
June 10th 2021. Build Number: 10.3.0.8
Breaking Change: The internal name of the adapter has changed to conform with corporate standards.
Any previously saved DXP's will need to be updated before they will work with
this version.
Authentication has been modified to be able to support Scheduled Updates and
Spotfire Automation Services.
*******************************************************************************************
May 4th 2021. Build Number: 10.3.0.7
Fixed:
- Issues with SharePoint Site list not showing all sites
- Fixed issues with data types
- Fixed "Ignore Empty Rows" check box to work
*******************************************************************************************
April 15th 2021. Build Number: 10.3.0.6
*******************************************************************************************
April 7th 2021. Build Number: 10.3.0.5
*******************************************************************************************
April 1st 2021. Build Number: 10.3.0.3
*******************************************************************************************
March 25th 2021. Build Number: 10.3.0.2
Initial Release
This version is for Spotfire 10.3 and newer.