Use Visio service in Sharepoint to display business data

In Sharepoint, you can use the Visio service to view the Visio diagram in a browser and deploy the functions to the system.

However, the reality is always a torment. After using this function, the relevant users subsequently suggested whether the Visio diagram can be bound to my business data to implement data changes, and the graphics will also change?

I remember that this feature was available in the 2010 era and has never been used.

Test Case

Take server monitoring in it O & M as an example to create a custom list of "servers"

Field List: title, status (drop-down options: Normal, warning, shutdown), IP address

Enter a part of the data, as shown in:

Open Visio, create a new document, and select "Basic Network Diagram" as the type"

In Visio, draw the image of each server, click the "data" tab in the top menu, and click "link data to shape", as shown in:

In the data source, select the Sharepoint list

In the website address box, enter the address of the site where the list is located, click Next, and select the list to bind

Click "finish". The data source has been added to the Visio page.

After the data is added to the page, you need to associate the data with the image and click "Auto Link"

The automatic link can be linked according to the specified link or manually

After the binding is successful, the bound data information is displayed on the image:

Next, we need to change the text information displayed on the right of the image to a direct graphic tag. Right-click the image and choose "data"> "edit data graphics"

Delete default title and ID information

Click "new project" to display the "status" field. In the "show as" drop-down box, select the desired style.

You can select the following types of display styles. In this example, select "icon set"

The icon set has different preset styles for you to choose from. After the selection is complete, configure the icon display conditions in the icon rules.

After the configuration is complete, the corresponding server status icon can be displayed in Visio based on the data:

The design in Visio is basically complete. We need to publish this document to the SharePoint document library to facilitate Web display,

Change the data and set the FTP server to "normal"

Then refresh the web interface

As shown in, the result is a little disappointing, and the figure has not changed. After troubleshooting, the reason is that the data graph displayed by the Visio service has a cache time. The default time is 5 minutes.

Solution

Go to the management center and click "manage service applications ".Program", Select the Visio graphics service, and click" manage ".

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Click "global settings"

On the settings page, change "minimum cache retention time" to 0 and save the settings.

Refresh the page and you will see that the image has shown as expected:

Additional questions

Someone may ask, what is the significance of this case? The data still needs to be manually changed, which has no practical significance. This is not the case. In this case, you can actually create a Timer Program and try to capture the server status with WMI, you can also use a simple Ping test to update the regularly extracted data to the corresponding list based on your actual needs.

This example provides only one guide, which can be used in many aspects. The data source is not just a Sharepoint list, but also an SQL Server database, you can directly call your business data for binding and display, such as displaying the charge quota of each department (a view can be created in the reimbursement system), staff seat distribution chart and idle status (the idle status can be determined by the attendance system, or manually set by the staff in the portal, or by the lync status ), device status and idle vehicles.

Existing Defects

• It is not suitable for displaying many images, such as employee seat distribution charts. If you draw 1000 employees on a Visio page, this presentation will be of little significance and may not be displayed, if this is the case, we recommend that you split multiple Visio files, you can create directories by department or by office;
• For frequently changed data, the maintenance workload is large. Taking the employee distribution chart as an example, employees need to change the Visio image and upload it again;