• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    AutoCAD Architecture

    Reply
    Active Member
    Posts: 6
    Registered: 12-12-2008

    export data from spaces and blocks

    98 Views, 4 Replies
    02-07-2012 12:46 AM

    excuse me for my english, since it is not my native language.

    I have questions about exporting data for drawings.

     

    We make use of spaces to create a list with roomnumbers, room use and the area.

    we also create plans with office furniture.

    we have blocks with attributes to extract data like workstation numbers, department, roomnumbers etc.

     

    for the info from the spaces we use export property data to create an database file.

    for the export of the attributes we use dataextraction to crete an .xls file

     

    Is there a way to combine the work so that we can export the attribute data with the export property data?

    Is there a way to link the blocks (who are within a closed pline) to the pline (space)?

     

    Can it be done with lisp or VBA?

     

    thanks in advance

    Kind regards

    Ruud Koopman

     

    Valued Mentor
    Posts: 473
    Registered: 03-13-2008

    Re: export data from spaces and blocks

    02-07-2012 05:16 AM in reply to: RKoopman

    I usually work in AutoCAD MEP but it is built on top of AutoCAD Architecture so this should work.  I believe that one way to do what you want would be to convert your blocks to mvblocks.  That would make them an AEC object.  You could then create a property set that would hold the same information that the attributes held previously.  In addition, you could add to your property set a location property definition that would allow the mvblock to "know" which room it was in.  This way, the workstation mvblock would automatically know which room it was located in.  If you moved the workstation, it would know that it had been moved and the property information would automatically update.

     

    I use this information in the MEP world to associate pipes and ducts with rooms.  The pipe and duct read the room information and get the ceiling height and bottom of deck height.  The pipe and duct are then aware if they are below the ceiling space or above the deck and are able to report this information through a label attached to them.  Same concept just a different implimentation.

     

    I am not sure if this answers your question or not but I hope the information was helpful at least. :smileyhappy:

     

     

    EDIT:  You could probably add the property set to your blocks without converting them to AEC blocks.  The disadvantage would be that the property set would apply to ALL Blocks.  If you made them a mvblock, I believe that you could create classifications and assign individual property sets to those classifications.  i.e.  A property set would only be valid for a workstation mvblock if a workstation classification was created.  I don't believe that you can create classifications for standard block references.

    Active Member
    Posts: 6
    Registered: 12-12-2008

    Re: export data from spaces and blocks

    02-08-2012 06:53 AM in reply to: RKoopman

    thanks for your answer,

    but I can't get it to work.

     

    Do you now if there is a tutorial, or can you supply me with one of the blocks?

    then i can take a look where I go wrong....

     

    thanks 

    Mentor
    David_Knight
    Posts: 249
    Registered: 04-08-2004

    Re: export data from spaces and blocks

    02-08-2012 08:38 AM in reply to: RKoopman

    Try this out...

     

    Smart Tags for Doors, Spaces..  Smart Room Tag, Door Tag, Code Tag, Room Schedule, and Door Schedule.  Been working on these for a long time.  I couldn't have done it without help from people here.  Maybe this will help you out too... Then again, maybe I misunderstood what you're looking for.

     

    Good luck.

     

    *edit*

     

    meant to include this link.

     

    http://www.jtbworld.com/aca_db.htm

     

    we bought his script/database tools to do our sychronizing.  but we've found its easier sometimes to just do it manually.

    Valued Mentor
    Posts: 454
    Registered: 04-15-2008

    Re: export data from spaces and blocks

    02-08-2012 08:43 AM in reply to: RKoopman

    http://architects-desktop.blogspot.com.au/2006/08/adt-schedule-feature-resources.html

     

    really good resourses for scheduling etc.

    I'd also say convert to aecMVB's too as they will give you extra flexibilty and more power.

    www.ausaca.blogspot.com
    Do you know all about the Roof Object? Learn it's secrets
    http://www.youtube.com/playlist?list=PLD9BF5D8FF70CD3DF&feature=view_all