Jump to content

volkansahin
 Share

Recommended Posts

I need a complicated lisp for take information to attributes and choose blocks in cad file.

So, I am working about Building Automation Systems, I am preparing "point list" and " connection diagram" for a project. My manager wants a lisp from me for choose blocks and insert data from excel point list automatic. Can anybody help me for it? I have not any idea about lisp language.(

I am searching some solutions last 2 days. if possible, a lisp will look to point list, choose module type (there are 3 type modules, so 3 blocks.) and draw modules as example and will write module no, cable no (C1-xxx), equipment name and description to attributes.

I attached point list and example blocks to here. Thanks for your helps.

diagram_example.dwg

point list.xlsx

Link to comment
Share on other sites

No code just some suggestions

 

Your dwg its all seperate lines and text for the connections make into block.

 

1 make a csv file from excel easy part

 

Read 1 line csv and make a List of that line pull out variables like C10-202, 6-8, insert a block that is the 3 parts, . Insert attribute values. c10-201 has 2-4

 

I don't do this type of work but some rule in there about 2&4 no 3 etc the symbols change automatically from excel/csv info.

 

I think its achievable but for me not my industry.

Edited by BIGAL
Link to comment
Share on other sites

Had another look you need to make parts of the dwg into blocks start with the G-U-M and the B-M the Cxx-XXX the universal module 1-33.

 

The 1-33 you can turn attributes on and off so number will disappear, or else put each number in 33 attributes probably easier. The symbols may need additional blocks.

 

If you post a sample dwg with the excel columns marked would make much easier to think about it.

 

Lastly this may border on a commercial answer.

Screen Shot 08-17-18 at 05.04 PM.PNG

Link to comment
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.   Restore formatting

  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.

 Share

×
×
  • Create New...