How do I import stories with Multiple "Acceptance Criteria" Values

[Julie Hebert]

I have made several attempts/tests to upload issues with multiple acceptance criteria without success.  I reach the level of creating the multiple acceptance criteria elements, but they are all with "Empty Name" content.  Here the content of what I put in the Acceptance Criteria cell :

{
  "data": [
     {
       "Name": "abc"
     }
  ]
}

Normally, I should read "abc" instead of "Empty Name" in the acceptance criteria bullet.  What am I doing wrong?

[Prince Nyeche]

Hi,

Have you tried using the Jira CSV Importer to import values to a custom field in Jira issues? Also, what method are you using to import? For example, JSON or the REST API since you're using an object to represent your value.

[Julie Hebert]

I am currently using the JIRA csv importer indeed.  I use the US-ASCII, comma delimited method to import.  It work correctly for all other fields but acceptance criteria where it tells me that, whatever I write as data in the cell, "the Json format of the message is not adequate".  That's why I started puting some Json code in this cell...

[Wojciech Wardaszko]

Hi @Julie Hebert 

Welcome to the Community!

It's a totally wild guess here, but this error kind of brings the Atlassian Document Format to mind. From what I've gathered it's the required format for textarea custom fields.

You may want to try using that format for your data to see if it will get imported correctly. 

Cheers!

[Julie Hebert]

Thanks @Wojciech Wardaszko .  I tried your alternative, but also got an "Empty Name" result.  

[Julie Hebert]

@Wojciech Wardaszko & @Prince Nyeche :  The actual error message is " Not a valid JSON OBJECT".  not format.  Does this make a difference?

[Prince Nyeche]

Please let us know what the field type of this custom field is. If it's simply a single-line text field, a multiline text field or a message custom field. 

[Julie Hebert]

Here's what made it work finaly:

• one column per acceptance criteria
• this format for the value in the cell needs to be like this:  
• 
• Example:  

[Jay Aiken]

@Julie Hebert Thanks! I've never been able to make this work. Followed your guidance above and it worked first try. Incredible. Thanks again!