December 1, 2011 at 8:02 pm #5827
I’m 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 them 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 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? Conversely, is there a way to associate a room number with each polyline in AutoCad?
Additionally, 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.December 8, 2011 at 8:21 am #6979
I’m not very experienced on the CAD/Visio issue, but what I’ve found is that the import CAD functionallity converts everything to lines and arcs without importing tha metadata connected to it. That also includes Spaces that you might have created in AutoCAD. If you have a full AutoCAD version, I’ve found that using Visio for schematics and line diagram combined with AutoCAD for plan and elevation gives you the best of both worlds. If you have AutoCAD LT you’re stuck with Visio for all those. Many Autocad resellers can offer a good price on a upgrade from LT to full version. A little tip: They can often give you a better price on AutoCAD verticals (MEP, Architecual and such) than they can on a standard AutoCAD.