bVisual

Shape Data

Published on by

Visio Org Charts with Multiple Languages

I had an enquiry recently about displaying Organisation Charts with text in different languages. This set me thinking, and, if you have Visio Professional, then you can use Link Data to Shapes to add this capability to existing diagrams, but Visio Standard users can just the Org Chart Wizard.

I will use the OrgData.xls file that is provided in the <Program Files>\Microsoft Office\Office 15\Visio Content\<LCID>\ folder to demonstrate this. I have English US (1033) and Norwegian Bokmal (1044) available to me, as shown below:

In Englsih

image
[Read more…] about Visio Org Charts with Multiple Languages

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

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

Linking SQL database on Azure to Visio

Microsoft Visio has many data sources available for Link Data to Shapes, and one of those is SQL Server. Microsoft Azure is increasingly becoming a low-cost, and always available, choice for hosting all sorts of data, and applications, so I thought I would document how easy it is to setup a SQL database on Azure for use with Visio.

Creating the SQL database on Azure

First, you need register for an Azure subscription, and then create a SQL database on a server in a suitable location.

Create Azure Sql database

[Read more…] about Linking SQL database on Azure to Visio

Published on by

Union Jacked?

I am in Edinburgh, capital of Scotland, today. All talk is of the vote on Scottish independence next week … so, I thought I would make a Union Jack Visio shape that can be automatically changed, using Shape Data values, to represent the countries left in the union!

The Union Jack is comprised of the flags of England, Scotland and Ireland … sorry Wales, you are only a principality. Yes, I know that Northern Ireland is a province, but it was decided that St Patrick’s Saltire should be kept even after Eire got independence.

Note that a single country flag has an aspect ratio of 5:3, but a multi-country union flag has an aspect ratio of 2:1.

image
[Read more…] about Union Jacked?

Published on by

Using Icon Sets shapes to display Shape Data values

A reader of my blog recently asked whether it is possible to use the icons in out-of-the-box Visio as the main shape, and get it to refresh with data. I pointed out that all of the icon sets are available in a handy stencil under Visio Extras, so all that remains is to make the icon display change according to data values.

SNAGHTML2b09d2
[Read more…] about Using Icon Sets shapes to display Shape Data values