1 answer
Hi @sanjay_rakh
For your requirement, you will need to do something like this:-
import com.adaptavist.hapi.jira.issues.Issues
def file = new File('/home/ram/Downloads/issue_data.csv') // Modify the Path where the csv is stored
def list = [] as ArrayList<Map>
def projectKey = 'MOCK'
def epic = Issues.getByKey('MOCK-1') // Enter Epic Key
/**
* Extract the value from the CSV file and add it to a List of Maps
*/
file.eachLine {
def column = it.split(',')
def mapInput = [:] as Map
mapInput.put('Issue Type', column[0])
mapInput.put('Summary', column[1])
mapInput.put('Component', column[2])
mapInput.put('Estimated Time', column[3])
mapInput.put('Description', column[4])
mapInput.put('Priority', column[5])
mapInput.put('Assignee', column[6])
list.add(mapInput)
}
list.remove(0)
list.each { Map map ->
Issues.create(projectKey, map['Issue Type'].toString().trim()) {
setAssignee(map['Assignee'].toString().trim())
setSummary(map['Summary'].toString().trim())
setDescription(map['Description'].toString().trim())
setPriority(map['Priority'].toString().trim())
setComponents(map['Component'].toString().trim())
setOriginalEstimate(map['Estimated Time'].toString().trim())
setPriority(map['Priority'].toString().trim())
setEpic(epic)
}
}
Please note that the sample working code above is not 100% exact to your environment. Hence, you will need to make the required modifications.
I have tested this in my environment, and it works as expected. I can create new issues according to the values set in the CSV file and automatically add them to the Epic issue.
Below is the sample CSV document that I have tested with:-
First, ensure that you have the Epic created first. Once you have done that, set the Epic key to this line:-
def epic = Issues.getByKey('MOCK-1') // Enter Epic Key
Next, ensure you have saved the csv file in the correct directory path that is accessible to your Jira instance. You must update the path and file details in this line:-
def file = new File('/home/ram/Downloads/issue_data.csv') // Modify the Path where the csv is stored
Finally, execute the code on the ScriptRunner console.
I hope this helps to solve your question. :-)
Thank you and Kind regards,
Ram
Thank you @Ram Kumar Aravindakshan _Adaptavist_ for working on this and writing the script. I am see below error
Cannot find matching method MutableIssue#setDescription(V)
Cannot find matching method MutableIssue#setSummary(V)
etc
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.