Want to visualize your VideoHub routing in an Excel table?

Got something to discuss that's not about Blackmagic products? Then check out the Off-Topic forum!
  • Author
  • Message
Offline

Ian Morrish

  • Posts: 580
  • Joined: Sun Jan 18, 2015 9:24 pm
  • Location: New Zealand

Want to visualize your VideoHub routing in an Excel table?

PostSun Nov 19, 2017 5:55 am

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
Regards,
Ian Morrish
Video Integrated Scripting Environment
(Windows PowerShell with ATEM driver + more)
https://ianmorrish.wordpress.com
Offline

Ian Morrish

  • Posts: 580
  • Joined: Sun Jan 18, 2015 9:24 pm
  • Location: New Zealand

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

PostTue Nov 21, 2017 4:28 am

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.
Regards,
Ian Morrish
Video Integrated Scripting Environment
(Windows PowerShell with ATEM driver + more)
https://ianmorrish.wordpress.com
Offline
User avatar

Jack Fairley

  • Posts: 1863
  • Joined: Mon Oct 03, 2016 7:58 pm
  • Location: Los Angeles

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

PostThu Nov 23, 2017 12:55 am

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.
Ryzen 5800X3D
32GB DDR4-3600
RTX 3090
DeckLink 4K Extreme 12G
Resolve Studio 17.4.1
Windows 11 Pro 21H2

Return to Off-Topic

Who is online

Users browsing this forum: No registered users and 15 guests