bVisual

Shape Design

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

Published on by

Adding Configure Callout functionality to Visio Callouts

Visio is always improving but sometimes some functionality is hard to find, and gets forgotten about. For example, the Custom callout 1,2 and 3 masters on the Visio Extras \ Callouts stencil have been there for a few years, yet most users do not find them or realise what they can do. They provide the ability for a connected callout shape to display the values, and optional labels, of a target shape. This can be most useful for automatic annotations because they are always up to date. However, Visio recently introduced some new Callout shapes, but this ability is not there by default. In this blog, I show you how to add this useful feature to the new Callouts.

First, let’s look at the older Custom callout shapes, which automatically open a Configure Callout dialog when connected to another shape. This callout invites you to display selected Shape Data rows of the target shape:

image

 

[Read more…] about Adding Configure Callout functionality to Visio Callouts

Published on by

Creating a Schema from Visio External Data record sets

Visio introduced External Data record sets in 2007, and I have made great use of them ever since. Visio 2013 has deprecated reverse engineering of databases to produce a schema, which was a function that I loved to use because it allowed me to provide clients with up to date, annotated, enhanced schema diagrams. Microsoft have, however, provided some nice database schema templates in Visio 2013 Professional, so I thought I would provide a way to use the External Data record sets to produce schema diagrams.

I have created a new custom stencil, based upon the IDEF1X Database Notation template in Visio 2013 Professional, and have added some macros to provide the guided diagramming. I say guided because page position of tables and relationships are left to you, but the macros will create table definitions from External Data record sets.

All of the three database notation templates contain an Entity and an Attribute master. In fact, they also have a Primary Key Attribute master too, but this is identical to the Attribute master, apart from a setting to say it is the primary key. This can be done from the Attribute shape anyway, so I will dispense with the Primary Key Attribute master.

image
[Read more…] about Creating a Schema from Visio External Data record sets