Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DWG to Visio: Importing room number for each polyline.

Status
Not open for further replies.

NormBeauchemin

Technical User
Dec 2, 2011
1
0
0
US
I've been tasked with importing an Autocad/AutocadLT 2007 dwg file into Visio 2010 to create a floor plan. I want to link each space in the Visio floor plan to an Excel spreadsheet. Each space will need to have an identifier – e.g. room number – in its properties in Visio and in its corresponding record on the spreadsheet. I’m dealing with a lot of rooms, so I’d rather not have to number each space in Visio manually.

All of the rooms on the floor plan in the dwg file are polylined and all of the polylines are on the same layer of the dwg file. This layer contains nothing but the polylines. I also have another layer that has room numbers for each polylined room. The only thing on this layer are the room numbers as mtext objects.

As far as I can tell, the mtext objects aren’t linked to their respective polylines. After I insert the dwg into a new Visio document, using Insert>CAD Drawing, I right click on the drawing and choose CAD Drawing Object>Convert. In the dialogue box that opens, I check the box for the polyline and room number layers. I then select the polyline layer and go to Plan>Assign Category and choose “space”, which converts all of the polylines to spaces.

Is there a way to associate a room number with each polyline in AutoCad? Is there any way to map the room numbers on the room number layer in the Visio file to the Space ID property of the spaces I created?

I tried creating a block in AutoCad, on the polyline layer, consisting of a single polyline and a block attribute that stored the room number as a value. When I selected the polyline layer in Visio and went to Plan>Assign Category and chose “space”, to convert all of the polylines to spaces, the block was not converted to a space. It became an object in Visio that had its room number stored as a value, but it wasn’t a space.

Can I store the room number in AutoCad as xdata associated with each polyline and somehow have Visio recognize it as a property of each space?

Is there any way to create a custom property for polylines in AutoCad that the room number can be stored in?

I’m new to this. Any help would be greatly appreciated.
 
Man you've got a lot of moving parts there! I'm not real sure what you want to spend your time on - the AutoCAD portion, the Visio portion or the Excel portion.

If I'm reading your issue correctly - forget about attaching the XData to the polylines - which you can do, just use AutoCAD to get the artwork in, and the focus on Visio/Excel portion.

Sorry if that's no help...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top