Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

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

2 answers

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!

Why in jira csv import we are not able to get the field values when we try to import csv.

  • Definition of Done 
  • Acceptance criteria TODO 

These are the two fields values im trying but the field type says TODO list custom field some addon related.. is there any specific way to get the values?

Suggest an answer

Log in or Sign up to answer
TAGS

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