How to read csv file in script runner ?

Pravin_ixnnj4

Hi Team ,

I  need to read .csv file which present in my local machine and create ticket based on that 

can you please give idea  how can i implement this through script runner or any other way 

Thanks in advance .

PD Sheehan

When I need to read a csv for anything, I do it like this:

 

import com.opencsv.CSVReader
@Grapes(
@Grab(group='com.opencsv', module='opencsv', version='4.2')
)
def filePath = '/path/to/file/test.csv'
def reader = new CSVReader(new FileReader(new File(filePath)))
def data= reader.collect { it }.with { rows ->
    def header = rows.head()
def dataRows = rows.tail()

    dataRows.collect { row ->
        [header, row].transpose().collectEntries()
}
}

data.each{row->
    // access any data from the row by the name of the header
    // for example, row['colHeader'] or row.colHeader
}