Importing Coordinates into AutoCAD

[lewissheen24]

Hello,

 

I am having difficulty importing coordinates into AutoCAD 2011.

 

The formats i am trying import are CSV and TXT files.

 

Is there any quick ways to do this?

[Organic]

See http://www.lee-mac.com/ptmanager.html

[Murph_map]

An old post but still works http://map3d.wordpress.com/2006/06/25/points-from-a-text-file/

[BIGAL]

Bringing them in is easy what do you want to do with them ? Point, labels, co-ords, labels, surface model ??

[lewissheen24]

BIGAL - I would like the coordinates to be marked by a cross and have a label next to them, so when i set the points out i know which is which.

 

Also would you know how to export coordinates of points that i pick the centre of.ideally so i can put them into a excel sheet and download them to the survey instrument.

 

I am a AutoCAD novice so any help would be greatly appreciated, and depending how complicated the process is i may need a step by step guide.

[Organic]

What you want to do can be easily done in any survey software package, although AutoCad is not the right tool for the job. You would be better off using AutoCad Civil 3D or any other survey/civil program for importing/exporting points from equipment, survey calcs, creating DTMs etc.

[BIGAL]

Best way is if you want a cross and a lable is to use a block with attributes the advantage is then you can do step 2 very easy find certain block points and export the data CSV this you can read straight into most instruments.

 

Have a look at Lee's ptmanager first and if it doesn't do what you want come back, also let us know if it does meet your needs. Threre is heaps of point stuff out there.

[lewissheen24]

Ok cheers. I have sorted how i show the x,y coordinates, so they show like this:

 

X = ........

Y = ........

 

I am trying to do the lee-mac - writecsv http://www.lee-mac.com/writecsv.html , but it is coming up with an error.

 

Select objects: 1 found

Select objects: ; error: no function definition: LM:LST->CSV

 

All i have done is added this code to the command bar.

 

 

(defun LM:WriteCSV ( filename data / file sep )
   (if (setq file (open filename "w"))
       (progn
           (setq sep (ascii (cond ((vl-registry-read "HKEY_CURRENT_USER\\Control Panel\\International" "sList")) (","))))
           (foreach line data
               (write-line (LM:lst->csv line sep) file)
           )
           (close file)
           t
       )
   )
)

 

any help would be good

Edited January 28, 2013 by SLW210
Code TAGS!!

[SLW210]

Please read the CODE POSTING GUIDELINES and place your Code in Code Tags.

 

Not sure what you mean by "added this code to the command bar". You should just need to save the .lsp to a folder in AutoCAD's search path then load.

 

Here is a Lee Mac Tutorial-- How to Run an AutoLISP Program

[lewissheen24]

Got it working finally. thanks guys.

 

Is there any way i can export a coordinate with a name so it appears like this:

 

Name.....X........Y........Z.........

 

As always any help would be good.

[BIGAL]

A csv file can be in any format POINT X Y Z DESCRIPTION

PENZ

PNEZD

ENZD

 

You can start with simpler import points routine and customise one to suit your needs but have you really looked at the options within Lee-mac's point manager particuarly the block option.

[NEXTMARCUS]

Try this post:

 

http://www.cadtutor.net/forum/showthread.php?72677-Import-coordinates-from-a-text-file-txt-(sdr-csv)-in-AutoCAD

 

its a program made by Geobuilder.

 

Sorry about my very bad english

[lewissheen24]

BIGAL

 

How do you export x y name then?

 

And how do you import x y name?

 

Could you provide indepth instructions?

[BIGAL]

You need to post a picture/dwg of what you want it can all be done.

[lewissheen24]

Importing.docxPlease see attached files, indepth instruction would be great.

Exporting.docx

[BIGAL]

1st Simplest way is to create a block with the marker and 3 attributes. Label, X & Y set up the way you want them to look

 

In excel you can make the commands to create this all in one step

 

Using contenate you join the relevant columns to make 1 single column

 

Insert yourblockname x,y rotation scalex scaley scalez attrib1 attrib2 attrib3

Insert yourblockname x,y rotation scalex scaley scalez attrib1 attrib2 attrib3

Insert yourblockname x,y rotation scalex scaley scalez attrib1 attrib2 attrib3

 

This example inserts points just copy column F and paste onto command line.

 

 

Do one manully and write down every question that autocad asks this what you need to duplicate.

 

2nd part export is even easier if you have made the blocks just use DATAEXPORT it will do it all for you.

[lewissheen24]

I can make the block with the attributes, the rest i can't understand .

 

Your going to have to provide instruction step by step, not missing out any steps.

 

Treat me like a idiot!