In OP5 Monitor version 7.2.6, we introduced Sharable Dashboards. We also have a how-to guide that features a Python script to clone multiple dashboards to another user.
This how-to guide goes more involved in what happens when you copy a dashboard from one user to another. We include here some extended features that also delete the target user's dashboard.
- Start with a preconfigured dashboard that will be propagated to users;
- You need to remove the existing dashboard for the user before copying the new one. This must be done after the upgrade to 7.2.6, since the database layout has changed;
- Make sure that none of the users to whom you will be propagating the dashboards are logged in;
- Have a look at the database for dashboards:
Save this information to a text file for later use.
ID-ColumnNotice the column 'id', this is very important to have to be able to delete the users dashboard from two tables: 'dashboards' and 'dashboard_widgets'.
To remove the current dashboard for the user 'readonly', execute the following:
Repeat the procedure above for all users that should have a predefined dashboard.
Download the custom script that has been developed for this process to your op5 server: https://download.op5.com/fm/20101/copy-dashboard.php
Edit the script and change the parameters below, in this example I will copy the dashboard from the user '<user>' as the source user:
Use the aforementioned list of users that was saved from the database to insert into the array below:
Once you have double-checked the target and the source users, execute the script:
Log into OP5 Monitor with one of the target users that were specified as target in the script to verify.