Resize Page to Fit Contents, Set Zoom to Fit Page When the drawing is ready, the size of the page will be too large or too small – „fit to contents“ might be the solution. Additionally, I prefer the Zoom of the active Window to be set that it shows the whole drawing. ResultRead More →
24 Colors to choose from. „Cells“ contain all „Shape-Format“-Properties Details: https://docs.microsoft.com/en-us/office/client-developer/visio/cells-visio-shapesheet-reference ResultRead More →
Connect two existing Shapes The API is somehow weird, since it creates an (Shape-)Object, but it doesn’t return it. you’ll have to fetch the last object in the shapes-List ResultRead More →
Stencils and Stencil-Files Stencils are stored in „VSSX“-Files Page-Object Add a FTP-Server to the page ResultRead More →
Visualize Data from Python in Visio I needed to illustrate some data discovered by a python script in Microsoft Visio. As a starting-point i found two sources of infomation in the Internet: (1) Python => COM => MS Excel How to access a Windows COM-Application from Python: https://pbpython.com/windows-com.html MS Excel not Visio but 50% of the information needed (2) PowerShell => COM => MS Visio How to access Microsoft Visio using the COM-Interface https://www.powershellstation.com/2016/01/20/powershell-and-visio-1 PowerShell the other 50% needed. Result: „Python => COM => MS Visio“ Putting both pieces together, will allow a Python-Script to control MS Visio. (3) MS Visio „Object Model“ Without theRead More →
Go to https://docs.microsoft.com/en-us/azure/virtual-machines/acu and look for: ***Hyper-threaded and capable of running nested virtualization The following „script“ pulls the SKUs out of the table: wget -O – –no-check-certificate https://docs.microsoft.com/en-us/azure/virtual-machines/acu | egrep -B2 „\*\*\*“ | egrep „data-linktype“ | sed -E „s/^.+relative-path..([^\<]+).+$/SKU: \1/g“ C:\RH>echo „Hyper-threaded and capable of running nested virtualization“ && wget -q -O – –no-check-certificate https://docs.microsoft.com/en-us/azure/virtual-machines/acu | egrep -B2 „\*\*\*“ | egrep „data-linktype“ | sed -E „s/^.+relative-path..([^\<]+).+$/SKU: \1/g““Hyper-threaded and capable of running nested virtualization“SKU: D_v3SKU: Ds_v3SKU: Dv4SKU: Dsv4SKU: Ddv4SKU: Ddsv4SKU: E_v3SKU: Es_v3SKU: Ev4SKU: Esv4SKU: Edv4SKU: Edsv4SKU: F2s_v2 – F72s_v2SKU: M Next Step? Finding one with enough memory for an acceptable price.Read More →
The existing Windows-Comman-Script has been enhanced so it now waits until the Router-VM is up got an IP-Address assigned using DHCP. For Demonstration-Purposes an SSH-Connection will be established. The public-key of my laptop-ssh-client is part of the slipstreamed Router-Configuration. Deploy a Router-VM with hostname „CSY“. Establish an SSH-Connection to the discovered Router-IP: Have a look to the startup-config used: This is the „CMD“-Script used:Read More →
The following version adds a „-c“ option: „Connected IP-Address“-Check. the script exits, when the Router-VM is up and running and has an usable IP-Address The Script still checks all CDP-Packets received at the specified Interface: If the Sender has the correct „Hostname“ it reads the CDP-Management-IP-Address announced. This IP-Address has to be within the IP-Range of any connected IP-Network at the specified Interface. So it’ll be possible to establish a SSH-Session to the router-VM.Read More →
You got the task to generate a list of IP-Networks connected to LAN „VirtualBox Host-Only Network“. There might be more than one IP-Network. Use Scapy to crawl through all Interfaces and get the human-readable interface name [only required for windows users]. Use NetIfaces to get a list of IP-Addresses connected to this interface. Use IPAddress to calculate the IP-Network(s) directly connected. In my case, only one subnet is directly connected: 192.168.56.0/24Read More →
Using Windows: scapy reads: meaningful interface-names ip-address but no netmask netifaces reads: full Ethernet/IP/IPv6-Information but no meaningful interface-names Mixing both, provides everything needed. Netifaces only Adding Scapy to get meaningful interface namesRead More →