Discussion:
Dynamic Org Chart via an access data base
(too old to reply)
MRFoster
2008-05-05 10:42:00 UTC
Permalink
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
Aaron Rykhus [MSFT]
2008-05-13 23:06:33 UTC
Permalink
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.
MRFoster
2008-05-14 07:41:01 UTC
Permalink
Thank you very much Aaron.

Regards,
Mark
Post by 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
----------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights
Noppo
2010-10-01 01:43:04 UTC
Permalink
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.
Post by 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
------=_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--
Post by MRFoster
Thank you very much Aaron.
Regards,
Mark
Submitted via EggHeadCafe - Software Developer Portal of Choice
ObjectDumper LINQ To Export Collection Via .NET Reflection
http://www.eggheadcafe.com/tutorials/aspnet/21737599-5a63-4672-a32c-a36cca282a3f/objectdumper-linq-to-export-collection-via-net-reflection.aspx
Noppo
2010-10-01 01:44:28 UTC
Permalink
Did my previous post take?
Post by 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
------=_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--
Post by MRFoster
Thank you very much Aaron.
Regards,
Mark
Post by 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.
Submitted via EggHeadCafe - Software Developer Portal of Choice
Why GUIDs are not a good idea for SQL Server Primary Keys
http://www.eggheadcafe.com/tutorials/aspnet/d662b371-ed27-481c-aee0-ebe7cf2d9fad/why-guids-are-not-a-good-idea-for-sql-server-primary-keys.aspx
Paul Herber
2010-10-01 17:15:09 UTC
Permalink
Post by Noppo
Did my previous post take?
These newsgroups are no longer in use and it is unlikely that you will get an answer here.
There are replacement forums for Visio, Microsoft's own:
http://social.technet.microsoft.com/Forums/en-US/visiogeneral/threads

http://social.answers.microsoft.com/Forums/en-US/addbuz/threads?filter=alltypes%2cmf%3aa094743e-91c5-4bb1-a29f-87fdc36790ce

or Visio MVP VisioGuy
http://www.visguy.com/vgforum/
--
Regards, Paul Herber, Sandrila Ltd.
Electronics for Visio http://www.sandrila.co.uk/visio-electronics/
Electrical for Visio http://www.sandrila.co.uk/visio-electrical/
Electronics Packages for Visio http://www.sandrila.co.uk/visio-electronics-packages/
Ewilson
2010-10-05 12:18:11 UTC
Permalink
Post by Noppo
Did my previous post take?
Post by 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
------=_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 herehttp://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--
Post by MRFoster
Thank you very much Aaron.
Regards,
Mark
Post by 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.
Submitted via EggHeadCafe - Software Developer Portal of Choice
Why GUIDs are not a good idea for SQL Server Primary Keys
http://www.eggheadcafe.com/tutorials/aspnet/d662b371-ed27-481c-aee0-e...
Hi MRFoster

You can also try visio template for organization chart available at
http://visiotoolbox.com/2010/visio-download.aspx
As told by paul also refer to visguy, visio cafe, visio technet forum
for more details.

Regards.

Continue reading on narkive:
Loading...