Import KPIs Gestiona

Administrators will be able to import multiple Control Items for all users who have access.
Instead of registering item by item, you can perform this operation once via import.

In this article, we will see:

  • Import Instruction and Template
  • Import Control Items

Import Instruction and Template

Download the Import Template:

Below is how to fill out the template to perform the import correctly:

Column Mandatory Field Description
USER Yes Username (used to log in)
KPI’S ID No KPI’S ID is Mandatory in Case the KPI already Exists
KPI’S NAME Yes KPI’s Name
METRIC No KPI’s Metric
DESCRIPTION No KPI’s Description
CLIENT No KPI’s Client
GOOD FOR Yes Fill the Blank with +, – or =
CHRONIC RED Yes Chronic Red KPI Number
PRIORITY No KPI’s Priority
DECIMAL PLACES No Number of Decimal Places
COEFFICIENT Yes KPI’s Coefficient Number
SECONDARY Yes If KPI is Secondary fill in the blank with Yes, otherwise, fill in with No
DISABLED Yes If KPI is Disabled fill in the blank with Yes, otherwise, fill with No
BENCHMARK’S NAME No Benchmark’s Name
BENCHMARK’S VALUE No Benchmark’s Value
TYPE Yes KPI’s Type
(1C, 2A, 2B, 2C)
QUOTIENT No KPI’s Quotient
NUMERATOR No KPI’s Numerator
DENOMINADOR No KPI’s Denominator
MEDIUM DENOMINATOR No KPI’s Average Denominator
CALENDAR No Calendar’s Name

When filling in the data in the spreadsheet, remove the formatting to avoid errors during the import.

IMPORTANT:

If there are any Custom Fields registered, they need to be included in the import file – they are mandatory.

TIP: Export the report and copy the header to the import file.

Import Control Items

Click on the icon indicated in the side menu as below:

 

Next:

  1. Select the Control Items file type.
  2. Click the blue box to browse for a file or drag a file onto it. (Maximum size 10MB)

You can track the upload status in real time on the screen by viewing the bars:

Your data will be imported asynchronously. You don’t need to wait for it to complete; you can access other screens and continue working while the file uploads.

At the end of the import, a notification email will be sent confirming the completion of the process.

REMINDER: 

You will receive, along with the completion email, the restoration file containing the data prior to the import. If you want to check any information or revert any value, you can consult this file.