I was privileged to be invited to the biennial Robins & Morton conference in Orlando recently, where I assisted in presenting TimeTable to the hundreds of attendees there. A single wall-hanger (OPS) TimeTable Visio diagram automatically drawn from #OraclePrimaveraCloud data, is a condensed version of the same data printed as a Gantt chart some six times taller, as shown in the image below (there wasn’t enough ceiling height to print all the Gantt):
Microsoft recently announced the ability to access the shapes in the document stencil whilst using Visio for Web … if you have a Visio Plan 2 license. So, I thought I would make it clear what that means for custom shape developers. There are now three licenses that provide the ability to edit Visio diagrams in the web browser.
Typically, Visio solution developers create smart custom shapes that are deployed as masters in a stencil. None of the licenses currently provide the ability to deploy custom stencils for use by Visio in the web browser, however Visio Plan 2 license holders can access custom masters in the document stencil. This increases the ability of these users to use custom Visio documents on non-Windows devices. However, Visio in M365 users cannot edit Visio documents with custom masters, and Visio Plan 1 users cannot access the local document stencil.
I wrote a post about making a clock face in Visio fifteen years ago, but a reader recently asked about displaying multiple time zones. Well, I have previously written about time zones in Visio, so I accepted the challenge to improve upon my earlier work.
When Microsoft introduced a new way of linking external data to Visio shapes in 2007, I initially bemoaned the inability to update anything but Shape Data row values, unlike the old database add-on that I had been using for 10 years. The new method, though, has many advantages over the old way, not least that it is part of the Visio code library, for any Visio desktop user except the Standard edition.
The smartness of Visio shapes is derived from the formulas in the ShapeSheet that lies behind everything. There is a developer interface into this ShapeSheet in every desktop edition, but there is none in any of the web editions, even though the formulas, for the most part, work perfectly well (see my series of posts ShapeSheet Functions A-Z ).
The newer methodology of linking Visio shapes to data can also be used to refresh Visio diagrams automatically, even if the Visio document is not opened in the desktop edition. The Visio documents merely need to be stored in OneDrive, SharePoint (or Teams). This makes it suitable for solution development without assuming that every consumer has a desktop license. Indeed, the Visio Data Visualizer utilizes these newer external data recordsets embedded within the Visio document.
For my example, I used the Visio Sample Database that has been installed with Visio since 1997 for demonstrating the old database linking technology. It is an old style Access database (mdb), and can be found in a sub-folder of the Visio installation folder. I simply used the Data \ External Data \ Custom Import command to import the Bolts – Square Head table.
[Read more…] about Update any Visio ShapeSheet cell with External DataI recently revised my chess and checkerboard Visio documents to work in Visio for the Web (Visio Plan 1), but now that Microsoft are providing a version of Visio free to M365 business users, I need to make some further adjustment to get them to work for these users who do not have a Visio Plan 1 or Plan 2 license. The problem is that Microsoft restricts the capabilities of the free version by white-listing Visio masters. So, the answer is to delete the masters … then the Visio document becomes editable in Visio for M365!
So, what is the downside?
[Read more…] about Making Custom Shapes for Visio for M365Microsoft Visio has a useful Structured Diagramming concept that consists of Containers, Callouts and Connectors. The first of these features make it possible for shapes to know what they are contained within, as a better option to grouping shapes together. Grouping can hide or break the grouped shapes smartness, so Visio provides two ways of allowing shapes to be members of one or more containers. There are a few built-in Container shapes that can be added with the Insert / Diagram Parts / Container gallery, but shape developers can also create their own. Member shapes can be positioned anywhere within the container. There is a second type of container, List, that provides the ability to have ordered member items. There is no ribbon command to add these, but there are a number of these special shapes provided in the OOTB Visio stencils. For example, dragging and dropping a List box shape from the Software and Database / Software / Controls stencil will automatically add three List box item shapes to it.
