nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can we create Sub-Task based on number of rows in CSV file while creating ticket ?

sanjay_haxsn9

Hi All,

We are working on following requirement.

Create automatic Sub-Task based on attachment i.e. Sub-Task will be create based on the rows present in the file.

This has to be done while issue creation and I have tried Post Function for this requirement.

Please help and thanks in advance.

Accepted answers

All comments

Jack Brickey

There is no way that Jira could open the file and interrogate the number of rows.

Ankit Choudhary

Hi Jack,

Can it be done with the help of script by reading attachment file or there is no possibility of implementing it?

sanjay_haxsn9

Hi @Jack Brickey

Thanks for quick response but we are working on Jira Server so please guide us from server perspective.

Regards,

Sanjay Dhandare

Jack Brickey

so very sorry! So you will need an addon for sure, e.g. Automation for Jira, Scriptrunner, power scripts. If you have a scripting or automation addon already then the supporting docs should help guide you on this common UC.

sanjay_haxsn9

Thanks @Jack Brickey for updating we are already using Script runner

Nic Brough -Adaptavist-

Off-the-shelf, Scriptrunner has no librarys for parsing data out of files. It can do the rest of the work you mention - the sub-task creation, with presumably system and custom fields filled in (see https://library.adaptavist.com for lots of examples) but reading and understanding the attachment is not something it supports.

Of course, it's code, so it can be made to read the content of an attachment, and I have done that before, but only with plain text and writing the java/groovy from the ground up (work out where file physically is, open it with a file reader, grab the whole text), but for CSV you'll have to be more clever, manually writing code to parse the CSV (or find a library you can make available to SR and import it)