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
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
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
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