Import from Excel into Visio

[sclivin]

I have been tasked with trying to find a way that will import data from Excel
to Visio. The data that will be coming out of Excel will be generated from a
csv file from our software app that houses all of our assets, Remedy. The
data is in a parent/child/grandchild format (similar to an org chart, highest
level (parent) at the top, then subordinates (child) then sub ordinates
(grandchild) etc.) I have tried to do this import using the import utility
on the organization drawing but it puts all the data in one block.

Right now I'm having to update this in our Remedy app as well as keep Visio
drawings up-to-date. So you can see that his is a constant battle to keep
everything current.

Please if you have any ideas/solutions, i would greatly appreciate if you
can pass along your thoughts.

 

[Al Edlund]

there is a flowchart sample that was available in the v2002 sdk that would
allow reading an excel spreadsheet as input. You might check it out.
al

 

[sclivin]

Al,

I downloaded both the v2002 sdk and the v2003 sdk. The notes say I can do
it, but I'm unable to find out how. Have you done this? If so, can you
explain how?


--
Cheers,

Jim

there is a flowchart sample that was available in the v2002 sdk that would
allow reading an excel spreadsheet as input. You might check it out.
al

 

[Al Edlund]

in the v2003 sdk, I selected the vb.net version of the flowchart sample
solution, compiled it (I use vs.net 2005), installed it, and then opened the
flowchart stencil that was in the directory with the code, it drew the
flowchart based the attached excel file. total time about 10 minutes.
al

Al,

I downloaded both the v2002 sdk and the v2003 sdk. The notes say I can do
it, but I'm unable to find out how. Have you done this? If so, can you
explain how?