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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|