Jira Structure: Export to Excel script does not recognize method

[Diana]

I am following the documentation here on exporting a structure to excel using ScriptRunner. My aim is have to this saved as a Job to run periodically.

This is the script exactly:

import com.atlassian.jira.component.ComponentAccessor
String fileName = 'filename.xls'
String userName = 'admin'
Long structureId = 1L
Long viewId = 2L
String viewSpec = null
String expandState = null
String clientFilter = null
def plugin = ComponentAccessor.pluginAccessor.getPlugin('com.almworks.jira.structure')
def helper = plugin.getModuleDescriptor('helper').module
def ExcelExporter = plugin.classLoader.loadClass('com.almworks.jira.structure.export.excel.ExcelExporter')
def exporter = helper.instantiate(ExcelExporter)
def ForestSpec = plugin.classLoader.loadClass('com.almworks.jira.structure.api.forest.ForestSpec')
def spec = ForestSpec.structure(structureId, helper.userManager.getUser(userName))
exporter.configure(viewId, viewSpec, spec, expandState, clientFilter)
exporter.prepareExport()
exporter.createWorkbook({null})
def stream = new FileOutputStream(fileName)
try {
    exporter.writeWorkbookTo(stream)
} finally {
    stream.close()
    return new File(fileName).toPath().toAbsolutePath()
}

However, the code gives error under 

helper.instantiate(ExcelExporter)

that scriptrunner cannot not find a matching method for "instantiate" . What is the correct method?

In addition, on structure, how do I locate my viewID? I found my structureID, but not my saved View. Or, can I append this script so that it can search via a shared structure link? 

[Ram Kumar Aravindakshan _Adaptavist_]

Hi @Diana Gorv

Could you please share the exact error message that you are receiving?

I am requesting this to get a better understanding of the problem you are facing.

Also, instead of using ComponentAccessor.pluginAccessor.getPlugin method, have you tried using ScriptRunner's @WithPlugin and @PluginModule annotations? For example:-

@WithPlugin("com.almworks.jira.structure")

@PluginModule StructureComponents structureComponents

For more information on this, I suggest looking at the ScriptRunner Documentation.

I am looking forward to your feedback.

Thank you and Kind regards,

Ram

[Diana]

hi @Ram Kumar Aravindakshan _Adaptavist_  Thank you for the response back.

The exact message I get under helper.instantiate(ExcelExporter) reads:

"[Static type checking] - Cannot find matching method java.lang.Object#instantiate(java.lang.Class <? extends java.lang.Object>). Please check if the declared type is correct and if the method exists."

What's weird is that I just used the exact script example from the documentation on the Structure's website, I haven't made any modifications yet. I have also tried using @WithPlugin and @PluginModule annotation, I even tried importing

import com.onresolve.scriptrunner.runner.customisers.PluginModule

import com.onresolve.scriptrunner.runner.customisers.WithPlugin

, and the error is still pointing to 'instantiate'.

Currently I have scriptrunner version 7.9.0 and structure version 8.0.1. I can't seem to find the 'instantiate' method in the Atlassian api documentations. 

[Deepali Kohli]

Hello @Diana Gorv @Ram Kumar Aravindakshan _Adaptavist_ were you able to resolved this issue. I am exactly facing the same issue. Can you please guide, thanks!

Regards,

Deepali K

[Diana]

@Deepali Kohli 

Unfortunately, no. I think this might be a depreciated script, but I can't confirm.

[Stepan Kholodov _Tempo_]

Hello everyone,

The script in the article might not work on Jira version 9+. Please try to use the script below. You would need to set the file name and its destination, a user key of the user who'll be accessing the structure and the View id. The id of a view can be found the following way: select that view in a structure, click on the View button in the top-right corner, then click Manage views | Details of the selected view | Associations tab, hover with the cursor over the 'Add to the current structure's views' button and you will see its id at the end of the direct URL in the bottom-left corner of the screen. 

import com.atlassian.jira.component.ComponentAccessor

String fileName = '/.../filename.xls'

String userKey = 'JIRAUSER10000'

Long structureId = 1L

Long viewId = 2L

String viewSpec = null

String expandState = null

String clientFilter = null

def plugin = ComponentAccessor.pluginAccessor.getPlugin('com.almworks.jira.structure')

def helper = plugin.getModuleDescriptor('helper').module

def ExcelExporter = plugin.classLoader.loadClass('com.almworks.jira.structure.export.excel.ExcelExporter')

def exporter = helper.instantiate(ExcelExporter)

def ForestSpec = plugin.classLoader.loadClass('com.almworks.jira.structure.api.forest.ForestSpec')

def spec = ForestSpec.structure(structureId, helper.userManager.getUserByKey(userKey))

exporter.configure(viewId, viewSpec, spec, expandState, clientFilter)

exporter.prepareExport()

exporter.createWorkbook({null})

def stream = new FileOutputStream(fileName)

try {

exporter.writeWorkbookTo(stream)

} finally {

stream.close()

return new File(fileName).toPath().toAbsolutePath()

}

The script was tested on both Jira version 9.x and earlier versions. The mentioned error message - 'Cannot find matching method java.lang.Object#instantiate(java.lang.Class <? extends java.lang.Object>)' - can be observed in the body of the script but the script should work regardless of it when you click Run.

If the script doesn't work, please submit a support request at our portal since it would require an investigation to find out the reason.

Best regards,
Stepan Kholodov
Tempo