Results 1 to 3 of 3

Thread: Create Blocks with attributes from attached .mdb file

  1. #1
    Member
    Join Date
    2013-05
    Posts
    2
    Login to Give a bone
    0

    Default Create Blocks with attributes from attached .mdb file

    I hope I can explain this correctly. I have an access database attached to a blank drawing. The database is a list of existing oil wells. I want to have civil3d (or map) create a custom block (I already have the blocks created) inserted at a coordinate in the database and propagate the other fields in the database into attributes in the blocks. For instance, the first two fields in the database are the x and y. Some of the other fields in the database are the well status and company name. Is it possible for Map to read the first two fields to know where to put the block, then select the block to insert based on wells status and company name, and then complete attributes from the other fields (section, township, range, county, etc) into the block? I'm having a hard time getting my head wrapped around the map3d user's guide talking about topologies, link templates, object classifications, etc. Using Civil3D 2013 infrastructure design suite, Win 7 64-bit, office 64-bit.

  2. #2
    Geospatial Moderator Jmurphy's Avatar
    Join Date
    2000-11
    Location
    TN/KY Area
    Posts
    1,640
    Login to Give a bone
    0

    Default Re: Create Blocks with attributes from attached .mdb file

    First Welcome to AUGI.
    Second there's no easy button to do what you want. One way is use map import and select ASCII piont text file as the type, after you opened the MDB and saved to a txt file of course.
    This will create point blocks using the x,y,z data and a point number and short desc from the file. Then you would need to link those back to the mdb to get the rest of the info.

    OR
    If you know list you can write a short lsp to read the txt file and import the blocks and write the attributes from the file. You might find a lsp out there already that may be edited to work for your data.
    Then again you might find something from DotSoft
    or a google search.

  3. #3
    Member
    Join Date
    2013-05
    Posts
    2
    Login to Give a bone
    0

    Default Re: Create Blocks with attributes from attached .mdb file

    Thanks for the welcome Murph! I'm going to explore some more and see what I can do.

    Thanks

Similar Threads

  1. Create Balloon that's not attached to geometry?
    By gerrard.hickson in forum Inventor - General
    Replies: 3
    Last Post: 2010-10-06, 03:18 AM
  2. template file for blocks attributes extraction
    By grobnik in forum AutoCAD General
    Replies: 0
    Last Post: 2010-06-04, 08:52 AM
  3. What software was used to create attached image?
    By seanmc in forum DV - The 3rd Dimension
    Replies: 5
    Last Post: 2007-05-21, 03:23 AM
  4. Replies: 2
    Last Post: 2007-05-15, 10:53 PM
  5. Replies: 2
    Last Post: 2006-08-17, 02:46 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
  •