General discussion

Locked

Visio parking spaces & name database

By mlogsdon ·
I have made the circular parking lots ( 5 levels ) with Visio Pro. Looks great.
I have numbers from 1 to 476.
Now I am supposed to put names from an EXCEL database into each of the parking spaces.
The parking lot that is 5 levels is circular like a screw. So the names need to be at wierd angles also. Not all the parkings are horizontal and the font should be ( 8 ) to fit inside the parking spaces.
I got the database to put the name into the correct places - but - the names were in each spot twice on 2 differnt lines, within each space. Reapeating the name for the spot 2 times.
One on top of the other... Not sure how its in there 2 times?
I need to merge the database of SPACE/Name to the parking areas, and not have double name, and be in the correct angle. Not just horizontal all the time. I have Visio 2003 Bible and its not there that I can find. Have the Visio for Dummies and it won't even go there at all.
Ideas ? Thanks for looking, Mike, Missouri Senate

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by ronams In reply to Visio parking spaces & na ...

One reason for the text to be showing up twice is that you probably have grouped together objects. When you import from excel into your shapes, it is possible to have the data arrive into both the sub shape and the grouped shape, which would cause overlapping text. I find it best to create a master shape from multiple sub-shapes. Add all the custom properties to the grouped shape, then insert the custom properties into the subshapes one at a time. Then store the whole thing as a master. When you drag the master on to the page, you get a form asking you to fill in all the custom properties (which in your case is the text you want). Otherwise, you can create direct links from the excel file to the shapes, which is a longer conversation.

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums