Spotfire Analyst: Importing CSV files via SciStream function fails due to keyboard regional settings

Details:

In Spotfire Analyst, the following steps may fail:

Open Spotfire > File and data flyout > Other > Instrument Files with SciStream. Select any CSV file. Manage Format > Select any File format name. This results in an error message:

Error message: Could not read the selected data. AggregateException at :
One or more errors occurred. (HRESULT: 80131500)

Stack Trace:

Aggregated exception: 

ImportException at Spotfire.Dxp.Data:
Failed to open data source. (HRESULT: 80131500)

Stack Trace:
   at Spotfire.Dxp.Data.DataSource.ConnectWithoutPrompting(IServiceProvider serviceProvider, DataSourcePromptMode promptMode, Boolean updateInternalState, DataLoadSettings loadSettings)
   at Spotfire.Dxp.Data.Access.AddData.DataSourceAddDataFlow.ConfigureDataSourcesStep.<GetPromptRequests>d__7.MoveNext()
   at Spotfire.Dxp.Internal.EnumerableExtensions.<EnumerateWithExceptionHandling>d__4`2.MoveNext()

The following steps can be used to bypass the SciStream function:

Open Spotfire > File and data flyout > Other > Instrument Files with SciStream. Select any CSV file.

Workaround:

Switch the Windows client machine's keyboard / regional settings from German (or another non-English language) to US(English). This exact solution applied in one scenario, where German keyboard / regional settings were used.

In a broader sense, for non-English region Windows environments, the workaround to using SciStream function is likely going to be to use a file format setting that does not use a comma as the delimiter for dates and/or for numeric values.