nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Gettin null output in scriptrunner

Raman Kumar_10craw

Hello folks,

I have been trying to read a CSV via Groovy and spit out the values of columns into defined variables.

I used CsvReader to read the header and the records. When I run this code in my local groovy console, it gives me the desired output. But when I run it in JIRA Scriptrunner, it give me a null output. Not sure what I'm doing wrong.

Need some help please.

import java.io.FileNotFoundException
import java.io.IOException
import com.csvreader.CsvReader

CsvReader products = new CsvReader("D:/Program Files/Atlassian/JIRA/files/test.csv")

products.readHeaders()

    while (products.readRecord())
    {
    String id = products.get("ID")
    String project = products.get("Project")
    String time_entry = products.get("Open_for_Time_Entry")
    String clarity = products.get("Clarity_Project")
    String action = products.get("Action")
    String length = products.get("Length")
    String type = products.get("Type")
    String summary = products.get("Summary")

System.out.println(id + "\t" + project + "\t" + time_entry + "\t" + clarity)
}
products.close()

Comments

Nic Brough -Adaptavist-

Have you tried running it in the ScriptRunner console and check the logs it gathers as it runs?

My best guess is that it's either going to show an error opening the file, or the null is what you'd expect as the script has no output to go to the screen. (System.out.println is dropped into the logs, not the screen)

Ben Poulson

Ugh, I've run into this. The problem is that the groovy console doesn't support println. There are two ways to do it.

1) log output rather than printing it (just need to replace system.out.println with log.error)

2) Returning whatever it is you want to display (can't put it in a loop though, since a return outside a function will exit the script)

Bonus tip, Groovy doesn't require a variable to be declared as a type (it's like javascript in that aspect). Instead of declaring your variables as type String, you could declare them as type def. String works too, def is just also an option.

Let me know if that fixed it!

Raman Kumar_10craw

Thanks a lot Ben!

It worked.

Ben Poulson

No problem! If that fixed it, could you go ahead and mark my response as the answer?

Thanks!

Raman Kumar_10craw

somehow unable to mark the answer

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira