Importing past Assessment Results for indicator scoring

[Steve Conover]

I am implementing Application Portfolio Management, including developing scoring profiles.   

We have a set of assessments with results that were gathered last year in spreadsheets. 

Is there an option to import the assessment results/value matching the existing assessments setup in the scoring profile?  

Also, can we set the date that the assessment was submitted so that the indicator scores generated are put in last years fiscal period.   

Hoping there is a way to do this so we can use these as a baseline, allowing comparison to the assessments that we'll do within ServiceNow for this fiscal year.

Thank you!

Steve Conover

Enterprise Architect 

Gordon Food Service

[mcastoe]

Hi Steve,

you will need to create imports to populate the Assessment Instance [asmt_assessment_instance] and then the Assessment Instance Questions [asmt_assessment_instance_question] tables from your spreadsheets.  

What i suggest is that you run a small example of your assessment (in a sub-prod instance) and then examine the results in these two table and you will see the structure which will help you build the two import sets.  First you create the Assessment Instance, then you create the Answer records.

hope this helps,

Mark

[Steve Conover]

Mark,

Thank you for the response and confirming these would be the tables.  

Is there a standard import set for them.   When I generate the sheet for asmt_assessment_instance_question, I only get a single column - "Additional Information" in the Excel template. 

Minimally is there a reference for the required minimum fields. 

[mcastoe · Accepted solution]

Hi Steve,  

I have no idea why the Import generate template is behaving that way but i was able to just add all the columns in list view except the sys_... type attributes and just export to xlsx to build a template.  You will have to use an import set and build your transform to import so it should work fine.  I attached the one I created.