Metric dashboard – mass import

TeamGuru gives you an option to mass upload your data from your internal system. The data need to be saved in a standard CSV format.

Two file formats are supported:

A. Single metric in one row - Example: uploading various metrics for Org. unit TGCB, November and December 2024

B. Multiple metrics in one row
Supported date formats:
Daily values: D.M.YYYY or YYYY-M-D (e.g. 1.3.2024 for March 1st, 2024)
Weekly values: W.YYYY or W/YYYY (e.g. 1.2024 for Week 1 in 2024)
Monthly values: M.YYYY or M/YYYY (e.g. 1.2024 for January 2024)

1. Save file in .csv format (In Microsoft Excel go to Save-as and select .csv (semicolon separated values) format instead of .xls

2. Go to the Metric Dashboards and select Mass import in the submenu

3. Create a Mapping Template, which assures that the Metrics and Org. units names in the source file are assigned to the correct Metrics and Org. units in TeamGuru

4. Create a File Template for the TeamGuru to decode what values are stored in which columns of the source file.

Select a single metric format, in case your file is organized as shown in the example A above
Select a multiple metric format, in case your file is organized as shown in the example B above

Specify what data are in each column of your spreadsheet:

Example A:

Example B:

MULTIPLE IN 1 ROW

5. Upload the data from your source file - select the template, open the source .csv file and click on Import