A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Visio
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old April 28th, 2010, 11:44 PM posted to microsoft.public.visio.general
ker_01
external usenet poster
 
Posts: 87
Default VBA: pulling (network) folder security data into an "orgchart"?

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
  #2  
Old April 29th, 2010, 01:08 AM posted to microsoft.public.visio.general
James W.[_2_]
external usenet poster
 
Posts: 176
Default VBA: pulling (network) folder security data into an "orgchart"?

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/vi...CH100740891033

--
James W.


"ker_01" wrote:

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

  #3  
Old April 29th, 2010, 06:54 PM posted to microsoft.public.visio.general
ker_01
external usenet poster
 
Posts: 87
Default VBA: pulling (network) folder security data into an "orgchart"

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." wrote:

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/vi...CH100740891033

--
James W.


"ker_01" wrote:

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

  #4  
Old April 29th, 2010, 11:22 PM posted to microsoft.public.visio.general
James W.[_2_]
external usenet poster
 
Posts: 176
Default VBA: pulling (network) folder security data into an "orgchart"

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
--
James W.


"ker_01" wrote:

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." wrote:

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/vi...CH100740891033

--
James W.


"ker_01" wrote:

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

  #5  
Old May 1st, 2010, 08:21 PM posted to microsoft.public.visio.general
David J Parker [MVP Visio]
external usenet poster
 
Posts: 110
Default VBA: pulling (network) folder security data into an "orgchart"

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


"ker_01" wrote in message
...
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." wrote:

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/vi...CH100740891033

--
James W.


"ker_01" wrote:

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:07 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.