Author Topic: Export /Print Visio shapes and connections to a list  (Read 4731 times)

0 Members and 1 Guest are viewing this topic.

yoram

  • Newbie
  • *
  • Posts: 4
Export /Print Visio shapes and connections to a list
« on: November 09, 2020, 04:40:26 PM »
Hi ,

I have a visio drawing in which i created a box shape with text inside describing the shape  and  also small boxes  for its ports with numbering for the ports  - the shape is grouped .
Simmilarly i have other shapes - each with its own text and ports .

Now the shapes are connected with connectors between ports .

The goal : to export/print  a list  that will include  from device/shape port number to device/shape port number

Kindly if you can assist with VBA code for the solution .
see example attached :

I searched for solution , but need  a simple readable solution

Thanks

yoram

« Last Edit: November 09, 2020, 04:43:00 PM by yoram »

Surrogate

  • Hero Member
  • *****
  • Posts: 1328
    • ShapeSheet™ Knowledge Base
Re: Export /Print Visio shapes and connections to a list
« Reply #1 on: November 09, 2020, 11:29:19 PM »
I did same solution about 8 years ago and share there...
In this attachment you can see drawing with some network devices. You may reconnect dynamic connectors to ports (which you can see above green rectangles).

Macro in this file created table of connections. It create new Excel file named like as "T5_auto_T5_v027.xls", and fill this table there
« Last Edit: November 09, 2020, 11:33:10 PM by Surrogate »

yoram

  • Newbie
  • *
  • Posts: 4
Re: Export /Print Visio shapes and connections to a list
« Reply #2 on: November 10, 2020, 03:43:20 AM »
Hi ,

Thanks a lot .
It was exactly what i wanted  !!!

Could you also guide me , how can i add my own shapes to the document  (i assume as Master shapes )

Yoram

Surrogate

  • Hero Member
  • *****
  • Posts: 1328
    • ShapeSheet™ Knowledge Base
Re: Export /Print Visio shapes and connections to a list
« Reply #3 on: November 10, 2020, 05:00:54 AM »
In that example i have 3 level structure:
  • On-board ports;
  • Port in SFP-module in SFP-slot of Cisco C3750G-24TS;
  • Port in SFP-module in 24-ports card in Cisco 7606.
You need create table of connections only for on-board ports ?


yoram

  • Newbie
  • *
  • Posts: 4
Re: Export /Print Visio shapes and connections to a list
« Reply #4 on: November 10, 2020, 06:01:55 AM »
Hi ,

With your permission, i would be glad to cover all options that you have as well

Thanks

Yoram

Surrogate

  • Hero Member
  • *****
  • Posts: 1328
    • ShapeSheet™ Knowledge Base
Re: Export /Print Visio shapes and connections to a list
« Reply #5 on: November 12, 2020, 03:58:13 AM »
I created these masters many years ago ! And use it short time (few months). I forget details.
I can remember only that each port must have 3 shape data properties

My code read these properties and write to Excel table.

Sorry just now i dont have enougth time for investigate this :(

yoram

  • Newbie
  • *
  • Posts: 4
Re: Export /Print Visio shapes and connections to a list
« Reply #6 on: November 14, 2020, 07:34:43 AM »
No problem .
Thanks a lot for your help
Cheers !

tepebox

  • Jr. Member
  • **
  • Posts: 11
Re: Export /Print Visio shapes and connections to a list
« Reply #7 on: August 20, 2021, 06:59:11 AM »
I did same solution about 8 years ago and share there...
In this attachment you can see drawing with some network devices. You may reconnect dynamic connectors to ports (which you can see above green rectangles).

Macro in this file created table of connections. It create new Excel file named like as "T5_auto_T5_v027.xls", and fill this table there
Unfortunately this solutions seems not to work anymore... Too bad...

Surrogate

  • Hero Member
  • *****
  • Posts: 1328
    • ShapeSheet™ Knowledge Base
Re: Export /Print Visio shapes and connections to a list
« Reply #8 on: August 20, 2021, 07:09:43 AM »
Unfortunately this solutions seems not to work anymore...
Can you describe what wrong ?
PS
I think this is a very basic request and I found some more "fancy" implementations for network diagrams etc.
Yes, this solution not universal.
« Last Edit: August 20, 2021, 07:18:10 AM by Surrogate »