Wow....you made this way too easy. I really appreciate this tutorial. Coffee is on me. You would never be able to work for AutoDesk because you make too much sense and your approach is way to efficient, elegant, and effective.
Thank you very much for this video!. You saved me a lot of time. Is there any way to use a number in every point, to join them with lines automatically in that order?
Good video ! Would be interested to know if when importing the points, could you use a specific block instead of the points? And if the block has attributes, could these be imported too? Thanks !!
Thank you for the video, it is great. I want to ask if it is possible to also include the poin ID or number so it can be a part of the info of each point. I tryed but it presents an error.
I don't have levels, so tried with easting and northing only points and tried to paste in autocad the way you did but nothing appears? any idea what to do?
Hello and thank you for the video. I have an issue how to import Excel coordinate data into AutoCAD for the Cross Section Soil Line. If you could help me with that it would mean the world, thank you and king regards.
Does anyone know how to get a true scale in excel for a site plan? It seem that the bigger the site plan is the more the scale gets off. I think excel is not accounting for the grid lines and it throws the cells off. Is there an option in excel to take that into account?
Hi. Good question. I'm not sure that you can automatically do that in AutoCAD. You may have to manually add the text after importing the points. If you have access to Civil3D, however, then adding points will also add the elevation data as an object that can displayed very easily. Do you have Civil3D? If you do, you can see me importing a text file to Civil3D and displaying point elevations in this video: ua-cam.com/video/EOxB2pYWuGI/v-deo.html Wayne
The command line can appear in a floating tool bar, so it is possible to move it, hide it, minimise it and close it independently to everything else on the screen. If you have accidentally closed the toolbar, holding down the CTRL key and pressing 9 should bring it back.
sarji apke video se koi bhi engineer ban sakata hai ,par mere jaise ITI surveyer ko 1 help chahiye ki mere pass dumpy lvl hai .mai village map exel data banake cad me kaise banau .mere pass distunce, RL , point name, house name, normal bearing without second.hai.pls help us
I'm not sure that there is an easy way to join them automatically without writing a script, and I've never tried that. Depending on the number of points, it may be easier to manually join them using a line, polyline or 3DPolyline in CAD after they have been imported.
***** Is there a way to write a script with the coordinates so that I can import it into autocad and it will display a drawing instead of points? I can do that in solidworks.
+This Dude There may well be, I'm not sure. It's easy enough in Civil3D to code up the points to automatically join, but I'll be honest, it's not something I've ever tried to do in AutoCAD. One complication I can think of is that more than likely not all points will be joined to each other (for example, maybe you only need the outside points to be joined to form a boundary line, but the points inside would not need to be joined by lines), and it might be difficult to code them so that only the ones you want joined become joined while the rest are treated as single points. Not saying it can't be done, but I can't help you on that one, I'm afraid.
A point in AutoCAD only has 3 bits of information. They are the X, Y and Z coordinates. If you need to add more attributes to a point, perhaps you could look into importing a point file into Civil3D
Hi. Sorry, I do not have the 2007 version to do any testing with, but I'd imagine it's done the same way? The main component is getting the data in the correct format using Concatenate in Excel, and after that it's just the multiple point creation command in AutoCAD.
Not sure point numbers mean a whole lot in regular AutoCAD. They’re much more important in Civil3D, and I have videos showing how to import point files into Civil3D elsewhere on the channel.
Hi. There could be any number of reasons for that. If you have followed my video exactly, then the problem may be that the limits are set too low in AutoCAD, or that the numbers are not in a format that AutoCAD recognises. Can you give me an example of a coordinate for one of your points please?
The level should also be imported, but it won’t show up on the CAD screen as a label. If you follow the video and then use the “ID” command over one of the points, you should see the level data in there. It will be the 3rd value, after X and Y
Hi. The video just shows a quick way to get a lot of points into AutoCAD: how you join them is up to you. I suggest that you use object snaps, though, and make sure "node" is turned on. If you want to use a polyline to join them, it might be worth considering the use of a 3-dimensional polyline, which is started by entering "3dpoly" on the command line.
Hamdy elgohary Hi. I'm not sure that you can automatically do that in AutoCAD. You may have to manually add the text after importing the points. If you have access to Civil3D, however, then adding points will also add the elevation data as an object that can displayed very easily. Do you have Civil3D? If you do, you can see me importing a text file to Civil3D and displaying point elevations in this video: ua-cam.com/video/EOxB2pYWuGI/v-deo.html Wayne
Wow....you made this way too easy. I really appreciate this tutorial. Coffee is on me.
You would never be able to work for AutoDesk because you make too much sense and your approach is way to efficient, elegant, and effective.
Thank you for the brilliance of making it so quick.
I know people who would have explained this for 15 minutes.
Thankful regards
Thank you very much for this video!. You saved me a lot of time.
Is there any way to use a number in every point, to join them with lines automatically in that order?
Thank you so much for showing me this , I used to manually input all the data ! Give this man a pint
Excellent, fast and accurate. Just what I was looking for, thank you very much.
YA...ITS AMAZING.. I AM ALWAYS USING THIS METHOED.THANKS FOR SHARING
thank you for this, explained easily and so simple! life saver
Thanks for your comment.
Very precise! Thank you
Very Helpful !! Kindly let me know how can I input values ( XYZ along with the points...especially Levels )
Thanks for a quick, easy and informative video and method!
That was real quick, thanks for the information
Ta! You're a star! (Yes you are!)
Great video, could you do another showing how to join points and add the dimensions too the lines.
Good video ! Would be interested to know if when importing the points, could you use a specific block instead of the points? And if the block has attributes, could these be imported too? Thanks !!
Thank you for the video, it is great. I want to ask if it is possible to also include the poin ID or number so it can be a part of the info of each point. I tryed but it presents an error.
+PERMACULTIVOS it you edit the point label style, you should be able to include that information.
thank you so much i love ireland
Great!
tried this and worked perfectly. Thanks :)
Great! Glad you found it useful. Wayne
Informative
Thanks for this information it is so much helpful:)
Thank you so much for this video. Very helpful
Etienne Mutebutsi Glad you found it helpful.
Thanks for the video. Really informative, however when I import the points I cannot see them even when I zoom and e.
Any advice?
Thank you very much for this tuto!
Awesome like the MIZ
I don't have levels, so tried with easting and northing only points and tried to paste in autocad the way you did but nothing appears? any idea what to do?
It should work with just the X and Y values as long as you follow my method but leave out the final comma and Z value.
Hi. How can we add attributes to those points? for example, length and width to be show in properties?
When i provided the points,it is showing to specify the end point of the line and nothing visible on the screen
Can a google map be added to this? I need my excell data points plotted on a google map in autocad.
As far as I know, the map integration with AutoCAD Civil3D is with Bing maps, not Google.
is there a way to have to points IDs on the points as well ?
Not sure you can do that in AutoCAD. It’s very easy in Civil3D, though.
Thank you!!!!!!!!
Nice👍👍👍
very. nice sir love u. no i understands. its very easy method
+Saqib Saeed thank you. I'm glad it was useful for you.
great thanks
Thanks man...helpufll to me good
Hello and thank you for the video. I have an issue how to import Excel coordinate data into AutoCAD for the Cross Section Soil Line. If you could help me with that it would mean the world, thank you and king regards.
Send me an email and we can discuss. Cadandstuff[at]gmail[dot]com
VERY very good
Does anyone know how to get a true scale in excel for a site plan?
It seem that the bigger the site plan is the more the scale gets off. I think excel is not accounting for the grid lines and it throws the cells off. Is there an option in excel to take that into account?
Sir can u also teach the whole finished road
good information..
How do I make the levels appear next to the points? Thanks
Hi. Good question. I'm not sure that you can automatically do that in AutoCAD. You may have to manually add the text after importing the points. If you have access to Civil3D, however, then adding points will also add the elevation data as an object that can displayed very easily. Do you have Civil3D? If you do, you can see me importing a text file to Civil3D and displaying point elevations in this video: ua-cam.com/video/EOxB2pYWuGI/v-deo.html
Wayne
Hello plz tell us how to do to show the point number in autocad !
Thank you
what is the format file input the top con instrument (xyz)
my command line menu , where you type point , disappear how to bring it back , I full with a lot of menu this autocad screen
The command line can appear in a floating tool bar, so it is possible to move it, hide it, minimise it and close it
independently to everything else on the screen. If you have accidentally closed the toolbar, holding down the CTRL key and pressing 9 should bring it back.
How do you add the labels to each point?
Check out the video I did on it. It may help you. Have a nice day 🤘
sarji apke video se koi bhi engineer ban sakata hai ,par mere jaise ITI surveyer ko 1 help chahiye ki mere pass dumpy lvl hai .mai village map exel data banake cad me kaise banau .mere pass distunce, RL , point name, house name, normal bearing without second.hai.pls help us
I don’t understand what you are asking.
So how do I join the points?
I'm not sure that there is an easy way to join them automatically without writing a script, and I've never tried that. Depending on the number of points, it may be easier to manually join them using a line, polyline or 3DPolyline in CAD after they have been imported.
***** Is there a way to write a script with the coordinates so that I can import it into autocad and it will display a drawing instead of points?
I can do that in solidworks.
+This Dude There may well be, I'm not sure. It's easy enough in Civil3D to code up the points to automatically join, but I'll be honest, it's not something I've ever tried to do in AutoCAD. One complication I can think of is that more than likely not all points will be joined to each other (for example, maybe you only need the outside points to be joined to form a boundary line, but the points inside would not need to be joined by lines), and it might be difficult to code them so that only the ones you want joined become joined while the rest are treated as single points. Not saying it can't be done, but I can't help you on that one, I'm afraid.
I cannot wait to work this staff:) on 300£ per day thanks
THANKS. IT IS THE ESEAY WAY FOR THAT
thanks :)
How can I level the point, I want to show its station no. as well?
A point in AutoCAD only has 3 bits of information. They are the X, Y and Z coordinates. If you need to add more attributes to a point, perhaps you could look into importing a point file into Civil3D
Thanks 😊
Thanks BRO :)
interesting. but how can I use in AutoCAD 2007?
Hi. Sorry, I do not have the 2007 version to do any testing with, but I'd imagine it's done the same way? The main component is getting the data in the correct format using Concatenate in Excel, and after that it's just the multiple point creation command in AutoCAD.
What about point numbers?
Not sure point numbers mean a whole lot in regular AutoCAD. They’re much more important in Civil3D, and I have videos showing how to import point files into Civil3D elsewhere on the channel.
I love you
Wow! That's great, I think! :)
I Cant Plot the data in the autucad. it says invalid points
Hi. There could be any number of reasons for that. If you have followed my video exactly, then the problem may be that the limits are set too low in AutoCAD, or that the numbers are not in a format that AutoCAD recognises. Can you give me an example of a coordinate for one of your points please?
xyz format file how to save ?
co-ordinate is OK but where is level ?
The level should also be imported, but it won’t show up on the CAD screen as a label. If you follow the video and then use the “ID” command over one of the points, you should see the level data in there. It will be the 3rd value, after X and Y
how do i join these points ? simple lines ??
Hi. The video just shows a quick way to get a lot of points into AutoCAD: how you join them is up to you. I suggest that you use object snaps, though, and make sure "node" is turned on. If you want to use a polyline to join them, it might be worth considering the use of a 3-dimensional polyline, which is started by entering "3dpoly" on the command line.
thank you so much :D
how to add points with label?
I’m not sure that you can in regular “AutoCAD”. You can in Civil3D, though: do you have that application?
@@CADandStuff never heard of it! but now i will search for it
thanks
i can't import 2 points in the same time,one do work.
ty it's work now
sir plz send me fx 5800 p calculator program horizontal & vertical curve
what is why not easy
how can add labels also to the points??
Hamdy elgohary Hi. I'm not sure that you can automatically do that in AutoCAD. You may have to manually add the text after importing the points. If you have access to Civil3D, however, then adding points will also add the elevation data as an object that can displayed very easily. Do you have Civil3D? If you do, you can see me importing a text file to Civil3D and displaying point elevations in this video: ua-cam.com/video/EOxB2pYWuGI/v-deo.html
Wayne