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
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.htmlCsvPreference 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
}
Same problem here...anyone to help us?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.