VBA: pulling (network) folder security data into an "orgchart"?

[ker_01]

I have some csv reports of groups with various permissions to network folder
trees (example: Parent folder shows permissions for GroupA and GroupB as
modify, child folder 1 has GroupA modify and GroupB Read-only, and child
folder 2 has GroupA read-only and GroupC as modify, and so on).

I'm currently looking at this data and deciding how to best parse it out to
create an org tree of parent/child folder relationships, and list the groups
(and their access) in each box.

However, I'm thinking there has to be an easier way; has anyone used visio
to directly access a network folder and recursively pull child folders and
their properties (specifically, security group properties), and pop that into
a chart, something like an org chart?

I'd love any pointers or code snippets you'd be willing to share.

Thank you,
Keith

 

[James W.]

I really don’t think you need to develop your own code. Visio has an Org
Wizard that allows users to create charts from certain data sources such as
Exchange, Excel, text files or Org Plus. However the data source has to
follow a certain structure.
Create your organization chart by using the Organization Chart Wizard
http://office.microsoft.com/en-us/visio/HA102270331033.aspx?pid=CH100740891033

 

[ker_01]

It appears my response from earlier this morning never made it through, so
here is "take 2". I'll apologize in advance if my other reply eventually
shows up.

I've used the org chart wizard, and it is a great tool. If I need to either
clean up my current data, or write an Excel VBA script to re-pull the data in
a more usable format, that will be my backup approach.

What I'm really hoping for is a way to use that same VBA code directly in
Visio, to recursively search a directory tree and pull the security info, and
use that to directly populate the org chart wizard without the interim step
of saving the data to an external file. I have two knowledge gaps:

1. As I am recursively searching each directory (folder), how do I grab the
full list of every person or group with security access, and their assigned
level of access? I'm not familiar with this part of the object model- I don't
know how to grab the security information inside my recursive procedure.

2. If I can get all the appropriate data into an array in Visio VBA, I don't
know how to trigger the org chart wizard via code and feed it my array,
instead of pointing to an external data source.

Any assistance would be greatly appreciated!
Thank you,
Keith

 

[James W.]

There are a few code samples regarding the Org Chart in the SDK for Visio
2007 however I don’t think any match your requirements.

Sorry

 

[David J Parker [MVP Visio]]

You might find this log of mine interesting : Creating an Org Chart without
the Org Chart Wizard
http://bvisual.spaces.live.com/Blog/cns!3350D61BC93733A9!1311.entry