matthewhagwood Posted February 1, 2011 Share Posted February 1, 2011 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 Quote Link to comment Share on other sites More sharing options...
Grant Posted February 1, 2011 Share Posted February 1, 2011 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 Quote Link to comment Share on other sites More sharing options...
irneb Posted February 2, 2011 Share Posted February 2, 2011 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. Quote Link to comment Share on other sites More sharing options...
matthewhagwood Posted February 7, 2011 Author Share Posted February 7, 2011 Im not that fluent in programming language, (still learning). How would i approach creating an visual lisp that would assist in my situation? Quote Link to comment Share on other sites More sharing options...
SLW210 Posted February 7, 2011 Share Posted February 7, 2011 I will move this to Lisp section, maybe someone there can be of help. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.