Solution-specific Visio Discussions > Org Charting

adding photos to org charts automatically

(1/2) > >>

merlin777:
I wonder if someone can advise if this is feasible? Although I haven't used VBA I'd be willingto give it a go if it provides the solution.

I'm using Visio 2003. I have a dept of 90 staff in 4 teams reporting to some managers and supervisors. The org chart will need updating once every few weeks because of team movements and staff turnover and I don't want to rebuild it from scratch each time using the wizard which isn't very good. I want to add a photo to each box. The visible fields I want to use are name, position and extension and the photo. It will be saved as a web page for our company intranet (Visio does this really well).

Ideally I'll like to put some time into a carefully formatted org chart and just keep an excel sheet updated with the data for each position and have that update the org chart. However I know Visio can't do this with org charts.

So, what I'm wondering is, is it possible to put a table on another Visio page in the same document and use that to keep the org chart contents updated? I'm thinking that it might be better to forget the org chart-based document and construct my orgchart in a normal block diagram if I can creat a shape to display the photo and other fields. I was thinking I might identify the positions on the org chart by a position number (not displayed) and fill the chapes with the data from the table, including a file name for the relevant photo.

So, here are the questions...
1) do you think what I'm proposing is a sensible approach?
2) will it need VBA?
3) do you think there's a better way to do it?
4) will it still be suitable for the web (e.g. can I hide the extra sheet so it doesn't appear on the web)?
5) lastly, can you think of a better way?
 

Thanks in anticipation for your help
jc

merlin777:
Any thoughts on this? Just finding out how to link org chart shapes with a table on another page would help.

Yacine:

--- Quote from: merlin777 on July 04, 2010, 10:28:35 AM ---So, what I'm wondering is, is it possible to put a table on another Visio page in the same document and use that to keep the org chart contents updated? I'm thinking that it might be better to forget the org chart-based document and construct my orgchart in a normal block diagram if I can creat a shape to display the photo and other fields. I was thinking I might identify the positions on the org chart by a position number (not displayed) and fill the chapes with the data from the table, including a file name for the relevant photo.

--- End quote ---

I guess, it is this passage that kept everyone from answering.

If I understood you well, the structure is static, only the players will change.
So you can link each shape to a certain "function" field in your DB.
By updating the data, you will get the new names and other fields.

now for the pictures - I haven't worked it out but could imagine that it works - record a macro in which you insert an image.
With this code, you will iterate through all your shapes and replace the found picture by one having a link saved in your DB and corresponding to the person's ID saved in the shape.

HTH

aledlund:
I can't help think that by the time you try to get v2003 to work, the time spent would have paid for v2010 pro (which supports pictures in the orgchart shape)
al

merlin777:
I haven't come across 'function' fields. Could you give me a start on where to look?

Navigation

[0] Message Index

[#] Next page

Go to full version