Jump to content
matthewhagwood

Linking attributes to excel to autopopulate

Recommended Posts

matthewhagwood

I have read many posts about linking attributes with excel files but have yet been able to receive any help with what i'm trying to do, so any input would be greatly appreciated. I'm an engineer that works for a company that designs offshore drilling platforms. Currently i am generating panel termination sheets (image attached) and i have to generate one for every junction box but i have several to do (several 100). What i want to do is link my excel junction box schedule (image attached) and set up my attributes in such a way that i input the originating or terminating device and the rest of the attributes auto populate based on my excel sheet. For example (view attached image as reference), i want to input "s-t4630", then i want my cable size (3x2.5mm2), and my cable id (t46-el-2005-01) to generate.

REFERENCE IMAGES.zip

Share this post


Link to post
Share on other sites
Grant

I think the only way to do that will be to use Visual Lisp as you can call a spreadsheet and read the lines you need to populate your attribute files. Probably too complex for fields.

 

Maybe this post needs to be moved to the Lisp section

Share this post


Link to post
Share on other sites
irneb

Could you attach a sample DWG & XLS? I'm thinking you might be able to use the Express tools AttIn command if you rearrange the columns in Excel, then copy onto the TXT file generated with AttOut, then run the AttIn to import the text file into the attributes.

 

But if it's more complex than that Grant's idea is probably your best solution.

Share this post


Link to post
Share on other sites
matthewhagwood

Im not that fluent in programming language, (still learning). How would i approach creating an visual lisp that would assist in my situation?

Share this post


Link to post
Share on other sites
SLW210

I will move this to Lisp section, maybe someone there can be of help.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...