Page 1 of 1

Want to visualize your VideoHub routing in an Excel table?

PostPosted: Sun Nov 19, 2017 5:55 am
by Ian Morrish
I have written a PowerScript that loads the current configuration of a VideoHub into Excel.
It creates row and column headings using the labels you have defined in your hub.
If you have Windows 10 with Office installed then it should work. See https://ianmorrish.wordpress.com/2017/11/11/document-blackmagic-videohub-with-powershell-and-excel/ for download details. 40x40 prints nicely onto 2 A4 pages, just remember to enable the grid in print options.
Image

Re: Want to visualize your VideoHub routing in an Excel tabl

PostPosted: Tue Nov 21, 2017 4:28 am
by Ian Morrish
Here is an exe version that should create the same Excel file of your video hub configuration.
Exe defaults to assuming the local PC is a server for a studio hub. Otherwise you can add an ip address on the command line to connect to a smart hub.
You only need .Net 4.6.1 runtime and Excel 2010 or better, I think (keen for someone to test for me)
https://1drv.ms/u/s!ApGpqMMpRLhikIY6oZRIXcnbIInsLQ
Remember to unblock the file after downloading.

Re: Want to visualize your VideoHub routing in an Excel tabl

PostPosted: Thu Nov 23, 2017 12:55 am
by Jack Fairley
Executable works for me on latest Win 10 with Excel 2016, thanks. Would be nice if it would prompt for router/server IP, but it's fine this way.