I am writing a script that needs to read some data from a csv file. This is the line that I want to use to access the file and store the data. InputStream inputFile = getClass().classLoader.getResourceAsStream("projectToEpicMap.csv") String[] lines = inputFile.text.split('\n') List rows = lines.collect { it.split(',') } Where do I have to put my csv file so this line will be able to access it? At the moment all I am receiving is a NullPointerException. Right now I have the csv file in this location. \atlassian-jira\WEB-INF\lib

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; } } }

Where do I drop the CSV file so my ScriptRunner script can see it?

Mark Finta

I am writing a script that needs to read some data from a csv file. This is the line that I want to use to access the file and store the data.

InputStream inputFile = getClass().classLoader.getResourceAsStream("projectToEpicMap.csv")
String[] lines = inputFile.text.split('\n')
List<String[]> rows = lines.collect {
    it.split(',')
}

Where do I have to put my csv file so this line will be able to access it? At the moment all I am receiving is a NullPointerException. Right now I have the csv file in this location.

<JIRA Install Directory>\atlassian-jira\WEB-INF\lib

Accepted answers

Stephen Cheesley _Adaptavist_

Hi Mark,

I made a slight change to your script. I have used "File" instead of using the classloader as it's a simpler approach. I also added an if statement to check for the presence of the file, so that you get more useful output than before in case the file is not found.

File file = new File("<path_to_jira_home>/files/test.csv") // <-- Change this to your path...

if (file.exists() && file.isFile()) {
    String[] lines = file.text.split('\n')
    List<String[]> rows = lines.collect {
        it.split(',')
    }
} else {
"No file found at that location..."
}

A couple of points on this:

1. Create a new directory in your JIRA_HOME directory for storing these kinds of files.

2. You need to provide an absolute path to the files on the server. I don't believe this will work with relative paths.

You should be able to run this script in your "Script Console" as-is to test. I would always recommend against carrying out this kind of development in your production JIRA instance. It is always best to test these changes in a pre-production instance first :-)

I hope this helps!

Steve

All comments

Stephen Cheesley _Adaptavist_

Hi Mark,

File file = new File("<path_to_jira_home>/files/test.csv") // <-- Change this to your path...

if (file.exists() && file.isFile()) {
    String[] lines = file.text.split('\n')
    List<String[]> rows = lines.collect {
        it.split(',')
    }
} else {
"No file found at that location..."
}

A couple of points on this:

1. Create a new directory in your JIRA_HOME directory for storing these kinds of files.

2. You need to provide an absolute path to the files on the server. I don't believe this will work with relative paths.

I hope this helps!

Steve

Mark Finta

Deleted comment

Hemanshu Sood_xuz55p

Hi @Stephen Cheesley _Adaptavist_, @Mark Finta, can you please provide the complete script to acomplish this. I want to read a csv file from my local system and create/update tickets in Jira

Stephen Cheesley _Adaptavist_

Hey @Hemanshu Sood

Unfortunately, I don't have time right now to write the whole script front to back. The snippet provided in my response should do 75% of what you want. You simply need to add the logic that will update JIRA issues based on the content. It should be straight forward enough. You can use the Atlassian Java API to help you find out how to update JIRA issues.

Feel free to come back if you get stuck or have any specific questions :-)

Ivana Srebrenova

Hello,

Can we read a csv file attached on a issue or some other location and read in in Cloud with Script Runner?

Welcome!

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

Quick Links

Find more posts tagged with

csv

scriptrunner

adaptavist

groovy