import points with label

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

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

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.

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.

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.

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

Hi Pascal,

great stuff. So simple and works so effectively.

Cheers

Bruno

I did the same job with 58000 points. It worked perfect.

rvpas, thank you for your script!

I want to import something like this in AutoCAD which is the simplest and fastest way?

cote k-lumea.txt

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 

*Thread revive*

What if I wanted the point to be a specific block/object I.E. I made a + symbol?

Thanks Scott

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.

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....

Thanks guys !

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!

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.

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