bVisual

Visio Pro for Office365

Published on by

Have multiple alternate languages in the same Visio diagram

I wrote a Visio add-in a few years ago that provides the ability to switch a multi-page Visio diagram between alternative languages. This particular client had just under a hundred pages of process flowcharts, with hyperlinks between the pages. They had to produce this Visio document in seven different languages and got extremely fed-up with trying to synchronise all the different copies whenever any changes were made, so a single Visio document which can store all of the alterative shape texts and page names was a much simpler time saving-solution. Moreover, Microsoft provide an online cognitive service which is useful for automatic speedy translations, though these can be overridden by a more knowledgeable user.

However, since this add-in was written, Microsoft have changed this translation service, and Visio has introduced 64bit version as the default. Therefore, I have updated the Multi-Language Text for Visio add-in to support both of these, and taken the opportunity to change the installation and licensing system.

[Read more…] about Have multiple alternate languages in the same Visio diagram

Published on by

Temporary Fix for Data Refresh in Visio Click-2-Run

Visio is an enormous application with literally millions of lines of code, so it is inevitable that bugs creep in for time to time, and can lay dormant .. until you really need it! Such an incident happened to me during a project for a large organisation where the latest and greatest build and versions are held up by the internal IT departments until they are sure that there is absolutely nothing hidden inside. In this project, I was given a laptop with Visio Pro for Office 365 to work with … not a problem, even though that moniker already told me that this was a seriously out of date edition, since it has been called Visio Online Plan 2 for quite a while. Anyway, I developed a solution that relies heavily on linked SharePoint lists and document libraries, using a view. The automatic name of these views are very verbose, so I consistently renamed them. Also, I had the same SharePoint Document library view linked more than once, so that I could link multiple rows to shapes, so renaming was, and is, absolutely essential. Several weeks went by, and my solution was working fine, until one day last week, my colleague told me that the Data / Refresh All was failing for him, and for other users. A review of his laptop showed that his Visio version had been updated to build 1708 from 1609 and the refresh was reverting the carefully renamed data recordsets back to the underlying SharePoint view name. My own personal laptop, not the client’s, is at build number 1808, so I will get the real fix from Microsoft soon via the normal channel updates for Click-to-Run.

DataRefreshNameError
Data Refresh Name Error
[Read more…] about Temporary Fix for Data Refresh in Visio Click-2-Run

Published on by

Create & edit Visio diagrams in browser

Visio Online is now generally available! You can read more about it here , but what does it mean? Well, if you have Visio Pro for Office 365 (like me) then you should find that it is now converted to Visio Online Plan 2, which includes Visio Online as well. Visio Online Plan 1 does not include Visio Pro for Office 365, but these users can view all Visio documents, and can also create and edit simple ones (see the FAQ for more details).
Selecting a New / Visio Drawing in my Office 365 tenant now opens a Basic Diagram in Visio Online. I can then choose to create a diagram from a different template using File / New.

I would also expect to be able to access Visio Online from the waffle menu in the top left of my Office 365 client. This takes me to the Visio Online Gallery, where I can open existing diagrams, or view Popular Diagram templates. At the moment, it only invites me to purchase or upgrade my subscription, but I assume that they will soon be starter diagrams for me to edit

I can also edit some existing simple diagrams that I have selected to view online.

The Shapes search feature looks pretty useful … perhaps it will provide access to third party shapes in the future too!

Visio Online is not as full-featured as Visio desktop editions, but it is really great to see this lightweight editor (at last). It works with the native Visio files, so no need for any conversion, but there are some limitations on file size and features that can be opened by the web version. There are some users who may only need this, but others will still want the desktop, especially Visio Pro for Office 365, because they have more demanding needs, such as Shape Data and links to data sources. It may even be enough for some Mac users out there too, who have long wished to be able to view and edit Visio diagrams without a Visio-clone or converter.
Keep it up Microsoft! Well done.

Published on by

Reverse Engineering SQL Server DBs with Visio Pro DBRE

The news is out: due to popular demand DBRE (Database Reverse Engineering) is [almost] back in Visio. It is currently out in preview, as announced in MS Power User , for Visio Pro for Office365 users at least. It is, however, only providing support for MS SQL Server and Oracle Server, although there is an ODBC Generic Driver too.
My test machine is a Surface Pro 1, which does not have SQL Server installed, so my instinct was to test DBRE with a SQL Azure database that I created for my eXplore Visio app  ( see Windows Store ).



Try as I might, I could not get the full database structure with the Microsoft SQL Server driver that I had installed by default. With a little help from Microsoft, I discovered that I needed to download the Microsoft ODBC Driver 13 for SQL Server from Microsoft ( see Download Driver). However, I still needed to set the default database for Visio to use as Microsoft SQL Server, not ODBC Generic Driver. In retrospect, it makes sense, but it did confuse me for a while.
Once I understood that, I was able to change my default database to the desired visioFeatures one, and to reverse engineer my SQL Azure database tables, views and stored procedures.

[Read more…] about Reverse Engineering SQL Server DBs with Visio Pro DBRE