INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

DWG to Visio: Importing room number for each polyline.

DWG to Visio: Importing room number for each polyline.

(OP)
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.  

RE: DWG to Visio: Importing room number for each polyline.

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...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close