Create default list of issues when creating JIRA epic associated with component type

sanjay.rakh

We would like a specific list of issues to be created when an epic is created with component of type "Upgrade Project" or "New Client Project". 

These issue will be created from CSV file wherein we have 7 Issue Type of type Task and summary end text would be appended text (example:  ABXX Upgrade Project - UAT Build ) and would have different component for each task as it is CSV file. 

Issue Type

Summary

Component

Estimated Time

Description

Priority

Assignee

Can someone please help to automate this using Scrip runner groovy script.

Ram Kumar Aravindakshan _Adaptavist_

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