It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How do I import stories with Multiple "Acceptance Criteria" & "Definition of Done" Values

Valerie Strode Apr 12, 2018

Due to the number of values we have to import, and the size of our team, and our interactions, we import our stories and epics using the CSV Import.

We use two check listed fields ("Acceptance Criteria" & "Definition of Done").  Each of these usually have more than 1 value in them.

At the moment, we are over populating the "Description" field in excel, export to CSV, import to JIRA, then manually have to edit the story to assign sprint, acceptance criteria, and definition of done.

Needless to say, this is a royal pain.  I'm not addressing the idiocy of not being able to import sprint name at this time.  I'm focusing on "Acceptance Criteria" & "Definition of Done".  How can we not have to do this manual work around to import?

Thank you.

Lee

1 answer

1 vote
Tim Reiking Aug 13, 2018 • edited

Hi Valerie, good question.


You should be able to import multiple values into a single custom field by adding a second column to your CSV file with the same name as other column where the second column contains the value of second option.
For example:
Key,Summary,Description,Acceptance Criteria,Acceptance Criteria,Priority,etc
ABC-123,Summary,Description,OptionA,OptionB,High,etc

Then during your CSV import mapping you only have to map a single custom field. You may also need to check the box to map your value as well (if your CSV values differ from the ones in Jira).
See "Aggregating multiple values into single fields" on Importing data from CSV.

I'm also a developer with cPrime and I've found that Power Scripts has a really good feature for dealing with this issue. It is free to try for 30 days.

You can use following routines to fix update your fields if the OOTB import solution doesn't work for you.

The useful thing is with Power Scripts you don't need to know Java/ Groovy to write scripts so it's really easy to use. The script is:


struct csvInfo {
string projectKey;
string summary;
string description;
string issueType;
string acceptanceCriteria;
string definitionOfDone;
}

csvInfo [] fileContent = readFromCSVFile("C:/test.csv", true);
for(csvInfo i in fileContent) {
string newTicket = createIssue(i.projectKey, "", i.issueType, i.summary);
%newTicket%.#{Acceptance Criteria} = i.acceptanceCriteria;
%newTicket%.#{Definition of Done} = i.definitionOfDone;
}

If you custom fields require multiple values to be set, the values can be separated by "|". Example: "OptionA|OptionB".

You will be able to run your new script from the SIL Runner Gadget from you dashboard. 

Hope that helps!

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Jira

Try Jira Cloud for Outlook: Organize your work without leaving your inbox

Hi Atlassian community, My name is Max and I work on the product integration team at Atlassian. I am pleased to announce the early access program for the Jira Cloud add-in for Outlook. This add-in...

2,395 views 6 15
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you