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
Please sign in to leave a comment.
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).
Hi Julia Bernikova , I have done this thing:
Request #7319754
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.