Dynamic Org Chart via an access data base

M

MRFoster

Hello All,
I am able to find some very generic information re Org Charts
and dynamic updating via an access database. Would anyone out there be able
to point me in the direction of some very specific information regarding
building this?

At present I import a 700 employee org chart via excel from scratch and
publish this on our intranet fortnightly. If I am able to dynamically update
this instead of starting all the way from the beginning, my God I could not
tell you how much I would be in your debt!

Thank you in advance for your assistance on this.

Regards,
Mark
 
A

Aaron Rykhus [MSFT]

The book Visio Inside Out (for whatever version you have) would be the best
reference I can think of as far as detailing what the Organization Chart
can do. I'm not sure the Visio user interface itself can give you the level
of automation you're looking for. There's a Visio Developer reference on
the help menu in Visio and a free download for the Visio SDK on the
Microsoft website if you're interested developing something using the
object model.

There's also a way to run Visio org charts from the command line using
OrgWiz.exe that installs to the same folder the Visio executable is in
(VISIO.EXE). The arguments you can use with OrgWiz.exe are here
http://office.microsoft.com/en-us/visio/HP010384221033.aspx


Hope that helps...

Aaron Rykhus, Visio Support
Microsoft Corporation
 
N

Noppo

Mark,
I'm quite curious where you ended up on this.
i'm seeing here at work that Access and Visio are linked to do a gigantic org chart where each logical group gets is own page, but the creation of it is entirely manual. The data link is not, but the rest is. So, from a db standpoint, the Access table provides the meat for each box, but after that, it's all manual.

I'm interested in learning if you have been able to go further than what i've seen here, and if you have, i'd like to know how far you've gotten, and how you've done it. Shout back. Hopefully, you check this forum.

Regards from Japan.


Hello All,
I am able to find some very generic information re Org Charts
and dynamic updating via an access database. Would anyone out there be able
to point me in the direction of some very specific information regarding
building this?

At present I import a 700 employee org chart via excel from scratch and
publish this on our intranet fortnightly. If I am able to dynamically update
this instead of starting all the way from the beginning, my God I could not
tell you how much I would be in your debt!

Thank you in advance for your assistance on this.

Regards,
Mark
On Tuesday, May 13, 2008 7:06 PM arykhu wrote:
------=_NextPart_0001_095D94C4
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

The book Visio Inside Out (for whatever version you have) would be the best
reference I can think of as far as detailing what the Organization Chart
can do. I'm not sure the Visio user interface itself can give you the level
of automation you're looking for. There's a Visio Developer reference on
the help menu in Visio and a free download for the Visio SDK on the
Microsoft website if you're interested developing something using the
object model.

There's also a way to run Visio org charts from the command line using
OrgWiz.exe that installs to the same folder the Visio executable is in
(VISIO.EXE). The arguments you can use with OrgWiz.exe are here
http://office.microsoft.com/en-us/visio/HP010384221033.aspx


Hope that helps...

Aaron Rykhus, Visio Support
Microsoft Corporation
----------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
------=_NextPart_0001_095D94C4
Content-Type: text/x-rtf
Content-Transfer-Encoding: 7bit

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 The book Visio Inside Out (for whatever version you have) would be the best reference I can think of as far as detailing what the Organization Chart can do. I'm not sure the Visio user interface itself can give you the level of automation you're looking for. There's a Visio Developer reference on the help menu in Visio and a free download for the Visio SDK on the Microsoft website if you're interested developing something using the object model.
\par
\par There's also a way to run Visio org charts from the command line using OrgWiz.exe that installs to the same folder the Visio executable is in (VISIO.EXE). The arguments you can use with OrgWiz.exe are here http://office.microsoft.com/en-us/visio/HP010384221033.aspx
\par
\par
\par Hope that helps...
\par
\par Aaron Rykhus, Visio Support
\par Microsoft Corporation
\par ----------------------------------------------
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par }
------=_NextPart_0001_095D94C4--
On Wednesday, May 14, 2008 3:41 AM MRFoste wrote:
Thank you very much Aaron.

Regards,
Mark

"Aaron Rykhus [MSFT]" wrote:
 
N

Noppo

Did my previous post take?
Hello All,
I am able to find some very generic information re Org Charts
and dynamic updating via an access database. Would anyone out there be able
to point me in the direction of some very specific information regarding
building this?

At present I import a 700 employee org chart via excel from scratch and
publish this on our intranet fortnightly. If I am able to dynamically update
this instead of starting all the way from the beginning, my God I could not
tell you how much I would be in your debt!

Thank you in advance for your assistance on this.

Regards,
Mark
On Tuesday, May 13, 2008 7:06 PM arykhu wrote:
------=_NextPart_0001_095D94C4
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

The book Visio Inside Out (for whatever version you have) would be the best
reference I can think of as far as detailing what the Organization Chart
can do. I'm not sure the Visio user interface itself can give you the level
of automation you're looking for. There's a Visio Developer reference on
the help menu in Visio and a free download for the Visio SDK on the
Microsoft website if you're interested developing something using the
object model.

There's also a way to run Visio org charts from the command line using
OrgWiz.exe that installs to the same folder the Visio executable is in
(VISIO.EXE). The arguments you can use with OrgWiz.exe are here
http://office.microsoft.com/en-us/visio/HP010384221033.aspx


Hope that helps...

Aaron Rykhus, Visio Support
Microsoft Corporation
----------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
------=_NextPart_0001_095D94C4
Content-Type: text/x-rtf
Content-Transfer-Encoding: 7bit

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 The book Visio Inside Out (for whatever version you have) would be the best reference I can think of as far as detailing what the Organization Chart can do. I'm not sure the Visio user interface itself can give you the level of automation you're looking for. There's a Visio Developer reference on the help menu in Visio and a free download for the Visio SDK on the Microsoft website if you're interested developing something using the object model.
\par
\par There's also a way to run Visio org charts from the command line using OrgWiz.exe that installs to the same folder the Visio executable is in (VISIO.EXE). The arguments you can use with OrgWiz.exe are here http://office.microsoft.com/en-us/visio/HP010384221033.aspx
\par
\par
\par Hope that helps...
\par
\par Aaron Rykhus, Visio Support
\par Microsoft Corporation
\par ----------------------------------------------
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par }
------=_NextPart_0001_095D94C4--
On Wednesday, May 14, 2008 3:41 AM MRFoste wrote:
Thank you very much Aaron.

Regards,
Mark

"Aaron Rykhus [MSFT]" wrote:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top