Importing Excel Spreadsheet into custom properties

[un1xman]

I have not seen anything that would explain how to do the following.
If anyone has worked this out I would appreciate your advice.

I have an environment I want to document in Visio diagrams. With the
systems, I want to run scripts to build comma seperated listings of
the system configurations (IP, MAC Addy, OS version, etc.) From that
listing, I want to import the data into Visio 2003 as custom
properties for each of the systems documented in the drawing.

The reason I need to do this in this manner is the large number of
systems that will be documented by the process.

Please help!!!!

 

[WapperDude]

You might want to check this link:
http://office.microsoft.com/en-us/visio/HP012310081033.aspx?pid=CH100991471033

HTH
Wapperdude

 

[AlEdlund]

The short answer 'wrapperdude' is pointing out is that you can spend a "LOT"
of time trying to make this happen with v2003, vs. using v2007 Pro which has
most of the function already in it. v2003 is not going to do it
automagically so custom code will be required.
al

 

[WapperDude]

Thanks Al, that's an important clarification.

The short answer 'wrapperdude' is pointing out is that you can spend a "LOT"
of time trying to make this happen with v2003, vs. using v2007 Pro which has
most of the function already in it. v2003 is not going to do it
automagically so custom code will be required.
al

 

[un1xman]

Thanks Al, that's an important clarification.






- Show quoted text -

So is the procedure to do this kind of thing for v2003 documented
anywhere? I am stuck using this version of Visio for now since I work
for a Government Contractor.

 

[AlEdlund]

At a macro level your challanges are : find and open an excel file, apply
the cells to existing shapes on a drawing. If you're new to this then you
really should be over here to understand visio under the covers.
http://msdn.microsoft.com/en-us/library/aa245244(office.10).aspx

You haven't mentioned anything on your development process so you might
start here
http://support.microsoft.com/kb/254591/en-us
It's a brief discussion on mapping between drawings and excel in v5, but the
process is similar to what is currently available in many of the versions.

The visio sdk has numerous examples on how to interact with shape data (in
the older versions referred to as custom properties)
http://www.microsoft.com/downloads/...bd-b0bb-46e7-936a-b8539898d44d&DisplayLang=en

The MSDN Library (under office development) also has examples of how to
integrate visio with excel (usually outputting the drawing to excel).
Reading excel files is separate unto itself.

Al
ps. this is stage one in the list of usual requests, adding data to an
existing diagram (three more to go)

Thanks Al, that's an important clarification.






- Show quoted text -

So is the procedure to do this kind of thing for v2003 documented
anywhere? I am stuck using this version of Visio for now since I work
for a Government Contractor.