psyfr3ak Posted May 27, 2010 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
eldon Posted May 27, 2010 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
psyfr3ak Posted May 27, 2010 Author 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
eldon Posted May 28, 2010 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
BIGAL Posted May 31, 2010 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
rvpas Posted May 31, 2010 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
brunolda Posted January 13, 2012 Posted January 13, 2012 Hi Pascal, great stuff. So simple and works so effectively. Cheers Bruno Quote
mayromitsos Posted January 25, 2012 Posted January 25, 2012 I did the same job with 58000 points. It worked perfect. rvpas, thank you for your script! Quote
paduroiul Posted May 3, 2012 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
mayromitsos Posted May 18, 2012 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
Decker Posted October 8, 2014 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
BIGAL Posted October 9, 2014 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
sunji_lacsi Posted July 16, 2015 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
Twamgle Posted March 14, 2018 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
Vittorio Posted March 14, 2018 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 1 Quote
shadi Posted November 5, 2022 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
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.