Create visio diagram from MS Excel data

[Greg B. EMC]

I have a list of approximately 300 business applications and all interfacing
applciations for each.

I want to import the data one time and have Visio automatically create a
diagram with one box for each application and draw an arrow to each related
application.

The data is in two columns, "primary application" and "interfaced
application". For example:

PRIMARY APP INTERFACED APP
peoplesoft data warehouse
peoplesoft HR System
peoplesoft finance system
Data warehouse peoplesoft
data warehouse sales system
data warehouse CRM system
data warehouse executive reporting system
data warehouse finance system
etc...

I have Visio 2007. Does anyone have a good way to do this?

 

[AlEdlund]

Greg,
It would require custom code since this isn't a standard function. The good
news is that it is relatively straight forward.
al

 

[Bewildered]

OK -- Am I missing something, or was Al's response really that stupid?

 

[AlEdlund]

Possibly because I intended to mean that "writing the piece of code (vba?)
isn't that complicated. The code portions of opening and reading an excel
sheet are well documented on the msdn site, the dropping of multiple common
shapes is documented in the visio sdk, as well as connecting shapes. Since
'greg' appears to work for EMC (possibly a mis-assumption on my part) would
indicate he may have IT personnel available (or even skills on his part).
Conservatively an eight hour job for a professional. Certainly less time
than attempting to draw a diagram such as he described in support of data
center move (?), and keeping it up to date.
al
ps I try not to be stupid

 

[Paul Herber]

OK -- Am I missing something,

Possibly.

 

[Barb Way]

Greg - See the response I made in the next thread. There are links that
may be helpful.

Barb Way
Product Support - Visio
Microsoft Corporation
[This posting is provided "As Is" with no warranties, and confers no
rights.]
--------------------

I have a list of approximately 300 business applications and all
interfacing
applciations for each.

I want to import the data one time and have Visio automatically create a
diagram with one box for each application and draw an arrow to each related
application.

The data is in two columns, "primary application" and "interfaced
application". For example:

PRIMARY APP INTERFACED APP
peoplesoft data warehouse
peoplesoft HR System
peoplesoft finance system
Data warehouse peoplesoft
data warehouse sales system
data warehouse CRM system
data warehouse executive reporting system
data warehouse finance system
etc...

I have Visio 2007. Does anyone have a good way to do this?