Wei Li Posted October 12, 2021 Share Posted October 12, 2021 Hi, Great work for the excellent custom module.One of my customer is very interested in this. I tried some test on my environment(Spotfire 10.10 in Japanese OS) and I can not reload data from Google Sheets with Japanese character in filename, sheet name or column name. Could you please confirm this behavor and fix it if confirmed (I didn't recall that question/issue should be submitted here hence put it in the review part, please remove that review if possible too. Sorry for that) Many Thanks. Regards, Wei Li Link to comment Share on other sites More sharing options...
Wei Li Posted October 12, 2021 Author Share Posted October 12, 2021 The error message is as below 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.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.b__2() Spotfire.Dxp.Framework.DocumentModel.DocumentView.Use(DocumentView documentView, DocumentViewExecutionState documentViewExecutionState, Action action) Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.b__29_0() Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.LoadData(Boolean willPotentiallyLoadData) Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.d__120.MoveNext() Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.d__95.MoveNext() Spotfire.Dxp.Data.DataTable.d__292.MoveNext() Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now