Kintana Script : Standardizing Icon Usage

Purpose

You need to be very consistent about the icons you use for workflow steps.
To make the system easy for users you should use the same icon to represent the same action.

Icons are stored in the {KINTANA_HOME}\icons directory.

Tested

With HP PPM (Project and Portfolio Management) Kintana v6.0.

Usage

Paste the script into SQL Runner

Omit the comment, spool, and linesize statements if you're using SQL RUNNER.
SQL Runner only supports select statements and you'll get a KNTA-10648 error.

If using PL-SQL change 'yyyymmdd' in the output file name to today's date.

spool c:\icon_usage_yyyymmdd.txt
set linesize 1000

select unique wa.icon_name --, wa.approval_name
from KWFL_APPROVALS wa
where wa.icon_name is not NULL
union
select unique we.icon_name --, we.execution_name
from KWFL_EXECUTIONS we
where we.icon_name is not NULL

-------------------------------------------

select wc.icon_name, wc.condition_name
from KWFL_CONDITIONS wc
where wc.icon_name is not NULL

-------------------------------------------

select ww.icon_name, ww.workflow_name
from KWFL_WORKFLOWS ww
where ww.icon_name is not NULL

spool off

Download

KintanaScripts.zip (58 Kb)