I invested lot of time to prepare this video! for this if you wanna gift something to me then just SUBSCRIBE our channel and stay connected with us! (Its free!) Donate us here: www.paypal.me/learnxplore
IF WE WANT COORDINATES SEQUENCE NUMBERS ALSO ALONG WITH XY COORDINATES THEN WHAT IS THE OPTION THE ONE IS SHOWING IN POLYLINE I WANT THAT SEQUENCE NUMBERS IN EXCEL ALSO
may I ask are the coordinates extracted this way the exact position of the map. WHat I extracted is not the same, and i found out there is no correlation between this coordinates with the map's real coordinates i fund using photoshop
@@LearnExplore thank you for the reply. Sorry i didn't make myself clear. e.g. I got X=30891888.19 Y=29655181.89, and using paint, I got another coordinates for the same point as X=3290 Y=2882. And using thi method i ave obtained a lot. and im trying to find a way to see how these two sets of coordinates are related. So far they are not, but i think they should be related through some transformation aren't they?
guess you can use text2csv lisp drive.google.com/file/d/18ZPtK3aQ4HThw3B8Cfrz6pwRnEpOYsXK/view?usp=share_link text2csv select the layer select the folder give file name
Hi Actually the data I have choosen for the example there was no Z value because it is a 2D polyline. If you have the Z value in your data then use 3D POLYLINE COMMAND. I think the shortcut for the command is 3PL then list the 3D POLYLINE and extract coordinates.
get your points on separate layer, turn off the rest of the layers and type dataextraction, select points and enter, then follow screen ( points are not in order)
great video!!! do you have video show how to draw pline. from a xcel data (x,y) to autocad.. or take coord from xcel file and draw it on autocad... thanks you very much
Thank you for asking me about AutoCad Data extraction. Data extraction can export all Autocad drawing entities (poly line, circle, text, point etc...) details which is coordinates, layer name, block name, attribute value and line length, etc.. as Excel table or we can insert as a table in same drawing. I'm using Data extraction since 2010. you can access data extraction by typing "DATAEXTRACTION" or "DX" in AutoCAD command bar. for more details please subscribe my channel I'll upload a video about DATA EXTRACTION soon. Kind Regards, Saifudheen Pottoor
Z can be exported like the same way what is shown in this video. Just you have to use LIST command from the TOP view. And u hav to apply some filters in excel. And If the same is requested by more friends here then we will upload a video on exporting z values .
bro your audi is not at all clear, it is very difficult to understand what you are saying. I wish, you, to improve the clarity of your audio while recording. Thank you. You got a very good concept of subject.
I invested lot of time to prepare this video!
for this if you wanna gift something to me then just SUBSCRIBE our channel and stay connected with us! (Its free!)
Donate us here: www.paypal.me/learnxplore
I liked the vedio becuase of your comment, if you like the video like it and if you dislike, dislike is....Thats a good point,,,, I liked it ...Thanks
Thank you so much 🙏
huge help thanks for this!
Welcome. Thank You for your valuable feedback 😊
Awesome learning sir 🙏
IF WE WANT COORDINATES SEQUENCE NUMBERS ALSO ALONG WITH XY COORDINATES THEN WHAT IS THE OPTION THE ONE IS SHOWING IN POLYLINE I WANT THAT SEQUENCE NUMBERS IN EXCEL ALSO
THANK YOU! 🎉
may I ask are the coordinates extracted this way the exact position of the map. WHat I extracted is not the same, and i found out there is no correlation between this coordinates with the map's real coordinates i fund using photoshop
By this method u will get exactly the same coordinate. No correlation between data.
@@LearnExplore thank you for the reply. Sorry i didn't make myself clear. e.g. I got X=30891888.19 Y=29655181.89, and using paint, I got another coordinates for the same point as X=3290 Y=2882. And using thi method i ave obtained a lot. and im trying to find a way to see how these two sets of coordinates are related. So far they are not, but i think they should be related through some transformation aren't they?
Coordinates depend upon scale factor. May be you imported the image in autocad in larger scale
Hello. Thank you for the videos. But if we only have random points that are not joined by a poly line how can we extract the coordinates?
We will make video on this topic. Soon. Stay tuned.
Very easy .. use command( Data extraction )..
guess you can use text2csv lisp drive.google.com/file/d/18ZPtK3aQ4HThw3B8Cfrz6pwRnEpOYsXK/view?usp=share_link text2csv select the layer select the folder give file name
Good Working
Perfect 👌🏻 video
Waw! Thank you very much! This is very helpful.
Can we do this same practice with blocks?
For blocks video is already uploaded.... Please check in playlist.
wow... what a easiest method. you are great. keep going... i support to you .
Thank you for ur support ☺️
Good, I will try it tomorrow as you shown us
Really thank u very very very much for u channel
thank you. this video really helped me a lot.
Glad it helped!
Good explanation
thank you! God bless U
You are welcome
Thank you very much for uploading this video
Thank you so much, you're the best 🙏
You are welcome. 🙂
Very good explain
Thankyou very much sir
Thanks very useful
how do i copy easting, northing and depth in autocad drawing into a csv file
save your file of excel as a csv file....in the save as option
Usefull video ...Greater job bro..
Thanks bro, relay I have benefited.
Thank you very much.
Thanks a lot
Nice vid.
But how I will get the point to excel in specific order? I mean the first point of polyline to be in the first row in my excel and so on?
Yes exactly what u think. The vertices will be exported in sequence
Thank you
Useful video. But, I have hollow sphere in CAD and want to extract the coordinates of its center, how can i do that?
thank you so much
You are welcome sir. Please share our video
Thank you so much..liked and subbed.
Good video
I want nothing eating nd code convert to auto CAD how please give guide
Watch this your problem may solved ua-cam.com/video/AEeYQ_Nwtr0/v-deo.html
Hello in this video how to take Z cordinate bcz its showing only 000 so plz help
Hi
Actually the data I have choosen for the example there was no Z value because it is a 2D polyline.
If you have the Z value in your data then use 3D POLYLINE COMMAND. I think the shortcut for the command is 3PL
then list the 3D POLYLINE and extract coordinates.
if you want export xyz your poly line should be 3d poly (3Dpoly) then only you can get Z value.
thanks you
Viswagar
get your points on separate layer, turn off the rest of the layers and type dataextraction, select points and enter, then follow screen ( points are not in order)
Bhai video mst hai,pr hindi bol kr bnaiyega qki sbko English smjh nhi lgti hai.
great video!!! do you have video show how to draw pline. from a xcel data (x,y) to autocad.. or take coord from xcel file and draw it on autocad... thanks you very much
Already video uploaded in this topic
Wow very good
Its ok but where is level,is there any formula to get level
Use command 3P instead of PL to draw the line and then apply the same process
WHAT ABOUT Z CORDINATES
Points from Autocad to excel please make video
Select points and use list command
Sir suddenly list comment dissappears
Press F2 then you will find text box and then copy your desired data
thanks
How we can get z in same method
To get the Z value u have to apply the same method
Data extraction (autocad command “DX” ) more easy than this method.
Could you please tell me what the DX command is?
And in which version of AutoCAD this command is used?
Thank you for asking me about AutoCad Data extraction.
Data extraction can export all Autocad drawing entities (poly line, circle, text, point etc...) details which is coordinates, layer name, block name, attribute value and line length, etc.. as Excel table or we can insert as a table in same drawing.
I'm using Data extraction since 2010. you can access data extraction by typing "DATAEXTRACTION" or "DX" in AutoCAD command bar.
for more details please subscribe my channel I'll upload a video about DATA EXTRACTION soon.
Kind Regards,
Saifudheen Pottoor
I have added a video about DataExtraction please watch the link below.
ua-cam.com/video/DWNJzkERW0s/v-deo.html
You can use this command in 2016 or latest version .. DX ( Dataextraction )
Sir column coordinator I'd number command please sir
ID enter
Great
THANK YOU VERY MUCH :)
u r welcome! :)
What about z?xy very easy please tell also about z
Z can be exported like the same way what is shown in this video.
Just you have to use LIST command from the TOP view.
And u hav to apply some filters in excel.
And If the same is requested by more friends here then we will upload a video on exporting z values .
As per your question
ua-cam.com/video/LDoWydribuY/v-deo.html
Plz send lisp
bro your audi is not at all clear, it is very difficult to understand what you are saying. I wish, you, to improve the clarity of your audio while recording. Thank you. You got a very good concept of subject.
Sorry for that. will try next time
Plis subtitle Indonesia bro
Plz translate for hindi
Malayalee analle
Plz send lisp