Note: Users will need the permission "Can See Training Records for Whole Company".

 

Log in to ZenQMS and click on the Training Module icon. Click on the drop down labeled My Training Dashboard and select Training: Trainee Records.

 

Using the drop-down on the left hand corner labeled Just Showing Myself, select Groups:

groups.png

Next to the desired Trainee / Role Name, click the Training Matrix hyperlink. This action will download the matrix. There is a chance that your pop-up blocker may block the download; please make sure that you allow pop-ups/downloads from the ZenQMS application. Please note that this file is a .csv file (comma-separated values) so it is unformatted data.

 

Before you can use this data in excel, you will need to important the data from the .csv file into an excel file:

matrix.png

 

Importing Data From .csv to Excel

Open a blank workbook in Excel

 

In the top toolbar, click Data

 

Select From Text/CSV:

Annotation_2020-09-08_105017.png

Select the .csv file you would like to open then click import

 

For the next pop-up, the key universal items that need to be selected are Delimiter/Delimited and Semicolon, then click Load.

 

Note: If your version is different, you may need to select Delimited, then click Next, then select Semicolon from the radio buttons, then click Load/Finish

 

 

Was this article helpful?
0 out of 4 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.