Jira is not recognising my upload from CSV

Question

I'm creating a CSV template for some analysts, they would need to fill it and I then do a bulk upload to Jira.

I want to upload them as defects. The issue I'm facing is:

I have a label when filling out a defect and I want to select one of the options, so for example I have a label called 'Label A' and it has 3 options in a list.

In the excel file I put the top row as 'Label A' and under it for one of the entries I put the full name of one of the options (Displayed on JIRA) for example 'Option A'. But I write this in the excel file as : Option A

But after uploading it does not recognise this and returns a validation error.

This is the same for a tick box label, for e.g. 'Label B'

However any text that I put up, (Something that requires free text and is not a multiple option) like for example 'Summary', I would put any random text e.g. 'abcd', and this will validate fine.

So my question is, what am I doing wrong with the way I'm formatting my CSV for when I upload answers to multiple choice parts of a defect?

Answer 1

I think if you can create a sample issue (like you need to be upload) in jira then you can export(Export all fields) that created issue and analyse the output excel file. then you can understand the input format that jira required form your CSV file.

UPDATED

the other thing you can do is read the JIRA log file it will tell you the actual error occurred some times.

are you export your created issue with this option?..see screenshot below..

Answer 2

The approach will depend on the field types you are using.

For example, if you were loading a simple text field then the text in the CSV file will just be inserted in to the text field.

If, however, you are populating a custom field that is represented by a radio button or a drop-down listbox then you will need to use the field mapping option that is offered during the CSV import.

Say you had a radio button that said either 'true' or 'false'. You would tick the mapping option for this field during the CSV import and configure it to map true -> true and false -> false. You can also do this mapping in the CSV file itself.

You can see more details on this link:

Atlassian - Importing Data from CSV