Page 1 of 7 12345 ... LastLast
Results 1 to 10 of 64

Thread: Reference information from tables into blocks

  1. #1
    100 Club
    Join Date
    2006-11
    Location
    Martinsburg, WV USA
    Posts
    193
    Login to Give a bone
    0

    Default Reference information from tables into blocks

    I work in the commercial glass industry, and I am looking for someone to help make my job a bit easier.

    I have attached a file with an example of what I can do, and I will explain where I want to go from there.

    In the drawing attached, I have four window elevations drawn. Each window elevation consists of four pieces of glass, which are represented as dynamic blocks. After I have my elevations drawn, I use EATTEXT to extract the glass sizes into a table format, which I use to order the glass.

    I have to assign glass tag numbers to each piece of glass on each elevation for our field employees to use to locate where all of the glass goes when it comes bulk shipped to the jobsite in crates. So, after I create my table, I then have to start at the top of the "Glass-Tag" column and number each row 100, 101, 102, etc...

    After I have the table filled in with the glass tags, I have to go to the elevations and mark the attributes to correspond with the marks I inserted in the table.

    What I want to know is if there is a way a program can be written that after I fill out the tag numbers in the table, that I can have AutoCAD write those tags back to the corresponding attributes in the dynamic blocks.

    I know this is possible, but I have no understanding of programming or any idea of how intense of a project that would be. I have seen this same scenario used by other companies (where they wrote their own LISP, but are not so willing to share!)

    Is there anyone willing to help me out here?
    Attached Files Attached Files
    Last edited by jim.knipe426609; 2008-03-10 at 03:22 PM. Reason: changed dynamic block for clarity

  2. #2
    I could stop if I wanted to
    Join Date
    2007-08
    Posts
    201
    Login to Give a bone
    0

    Default Re: Reference information from tables into blocks

    Hi,

    It's possible to reply your request, but it's much more easy for me to do it the reverse way: first increment the attribute using the attached LISP incsuf, then extract attributes.
    Attached Files Attached Files

  3. #3
    100 Club
    Join Date
    2006-11
    Location
    Martinsburg, WV USA
    Posts
    193
    Login to Give a bone
    0

    Default Re: Reference information from tables into blocks

    I like that LISP, but its not exactly what I am looking for.

    If i have 400 pieces of glass spread out through a job that are the same size, I want to label all of those pieces of glass with the same part mark. The reason is, if there are 400 typical sized glass units, there is no reason that our field personnel should waste time looking for piece 94 of 400, when they can grab any one of the 400 pieces to install. So, I think it still needs to be a reference back from the table where the quantites are listed.

    However, i do like your program! it would be useful in other aspects of our work.

    I would love to take the time to learn some programming, but the time just isnt there right now...

  4. #4
    Certifiable AUGI Addict irneb's Avatar
    Join Date
    2015-11
    Location
    Jo'burg SA
    Posts
    4,512
    Login to Give a bone
    0

    Default Re: Reference information from tables into blocks

    Standard AutoCAD doesn't provide a way of importing. Although if you install Express Tools, you'll have Export / Import Attribute information. Unfortunately this doesn't do dynamic block properties (like the newer Data Extraction in 200, but that can be got at using fields. Also it only saves to a Tab delimited TXT file.
    The main thing about this method is there's a HANDLE column which identifies each block with a unique serial code. This so that the import function knows which block's attribute values to change.
    Knowledge is proportional to experience, but wisdom is inversely proportional to ego!
    My little bit of "wisdom": Hind-sight is useless, unless used to improve the next forethought!

  5. #5
    100 Club
    Join Date
    2006-11
    Location
    Martinsburg, WV USA
    Posts
    193
    Login to Give a bone
    0

    Default Re: Reference information from tables into blocks

    Even using that express tool, i would have to individually type each part mark in the file I export, then re-import it correct?

  6. #6
    AUGI Addict fixo's Avatar
    Join Date
    2005-05
    Location
    Pietari, Venäjä
    Posts
    1,269
    Login to Give a bone
    0

    Default Re: Reference information from tables into blocks

    James, can you change all glass tags manually
    and then upload edited drawing again
    I can imagine how it will looks like

    Attached is other lisp to draw glass sizes legend table
    if you need it

    ~'J'~
    Attached Files Attached Files
    "The whole problem with the world is that fools and fanatics are always
    so certain of themselves, and wiser people so full of doubts."
    Bertrand Russell

  7. #7
    100 Club
    Join Date
    2006-11
    Location
    Martinsburg, WV USA
    Posts
    193
    Login to Give a bone
    0

    Default Re: Reference information from tables into blocks

    Quote Originally Posted by fixo View Post
    James, can you change all glass tags manually
    and then upload edited drawing again
    I can imagine how it will looks like

    Attached is other lisp to draw glass sizes legend table
    if you need it

    ~'J'~
    Here you go. I have broken it down a bit further to help explain where I am looking to go with this.
    Attached Files Attached Files

  8. #8
    AUGI Addict fixo's Avatar
    Join Date
    2005-05
    Location
    Pietari, Venäjä
    Posts
    1,269
    Login to Give a bone
    0

    Default Re: Reference information from tables into blocks

    James, I'll try to do it tomorrow
    Now is too late

    ~'J'~
    "The whole problem with the world is that fools and fanatics are always
    so certain of themselves, and wiser people so full of doubts."
    Bertrand Russell

  9. #9
    AUGI Addict fixo's Avatar
    Join Date
    2005-05
    Location
    Pietari, Venäjä
    Posts
    1,269
    Login to Give a bone
    0

    Default Re: Reference information from tables into blocks

    Quote Originally Posted by james.126519 View Post
    Here you go. I have broken it down a bit further to help explain where I am looking to go with this.
    Not solved yet, coz I was crazy busy
    Still working with it now
    Keep watching

    ~'J'~
    "The whole problem with the world is that fools and fanatics are always
    so certain of themselves, and wiser people so full of doubts."
    Bertrand Russell

  10. #10
    Certifiable AUGI Addict irneb's Avatar
    Join Date
    2015-11
    Location
    Jo'burg SA
    Posts
    4,512
    Login to Give a bone
    0

    Default Re: Reference information from tables into blocks

    Here's what I meant by the Express tool. I've modified your block to have the width & height shown as attributes instead of the MText you had - this so it exports these values as well.

    The steps are (as per pages in attached):
    1. Export Attributes
    2. Select where to place file
    3. Select the relevant blocks (you can select by crossing over other stuff, it will only select blocks)
    4. Go to the folder in explorer, right-click, select Open With --> Ms Office Excel (or any other spreadsheet program will do)
    5. In Excel, I convert to table so it's easier to sort. Select all (Ctrl+A). And click on Format as Table (select one of the format templates)
    6. Click on the arrow next to say Height, select Sort Smallest to largest
    7. Modify the 1st Tag value for say the 16 3/4 group.
    8. Copy-n-paste for the rest of the group.
    9. Do the same for the 22, 35 and 38
    10. Save & click Yes when told you're going to lose formatting
    11. In AutoCAD, import
    12. Select the file
    13. And viola!
    So most of your work is in Excel, where it's basically much easier to do these type of changes.
    This is probably a very simple example. If you've got much more glazing panels to sort out, you may want to look at formulas to have Excel calculate this itself. You're going to use one of the VLookUp formulas or a derivative thereof.
    Attached Files Attached Files
    Knowledge is proportional to experience, but wisdom is inversely proportional to ego!
    My little bit of "wisdom": Hind-sight is useless, unless used to improve the next forethought!

Page 1 of 7 12345 ... LastLast

Similar Threads

  1. View Reference information disappearing
    By MTristram in forum Revit Architecture - General
    Replies: 0
    Last Post: 2008-10-23, 02:48 AM
  2. cross reference tables and blocks in both directions
    By james.126519 in forum API Wish List
    Replies: 0
    Last Post: 2008-02-29, 01:48 PM
  3. Reference text between tables
    By rb773 in forum AutoCAD Tables
    Replies: 1
    Last Post: 2007-11-12, 09:42 PM
  4. Excel Information Into Tables
    By CADdancer in forum AutoCAD Tables
    Replies: 4
    Last Post: 2007-08-03, 03:56 PM
  5. Blocks, Databases and Tables
    By WeirdOne in forum AutoCAD Map 3D - General
    Replies: 14
    Last Post: 2006-04-19, 06:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •