Network Asset Database Integration to Visio 2002

[hiland.mike]

I am hoping to do something that seems fairly simple, but I cannot
quite figure it out.

I would like to be able to double-click on a shape and have it open a
Custom Property Sheet with ONLY fields that I have selected from my
database. I have seen how to cause the double-click to open the
Custom Property Sheet, but all I see are the fields provided by either
the shape designer (Compaq?) or defaults in Visio.

We have a Notes database that is used for asset tracking (server name,
serial number, location, etc.)
We have Visio drawings depicting servers in racks in our datacenter.
I have successfully linked Visio 2002 to our Notes database and can
see the fields and values, so the database link is working.
I have done the Edit Custom Property Sheet and Apply Custom Property
Sheet actions, but either they don't do what I think they should do or
it is not working. I may see my fields at the top of the normal
Custom Property Sheet, but those fields are not linked to the
database. They are just user-defined fields and as such, there is no
value (they are blank).

Can anyone tell me the steps that I need to follow not that my
database link is working?

Thanks in advance for any thoughts or comments.

 

[Al Edlund]

With v2002 you're going to end up writing custom code, at a minimum a simple
form with the fields that you want to display.
al
<
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Mike Hiland]

With v2002 you're going to end up writing custom code, at a minimum a simple
form with the fields that you want to display.
al









- Show quoted text -

That is what I was afraid of. Thanks for the reply!

 

[Mike Hiland]

With v2002 you're going to end up writing custom code, at a minimum a simple
form with the fields that you want to display.
al









- Show quoted text -

Is this easier in later versions? 2003? 2007? What would you
recommend?

Thanks!

 

[Al Edlund]

In v2007 they support 'datarecordsets' to ease the challange of keeping
data/drawings in-sync. The key thing here though is your desire for some
custom viewing and for that the feature they developed is data graphics. You
might want to check over on the visio insights blog to get an idea of how
powerful a tool it is. David Parker has a book on data visualization using
Visio that is a good start also.

http://blogs.msdn.com/visio/

al

 

[Mike Hiland]

In v2007 they support 'datarecordsets' to ease the challange of keeping
data/drawings in-sync. The key thing here though is your desire for some
custom viewing and for that the feature they developed is data graphics. You
might want to check over on the visio insights blog to get an idea of how
powerful a tool it is. David Parker has a book on data visualization using
Visio that is a good start also.

http://blogs.msdn.com/visio/

al








- Show quoted text -

Great - thanks!