Help! Org Chart hyperlinks publish incorrectly!

[KR]

I've used an Excel 2003 file to create a Visio2003 Org Chart using the Org
Chart wizard. I then published the chart using [File/Save as Web Page]. I
used the option in the wizard to hyperlink across pages, and to manually
define how much shows on each page. On each page, I show one level of
reporting relationships (and do so for each level of the organization), so
that each link will only show one level down.

Then when I look at the various pages in the html output and start clicking,
I end up getting the wrong pages linked. For example, on one page I have
------------------------------------------------
Main Manager

Sub-Mgr1 Sub-Mgr 2 Sub-Mgr 3
------------------------------------------------
And when I click on the SubMgr1 box, What pops up is the page for SubMgr 2
(and SubMgr2's direct reports). The data is correct, it just wasn't the box
I clicked on. This is true for a lot of the links, on multiple pages.

Any idea what I'm doing wrong? Is this a bug? Any help would be greatly
appreciated!!!

Thanks,
Keith

 

[Mike Mueller [MSFT]]

I just tried this with the sample data provided with Visio 2003 and all the
links are correct. Is there something unusual about your data?

 

[KR]

Not that I know of source table info at the bottom of this post.

I have a total of about 250 people in the chart, and just used the wizard
straight through.

Tools/Add-Ons/Org Chart/Org Chart Wizard; file or database; text/excel file;
select the file
Pulled in the EmployeeID and ManagerID fields (ManagerID is the EmployeeID
of that Manager)
Didn't know what it was for, so in the optional first name field I put in
"Last,First Name" field from the file
For what is displayed, I put in "Last,First Name" and "Department Name"
fields. No custom fields/properties
Selected "I want to specify how much is shown" and hyperlink across pages
and synchronize across pages

For each person who has direct reports, I select that person as the person
to be at the top of a new page, showing 1 level of direct reports. I have a
total of 60 people with direct reports, so that is 60 pages. I started
adding from the top of the org chart, then the next level down, then went
back and did all the 3rd-level managers. I also added in some 4th level
managers, but was not systematic about the order in which I added them
because I thought the hyperlinks would link based on the information in the
excel table, rather than the order in which I added them in the wizard.

Then I clicked Finish. I did go back through a few pages where the chart was
too wide for the page (more than 5 direct reports) and selected the person
at the top of the page and changed the format for that page to Horizontal
Layout/Stagger using the toolbar. I also changed the box sizes by selecting
all, then going under Org Chart/Options/Options/Shape Display Width&Height
and setting them to 40mm and 20mm respectively. This seems to affect all
boxes on all pages, which was nice because I thought I'd have to do it for
every page.

Lastly, I did File/Save as Web Page, and got this file I'm working in now.

My raw data file has (in general format), about 250 rows with the following
columns:
LastName,FirstName (text)
EmployeeID (number stored as text, unique key)
(several unused columns, all text)
Department Name (text)
ManagerID (number stored as text)

I have no idea why so many of my links are broken- I can click on a name and
get someone from the same "level" in the organization who reports to someone
completely different, then when I click on their name (top name on that
page) to get back up a level, I end up in that new person's tree (one level
up showing the direct report who was just clicked) rather than ending up
back in the part of the tree where I started. Very weird.

Any suggestions greatly appreciated,
Keith

I just tried this with the sample data provided with Visio 2003 and all the
links are correct. Is there something unusual about your data?

--
Mike Mueller
WinFX SDK Team

This posting is provided "AS IS" with no warranties, and confers no rights.

I've used an Excel 2003 file to create a Visio2003 Org Chart using the Org
Chart wizard. I then published the chart using [File/Save as Web Page]. I
used the option in the wizard to hyperlink across pages, and to manually
define how much shows on each page. On each page, I show one level of
reporting relationships (and do so for each level of the organization), so
that each link will only show one level down.

Then when I look at the various pages in the html output and start
clicking,
I end up getting the wrong pages linked. For example, on one page I have
------------------------------------------------
Main Manager

Sub-Mgr1 Sub-Mgr 2 Sub-Mgr 3
------------------------------------------------
And when I click on the SubMgr1 box, What pops up is the page for SubMgr 2
(and SubMgr2's direct reports). The data is correct, it just wasn't the
box
I clicked on. This is true for a lot of the links, on multiple pages.

Any idea what I'm doing wrong? Is this a bug? Any help would be greatly
appreciated!!!

Thanks,
Keith

--
The enclosed questions or comments are entirely mine and don't represent
the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.

 

[Mike Mueller [MSFT]]

One other question:

Are the hyperlinks broken in the Visio document also or only in the Web
page?

--
Mike Mueller
WinFX SDK Team

This posting is provided "AS IS" with no warranties, and confers no rights.

Not that I know of source table info at the bottom of this post.

I have a total of about 250 people in the chart, and just used the wizard
straight through.

Tools/Add-Ons/Org Chart/Org Chart Wizard; file or database; text/excel
file;
select the file
Pulled in the EmployeeID and ManagerID fields (ManagerID is the EmployeeID
of that Manager)
Didn't know what it was for, so in the optional first name field I put in
"Last,First Name" field from the file
For what is displayed, I put in "Last,First Name" and "Department Name"
fields. No custom fields/properties
Selected "I want to specify how much is shown" and hyperlink across pages
and synchronize across pages

For each person who has direct reports, I select that person as the person
to be at the top of a new page, showing 1 level of direct reports. I have
a
total of 60 people with direct reports, so that is 60 pages. I started
adding from the top of the org chart, then the next level down, then went
back and did all the 3rd-level managers. I also added in some 4th level
managers, but was not systematic about the order in which I added them
because I thought the hyperlinks would link based on the information in
the
excel table, rather than the order in which I added them in the wizard.

Then I clicked Finish. I did go back through a few pages where the chart
was
too wide for the page (more than 5 direct reports) and selected the person
at the top of the page and changed the format for that page to Horizontal
Layout/Stagger using the toolbar. I also changed the box sizes by
selecting
all, then going under Org Chart/Options/Options/Shape Display Width&Height
and setting them to 40mm and 20mm respectively. This seems to affect all
boxes on all pages, which was nice because I thought I'd have to do it for
every page.

Lastly, I did File/Save as Web Page, and got this file I'm working in now.

My raw data file has (in general format), about 250 rows with the
following
columns:
LastName,FirstName (text)
EmployeeID (number stored as text, unique key)
(several unused columns, all text)
Department Name (text)
ManagerID (number stored as text)

I have no idea why so many of my links are broken- I can click on a name
and
get someone from the same "level" in the organization who reports to
someone
completely different, then when I click on their name (top name on that
page) to get back up a level, I end up in that new person's tree (one
level
up showing the direct report who was just clicked) rather than ending up
back in the part of the tree where I started. Very weird.

Any suggestions greatly appreciated,
Keith

I just tried this with the sample data provided with Visio 2003 and all the
links are correct. Is there something unusual about your data?

--
Mike Mueller
WinFX SDK Team

This posting is provided "AS IS" with no warranties, and confers no rights.

I've used an Excel 2003 file to create a Visio2003 Org Chart using the Org
Chart wizard. I then published the chart using [File/Save as Web Page]. I
used the option in the wizard to hyperlink across pages, and to
manually
define how much shows on each page. On each page, I show one level of
reporting relationships (and do so for each level of the organization), so
that each link will only show one level down.

Then when I look at the various pages in the html output and start
clicking,
I end up getting the wrong pages linked. For example, on one page I
have
------------------------------------------------
Main Manager

Sub-Mgr1 Sub-Mgr 2 Sub-Mgr 3
------------------------------------------------
And when I click on the SubMgr1 box, What pops up is the page for
SubMgr 2
(and SubMgr2's direct reports). The data is correct, it just wasn't the
box
I clicked on. This is true for a lot of the links, on multiple pages.

Any idea what I'm doing wrong? Is this a bug? Any help would be greatly
appreciated!!!

Thanks,
Keith

--
The enclosed questions or comments are entirely mine and don't
represent
the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.

 

[KR]

Mike- thanks for continuing to follow this thread. I've been working on this
for about the last hour (make a small change, check everything, save as web
page, check again, then start with another small change, all starting with
various copies of my old files).

I think I've figured out when the problem occurs- I'm just surprised,
probably because I don't know anything about how Visio creates and maintains
hyperlinks across multiple pages.

The error seems to occur because (in one of my earlier files) I had one or
two extra names in the wizard (people who didn't have direct reports)... so
in Visio, their page only had their box at the top of the page, with no
direct report boxes. I deleted those pages, since they didn't add value, and
that seems to be the source of the problem. Unlike Excel, which generally
seems to use relative references /and/ autocorrects when ranges are inserted
or deleted, it appears that Visio uses fixed references for hyperlinks (e.g.
"page-7.1") but doesn't update those when a page is deleted (nor does it
leave the remaining pages numbered as they were prior to the deletion).
Thus, it looks like all my subsequent pages were off by the number of pages
prior to that that had been deleted- which wasn't immediately obvious
before, because I didn't add my pages in a specific order. I would have
expected that if anything, it would have left a hyperlink from the source
page that would have errored out because the destination page no longer
existed, but that all other links would have remained 'correct'.

I'm just starting the process now of re-running the wizard from scratch with
those extra names removed from the start, and my guess is that this time my
final web product will have accurate links.

Thanks for the assistance,
Keith

One other question:

Are the hyperlinks broken in the Visio document also or only in the Web
page?

--
Mike Mueller
WinFX SDK Team

This posting is provided "AS IS" with no warranties, and confers no rights.

Not that I know of source table info at the bottom of this post.

I have a total of about 250 people in the chart, and just used the wizard
straight through.

Tools/Add-Ons/Org Chart/Org Chart Wizard; file or database; text/excel
file;
select the file
Pulled in the EmployeeID and ManagerID fields (ManagerID is the EmployeeID
of that Manager)
Didn't know what it was for, so in the optional first name field I put in
"Last,First Name" field from the file
For what is displayed, I put in "Last,First Name" and "Department Name"
fields. No custom fields/properties
Selected "I want to specify how much is shown" and hyperlink across pages
and synchronize across pages

For each person who has direct reports, I select that person as the person
to be at the top of a new page, showing 1 level of direct reports. I have
a
total of 60 people with direct reports, so that is 60 pages. I started
adding from the top of the org chart, then the next level down, then went
back and did all the 3rd-level managers. I also added in some 4th level
managers, but was not systematic about the order in which I added them
because I thought the hyperlinks would link based on the information in
the
excel table, rather than the order in which I added them in the wizard.

Then I clicked Finish. I did go back through a few pages where the chart
was
too wide for the page (more than 5 direct reports) and selected the person
at the top of the page and changed the format for that page to Horizontal
Layout/Stagger using the toolbar. I also changed the box sizes by
selecting
all, then going under Org Chart/Options/Options/Shape Display Width&Height
and setting them to 40mm and 20mm respectively. This seems to affect all
boxes on all pages, which was nice because I thought I'd have to do it for
every page.

Lastly, I did File/Save as Web Page, and got this file I'm working in now.

My raw data file has (in general format), about 250 rows with the
following
columns:
LastName,FirstName (text)
EmployeeID (number stored as text, unique key)
(several unused columns, all text)
Department Name (text)
ManagerID (number stored as text)

I have no idea why so many of my links are broken- I can click on a name
and
get someone from the same "level" in the organization who reports to
someone
completely different, then when I click on their name (top name on that
page) to get back up a level, I end up in that new person's tree (one
level
up showing the direct report who was just clicked) rather than ending up
back in the part of the tree where I started. Very weird.

Any suggestions greatly appreciated,
Keith

I just tried this with the sample data provided with Visio 2003 and all the
links are correct. Is there something unusual about your data?

--
Mike Mueller
WinFX SDK Team

This posting is provided "AS IS" with no warranties, and confers no rights.
I've used an Excel 2003 file to create a Visio2003 Org Chart using

the
Org

Chart wizard. I then published the chart using [File/Save as Web

Page].
I

used the option in the wizard to hyperlink across pages, and to
manually
define how much shows on each page. On each page, I show one level of
reporting relationships (and do so for each level of the

organization),
so

that each link will only show one level down.

Then when I look at the various pages in the html output and start
clicking,
I end up getting the wrong pages linked. For example, on one page I
have
------------------------------------------------
Main Manager

Sub-Mgr1 Sub-Mgr 2 Sub-Mgr 3
------------------------------------------------
And when I click on the SubMgr1 box, What pops up is the page for
SubMgr 2
(and SubMgr2's direct reports). The data is correct, it just wasn't the
box
I clicked on. This is true for a lot of the links, on multiple pages.

Any idea what I'm doing wrong? Is this a bug? Any help would be greatly
appreciated!!!

Thanks,
Keith

--
The enclosed questions or comments are entirely mine and don't
represent
the
thoughts, views, or policy of my employer. Any errors or omissions

are
my

own.

 

[Mike Mueller [MSFT]]

Yep, you are correct. Visio does not fix up hyperlinks when you delete a
page.

It actually makes sense if you think about it. Hyperlinks are just a string
stored in the shapesheet. Visio itself makes no assumptions about the string
since it could be an internal reference or an external URL.

I suppose that the Organization Chart solution should fix up the hyperlinks
since it is what actually generates them. I would actually consider this a
bug in the Org Chart solution.

--
Mike Mueller
WinFX SDK Team

This posting is provided "AS IS" with no warranties, and confers no rights.

Mike- thanks for continuing to follow this thread. I've been working on
this
for about the last hour (make a small change, check everything, save as
web
page, check again, then start with another small change, all starting with
various copies of my old files).

I think I've figured out when the problem occurs- I'm just surprised,
probably because I don't know anything about how Visio creates and
maintains
hyperlinks across multiple pages.

The error seems to occur because (in one of my earlier files) I had one or
two extra names in the wizard (people who didn't have direct reports)...
so
in Visio, their page only had their box at the top of the page, with no
direct report boxes. I deleted those pages, since they didn't add value,
and
that seems to be the source of the problem. Unlike Excel, which generally
seems to use relative references /and/ autocorrects when ranges are
inserted
or deleted, it appears that Visio uses fixed references for hyperlinks
(e.g.
"page-7.1") but doesn't update those when a page is deleted (nor does it
leave the remaining pages numbered as they were prior to the deletion).
Thus, it looks like all my subsequent pages were off by the number of
pages
prior to that that had been deleted- which wasn't immediately obvious
before, because I didn't add my pages in a specific order. I would have
expected that if anything, it would have left a hyperlink from the source
page that would have errored out because the destination page no longer
existed, but that all other links would have remained 'correct'.

I'm just starting the process now of re-running the wizard from scratch
with
those extra names removed from the start, and my guess is that this time
my
final web product will have accurate links.

Thanks for the assistance,
Keith

One other question:

Are the hyperlinks broken in the Visio document also or only in the Web
page?

--
Mike Mueller
WinFX SDK Team

This posting is provided "AS IS" with no warranties, and confers no rights.

Not that I know of source table info at the bottom of this post.

I have a total of about 250 people in the chart, and just used the wizard
straight through.

Tools/Add-Ons/Org Chart/Org Chart Wizard; file or database; text/excel
file;
select the file
Pulled in the EmployeeID and ManagerID fields (ManagerID is the EmployeeID
of that Manager)
Didn't know what it was for, so in the optional first name field I put in
"Last,First Name" field from the file
For what is displayed, I put in "Last,First Name" and "Department Name"
fields. No custom fields/properties
Selected "I want to specify how much is shown" and hyperlink across pages
and synchronize across pages

For each person who has direct reports, I select that person as the person
to be at the top of a new page, showing 1 level of direct reports. I have
a
total of 60 people with direct reports, so that is 60 pages. I started
adding from the top of the org chart, then the next level down, then went
back and did all the 3rd-level managers. I also added in some 4th level
managers, but was not systematic about the order in which I added them
because I thought the hyperlinks would link based on the information in
the
excel table, rather than the order in which I added them in the wizard.

Then I clicked Finish. I did go back through a few pages where the
chart
was
too wide for the page (more than 5 direct reports) and selected the person
at the top of the page and changed the format for that page to Horizontal
Layout/Stagger using the toolbar. I also changed the box sizes by
selecting
all, then going under Org Chart/Options/Options/Shape Display Width&Height
and setting them to 40mm and 20mm respectively. This seems to affect
all
boxes on all pages, which was nice because I thought I'd have to do it for
every page.

Lastly, I did File/Save as Web Page, and got this file I'm working in now.

My raw data file has (in general format), about 250 rows with the
following
columns:
LastName,FirstName (text)
EmployeeID (number stored as text, unique key)
(several unused columns, all text)
Department Name (text)
ManagerID (number stored as text)

I have no idea why so many of my links are broken- I can click on a
name
and
get someone from the same "level" in the organization who reports to
someone
completely different, then when I click on their name (top name on that
page) to get back up a level, I end up in that new person's tree (one
level
up showing the direct report who was just clicked) rather than ending
up
back in the part of the tree where I started. Very weird.

Any suggestions greatly appreciated,
Keith


I just tried this with the sample data provided with Visio 2003 and
all
the
links are correct. Is there something unusual about your data?

--
Mike Mueller
WinFX SDK Team

This posting is provided "AS IS" with no warranties, and confers no
rights.
I've used an Excel 2003 file to create a Visio2003 Org Chart using the
Org
Chart wizard. I then published the chart using [File/Save as Web Page].
I
used the option in the wizard to hyperlink across pages, and to
manually
define how much shows on each page. On each page, I show one level
of
reporting relationships (and do so for each level of the organization),
so
that each link will only show one level down.

Then when I look at the various pages in the html output and start
clicking,
I end up getting the wrong pages linked. For example, on one page I
have
------------------------------------------------
Main Manager

Sub-Mgr1 Sub-Mgr 2 Sub-Mgr 3
------------------------------------------------
And when I click on the SubMgr1 box, What pops up is the page for
SubMgr
2
(and SubMgr2's direct reports). The data is correct, it just wasn't the
box
I clicked on. This is true for a lot of the links, on multiple
pages.

Any idea what I'm doing wrong? Is this a bug? Any help would be greatly
appreciated!!!

Thanks,
Keith

--
The enclosed questions or comments are entirely mine and don't
represent
the
thoughts, views, or policy of my employer. Any errors or omissions are
my
own.

 

[KR]

Or alternatively, if Visio just left the pages with their original numbering
(instead of re-numbering the when a page is deleted) that would probably
also be sufficient to avoid the issue. Or like with Excel; you have
worksheet names, but also worksheet code names- so even if Visio wanted to
rename the sheet names that are visible to the user, they could always
implement a sheet code name, and have the hyperlinks based on the sheet code
name (which never change unless you do so with VBA code or via the VBE). Ah
well, at least for now the problem is solved ;-)

Thanks again,
Keith

Yep, you are correct. Visio does not fix up hyperlinks when you delete a
page.

It actually makes sense if you think about it. Hyperlinks are just a string
stored in the shapesheet. Visio itself makes no assumptions about the string
since it could be an internal reference or an external URL.

I suppose that the Organization Chart solution should fix up the hyperlinks
since it is what actually generates them. I would actually consider this a
bug in the Org Chart solution.

--
Mike Mueller
WinFX SDK Team

This posting is provided "AS IS" with no warranties, and confers no rights.

Mike- thanks for continuing to follow this thread. I've been working on
this
for about the last hour (make a small change, check everything, save as
web
page, check again, then start with another small change, all starting with
various copies of my old files).

I think I've figured out when the problem occurs- I'm just surprised,
probably because I don't know anything about how Visio creates and
maintains
hyperlinks across multiple pages.

The error seems to occur because (in one of my earlier files) I had one or
two extra names in the wizard (people who didn't have direct reports)...
so
in Visio, their page only had their box at the top of the page, with no
direct report boxes. I deleted those pages, since they didn't add value,
and
that seems to be the source of the problem. Unlike Excel, which generally
seems to use relative references /and/ autocorrects when ranges are
inserted
or deleted, it appears that Visio uses fixed references for hyperlinks
(e.g.
"page-7.1") but doesn't update those when a page is deleted (nor does it
leave the remaining pages numbered as they were prior to the deletion).
Thus, it looks like all my subsequent pages were off by the number of
pages
prior to that that had been deleted- which wasn't immediately obvious
before, because I didn't add my pages in a specific order. I would have
expected that if anything, it would have left a hyperlink from the source
page that would have errored out because the destination page no longer
existed, but that all other links would have remained 'correct'.

I'm just starting the process now of re-running the wizard from scratch
with
those extra names removed from the start, and my guess is that this time
my
final web product will have accurate links.

Thanks for the assistance,
Keith

One other question:

Are the hyperlinks broken in the Visio document also or only in the Web
page?

--
Mike Mueller
WinFX SDK Team

This posting is provided "AS IS" with no warranties, and confers no rights.
Not that I know of source table info at the bottom of this post.

I have a total of about 250 people in the chart, and just used the wizard
straight through.

Tools/Add-Ons/Org Chart/Org Chart Wizard; file or database; text/excel
file;
select the file
Pulled in the EmployeeID and ManagerID fields (ManagerID is the EmployeeID
of that Manager)
Didn't know what it was for, so in the optional first name field I

put
in

"Last,First Name" field from the file
For what is displayed, I put in "Last,First Name" and "Department Name"
fields. No custom fields/properties
Selected "I want to specify how much is shown" and hyperlink across pages
and synchronize across pages

For each person who has direct reports, I select that person as the person
to be at the top of a new page, showing 1 level of direct reports. I have
a
total of 60 people with direct reports, so that is 60 pages. I started
adding from the top of the org chart, then the next level down, then went
back and did all the 3rd-level managers. I also added in some 4th level
managers, but was not systematic about the order in which I added them
because I thought the hyperlinks would link based on the information in
the
excel table, rather than the order in which I added them in the wizard.

Then I clicked Finish. I did go back through a few pages where the
chart
was
too wide for the page (more than 5 direct reports) and selected the person
at the top of the page and changed the format for that page to Horizontal
Layout/Stagger using the toolbar. I also changed the box sizes by
selecting
all, then going under Org Chart/Options/Options/Shape Display Width&Height
and setting them to 40mm and 20mm respectively. This seems to affect
all
boxes on all pages, which was nice because I thought I'd have to do

it
for

every page.

Lastly, I did File/Save as Web Page, and got this file I'm working in now.

My raw data file has (in general format), about 250 rows with the
following
columns:
LastName,FirstName (text)
EmployeeID (number stored as text, unique key)
(several unused columns, all text)
Department Name (text)
ManagerID (number stored as text)

I have no idea why so many of my links are broken- I can click on a
name
and
get someone from the same "level" in the organization who reports to
someone
completely different, then when I click on their name (top name on that
page) to get back up a level, I end up in that new person's tree (one
level
up showing the direct report who was just clicked) rather than ending
up
back in the part of the tree where I started. Very weird.

Any suggestions greatly appreciated,
Keith


I just tried this with the sample data provided with Visio 2003 and
all
the
links are correct. Is there something unusual about your data?

--
Mike Mueller
WinFX SDK Team

This posting is provided "AS IS" with no warranties, and confers no
rights.
I've used an Excel 2003 file to create a Visio2003 Org Chart using the
Org
Chart wizard. I then published the chart using [File/Save as Web Page].
I
used the option in the wizard to hyperlink across pages, and to
manually
define how much shows on each page. On each page, I show one level
of
reporting relationships (and do so for each level of the organization),
so
that each link will only show one level down.

Then when I look at the various pages in the html output and start
clicking,
I end up getting the wrong pages linked. For example, on one page I
have
------------------------------------------------
Main Manager

Sub-Mgr1 Sub-Mgr 2 Sub-Mgr 3
------------------------------------------------
And when I click on the SubMgr1 box, What pops up is the page for
SubMgr
2
(and SubMgr2's direct reports). The data is correct, it just

wasn't
the

box
I clicked on. This is true for a lot of the links, on multiple
pages.

Any idea what I'm doing wrong? Is this a bug? Any help would be greatly
appreciated!!!

Thanks,
Keith

--
The enclosed questions or comments are entirely mine and don't
represent
the
thoughts, views, or policy of my employer. Any errors or omissions are
my
own.