Visio Drawing from database

[Steve]

Has anyone experimented with generating drawings from a database? I know how
to link objects in an existing drawing, but now want to be able to automate
the entire process. Obviously, writing the code to optimize the arrangement
of the objects on the page would be quite complex, but just populating a new
page with database-linked objects would be a good start.

Thanks in advance...

Steve

 

[AlEdlund]

It's definitely do-able. You might check out the visio sdk. There are some
things that help a lot with generics (dropmanyshapes as an example). I do a
lot of it with datacenter physical topology stuff. David Parker's book on
data visualization is an excellent source for ideas and pitfalls to avoid.
Access is a good tool to prototype with, but for larger projects you'll
probably move on to something like SQL. The same applies to VBA vs. DotNet.
al

 

[Steve]

Thanks, Al. I'll take a look at David Parker's book.

Steve