How do I export data from Impero?

You need to export data from Impero as a backup or to process in Excel or 3rd-party systems? Find the instructions for data export in each module.

Tip: You would need the role administrator to access the entirety of data. To export data for selected control programs or risk maps, you will need specific access rights. Read more here.

 

Control data

To export the entire set of your control master data, in other words, the complete control design with title, description, schedule, assignees and tasks:

1. Go to Dashboard. Click on "Export" on the top right

2. Choose as preferred if you want to export with single tasks in each control and the associated risks.

 

To export the entire set of your control activities meaning controls that had been sent out to responsibles:

1. Go do Dashboard. Click on "View activities".

2. Select the timeframe for due date that covers ideally the day when the environment was created until the furthest day in future when a control will be due - to have the entirety of data.

3. Tick mark all activities on the left. And click on "Export".

4. Select as preferred with or without control answers that have been submitted by the responsibles.

Note: It is also possible to go to Control Management to enter each control program to download the control master data or activities for that respective program separately.

 

To export control evidences in form of attachments that have been submitted by responsibles:

1. Go to Dashboard. Click on "View activities".

2. Open the activities for which documents have been uploaded by clicking on the control title.

3. Click on "Export" on the top right.

4. Select "Control and attached files". The attachments will be downloaded in the original format, e.g. Excel, PDF, JPEG etc. This step needs to be repeated for each control assignment.

 

Risk data

To export all registered risks and their assessment:

1. In the Navigation menu, enter "Risk Management".

2. Open each risk map by clicking on its name, such as here from 01 to 04:

3. Click on "Export" on the top right.

 

User data

1. Go to Navigation menu. Click on User Management.

2. Tick mark all users and click on "Export".

You will receive the user stats shown in Impero, however, not the sub-level information, such as in which groups the users are or in which programs one has an access right.

 

Event log

To export activities on login, user (de-)activation, changes on roles or control master data:

1. Go to Dashboard. Click on Event Log on the top right.

2. Select a timeframe that covers the day when the environment was created until today.

3. Click on to export the shown data.

 

Report data

1. Go to Navigation menu. Click on Reports.

2. Open each report under "My reports".

3. Click on to export the data of table shown. 

To export the bar chart above, you would need to make a screenshot.