Import indicator score data from Excel or CSV

[Aaron Munoz]

How can data from Excel or CSV be used to feed a manual indicator?

https://docs.servicenow.com/bundle/madrid-performance-analytics-and-reporting/page/use/performance-a...

Maybe the page above only worked when the table pa_scores was used before Istanbul.  I'm trying to use the table pa_score_l1 for manual indicators, but the easy import template cannot be opened by Excel.

Also, trying to use an import set and transform map is not straightforward for this particular table.

[sachin_namjoshi]

The scores are all still  kept in pa_scores tables.

If you are using pa_scores_l1 and _l2,then it gets little tough to import manual indicator score.But, you can achieve it using transform script. 

You may have to do some scripting in the transform map to pick up the correct elements.

https://community.servicenow.com/community?id=community_question&sys_id=6060cfa1db98dbc01dcaf3231f96191a

Regards,

Sachin

[Adam Stout · Accepted solution]

The way I tackle this issue is by loading the scores to be imported into a temp table and then use an automated indicator to do the import.  this is a great option in some cases compared to a standard manual indicator.  In others, it is an extra step, but with the split table design, this may be the only option other than manually typing all of these in.