psyfr3ak Posted May 27, 2010 Share Posted May 27, 2010 Hello all, i have 2500 points that i want to import, i have them in an excel file in the right way, and i can import them using multiple>point copy/paste. but i alsoo need to label them, up or down the point maybe to put an indicator. the ideea it's to create a grid, then manually using my eye to draw some line between this value, like drawing some same temperature/same pressure lines. any ideeas? thanks Quote Link to comment Share on other sites More sharing options...
eldon Posted May 27, 2010 Share Posted May 27, 2010 Can you post a bit of the data file to give an idea of the data format? and also a picture of what you hope to achieve? It might give someone an idea It sounds like the same thing as contours Quote Link to comment Share on other sites More sharing options...
psyfr3ak Posted May 27, 2010 Author Share Posted May 27, 2010 i just have 2 excel columns Object name | Indicator | (x.y) 1 3.31 323232,534343 2 5.02 2323232,2323232 3 23.09 2323232,2323232 etc... at this moment i'm just copy the (x,y) column, then in autocad command line i am typing multiple > point then paste. the problem is that i want also to automatically import the indicator. then using the point style format, to see the points as little circles, and the Indicator will be inside the circle. This is all i want. The next part, with drawing the splines like in interpolation i can do it manually, because i'm just interested in a small number of splines, but for the grid i have something like 2500 points. Quote Link to comment Share on other sites More sharing options...
eldon Posted May 28, 2010 Share Posted May 28, 2010 If your requirement was just this once, then I could do it for you. But if this is an ongoing need, then someone will have to write a lisp for you. Quote Link to comment Share on other sites More sharing options...
BIGAL Posted May 31, 2010 Share Posted May 31, 2010 There is lots of lisp programs here about "importing points" I know I have pasted a couple check the Lee Mac ones I am sure he has a labelling one. Its a common request and pretty easy to change a lisp that some else has done to suit your needs. Quote Link to comment Share on other sites More sharing options...
rvpas Posted May 31, 2010 Share Posted May 31, 2010 Hi, You can create a script in excel and copy and paste in command line Let see your example 1st - open excel/and copy your sheet 2nd - you have to create two commands a) insert point b) create text a same place of your point and get indicator value Well in colonne D or over type this formula ="point "&c2&" -text @ 200 0 "&b2&" " explanations " - explain to excel is text point - command point space - means enter & - means contaner use to add text c2 - cell where you have x,y -text - command single line @ - take lastpoint for base point 200 - height of text for exemple 0 - rotation=0 b2 - cell where you have indicator now click and drag your formula till the last line and after copy all lines of this colunm last paste directly in command line. Dont forget one thing use space for enter I attached an excel table good luck Pascal point+text exemple.zip Quote Link to comment Share on other sites More sharing options...
brunolda Posted January 13, 2012 Share Posted January 13, 2012 Hi Pascal, great stuff. So simple and works so effectively. Cheers Bruno Quote Link to comment Share on other sites More sharing options...
mayromitsos Posted January 25, 2012 Share Posted January 25, 2012 I did the same job with 58000 points. It worked perfect. rvpas, thank you for your script! Quote Link to comment Share on other sites More sharing options...
paduroiul Posted May 3, 2012 Share Posted May 3, 2012 I want to import something like this in AutoCAD which is the simplest and fastest way? cote k-lumea.txt Quote Link to comment Share on other sites More sharing options...
mayromitsos Posted May 18, 2012 Share Posted May 18, 2012 (edited) I want to import something like this in AutoCAD which is the simplest and fastest way? According to rvpas' script, copy the following text and paste it in command line. It should work. point 499990.537,499983.388,399.872 -text @ 0.5 0 52 point 499987.932,499983.304,399.857 -text @ 0.5 0 53 point 499985.838,499983.235,399.863 -text @ 0.5 0 54 point 499983.728,499982.97,399.532 -text @ 0.5 0 55 point 499980.244,499982.74,399.597 -text @ 0.5 0 56 point 499975.949,499982.347,399.668 -text @ 0.5 0 57 point 499972.445,499982.779,399.775 -text @ 0.5 0 58 point 499968.134,499981.417,399.755 -text @ 0.5 0 59 point 499962.13,499983.66,399.839 -text @ 0.5 0 60 point 499957.199,499984.703,400.005 -text @ 0.5 0 61 point 499972.808,499979.846,399.665 -text @ 0.5 0 62 point 499976.794,499980.068,399.609 -text @ 0.5 0 63 point 499979.546,499979.908,399.594 -text @ 0.5 0 64 point 499983.012,499979.631,399.483 -text @ 0.5 0 65 point 499988.163,499979.942,399.783 -text @ 0.5 0 66 point 499992.801,499980.186,399.636 -text @ 0.5 0 67 point 499992.94,499977.44,399.608 -text @ 0.5 0 68 point 499988.168,499977.868,399.692 -text @ 0.5 0 69 point 499984.371,499977.741,399.573 -text @ 0.5 0 70 point 499982.123,499977.9,399.489 -text @ 0.5 0 71 point 499977.999,499978.328,399.464 -text @ 0.5 0 72 point 499973.236,499977.189,399.542 -text @ 0.5 0 73 point 499974.049,499974.116,399.347 -text @ 0.5 0 74 point 499978.113,499974.696,399.125 -text @ 0.5 0 75 point 499981.796,499975.235,399.328 -text @ 0.5 0 76 point 499984.281,499976.199,399.413 -text @ 0.5 0 77 point 499989.083,499975.842,399.424 -text @ 0.5 0 78 point 499992.068,499975.326,399.26 -text @ 0.5 0 79 point 499993.022,499975.3,399.29 -text @ 0.5 0 80 point 499991.772,499973.995,399.139 -text @ 0.5 0 81 point 499989.046,499974.677,399.312 -text @ 0.5 0 82 point 499984.251,499975.17,399.179 -text @ 0.5 0 83 point 499984.356,499973.293,399.145 -text @ 0.5 0 84 point 499981.792,499974.879,399.009 -text @ 0.5 0 85 point 499981.602,499973.412,398.855 -text @ 0.5 0 86 point 499978.248,499974.117,398.95 -text @ 0.5 0 87 point 499977.798,499973.22,398.886 -text @ 0.5 0 88 point 499973.634,499972.835,399.25 -text @ 0.5 0 89 point 499974.111,499969.103,399.053 -text @ 0.5 0 90 point 499975.622,499970.14,398.96 -text @ 0.5 0 91 point 499976.17,499972.461,399.102 -text @ 0.5 0 92 point 499972.35,499985.121,400.041 -text @ 0.5 0 93 point 499973.397,499985.282,400.048 -text @ 0.5 0 94 point 499973.205,499986.147,400.033 -text @ 0.5 0 95 point 499974.301,499968.156,398.987 -text @ 0.5 0 107 point 499977.021,499968.121,398.887 -text @ 0.5 0 108 point 499977.594,499965.842,398.843 -text @ 0.5 0 109 point 499974.21,499965.576,399.009 -text @ 0.5 0 110 point 499974.568,499963.862,399.034 -text @ 0.5 0 111 point 499976.995,499964.141,398.997 -text @ 0.5 0 112 point 499978.364,499964.085,398.824 -text @ 0.5 0 113 point 499978.972,499964.31,398.622 -text @ 0.5 0 114 point 499981.326,499964.313,398.585 -text @ 0.5 0 115 point 499978.594,499963.398,398.811 -text @ 0.5 0 116 point 499976.332,499963.096,398.865 -text @ 0.5 0 117 point 499973.872,499962.837,398.811 -text @ 0.5 0 118 point 499981.658,499960.347,398.375 -text @ 0.5 0 119 point 499979.346,499959.882,398.44 -text @ 0.5 0 120 oint 499978.739,499959.878,398.651 -text @ 0.5 0 121 point 499973.755,499959.723,398.664 -text @ 0.5 0 122 point 499973.16,499959.062,398.616 -text @ 0.5 0 123 point 499956.65,499959.314,398.661 -text @ 0.5 0 143 point 499971.386,499987.077,399.886 -text @ 0.5 0 148 point 499968.857,499986.909,399.882 -text @ 0.5 0 149 point 499969.217,499983.092,399.321 -text @ 0.5 0 150 point 499971.428,499983.335,399.777 -text @ 0.5 0 151 point 499971.809,499977.634,399.511 -text @ 0.5 0 152 point 499969.896,499977.408,399.526 -text @ 0.5 0 153 point 499972.621,499970.526,399.119 -text @ 0.5 0 154 point 499970.34,499970.326,399.164 -text @ 0.5 0 155 point 499973.143,499966.432,398.895 -text @ 0.5 0 156 point 499970.691,499965.792,398.761 -text @ 0.5 0 157 point 499973.36,499963.49,398.893 -text @ 0.5 0 158 point 499970.942,499963.411,398.691 -text @ 0.5 0 159 point 499972.944,499960.61,398.698 -text @ 0.5 0 160 point 499968.843,499963.206,398.743 -text @ 0.5 0 161 point 499968.31,499959.583,398.646 -text @ 0.5 0 162 point 499968.177,499961.529,398.663 -text @ 0.5 0 163 point 499964.561,499959.025,398.566 -text @ 0.5 0 164 point 499964.334,499961.15,398.659 -text @ 0.5 0 165 point 499961.139,499958.69,398.529 -text @ 0.5 0 166 point 499960.826,499960.832,398.681 -text @ 0.5 0 167 point 499957.378,499959.445,398.553 -text @ 0.5 0 168 point 499957.297,499960.563,398.625 -text @ 0.5 0 169 point 499961.331,499954.441,398.384 -text @ 0.5 0 170 point 499963.879,499954.639,398.388 -text @ 0.5 0 171 point 499960.512,499951.05,398.31 -text @ 0.5 0 172 point 499974.214,499939.387,397.713 -text @ 0.5 0 215 point 499973.963,499943.485,397.722 -text @ 0.5 0 216 point 499977.492,499945.218,397.746 -text @ 0.5 0 217 point 499978.084,499939.743,397.704 -text @ 0.5 0 218 point 499977.019,499949.209,397.89 -text @ 0.5 0 219 point 499974.073,499949.441,398.016 -text @ 0.5 0 220 point 499973.903,499954.409,398.233 -text @ 0.5 0 221 point 499975.96,499954.572,398.143 -text @ 0.5 0 222 point 499983.237,499953.421,398.159 -text @ 0.5 0 223 point 499983.664,499947.342,398.021 -text @ 0.5 0 224 point 499983.744,499943.294,397.878 -text @ 0.5 0 225 point 499983.874,499940.408,397.875 -text @ 0.5 0 226 point 499987.751,499955.284,398.183 -text @ 0.5 0 227 point 499988.553,499950.146,398.119 -text @ 0.5 0 228 point 499988.987,499946.071,397.983 -text @ 0.5 0 229 point 499988.501,499943.425,397.937 -text @ 0.5 0 230 point 499988.477,499941.009,397.958 -text @ 0.5 0 231 point 499993.481,499941.407,398.023 -text @ 0.5 0 232 point 499993.505,499945.086,397.885 -text @ 0.5 0 233 point 499993.428,499949.678,398.123 -text @ 0.5 0 234 point 499993.063,499955.456,398.181 -text @ 0.5 0 235 point 499993.007,499955.639,398.273 -text @ 0.5 0 245 point 499992.899,499956.964,398.277 -text @ 0.5 0 246 point 499991.643,499956.822,398.268 -text @ 0.5 0 247 point 499991.762,499955.528,398.269 -text @ 0.5 0 248 point 499993.869,499961.107,398.379 -text @ 0.5 0 249 point 499992.668,499961.2,398.395 -text @ 0.5 0 250 point 499993.552,499966.376,398.826 -text @ 0.5 0 251 point 499992.302,499966.417,398.654 -text @ 0.5 0 252 point 499993.298,499970.203,398.976 -text @ 0.5 0 253 point 499992.109,499970.262,398.796 -text @ 0.5 0 254 point 499993.167,499973.389,399.041 -text @ 0.5 0 255 point 499992.033,499973.379,399.075 -text @ 0.5 0 256 Edited May 21, 2012 by Tiger added codetags Quote Link to comment Share on other sites More sharing options...
Decker Posted October 8, 2014 Share Posted October 8, 2014 *Thread revive* What if I wanted the point to be a specific block/object I.E. I made a + symbol? Thanks Scott Quote Link to comment Share on other sites More sharing options...
BIGAL Posted October 9, 2014 Share Posted October 9, 2014 Look at the previous post by Mayromitsos replace point number on end with + , simpler as the suggestions are to use excel to make a script just use DDPTYE a + is a supported style. Quote Link to comment Share on other sites More sharing options...
sunji_lacsi Posted July 16, 2015 Share Posted July 16, 2015 Hi,You can create a script in excel and copy and paste in command line Let see your example 1st - open excel/and copy your sheet 2nd - you have to create two commands a) insert point b) create text a same place of your point and get indicator value Well in colonne D or over type this formula ="point "&c2&" -text @ 200 0 "&b2&" " explanations " - explain to excel is text point - command point space - means enter & - means contaner use to add text c2 - cell where you have x,y -text - command single line @ - take lastpoint for base point 200 - height of text for exemple 0 - rotation=0 b2 - cell where you have indicator now click and drag your formula till the last line and after copy all lines of this colunm last paste directly in command line. Dont forget one thing use space for enter I attached an excel table good luck Pascal thank you so much for sharing this.... Quote Link to comment Share on other sites More sharing options...
rvpas Posted July 16, 2015 Share Posted July 16, 2015 Thanks guys ! Quote Link to comment Share on other sites More sharing options...
Twamgle Posted March 14, 2018 Share Posted March 14, 2018 I know this was nearly six years ago - but thanks. I wanted to plot the location of 400 or so incidents on mapping along with the severity and this was so much easier than my previous polyline method, and then inserting points at the grips! Quote Link to comment Share on other sites More sharing options...
Vittorio Posted March 14, 2018 Share Posted March 14, 2018 Hello all, i have 2500 points that i want to import, i have them in an excel file in the right way, and i can import them using multiple>point copy/paste. but i alsoo need to label them, up or down the point maybe to put an indicator. the ideea it's to create a grid, then manually using my eye to draw some line between this value, like drawing some same temperature/same pressure lines. any ideeas? thanks i just have 2 excel columns Object name | Indicator | (x.y) 1 3.31 323232,534343 2 5.02 2323232,2323232 3 23.09 2323232,2323232 etc... at this moment i'm just copy the (x,y) column, then in autocad command line i am typing multiple > point then paste. the problem is that i want also to automatically import the indicator. then using the point style format, to see the points as little circles, and the Indicator will be inside the circle. This is all i want. The next part, with drawing the splines like in interpolation i can do it manually, because i'm just interested in a small number of splines, but for the grid i have something like 2500 points. I want to import something like this in AutoCAD which is the simplest and fastest way? *Thread revive*What if I wanted the point to be a specific block/object I.E. I made a + symbol? Thanks Scott Hi guys! Hope this is not too late, but there are several AutoLISP programs/scripts out there that do the job just as desired: A very versatile Point Manager Program from Lee Mac: http://www.lee-mac.com/ptmanager.html A point import tool with various options (options are kinda tricky - one hast to edit the code in Notepad): http://www.hawsedc.com/gnu/pointsin.php Another point import tool with many options (eg. insert a block with point attributes): http://www.jefferypsanders.com/autolisp_IMPORTXYZ.html And finally one of my favourites, yet another point import tool and a point block with attributes: The AutoLISP: http://www.cadforum.cz/cadforum_en/download.asp?fileID=613 The block: http://www.cadforum.cz/catalog_en/block.asp?blk=8520 The tutorial: http://www.cadforum.cz/cadforum_en/import-a-xyz-coordinate-file-as-autocad-points-with-labels-tip8496 Hope it helps you and any future user post. 1 Quote Link to comment Share on other sites More sharing options...
shadi Posted November 5, 2022 Share Posted November 5, 2022 On 3/14/2018 at 9:25 PM, Vittorio said: Hi guys! Hope this is not too late, but there are several AutoLISP programs/scripts out there that do the job just as desired: A very versatile Point Manager Program from Lee Mac: http://www.lee-mac.com/ptmanager.html A point import tool with various options (options are kinda tricky - one hast to edit the code in Notepad): http://www.hawsedc.com/gnu/pointsin.php Another point import tool with many options (eg. insert a block with point attributes): http://www.jefferypsanders.com/autolisp_IMPORTXYZ.html And finally one of my favourites, yet another point import tool and a point block with attributes: The AutoLISP: http://www.cadforum.cz/cadforum_en/download.asp?fileID=613 The block: http://www.cadforum.cz/catalog_en/block.asp?blk=8520 The tutorial: http://www.cadforum.cz/cadforum_en/import-a-xyz-coordinate-file-as-autocad-points-with-labels-tip8496 Hope it helps you and any future user post. thank u very much , the pointsin lisp is very useful , i tried it ... that helped me a lot to insert block of points with attributes Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.