binding an autocad design to excel date

[Onda]

then so far, nn there are problems for dissected views, transmission organs such as pulley wheels or trees, which as you can well imagine are easily executable, with the polyline command. My question is in short, can I copy and paste a script, put multiple different operations? for example in the sectional view, polylinea, fittings and quotas?
Obviously in the front view, I will use other commands usually circumference, i.e. the juice is I can put more than one function, or I have to copy/paste every script, for every function different from polylinea, which obviously allows me to draw more lines with the same command, because if so nn it was, I should do up it is copy and paste several things, and at that point nn it would be more the same thing.
in case the syntax of, mainly: Can I find you in the links above?

The script can be as long as you want and you can make him do whatever you want.
The main difference from working with the mouse is picking.
with the script to put the quota you have to give the coordinate of the point, with the mouse click on the point with the object snap.
apart from this script can be long and do very complex operations, also wanting in 3d, without any problem.
the fittings are not easy to do with the script, because they don't quit picking. You should calculate them mathematically and then make a bow between the two lines. Happy birthday!
try to keep things simple, without instilling you in trigonometry or other complex claims.
learn the creation mechanism from excel and let us see what comes out.

 

[Shape]

as suggested by wave the problem of fittings and bevels through script is the selection of objects.

if you need to make fittings you should do them while you generate polylinea, if you look in the command line options there is the arc option which then in turn has this angle/center/close/direction/half-width/line/route/second
point/annulla/width obviously requires you to know the final points of the fitting and the corner, but with excel available I do not think there are problems for the calculation.
peer bevels I don't think there's any problem because you generate them with polylinea as they were lines.

quotas etc you have to give 2 points and the insertion point.

I don't know if you already know it but there are 3 methods in autocad in the input of measures

1) 0.0 means in point x0 y0 of the global ucs (absolute coordinates)
2)@100,0 means x100 y0 from the last selected/reaching point (related coordinates)
3)@100<45 means a segment 100 to 45° long from the last point reached (polar coordinates)

read well the autocad guide to the entry entry of the coordinates are explained above and others of course because besides those said there can be cylindrical coordinates, spherical coordinates etc.

 

[Nichi]

I am drawing up the designs, perhaps too banal question how do I put the excel version in English? (before messing up I ask you)

 

[Shape]

I am drawing up the designs, perhaps too banal question how do I put the excel version in English? (before messing up I ask you)

that I know you have to install it in English, it's not a translation.

However I know for certain that the files made with English version and/or other languages are converted automatically (word of formulas)

 

[Nichi]

for anyone who can serve, to change from the virogla to the point as a decimal separator, on excell, it is enough to go on start-pannello of control- international settings and languages- customize- to replace the "." to "," and the game is done, in essence of excell nn it has to change nothing xd

 

[Shape]

for anyone who can serve, to change from the virogla to the point as a decimal separator, on excell, it is enough to go on start-pannello of control- international settings and languages- customize- to replace the "." to "," and the game is done, in essence of excell nn it has to change nothing xd

ahh now I understand, you were referring to what wave suggested for settings in English.... "," and "." ahahahahahahah !!!

he refers to exactly what you did, control panel etc etc etc etc.

 

[Nichi]

cmq I almost finished the sheet with the design all possible checks, it does everything by itself, then the tosta part will be formatting them so that autocad read them, but I think after a little confidence the game is made

 

[Nichi]

work in progress though right now I'm having trouble finding the script for the command size

 

[Nichi]

trivially the problem I have is for the view of the hole for the shaft in the toothed wheel, and nn I can understand how to draw the intersection between the diameter of the shaft and the hub quarry, ideas?

 

[Onda]

You have to make a circle rather than cut a circle.
Not having the snap available, it's easier to use math.
I think we already wrote it.

 

[Nichi]

no vabhe thank you, but I discovered how to make the script of size,
just give coordinates of the point belonging to the first line, coordinates of the point belonging to the second (separate from a space), accapo, next again, point belonging to the line that you can cut

 

[Nichi]

Now I have the slightest idea of how to project the intersection, first in the section of the toothed wheel....

 

[Nichi]

I'm almost finished, but I understand why sometimes when I cover the script in the command bar, I'm wrong the design then maybe I take it back and I do it well the script in question for example:

psyche
0.0
0.25
2,31.5
58,31.5
60,29.5
60,0
60, 29.5
58,-31.5
2,-31.5
0,-29.5
0.0
0.24.75
60,24,75
60,-24,75
0,-24.75
0.0
0.17.3
60,17.3
60, 14
0,-14
0.13.4199999999999
60,13.419999999992

psyche
114,17.3
118,17.3
110,17.3

line
110, 11.1
110,17.3

line
118, 11.1
118,17.3

circle
114,0 14
;
size size
114,14 110,-11.1 118,-11.1

110, 11.1
11,14
118, 11.1

-layer current sampling

-ptratt 1,18.3 1,-15 properties ansi31



;
-layer current symmetry axes

line
- 15,0
143,0

line
11,32.3
11, 29

line
- 15,28.5
75,28.5

line
-15,-28.5
75, 28.5

-layer current quotas

dimlinear
2,31.5 2,-31.5
- 20,0

dimlinear
0,-28.5 60,-28.5 horizontal
2,-46.5

dimlinear
0,-29.5 2,-31.5 horizontal text 2x45%%
1.

dimlinear
100,0 128,0 horizontal text 28 h7
11, 29

dimlinear
110,17.3 118,17.3 horizontal text 8 d10
114,27.3

 

[Nichi]

then the problem is this, I created a sheet of excell for the sizing of trees and wheels, in the background to the sheet there are formatted rows, it seems correctly, so that by copying them and pasting them in the text bar below to autocad I design everything. What's the problem? the problem is that often the drawing that comes is wrong, in the sense that it can macate something, however, nn know how often this problem solves by deleting the drawing there and taking the same text into the text bar. I put the script in question. I tried to set filedia and cmddia to 0 put the commands and then put them back to 1 but nn is served to nothing. If you want to try copying it in your box and tell me what is coming to you, I have a 2010 autocad the most common errors are the non-completion of the sample and command size on the shaft hole. the lines of ";" the use to separate malicious commands, in the sense that if there is them I put them wrong the design.
important to say however that maybe the names of the layers can be different and therefore you can present problems in case you want to try on your autocad

psyche
0.0
0.25
2,31.5
58,31.5
60,29.5
60,0
60, 29.5
58,-31.5
2,-31.5
0,-29.5
0.0
0.24.75
60,24,75
60,-24,75
0,-24.75
0.0
0.16.3
60,16.3
60,-13
0,-13
0.12.4999999
60,12.4999999

psyche
113,16.3
117,16.3
109,16.3

line
10-12.1
109,16.3

line
117, 12.1
117,16.3

circle
113,0 13
;
size size
113,13 109,-12.1 117,-12.1

10-12.1
11,13
117, 12.1

-layer current sampling

-ptratt 1,17.3 1,-14 properties ansi31



;
-layer current symmetry axes

line
- 15,0
141,0

line
113,31.3
113, 28

line
- 15,28.5
75,28.5

line
-15,-28.5
75, 28.5

-layer current quotas

dimlinear
2,31.5 2,-31.5
- 20,0

dimlinear
0,-28.5 60,-28.5 horizontal
2,-46.5

dimlinear
0,-29.5 2,-31.5 horizontal text 2x45%%
1.

dimlinear
100,0 126,0 horizontal text 26 h7
113, 28

dimlinear
109,16.3 117,16.3 horizontal text 8 d10
113,26.3

dimlinear
113,-13 113,16.3 vertical
146,0
;
-text
141.8 1 90
+0.2

-text
144,9 1 90
0
;
psyche
30,41.5 24.23,31.5 21.35,36.5 27.11.36.5

psyche
73,38.5 67,23,28.5 64,35,33.5 70.11,33.5

psyche
30,-3 24.23,-13 21.35,-8 27.11,-8

psyche
-10,-19 0,-24.77 -5,-27.54 -5,-22

psyche
99.21 109.15.23 104.12.35 104.18.11

 

[GP.]

You'd better attach something to make the final result understand, to me it's on size.
I don't understand what the data is like:

dimlinear
100,0 126,0 horizontal text 26 h7113, 28

dimlinear
109,16.3 117,16.3 horizontal text 8 d10
113,26.3

 

[Nichi]

are texts, the tolerances of the tree and the width of the quarry the result, and the various "casistics" of error are below, from here I go wrong the first and a wheel made well

 

[Nichi]

It seems to me that the problem is caused by the fact that some commands that I take off after I have "determined" their use, they start again. In order to overcome this problem I had put some; at the end, but I am not sure it is a quiet thing for autocad. typing the controls by hand does not happen this thing. For example, the circle command after drawing one (gluing commands from excel) asks me new data for another circle.

 

[Shape]

the problem is often generated by a zoom factor and active snaps.
by passing the coordinates a snap is hooked and everything goes into the mess because it does not detect intersection.

try inserting a zoom extensions before performing cutting operations and disable snaps, you will see it goes.

 

[GP.]

the problem is often generated by a zoom factor and active snaps.
by passing the coordinates a snap is hooked and everything goes into the mess because it does not detect intersection.

try inserting a zoom extensions before performing cutting operations and disable snaps, you will see it goes.

in fact as the first command you should set a zoom on a suitable window, while the snaps do not worry me as I always set osnapcoord = 1
@nichi- the names of layers containing spaces should be enclosed between quotes
- you should use -layer def... as well as making a layer current, it creates it if it does not exist
- as set does not work me the size, the data is always those or from time to time comes from calculations made in excel?... because at the limit you can try another procedure.
- add two blank rows at the bottom of the code below

psyche
0.0
0.25
2,31.5
58,31.5
60,29.5
60,0
60, 29.5
58,-31.5
2,-31.5
0,-29.5
0.0
0.24.75
60,24,75
60,-24,75
0,-24.75
0.0
0.16.3
60,16.3
60,-13
0,-13
0.12.4999999
60,12.4999999

psyche
113,16.3
117,16.3
109,16.3

line
10-12.1
109,16.3

line
117, 12.1
117,16.3

circle
113,0 13
;
size size
113,13 109,-12.1 117,-12.1

10-12.1
11,13
117, 12.1

-layer current sampling

-ptratt 1,17.3 1,-14 properties ansi31



- current layer "symmetry axes"

line
- 15,0
141,0

line
113,31.3
113, 28

line
- 15,28.5
75,28.5

line
-15,-28.5
75, 28.5

-layer current quotas

dimlinear
2,31.5 2,-31.5
- 20,0

dimlinear
0,-28.5 60,-28.5 horizontal
2,-46.5

dimlinear
0,-29.5 2,-31.5 horizontal text 2x45%%
1.

dimlinear
100,0 126,0 horizontal text 26 h7
113, 28

dimlinear
109,16.3 117,16.3 horizontal text 8 d10
113,26.3

dimlinear
113,-13 113,16.3 vertical
146,0
-text
141.8 1 90
+0.2

144,9 1 90
0
psyche
30,41.5 24.23,31.5 21.35,36.5 27.11.36.5

psyche
73,38.5 67,23,28.5 64,35,33.5 70.11,33.5

psyche
30,-3 24.23,-13 21.35,-8 27.11,-8

psyche
-10,-19 0,-24.77 -5,-27.54 -5,-22

psyche
99.21 109.15.23 104.12.35 104.18.11