Search the Community

Dear Members! Problem part I I now turn to you with the question of how to extract certain data from the "_massprop" command and assign it to a variable immediately. I am working on an automation task where a cable cross section has to be pulled out on a given 3D polilyne path. I need to extract the volume of the resulting 3D solid to calculate the volume of the displaced top. Problem part II Similarly, I should extract the length of the extracted 3D tube from the property table. This data is available if I extract the cross section with the _extrude / path command. I have to assign the extracted data to a variable within the lisp program to perform a mathematical operation on it. As follows: (setq V (volume data from the _massprop command)) (setq Vm (/ V (1000 ^ 3)); converting the mm3 to m3 Problem part III I would like to write the obtained result in a table in the model space. Column 1: "Volume of ground displaced by the pipeline" Colum 2: "The result of the calculation (which will be the value of a variable Vm)" Here is my code for calculation the cross section of the cable and to extrude it. The polyline must to be placet at '(0 0 0) All help comes in handy: (defun c:kabel(/ K_A K_AKEM K_DKE K_DKEM K_H K_L K_PT0 K_PT1 K_PT2 K_PT3 K_PT4 K_PT5 K_RKE K_RKEM K_RTOT K_SS1 K_V PIR) (setq K_Dke (getreal "Adja meg a kábel ér külső átmérőjét:")); Give me the diameter of the subcable (setq K_Akem (getreal "Adja meg a kábel ér magjának keresztmetszet területét (mm2)-ben) :")); Give me the copper cross section area (setq K_L (getreal "Adja meg a beillesztett polilyne teljes hossszát m-ben:")); Give me the length of the cable route (setq pir 3.141592654) (setq K_Dkem (sqrt (/ (* K_Akem 4) pir))); The copper diameter (setq K_Rke (/ K_Dke 2)) (setq K_Rkem (/ K_Dkem 2)) (setq K_pt0 '(0 0 0)) ; The low right cable part (you have 3 of them) (setq K_pt1 (polar K_pt0 (* pi 0.666666666666) K_Dke )); The center position of the upper cable part (setq K_pt2 (polar K_pt0 pi K_Dke)); The center of the third cable part ( part 3 of 3) (setq K_h (* K_Dke (sin (/ pi 3)))) (setq K_pt3 (polar K_pt2 0 (/ K_Dke 2))) (setq K_pt4 (polar K_pt3 (/ pi 2) (* K_h 0.333333333333)));The outer circle center point calculated from 3 cabel parts which are 120 degree from each other, like a mercedes logo (setq K_Rtot (+ K_Rke (* K_h 0.666666666666666))); Radius of the cable pipe (setq K_pt5 (polar K_pt4 (/ pi 2) K_Rtot)) (command "_circle" K_pt4 K_Rtot "") (setq K_ss1 (ssget "_L")) (command "_extrude" "_Mode" "_solid" K_ss1 "" "_path" '(0 0 -0.1) "") (setq K_A (* (* (/ K_Rtot 1000) (/ K_Rtot 1000)) pir)) (setq K_V (* K_A K_L)) (alert (strcat "The volume of the cable=" (rtos K_V) "m3")) (princ) )

Hello, I would like to get some help with the task I have in hand. let me explain my dilemma. I have a "CVS" file that is comma delimited format. the file has two pieces of information separated by comma. Example bellow: 50,WTF-00011 75,WFT-00023 100,WFT-00050 etc.... the file could have up 6000 lines. I don't do not know how to write a code separate the line using the comma as a separator. I would like to assign the values before the comma into a variable "VAR1" for later use later in the program. I would like to assign the values after the comma into a different variable "VAR2" for use later in the program. Thank you in advance for your help. Kind regards, Ricky

Hello dear community, My task is to validate coordinates of antenna changes for a mobile network; this list is supplied in Excel format an the respective points are introduced in matlab on separate layers for each antenna change, e.g. AC_1>2, AC_5>100, AC_80>34, ... On another layer are the locations of the antennae as points. I want to validate that no antenna change (AC) takes place too far away from that antenna. I have developed a process to do this, yet I still don't have figured out how to do each step. Process: For each antenna (how are for-loops done?) 1. disable (make layers non-visible) all non-relevant layers for this antenna Solution: -layer au *_* ei *45_*,*_45* 2. Connect all remaining visible points with lines (e.g. tree spanning algorithm) 3. Center to the region containing all remaining points and set a predetermined scale (allows to validate distances on paper with ruler after printing) 4. Print to a pdf A3 with same scale always However I do not know how to loop over antennas and don't know how to implement steps 2-4. I would be very thankful if you could provide me same valuable tips. My knowledge in AutoCAD is not very developed, but I have strong programming knowledge. Thank you in advance.

Dear folks, There is an idea to get things easier in my workflow but I need check if it is possible or not. There are over 100 closed polyline objects on the model and each has a unique ID written in its Hyperlink value (like X_D_YYYY) And each of these polylines has a block placed in the enclosing area with an attribute. My aim is to get the Hyperlink from enclosing polyline and populate the block attribute with that value. You may find an example as DWG at the attachment. Regards. get-Enclosing-polyline-data.dwg

I don't know if this is possible but have to ask. If I had an Excel spreadsheet sheet that had a list of part numbers, could I Import that into AutoCAD so that it would load premade 3d blocks where I want it to. For example I have a warehouse drawing with specific parts stored in specific locations. I have block drawings already made for each part. I have an Excel sheet with a list of part numbers. Is there a way I can import the Excel sheet and have it populate my warehouse drawing with the part drawing blocks in their perspective locations? Thanks!

Hi. So as I was sitting in class today I noticed that If I froze my two layers a-door and a-sanr-fixt I realized my doors were disappearing on both layers. I realize this is because I created my blocks on the a-sanr-fixt layer. Now what I'm wondering is if there is anyway to remove the a-sanr-fixt from the door properties so that way when I freeze my a-sanr-fixt layer the doors wont freeze. This issue is happening across all layers. Any help would be greatly be appreciated. If anyone has fixed this before please link me to that.

Hello, all. I have a question concerning block counting. I have become familiar with the BCOUNT command, but I wanted to take it one step further for my particular application. What I have is several viewports within a drawing. Each viewport represents a particular floor of a building. Furthermore, within each floor are "loops" defined by colored, dashed lines in which there reside certain devices (blocks). Identical devices may exist within other loops on the same floor. Here's the question: Is there a way to count (and possibly export that data to a spreadsheet) the number of blocks that reside within each loop boundary? The boundaries are rarely simply rectangles. It's easy to count the number of blocks within a viewport, but I'm having trouble figuring out (if there even IS a way) how to count the number of blocks within my loop boundaries. **I should clarify and say that, when I say viewports, what I really mean is layouts. There is one viewport per layout/floor. Sorry if this caused any confusion or cringing. Thanks in advance. Beef

Hello all, I work in a manufacturing facility and we are trying to come up with a way to extract data from an AutoCAD file in to a .KML or .CSV file which gives coordinate points, etc. This will be used in a mapping-type software to display/highlight areas of the plant with zooming capabilities and information shown on the left-side. We are trying to make it look something like Google Maps, so it can used to determine areas of the plant undergoing work, lighting zones, etc. We are in the preliminary stages of this project and I could use some help/advice on how you guys would approach this. I have intermediate AutoCAD knowledge, hence I am reaching out to the community. In a nutshell, I want to be able to extract coordinate data from our layout(s) which can used to pinpoint locations on the map and highlight regions, etc. Perhaps it could export data in to Excel with attributes assigned to the coordinates which give Area, Bay Location, etc. The initial thought was to somehow export this to a .KML file and use that as a starting point. Let me know what you guys think, and how to best approach this. Any help would be greatly appreciated! Thank you.

Hi everyone, So I just upgraded to MEP 2013 last week and am in a bad situation where when I keep making my data link tables to a range on an excel table the file name's full address is not staying when I go to insert the table. (ex. D:/Documents/JB Plans/NK.xlsm is just NK.xlsm when I try to insert the table) Does anybody know of some defaulting or setting that I haven't found involving this issue? Thanks

Hi there, I decided to try the advice I read and start using Data Link Tables for my Excel sheet instead of OLELinks. The appearance is far sharper, and I am also pleased there is no background color transfered. What IS the problem is when I update the table, its goes from 12" Wide by 12" Tall table @ 7/16" Text W/O borders back to 3" Wide by 10" Tall with varying text size to fit and gains back all borders except diagonals (of which none are present on the Excel file). So I need to figure out a way to default the format when I refresh so that it holds each cell at the 6"X1" dimensions with no border. With that, If there is a way to have a stencil for making the range links with Excel, that would be useful. I use the exact same 4 or 6 ranges (2 formats) in every dwg. Thanks Everyone!

Hi Guys, Hope I've got the right part of the forum for posting this thread... I am trying to import xyz data into AutoCAD using the multiple - point command, however when I paste the data as part of the command line it does not process the points but pastes the data as text into the model space. I hope I have explained this well enough, sorry if I have not. I have also tried using ascpoint.lsp however I struggled to get to grips with making it produce the points on screen. Thanks in advance.