Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import Eastings/Northings into LT2000

Status
Not open for further replies.

FAM

Technical User
Jan 13, 2003
345
GB
I have about 30 points in an excel/text file consisting of Eastings/Northings/Comments, is it possible to import these automatically as points into a CAD File?
Im currently doing it manually.

Thanks in Advance
 
Hi,

Yes it is possible to what you need. Just one question though.....

What's a Easting or Northing? I presume that these are surveyors coordinates - is that correct?

To create ACADPOINTS in a drawing from a list of coordinates is really quite simple. If you email a copy of the excel file so I see what kind of info it is and how it's all layed out, I'll take a look at it and write a bit of code or program to help you. Please also write a more detailed description of exactly what you want and what everything does or needs to do..



Cheers,

Paul @ basepoint designz..


basepoint designz
renegade@tiscali.co.uk
 
They are surveyors coordinates but i wont be allowed to send you the file (Confidentalty Agreement) but its 30 line of basically
Comment Easting (m) Northing (m)
1 562 632.3 361 553.2
2 562 597.3 362 020.2

but i would like to be able to import them all as points or symbols into a dwg file.

Cheers


 
Since LT doesn't handle lisp you are limited to using a script. However a script may work just fine. If the point you want to create is a standard point entity and not a symbol with attributes, the following approach will work. A symbol with attributes could be accomplished similarily.

First delete the column with comment/point number. Save the excel file to csv format. You'll then have a text file with N & E separated by commas. At the top oif the file, type in AutoCAD commands to start the point function:

Multiple
point
E1,N1
E2,N
etc. etc

Save the file with a .scr file extension. Execute this file by typing SCRIPT within AutoCAD. After it runs you'll need to hit Escape to stop the multiple point command.

Good luck. Let us know if questions.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top