how to read from a CSV file using Groovy script .

[Abyakta Lenka]

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

[Areg Vrtanesyan _Work_]

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
}

[Dirk Penné]

Same problem here...anyone to help us?

[Joel]

Yahtzee... This seems to be the direction.

https://community.atlassian.com/t5/Adaptavist-questions/Where-do-I-drop-the-CSV-file-so-my-ScriptRunner-script-can-see/qaq-p/708356

[Joel]

Also am interested in this.