bVisual

SharePoint

Published on by

Using SharePoint Choice Columns with Visio Services

Back in March 2014, I wrote about mapping SharePoint Column Types to Visio Shape Data Types ( see http://blog.bvisual.net/2014/03/03/mapping-sharepoint-list-columns-to-visio-shape-data-types/ ), and I skipped over the remaining SharePoint column types that could not be directly mapped. I described Rich Text previously ( see http://blog.bvisual.net/2014/11/14/using-sharepoint-rich-text-multiple-line-columns-with-visio-services/ ), and in this article I describe some of the possibilities of using the SharePoint Choice column type.

There are three different options for Choice columns in SharePoint 2013, but only the third, Checkboxes, allows for multiple selections.

image
[Read more…] about Using SharePoint Choice Columns with Visio Services

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 Find and Highlight Visio Shapes by Shape Data values in SharePoint Content Editor

In August, I wrote about Using JavaScript to Display Visio Shape Data and Hyperlinks in SharePoint Content Editor ( see http://blog.bvisual.net/2014/08/16/using-javascript-to-display-visio-shape-data-and-hyperlinks-in-sharepoint-content-editor/ ), so now I have added the ability to select shapes by a property value. The main advantage of using JavaScript in the client is that there is no need to go back to the server to refresh the page.

In the following screenshot, I have used the standard web part connections between the BeSmart Ltd document library view and the Visio Web Access control in order to set the Drawing URL.

image

[Read more…] about Using JavaScript to Find and Highlight Visio Shapes by Shape Data values in SharePoint Content Editor

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