Duplication of Org Chart Wizard

[jyazelatusc]

I am using an ODBC connection to an Oracle database view to build different
Org charts from our personnel information using the Visio wizard.
Unfortunately, I need several different org charts from the same data (EX: 1
for our employee "name" reporting structure and another for our "functional"
reporting structure.)

I would like to be able to create a wizard and "save" it for re-use - before
moving on to another type of org chart. As it is, I am re-building the
wizard for each type of org chart needed.

If someone could tell me how to do this - it would be terrific!

 

[vandido626]

I am using an ODBC connection to an Oracle database view to build
different
Org charts from our personnel information using the Visio wizard.
Unfortunately, I need several different org charts from the same data
(EX: 1
for our employee "name" reporting structure and another for our
"functional"
reporting structure.)

I would like to be able to create a wizard and "save" it for re-use -
before
moving on to another type of org chart. As it is, I am re-building the

wizard for each type of org chart needed.

If someone could tell me how to do this - it would be terrific!

I was looking for a similar solution yesterday and couldnt find a
straight answer. So what I did was create the org charts that I would
be creating on a regular basis one time. Once I had the page breaks and
layout that I wanted I exported the org charts to excel. If you import
the export you just created you will notice that visio lays out the org
charts the way you originally created it. What I did then was create a
table that matched my visio exports (format). Once I did that I
imported the new tables I created and it kept the page breaks and org
structure I wanted.

 

[jyazelatusc]

Well, that really sounds easy! The problem is that I cannot figure out how
to export the org chart to excel! Would you mind giving me those directions
as well?

Regards!