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
Hi Ross, are you using a Risk Register app from the marketplace, or are these fields you have defined yourself?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
it is a RED, AMBER, GREEN select list.
It exists on the standard Jira Risk (issue/type) creation wizard.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 -
Mapping -
Jira Issues -
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.