How to Import Risk Assessment in Risk Assessment Designer?

[Jehiellb]

Hi Team,

Is there any way to export an excel template for Risk Assessment Designer to be used for creating set of questions? Is there any way to Import a set of questions (an excel file) to Risk Assessment Designer?

Your help will be much appreciated, Thanks in advance!

[Jorge G_]

I don't think there's a way to do this natively at the moment. The only way to do this is through XML files per the documentation: https://docs.servicenow.com/bundle/newyork-servicenow-platform/page/administer/assessments/task/t_Ex.... I would suggest creating a spreadsheet and then transforming it into an XML file, but that may be a bit overkill if it's only happening a few times. 

[Jan Spurlin]

@Jehiellb have you considered importing the questions into the Question Bank?  That would be a simpler set of import templates.  You would only need to import to the Assessment Categories (asmt_metric_category) and the Assessment Metrics (asmt_metric) tables.  The questions go into the Assessment Metrics tables with  a link to the categories.  

[Jehiellb]

Hi Jan,

Thank you for your response, I would appreciate if you could provide instructions on how can I achieve your proposed solution so I could try.

Your help is much appreciated, Thank you!

[Community Alums · Accepted solution]

@Jehiellb take a look at this article created by SN Product Manager. You will find all the steps there, its easy 🙂

https://community.servicenow.com/community?id=community_blog&sys_id=356c8cf5db39c450190dfb2439961968

[Jan Spurlin]

Generally when I am importing data into a table, I go to a module that utilizes that table and look at the records in it.

There is a question bank module in both Policy & Compliance and Risk. There is a setting on the tables to flag that the entry is either for Risk or Compliance. I don't know the field name off the top of my head. That will provide you with the fields you need on your import source and how to build your transform map.

On the asmt_metric table (aka the questions) you will may need to link it to the categories via a sys Id.  The categories have to be imported first.

If you are not familiar with importing data into ServiceNow, there are several sources to help you learn about that process.  One is on the Developers site.  I'm not sure if there is anything in Now Learning - but wouldn't be surprised if there was.

Hope this helps.