Need to find some reading material on switch ports mapping

[Theproj]

I must be either searching for the wrong terms or I am overlooking keywords in results without realizing it.

I would like to understand how to "automagically"  map two points.

Example items:

Csv file:  ServerName.domain.local, NIC0, MAC,CiscoSW.domain.local,CIscoSW IP, PortID,VLAN/.xlsx/x.xxx
Server Rack object
Cisco 48 Port Switch object
Dell R730 QUAD Nic object

BasicObjective:
Dell R730 stencil object named "ServerName.domain.local"
Cisco 48 Port Switch object stencil object named CiscoSW.domain.local

Script, or other method, that reads a csv/xls/etc (from above), and creates a connector between the NIC0 on the ServerName.domain.local stencil object to the port# CiscoSW.domain.local

I don't know if I create labels with a naming convention per port or what...

Any help will be appreciated as hoping to eventually do it in powershell where I'm a little more comfortable.

Thanks for any pointers!
local

[djc664]

If the values ServerName.domain.local are unique and 1-to-1 in your list, you can use those as part of a data link. You'll want to get your source file converted to an Excel sheet, and you need Visio Professional to link data.

Here's a short, basic how-to in doing this "manually" within Visio.
https://blogs.office.com/2013/04/25/data-linked-diagrams-linking-data-from-an-external-data-source/

Here's a much more in-depth how-to in doing this automatically in Visio which requires some programming.
https://msdn.microsoft.com/en-us/library/office/ff766177.aspx