bVisual

SharePoint 2013

Published on by

Displaying SharePoint Document Library Column Values on Visio Services Diagrams

It is often useful to be able to link text or graphics to the values in the SharePoint document library that a Visio diagram is stored in. A SharePoint Document library is just a list with columns and Visio 2013 documents can be linked to the data in SharePoint lists … and it will be automatically refreshable. This means that Approval Status changes, for example, can be displayed as text or icons. This article goes through the methodology of linking data from the SharePoint document library to the Visio document.

[Read more…] about Displaying SharePoint Document Library Column Values on Visio Services Diagrams

Published on by

Viewing Visio Documents in SharePoint through Outlook

This post comes with the sub-title “Now why didn’t I did know that!”. Sometimes it is easy not to see the wood for the trees, and this is one of those occurrences. I often get asked whether you need a Visio license to view Visio documents in a SharePoint document library. Well, no, but you do need a SharePoint Enterprise Client Access Licence to use Visio Services ( see http://office.microsoft.com/en-us/sharepoint/sharepoint-licensing-overview-collaboration-software-FX103789438.aspx ).
[Read more…] about Viewing Visio Documents in SharePoint through Outlook

Published on by

Using JavaScript to Display Visio Shape Data and Hyperlinks in SharePoint Content Editor

I like embedding Visio diagrams into SharePoint web pages, but I am not too enamoured with the Shape Info panel and the popup hyperlinks menu because they clutter the diagram surface. So, I thought I would take some time to make an html document that can be included in a Content Editor web part. This html document includes JavaScript to read the hyperlinks and Shape Data of each selected shape, and, besides providing the opportunity to style the resultant table, allows you to interpret the content of the Shape Data values, and even the hyperlinks. I have shown an example where the multiple hyperlinks on the selected shape are clickable in the top list, and those interpreted from the values in Shape Data rows are clickable, and listed below the regular Shape Data rows. Of course, I could have combined the two types of hyperlinks into one list, separated from the regular Shape Data. Note that the values in the built-in Shape Info panel are not clickable. 

image

So, this means that I can do away with the Shape Info panel and the hyperlinks popup within the Visio Web Access control, and provide hyperlinks, buttons, images, media files, or whatever, in the Content Editor html document. Therefore, I untick the Show the Shape Information Pane option, and tick the Disable Hyperlink option in the web part editor.

[Read more…] about Using JavaScript to Display Visio Shape Data and Hyperlinks in SharePoint Content Editor

Published on by

Connecting Visio and Excel Web Access controls in SharePoint 2013

I have recently been working on an FM project where I have spaces and personnel shapes in Visio floor plans data linked to Excel tables. I constructed a number of related tables in an Excel workbook and wanted to demonstrate the relationships. I decided that this is best explained with a combination of a diagram and sample data , so this article describes how to connect Visio and Excel web parts together in SharePoint 2013 web pages, without code.

Preparation

First, I constructed an Excel Services workbook and a Visio Services document.

Excel Workbook Tables

The Excel workbook has a number of tables on similarly named worksheets.

image
[Read more…] about Connecting Visio and Excel Web Access controls in SharePoint 2013

Published on by

Mapping SharePoint List Columns to Visio Shape Data Types

The shape data in Visio 2013 diagrams can be linked to many external data sources, and one of the most useful is a SharePoint List. However, the Shape Data rows have a smaller number of expected data types than the column types that are available in SharePoint. This article begins an exploration of the mapping of SharePoint list column types to Visio data types.

The Type cell of a Shape Data row defines the data type, which is a number from 0 to 7, that is stored in that row.

Data TypeDescription
0String
1Fixed List
2Number
3Boolean
4Variable List
5Date or Time
6Duration
7Currency

The Format cell can modify the display of Value, or can provide the option values for the two list types.

[Read more…] about Mapping SharePoint List Columns to Visio Shape Data Types