Hey, Scripting Guy! Can I Use WMI and Windows PowerShell to Make a Microsoft Visio Drawing?

re: Hey, Scripting Guy! Can I Use WMI and Windows PowerShell to Make a Microsoft Visio Drawing?

aaspnas — Wed, 10 Apr 2013 09:21:55 GMT

Very useful indeed.

For holding shape data i use an Excel file where a row contains the data for each shape, first row holding column headings. In Visio you can then add the shape data as a recordset:

$pathToShapeData = "C:\Data\ShapeData.xlsx"

$connection = "Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=$pathToShapeData;Mode=Read;" + 'Extended Properties="HDR=YES;IMEX=1;MaxScanRows=0;Excel 12.0;";' + "Jet OLEDB:Engine Type=34;" ### Note, one long line...

$command = "SELECT * FROM [Sheet1$]"

$recordSet = $document.DataRecordsets.Add($connection, $command, 0, "ShapeData")

Once you have your recordset you can link your shapes to the data:

$shape.LinkToData($recordSet.ID , $recordsetRowID, $false)

where $recordsetRowID corresponds to the c0 property value of the record.

If the data changes in excel you can just refresh the data and have the shape properties reflect the updated value:

$recordSet.Refresh() ### or do the refresh manually in Visio...

For further reference see msdn.microsoft.com/.../ff767582%28v=office.14%29.aspx and

msdn.microsoft.com/.../ff766962%28v=office.14%29.aspx

re: Hey, Scripting Guy! Can I Use WMI and Windows PowerShell to Make a Microsoft Visio Drawing?

CarlosValdes — Tue, 05 Feb 2013 14:19:14 GMT

Great tutorial!!!

I would like to add some values to the shape data, for example on the pc stencil there are some values like (Serial number, room, building, etc...).

Can I add some values programatically to this stencil?? How can i do it?

re: Hey, Scripting Guy! Can I Use WMI and Windows PowerShell to Make a Microsoft Visio Drawing?

MikeShepard — Wed, 13 Jan 2010 16:29:29 GMT

I think there is a typo in the sript.

This:

$shape6.Text = "$(($networkinfo.IPAddress)[0])"

Should have been this:

$shape6.Text = "$($networkinfo[0].IPAddress)"

That is, get the IP address of the first entry in the results from get-networkadapterconfiguration