Trying to upload a CSV file of Risks

Ross Edwards October 14, 2024

Hi guys, I am trying to upload a CSV file that just contains Risks to my Jira project.  I am using a Configuration file to do so.

I click on validate before I upload the file and receive the following error

Issue can't be created due to error/s [ Information Risk is required ]

The information seems to been on the Risks RAG field.  I cannot work out how to create this in my Config File.

Can anyone shed some light on this please

Cheers

 

Ross

3 answers

0 votes
Craig Schwarze _ProjectBalm_
Atlassian Partner
October 15, 2024

Hi Ross, are you using a Risk Register app from the marketplace, or are these fields you have defined yourself?

Ross Edwards October 15, 2024

Hi no apps I don't believe.  The fields are in the standard Jira issue create wizard under the risk management tab

if you create a risk without the Risk RAG set the error will appear before it will let you create the issue

 

0 votes
Rilwan Ahmed
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 14, 2024

Hi @Ross Edwards ,

Welcome to the community !!

Below article contains steps by step guide to prepare csv file for ticket imports into the jira project. Hope this helps. 

https://confluence.atlassian.com/servicemanagementserver/creating-issues-using-the-csv-importer-939937206.html

0 votes
Kishan Sharma
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 14, 2024

Hi @Ross Edwards 

Welcome to the Atlassian Community!

Few follow-up questions - It appears that "Information Risk" is a custom field. Could you please specify the type of this custom field? Additionally, has it been configured as a required field ? I trust that you have a column in your CSV file that includes this particular field.

Ross Edwards October 14, 2024

Hi Kishan, 

Thanks for the reply.  I hadn't put the field into my CSV file which I have now corrected and am still getting the same error.  When I try and create a risk in Jira, it gives me the same error on the Risk Management tab above the Risk RAG dropdown, so I presume this is a mandatory field for a risk.

I've not added it to my config file, would I just need to add the Information Risk into it?

If so how?

Kishan Sharma
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 14, 2024

Hi Ross,

From the information provided, it appears that the field in question is mandatory. Therefore, it will be necessary to input this information during the CSV import process. Could you please confirm the type of the field? Is it a select list, text box, or checkbox or some other? You will have to map the CSV field to the Jira field during the import. Are you using cloud or data center ?

Ross Edwards October 15, 2024

it is a RED, AMBER, GREEN select list.

It exists on the standard Jira Risk (issue/type) creation wizard.

Kishan Sharma
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 16, 2024

Hi @Ross Edwards 

If its a select list field you should be able to import values from CSV too. Refer below sample CSV I tried to import in my project, I mapped the column "SelectList" from my CSV to "RAG Status" Jira field (select list having Red, Amber Green values) and it worked as expected.

CSV -

RAG.png

Mapping -

selectList-RAG.png

Jira Issues -

Jira-Issues.png

 

 

Suggest an answer

Log in or Sign up to answer