Visio 2002 line coloring by database value

[Roelof]

Hi,

I've made adrawing in Visio 2002 that represents System components (round
shapes with coloring) and the lines between them represent the connection
between different systems.

Now I've managed to connect my oracle database with these lines so that when
I click a line it show me the information about these connections.

What I now want to do is to change the color of the line based on a database
value, but I can only find a way to change shape fills based on database
values. It happens to be so that lines don't have fills so I'm stuck here.

Anybody got an idea to how to manage this??

 

[Al Edlund]

You might consider using layers with different colors and move the shapes
appropriately to the status that you are trying to show. You also might
investigate the color by value addin.
al

 

[Roelof]

Layers with different colors is not an option and the color by value addon
can only change the fill color by database value. Problem is lines don't have
a fill.

Maybe I can change lines in to somekind of shapes? anyone knows how to do
something like that?

 

[David Parker]

You can use the Database Wizard in v2002 to change the LineColor according
to a DB value

 

[Roelof]

Can you explain how, I can't figure it out.

You can use the Database Wizard in v2002 to change the LineColor according
to a DB value

 

[David Parker]

Firstly, you need to have a column in the table/view that returns the color.
This can be an RGB value or a number from 0 to 24 in the Visio color map
Then, Database Wizard (here are some of the relevant actions):
Link Shapes to database records
Master on the document stencil
Select a Datasource (eg Visio Database Samples)
Select database object (eg Example - Color Blocks)
Select Primary Key
....
Map LineColor to you database column