user.startsWith is not a function during Google Sheet import

I'm trying to get over the last hurdle of the importing from GoogleSheets and hit this error during my import.

Any thoughts as to what I can try, I'm down to a pretty bare bones sheet at this point.

Thanks,

Kevin

28/02/25 22:34:55,267 ERROR [321-14] [mportLogging] Import failed with error: TypeError: user.startsWith is not a function  jetbrains.youtrack.scripts.sandbox.EvaluationException: TypeError: user.startsWith is not a function     at jetbrains.youtrack.scripts.internals.ExceptionsProcessingKt.withScriptingAndDBExceptionsProcessing$createException(ExceptionsProcessing.kt:29)     at jetbrains.youtrack.scripts.internals.ExceptionsProcessingKt.withScriptingAndDBExceptionsProcessing$wrapSpecifically(ExceptionsProcessing.kt:64)     at jetbrains.youtrack.scripts.internals.ExceptionsProcessingKt.withScriptingAndDBExceptionsProcessing(ExceptionsProcessing.kt:89)     at jetbrains.youtrack.scripts.internals.ExceptionsProcessingKt.withScriptingAndDBExceptionsProcessing$default(ExceptionsProcessing.kt:18)     at jetbrains.youtrack.imports.model.ImportExtensionsKt$doStart$3$1.invoke(ImportExtensions.kt:96)     at jetbrains.youtrack.imports.model.ImportExtensionsKt$doStart$3$1.invoke(ImportExtensions.kt:95)     at jetbrains.youtrack.scripts.internals.RunInContextKt.runInContext(RunInContext.kt:17)     at jetbrains.youtrack.imports.model.ImportExtensionsKt$doStart$3.invoke(ImportExtensions.kt:95)     at jetbrains.youtrack.imports.model.ImportExtensionsKt$doStart$3.invoke(ImportExtensions.kt:90)     at jetbrains.youtrack.api.application.ThreadLocalToggleKt.runWith(ThreadLocalToggle.kt:27)     at jetbrains.youtrack.imports.model.ImportExtensionsKt.doStart(ImportExtensions.kt:90)     at jetbrains.youtrack.imports.model.ImportExtensionsKt$start$1.execute(ImportExtensions.kt:56)     at jetbrains.youtrack.core.job.AbstractJob.doExecute(AbstractJob.kt:114)     at jetbrains.youtrack.core.job.AbstractJob.tryExecute$youtrack_core(AbstractJob.kt:102)     at jetbrains.youtrack.core.job.AbstractJobProcessor$JobExecutionTask.executeJob(AbstractJobProcessor.kt:229)     at jetbrains.youtrack.core.job.AbstractJobProcessor$JobExecutionTask.runInContext(AbstractJobProcessor.kt:213)     at jetbrains.youtrack.core.job.AbstractJobProcessor$JobExecutionTask.access$runInContext(AbstractJobProcessor.kt:193)     at jetbrains.youtrack.core.job.AbstractJobProcessor$JobExecutionTask$run$1.invoke(AbstractJobProcessor.kt:201)     at jetbrains.youtrack.core.job.AbstractJobProcessor$JobExecutionTask$run$1.invoke(AbstractJobProcessor.kt:201)     at jetbrains.youtrack.core.job.context.BeanContainerContext.doApply(ExecutionContexts.kt:47)     at jetbrains.youtrack.core.job.context.ChainedExecutionContext.apply(ChainedExecutionContext.kt:29)     at jetbrains.youtrack.core.job.context.ChainedExecutionContext$apply$1.invoke(ChainedExecutionContext.kt:26)     at jetbrains.youtrack.core.job.context.ChainedExecutionContext$apply$1.invoke(ChainedExecutionContext.kt:25)     at jetbrains.youtrack.core.job.context.LogExecutionContext.doApply(ExecutionContexts.kt:24)     at jetbrains.youtrack.core.job.context.ChainedExecutionContext.apply(ChainedExecutionContext.kt:25)     at jetbrains.youtrack.core.job.AbstractJobProcessor$JobExecutionTask.run(AbstractJobProcessor.kt:201)     at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)     at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)     at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)     at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)     at java.base/java.lang.Thread.run(Thread.java:1583) Caused by: org.graalvm.polyglot.PolyglotException: TypeError: user.startsWith is not a function     at <js>.:=>(scripts/@jetbrains/youtrack-spreadsheets-client/user.js:22)     at <js>.:=>(scripts/@jetbrains/youtrack-spreadsheets-client/field.js:84)     at <js>.getIssueFields(scripts/@jetbrains/youtrack-spreadsheets-client/field.js:51)     at <js>.convertSpreadsheetIssue(scripts/@jetbrains/youtrack-spreadsheets-client/issue.js:163)     at <js>.:=>(scripts/@jetbrains/youtrack-spreadsheets-client/issue.js:81)     at <js>.:=>(scripts/@jetbrains/youtrack-spreadsheets-client/issue.js:79)     at <js>.getIssueUpdates(scripts/@jetbrains/youtrack-spreadsheets-client/client.js:70)     at org.graalvm.polyglot.Value.invokeMember(Value.java:934)     at jetbrains.youtrack.imports.runtime.JsClientAdapter.callOptionalJs(JsClientAdapter.kt:28)     at jetbrains.youtrack.imports.runtime.JsClientAdapter.getIssueUpdates(JsClientAdapter.kt:774)     at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)     at java.base/java.lang.reflect.Method.invoke(Method.java:580)     at jetbrains.youtrack.imports.runtime.client.ClientInvocationsLoggingHandler.invoke(ClientInvocationsLoggingHandler.kt:34)     at jdk.proxy4/jdk.proxy4.$Proxy292.getIssueUpdates(Unknown Source)     at jetbrains.youtrack.imports.runtime.ImportProcessingDocumentsKt$defineContinuousClientRequest$1.invoke(ImportProcessingDocuments.kt:296)     at jetbrains.youtrack.imports.runtime.ImportProcessingDocumentsKt$defineContinuousClientRequest$1.invoke(ImportProcessingDocuments.kt:293)     at jetbrains.youtrack.imports.runtime.ImportProcessingDocumentsKt.doProcessDocuments(ImportProcessingDocuments.kt:335)     at jetbrains.youtrack.imports.runtime.ImportProcessingDocumentsKt.access$doProcessDocuments(ImportProcessingDocuments.kt:1)     at jetbrains.youtrack.imports.runtime.ImportProcessingDocumentsKt$processDocumentsInProject$3.invoke(ImportProcessingDocuments.kt:248)     at jetbrains.youtrack.imports.runtime.ImportProcessingDocumentsKt$processDocumentsInProject$3.invoke(ImportProcessingDocuments.kt:246)     at jetbrains.youtrack.imports.runtime.TimeInterval$Companion.withTimeInterval(TimeInterval.kt:75)     at jetbrains.youtrack.imports.runtime.ImportProcessingDocumentsKt.processDocumentsInProject(ImportProcessingDocuments.kt:246)     at jetbrains.youtrack.imports.runtime.ImportStageProjects.execute(ImportStageProjects.kt:54)     at jetbrains.youtrack.imports.runtime.ImportProcedureProjectsImportKt$doProjectsImport$3.invoke(ImportProcedureProjectsImport.kt:32)     at jetbrains.youtrack.imports.runtime.ImportProcedureProjectsImportKt$doProjectsImport$3.invoke(ImportProcedureProjectsImport.kt:27)     at jetbrains.youtrack.imports.runtime.TimeInterval$Companion.withTimeInterval(TimeInterval.kt:68)     at jetbrains.youtrack.imports.runtime.ImportProcedureProjectsImportKt.doProjectsImport(ImportProcedureProjectsImport.kt:27)     at jetbrains.youtrack.imports.model.ImportExtensionsKt$doStart$3$1$1.invoke(ImportExtensions.kt:115)     at jetbrains.youtrack.imports.model.ImportExtensionsKt$doStart$3$1$1.invoke(ImportExtensions.kt:96)     at jetbrains.youtrack.scripts.internals.ExceptionsProcessingKt.withScriptingAndDBExceptionsProcessing(ExceptionsProcessing.kt:80)     ... 28 more

0
3 comments

Hi Kcaporaso!

The issue is apparently with processing the “Author” field values, so reviewing your Google Sheets document would provide more info. Can you please open a ticket with us at https://jb.gg/ytsup and share the document link? Also, please attach the full import logs (can be downloaded from the import configuration in YouTrack).

 

0

Hi Julia Bernikova , I have done this thing:

Request #7319754

0

Oh, I think because I had the header as:  Author (user)

I took off the (user) and it imported stuff.  Ok, so I guess I misunderstood the user of (user).

Sorry about that.

0

Please sign in to leave a comment.