My SQL and SharePoint Saturday additional content

I am presenting my view of using Visio to Visualize data with SQL Server and SharePoint today. The slideshow is available for viewing at https://doc.co/Q43c2m but, whilst I wait for my turn to talk, I have created a smart prism shape to demonstrate many of the smartness of shapes and the data linking features of Visio. The file can be downloaded from http://1drv.ms/1FDAZgI .

image

 

Read the rest of this entry »

Visualising SharePoint and SQL Data with Visio Professional

I will be venturing to the dark side of the moon on Saturday 12th September 2015 at SQL Saturday in Cambridge, UK ( see http://www.sqlsaturday.com/411/EventHome.aspx ).

Read the rest of this entry »

SQL Saturday Business Intelligence Special in Edinburgh

We had a fantastic weekend in Edinburgh where I presented Visio as a BI solution for SQL professionals at SQL Saturday. I volunteered because, quite frankly, I do not think that Microsoft promote Visio for BI enough, even though they have put in the BI domain for Microsoft partner competencies. This was a community event, so many thanks to all of the sponsors for enabling it, the many volunteers for running around, and especially to Jen Stirrup for organising it ( see http://jenstirrup.com/2015/06/15/jens-pass-diary-sqlsaturday-edinburgh-my-heartfelt-thanks-go-to/ ).

Read the rest of this entry »

Making unused data-linked SharePoint columns in Visio invisible automatically

I described how and why I sometimes link a SharePoint document library to Visio documents in a previous article ( see https://blog.bvisual.net/2015/02/10/displaying-sharepoint-document-library-column-values-on-visio-services-diagrams/). I mentioned that I always switch off the visibility of some columns because they are rarely needed in my Visio shapes as shape data rows. In this article, I present a VBA macro that can switch them off for you, therefore ensuring consistency.

The Link Data to Shapes feature in Visio does not allow for filtering of columns or rows when SharePoint lists are used as a data source. One answer is to create a view of the list in SharePoint to restrict the rows and some columns, but other columns still get pulled through to the External Data recordsets in Visio by default:

image

Read the rest of this entry »

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 the rest of this entry »

Using SharePoint Choice Columns with Visio Services

Back in March 2014, I wrote about mapping SharePoint Column Types to Visio Shape Data Types ( see https://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 https://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 the rest of this entry »

Social learning about Visio made easy

I wrote my Visio MVP Sessions Universal app ( see https://blog.bvisual.net/2014/07/02/the-visio-2010-mvp-sessionson-windows-phone-8-1/ ) to provide access to the educational content that we did for Visio 2010. I was concerned because the links had disappeared from the Microsoft web site in favour of Visio 2013 content, but they are all together now in the social learning portal that Microsoft partners can provide now using the TidWiT portal … plus there is a lot more great content.

image

Simply click on http://bvisual.ontidwit.com/ to explore …

Enjoy!

davecra.wordpress.com/

Microsoft Office Development, and more...

PowerShell.Amsterdam

Automate, Accelerate, Accurate

johnvisiomvp

Life with Visio and other Microsoft Toys!

Title (Required)

Windows Server Essentials Tips & Tricks

Nilsandrey's Weblog

Just another WordPress.com weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Shapes, Stencils, Drawings Templates, Tutorials, Tips & Developer Info for Microsoft Visio

Hannes's Virtual Earth

Tips & Tricks around Mapping and Cloud Computing

Pluralsight blog

be smart, be clear, be visual ...