Microsoft Visio 2007 IP telephony Network Diagram from Excel sheet

Started by patel77, January 21, 2011, 03:37:26 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

patel77

Hi All,

I am very new to Visio 2007. I have done basic network diagrams using drag and drop boxes with some vendor specific stencils, but I am not professional.

I have a data on excel sheet having 140 rows and many colums. The data includes the one reference point to many different network connections. Basically, I have to prepare the visio for our telecom equipment connected accross the globe. We have avaya IP PBX at every country and connected through E1/T1 with the routers on the same room. The routers are also connected to our regional hubs through E1/T1 connections.

How to draw the visio automatically from this excel sheet? So that it will pick up the right Avaya ICON, Cisco Router and connect to the rigional hub with TXT attached to that line as E1/T1 as well as the locations TXT on each icon i.e. London, Florida, Paris........etc

Please guide me.

Thanks and Regards,
Patel77

aledlund

There is not automated facility to create the drawing you wish to have based on internal Visio functions. Your choices are to create it manually and then use datalinking (assumes you have v2007 Pro) to associate records with shapes, or write an application.

http://office.microsoft.com/en-us/visio-help/demo-show-it-like-it-is-connect-data-to-your-visio-diagram-HA010051819.aspx?CTT=1

al

patel77

Hi,

Thank you very much for your reply. I have visio 2007 Professional installed with me. I am agree with you that there is no automation except application. I have heard about some scripts/application can help to make it automated and I would like to know about it if anyone have any sample on it.

Thanks and regards,
Patel77

aledlund

For 140 rows it is probably faster (and less expensive) to do it manually than attempt an automated solution. Once your drawing is created then you can link your spreadsheet(s) to the appropriate shapes (site and link data).

Maps
http://www.visguy.com/category/visio-content/shapes/maps-geography/

Avaya
http://support.avaya.com/css/appmanager/public/support?_nfpb=true&_pageLabel=WNContent_Public&contentid=C20097681410857094

cisco
http://www.cisco.com/en/US/products/hw/prod_cat_visios.html

This has some pointers to sample vb.net projects on automating diagram creation topics.
http://visguy.com/vgforum/index.php?topic=836.0

al