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

    AutoCAD Civil 3D

    Reply
    Active Member
    Posts: 10
    Registered: ‎01-18-2013

    Creating an excel table for populating point loc and label multiple files

    198 Views, 4 Replies
    01-18-2013 09:10 AM

    Info first

    Excel 2007 sp3 (32bit)

    Civil 3d 2012

     

    I have some data in the form of

     

    point#    |    X    |    Y   |    Desc_1   |   Desc_2  |   Desc_3  |....... ect

     

    I would like to make an excel table that i can create multiple points from and make that table dynamic, ie if i edit the table the points will change.

     

    I would be labeling the points according to the different desc_# in multiple drawings

     

    Is there any way to do this? I have messed with creating a user defined property classification and creating a new point file format, but i want that point file I imported to be dynamic, and if I change values the values will change in all my drawings.

     

    I attached the data I am attemting to link to.

     

    Thank you in advance

    Please use plain text.
    *Expert Elite*
    TRogers
    Posts: 630
    Registered: ‎09-05-2007

    Re: Creating an excel table for populating point loc and label multiple files

    01-18-2013 09:29 AM in reply to: palabalo

    Try the DATALINK command. 

    If the issue was resolved by this method, please click on "Accept As Solution"
    *Civil 3DJ*
    Todd Rogers

    Visit my blog here.

         
    Please use plain text.
    Active Member
    Posts: 10
    Registered: ‎01-18-2013

    Re: Creating an excel table for populating point loc and label multiple files

    01-18-2013 10:41 AM in reply to: TRogers

    Yes I can bring that table into civil 3d but how do I get my points to generate from that?

     

     

    Please use plain text.
    *Expert Elite*
    BrianHailey
    Posts: 2,392
    Registered: ‎04-27-2005

    Re: Creating an excel table for populating point loc and label multiple files

    01-20-2013 09:11 PM in reply to: palabalo

    There is no way that I'm aware of to create points in the drawing that are dynamically linked to an external file. Perhaps with some programming it could be accomplished. It shouldn't be too hard to simply reimport the points as long as the point numbers don't change. When prompted that an existing point is in the drawing, use the "merge" option.

    Please use plain text.
    *Expert Elite*
    sboon
    Posts: 1,384
    Registered: ‎11-08-2005

    Re: Creating an excel table for populating point loc and label multiple files

    01-20-2013 11:17 PM in reply to: BrianHailey

    It is possible to link an import event in a Survey database to a csv file.  You can then re-run the import event to update the database and drawing.

    Please use plain text.