Display full version of the post: Import point coordinates with id's

bmshutts
12.11.2009, 15:20
I have a long list of point id's and coordinates.  I would like to import these points along with the ID's with out having to manually find each point and label it.  Does it have to be in a block?  I would like to simply copy it from EXCEL into CAD.  I use     ID     X    Y  Z    or  ID,X,Y,Z format.
I can import the long list of points but how do I put the Labels with it?

CarlB
12.11.2009, 19:16
You could use a lisp routine (recently mentioned in the General forum) to place a block at each point, & include an ID & a (optional) description.
 
-or-
 
save excel data to a csv file, edit it to work as a script (.scr) file to automatically create the points and the text.
 
Points part of script would look like:
 
MULTIPLE
POINT
x1,y1
x2,y2
x3.y3
etc...
 
Then a script to place text next to the points:
 
TEXT
x1,y1 Height ID1 rotation [space or blank line to repeat the text command, may need to experiment]
x2,y2 Height ID2l rotation
etc..