Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Visio 2013 - How to Extract comments from all shapes on one page and place them in Excel worksheet.

Posted on 2014-03-12
6
Medium Priority
?
2,212 Views
Last Modified: 2016-09-01
I have a diagram with about 200 shapes.  I would like to extract the names of those shapes and the contents of the COMMENTS field.  I would like to place these on an Excel worksheet.

How can I do this?
0
Comment
Question by:brothertruffle880
  • 3
  • 2
6 Comments
 
LVL 31

Accepted Solution

by:
Scott Helmers earned 2000 total points
ID: 39924502
The Visio report writer will do that for you quite easily.

Select Review>Shape Reports then step through the wizard, selecting <Displayed Text> as one of the fields you want in your report. Then when you run the report, choose Excel as the output type.
0
 

Expert Comment

by:HvdH62
ID: 41549711
"Displayed text" will not show comments under Review/Shape reports in Visio 2013. Any other solution?
0
 
LVL 31

Expert Comment

by:Scott Helmers
ID: 41550340
I can think of two alternatives:

1) Because the report writer doesn't seem to have direct access to the Comments cell, you can create a Shape Data field or a User cell and then equate it to the Comments cell. After than, just include your Shape Data field or User cell in the report definition.

2) If your shape doesn't already display other text, you could Insert>Field, use a custom formula and set it equal to Comment. That will display the comment text on the shape but will also make it available in a report via the <Displayed Text> field.

Let me know if you need additional help with either technique.
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 

Expert Comment

by:HvdH62
ID: 41550580
Hi Scott,
1) Shape data field doesn't see comments. User field is not known in Visio 2013.
2) Nice idea, but 'Comments' is not in the Fields list and thus cannot be added.
Other ideas?
0
 

Expert Comment

by:Ryan M
ID: 41779836
I'm also not having any luck with this and would love suggestions.  Thanks!
0
 
LVL 31

Expert Comment

by:Scott Helmers
ID: 41779991
Suggestion #2 in my reply above does work. This image shows how to insert the Comment field so its contents displays on a shape:commentThen the text of the comment will be available as <Displayed Text> when you are defining a report.

Also, you said that User fields are not known in Visio 2013. They certainly are (they've been in every version of Visio since the beginning). However, they are not accessible via the Visio user interface. You need to learn how to edit the ShapeSheet to work with user cells. To get started with the ShapeSheet you might try part 1 of the "Becoming a Visio Power User" series I recorded for Microsoft Virtual Academy.
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

David Parker’s latest book, Microsoft Visio 2010: Business Process Diagramming and Validation, will give you the tools to turn flowcharts and other business diagrams into valuable, data-driven corporate assets. Armed with the knowledge you’ll gain f…
The ability to add structure to Visio diagrams using containers, lists and callouts is one of my favorite features in Visio 2010. In this article we’ll examine containers. We’ll explore lists (http://www.experts-exchange.com/Microsoft/Applications/M…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question