Re: [Sigia-l] Microsoft excel sitemapping tool..???

From: jeff_at_jefflash.com
Date: Thu Jul 01 2004 - 12:00:41 EDT

Next message: chris: "[Sigia-l] information management, plaxo and privacy concerns"
Previous message: Parry Ruparelia: "[Sigia-l] Microsoft excel sitemapping tool..???"
Maybe in reply to: Parry Ruparelia: "[Sigia-l] Microsoft excel sitemapping tool..???"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

> Does anyone know of any automated method
> of creating a visual sitemap from a
> Microsoft Excel file?

It is possible to do it "cleanly" with Excel+Visio, but you need to tweak
your Excel data. I ran into this problem about a year ago and found a way
around it. I started with Michael Angeles' article
-->
http://www.boxesandarrows.com/archives/automating_diagrams_with_visio.php
which was a good start, but I needed to do more to get it to be
"desirable," and ended up tricking out my data a bit.

The short answer is that your content matrix in Excel needs to not only
display the page ID #, but also the parent page ID #, along with the page
title. So, in delimited format, something like

I wrote a formula to take the PageID and strip off the last digit and
period to automatically refer to the parent, rather than doing it by hand,
so that helped.

Then, I exported the data from Excel and imported it in Visio using the Org
Chart Wizard. It displayed beautifully, requiring only a few minor tweaks.

Hopefully this explanation made sense. Feel free to contact me off-list for
more details or examples of the spreadsheet. I actually started writing
this up for Boxes and Arrows as a followup to Michael's article, but got
busy and sidetracked halfway through. If enough people are really
interested, with a big of cajoling, I may think about finishing it up...

Jeff

--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .

------------
When replying, please *trim your post* as much as possible.
*Plain text, please; NO Attachments

Searchable list archive: http://www.info-arch.org/lists/sigia-l/
________________________________________
Sigia-l mailing list -- post to: Sigia-l_at_asis.org
Changes to subscription: http://mail.asis.org/mailman/listinfo/sigia-l

Next message: chris: "[Sigia-l] information management, plaxo and privacy concerns"
Previous message: Parry Ruparelia: "[Sigia-l] Microsoft excel sitemapping tool..???"
Maybe in reply to: Parry Ruparelia: "[Sigia-l] Microsoft excel sitemapping tool..???"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.6 : Thu Jul 01 2004 - 13:50:41 EDT

Return to http://www.info-arch.org/lists/sigia-l/0407/0004.html