How do I bulk load Stories with multiple Acceptance Criteria?

Sumant Panda August 23, 2021

What is the format in which I need to create a CSV file to bulk load User Stories with Multiple Acceptance Criteria 

4 comments

Comment

Log in or Sign up to comment
Sumant Panda August 23, 2021

Sample CSV File

EpicLink,Issue Type,Summary,Description,Team,AC1
XXXX-9,10001,Test Summary,Test Description,"Team 1","Test Acceptance Criteria 1"

Jack Hunter _HeroCoders_
Atlassian Partner
August 24, 2021

Hello @Sumant Panda,

Can you tell us what is "Acceptance Criteria"? Please share a screenshot.

Cheers,
Jack 

Sumant Panda August 24, 2021

AcceptanceCriteria.png

Hello Jack, I am trying to bulk load stories which will have multiple acceptance criteria

Jack Hunter _HeroCoders_
Atlassian Partner
August 25, 2021

Alright, I think you are using Checklist for Jira app.

CC @Yves Riel _Okapya_ to answer the question.

Like Sumant Panda likes this
Yves Riel _Okapya_
Atlassian Partner
August 25, 2021

Hi @Sumant Panda ,

It indeed seems to be Checklist for Jira but that seems to either be server or Data Center, not cloud.

CSV import is available starting with v5.1 and here's the format that need to be followed:

https://okapya.atlassian.net/wiki/spaces/CHKDOC5/pages/2348318721/Exporting+importing+checklist+CSV+data

Regards,

Yves

Sumant Panda August 25, 2021

Hi @Yves Riel _Okapya_ ,

This does not work.

Data Used: 

Epic Id,Issue Type,Summary,Description,Team,AC1
ARTDL-9,10001,Test Summary,Test Description,"Team 1", "{""name"":""Item to import""}"

Error Log:

2021-08-25 22:13:55,189 INFO - Importer started!
2021-08-25 22:13:55,191 INFO - Engine is running in Validation-only mode
2021-08-25 22:13:55,193 INFO - All issues will be imported to project: Surrounding Systems (SURBP)
2021-08-25 22:13:55,193 INFO - Creating issue: [externalId='autoid-795921822887527054', summary='Test Summary']
2021-08-25 22:13:55,199 WARN - The value [ {null={"name":"Item to import"}} ] can't be added to the Custom Field [ Acceptance Criteria (CL) ]. The value [ {null={"name":"Item to import"}} ] can't be found or is in the incorrect format
2021-08-25 22:13:55,355 INFO - No problems found with issue 'Test Summary'

 

Jira Version Details:

Jira Version.png

Yves Riel _Okapya_
Atlassian Partner
August 25, 2021

Hi @Sumant Panda ,

As mentioned above, the CSV import only works starting checklist v5.1. Did you update the app? Your screenshot shows version 4.x.

Yves

Sumant Panda August 25, 2021

@Yves Riel _Okapya_ I will check tomorrow morning with the administrator and get back to you

TAGS
AUG Leaders

Atlassian Community Events