how to read from a CSV file using Groovy script .

Hello ,

I am trying to read a CSV file which has two columns

issue_key | custom_filed_value

i am trying to get the value of key and value using groovy script so that i can update the issue key got from the CSV .

Any help is highly appreciated .

Abyakta

4 answers

Suggest an answer

2 votes

I have used Super CSV to read data but in confluence.

Should work in Jira too

https://super-csv.github.io/super-csv/examples_reading.html

Also it is good idea to run dos2unix if you have it in Linux to fix format and encoding.

// Misc manipulations
import java.nio.charset.StandardCharsets

// CSV Imports - http://super-csv.github.io/super-csv/index.html
import org.supercsv.io.CsvBeanReader
import org.supercsv.io.CsvMapReader
import org.supercsv.prefs.CsvPreference
import org.supercsv.cellprocessor.CellProcessorAdaptor
import org.supercsv.cellprocessor.ift.CellProcessor
import org.supercsv.cellprocessor.Optional

def csvFile="/some/path/csvFile.csv"
// as in https://super-csv.github.io/super-csv/apidocs/org/supercsv/prefs/CsvPreference.html
CsvPreference PIPE_DELIMITED = new CsvPreference.Builder('"', '|', "\n").build()

def mapReader = new CsvMapReader(new InputStreamReader(new FileInputStream(localFilePath), StandardCharsets.UTF_8), PIPE_DELIMITED)

def header = mapReader.getHeader(true)

while ( (issuesMap = mapReader.read(header)) != null ) {

 def issueKey = issuesMap."issue_key" def cfValue = issuesMap."custom_filed_value"
// Rest is to find issue by Key in Jira and use mutable Issue and CF Manager to set CF value
}