Custom Connector for TIBCO Spotfire® to read data from Google Sheets

This Connector allows TIBCO Spotfire® users to import data from Google Sheets, CSV and Excel Files located on Google Drive or Google Shared Drives.

Compatible Products

TIBCO Spotfire®

Provider

TIBCO Software

License

TIBCO Component Exchange License

Overview

This Connector allows TIBCO Spotfire® users to import data from Google Sheets, CSV and Excel Files located on Google Drive or Google Shared Drives.

Release(s)

Release 1.0.0

Published: September 2021

Initial Release

Review (1)
5
w.li 9:10pm 09/28/2021

Great work!

I have an issue to report.

If sheet name contains Japanese character, it works fine whe creating new connect and load data to analyst.

However next time when opening the dxp and reload the data, it failes with error as below, it Seems some dictionary can not find appropriate sql table name(which contains Japanese characters). Please fix this. Thanks.

ImportException at Spotfire.Dxp.Data:

System.Collections.Generic.KeyNotFoundException: 指定されたキーはディレクトリ内に存在しませんでした。

   場所 System.ThrowHelper.ThrowKeyNotFoundException()

   場所 System.Collections.Generic.Dictionary`2.get_Item(TKey key)

   場所 Spotfire.Dxp.Data.Adapters.GoogleSheetsCustom.GoogleSheetsCustomAdapterConnection.ExecuteQueryCoreImpl(SqlQuery query, QueryResultWriter resultWriter, CancellationToken cancellationToken)

データ接続:

Google Sheets (Custom)

Document ID:

1Zy9i5I_GeIiGbR7Skgd4dGeBChF9Yn9pHyY0SXGOW5Q

Document Name:

test-data

Document Type:

Google Sheet

Items:

???1 (HRESULT: 80131500)

Stack Trace:

   場所 Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.CreateView(ManagedDataConnection dataConnection, Guid virtualJoinViewId, DataTableSchema schema, Guid promptCollectionId, CxxSession session, IServiceProvider serviceProvider, GlobalMethodRegistry globalMethodRegistry, NotificationService notificationService, Int32 rowLimit, PendingViewRequestsManager pendingViewRequestsManager)

   場所 Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.GetColumnsAndProperties()

   場所 Spotfire.Dxp.Data.Persistence.DataItem.PerformUpdate(DataColumnProducer producer, Boolean forceUpdate)

   場所 Spotfire.Dxp.Data.Persistence.DataPool.GetDerivedData(DataColumnProducer producer, Boolean loadingPre50CalculatedColumnProducer, DataPoolReferenceType dataPoolReferenceType)

   場所 Spotfire.Dxp.Data.Persistence.DataPool.GetData(DataColumnProducer producer, Boolean loadingPre50CalculatedColumnProducer, DataPoolReferenceType dataPoolReferenceType)

   場所 Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.PoolReferenceCompute_(DocumentNode node)

   場所 Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.ComputeValue(NonSharedRuntimePropertyValue`1 runtimePropertyValue, StatelessPropertyComputer`1 propertyComputer, DocumentNode ownerNode)

   場所 Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.<>c__DisplayClass33_1.<LookupOrEvaluateValue>b__0()

   場所 Spotfire.Dxp.Framework.DocumentModel.ThreadTransactionInfo.EvaluateWithLimitationTarget(ILimitationTarget limitationTarget, Executor executor)

   場所 Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.LookupOrEvaluateValue(StatelessPropertyComputer`1 propertyComputer, DocumentNode ownerNode, StatelessDependencyDeclarer dependencyDeclarer)

   場所 Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.GetValue(StatelessPropertyComputer`1 propertyComputer, StatelessDependencyDeclarer dependencyDeclarer, DocumentNode ownerNode)

   場所 Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.<>c__DisplayClass29_0.<get_Value>b__2()

   場所 Spotfire.Dxp.Framework.DocumentModel.DocumentView.Use(DocumentView documentView, DocumentViewExecutionState documentViewExecutionState, Action action)

   場所 Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.<get_Value>b__29_0()

   場所 Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.LoadData(Boolean willPotentiallyLoadData)

   場所 Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.<TryLoadData>d__120.MoveNext()

   場所 Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.<LoadLinkedData>d__95.MoveNext()

   場所 Spotfire.Dxp.Data.DataTable.<PerformLoadLinkedData>d__292.MoveNext()

 

 

No reference content found. Please check back soon.