Import many points together

Hi. Can I import all points, picked-up with Trimble total station in AutoCad 2009? I mean not one-by-one, but all simultaneously, using connection via a cable between total station and PC.

don't you download the Trimble info into it's own software as maybe a dxf then import it?

I don't know much about a direct cable connection method, but if you get the point data into an Excel file, there are several LISP files which will easily import them into ACAD available.

Sorry, Bill Tillman, I tried to enter the raw data in Excel file, but the way they look is not acceptable. Can you explane more how to enter these data in Excel?

Sorry, Bill Tillman, I tried to enter the raw data in Excel file, but the way they look is not acceptable. Can you explane more how to enter these data in Excel?

If you want a one step solution, then you should be using the Trimble software Trimble Survey Controller. It only costs!

For those of us seeking a more economical solution, the usual way is to download the data as a text file, and then import into AutoCAD. There are more lisps that use text files than use Excel format.

You say the way they look is not acceptable. Could you say what is not nice?

the way they look is not acceptable.

I successfully entered the data in an Excel file, but neither AutoCad nor LisCad open the file with measurements?!

I am getting confused here, but I guess that you mean is that when you imported the Excel file into AutoCAD, you saw a spreadsheet in AutoCAD. Not very useful for you, but that is what happens with Excel.

DO NOT USE AN EXCEL FILE unless Bill Tillman would be so kind as to outline his method.

First of all you wanted to download from the total station directly into AutoCAD. If you have paid lots of money for the software that belongs to the total station, you probably can download a DXF file.

Most surveyors that I know download the X, Y, Z data file as a text file. Then using a Lisp routine, that file is turned into points in AutoCAD. One very good lisp site is Jeffrey Sanders and he has a very good lisp called IMPORT XYZ.

Hi, Eldon, I opened the program citied above which got the data from the Total stations, but it shows only the Z-values in the spreadsheet?!.

I do not understand what data you have got. Could you please post your data file that you have downloaded from the total station.

0001 INPUT T_ 0 P 948 PC -0.018

0002 KN STAT

0003 A 0 X 51455.581 Y 43574.864

0004 A 0 Hz 121.4115 V1 98.5810

0005 Om 198.0085

0006 S 0 X 51362.081 Y 43817.644 Z 0.000

0007 POLAR

0008 INPUT m 1.000000

0009 10 SD 103.070 Hz 127.3025 V1 100.0215

0010 10 X 51319.220 Y 43911.380 Z -0.034

0011 KN STAT

0012 A 0 X 51362.081 Y 43817.644

0013 A 0 Hz 201.6705 V1 100.4065

0014 Om 274.3680

0015 S 10 X 51319.220 Y 43911.380 Z -0.034

0016 KN STAT

0017 A 0 X 51362.081 Y 43817.644

0018 A 0 Hz 327.3035 V1 100.4055

0019 Om 0.0005

0020 S 10 X 51319.220 Y 43911.380 Z -0.034

END

There is slightly disarrangement after "copy-paste".

That download is not very useful for putting into AutoCAD. It tells me that your length units are metres and your angular units are grads, and the actual measured angles and distances are recorded together with other information.

You will have to explore your total station, and find out how it will download a coordinate file with point numbers if you have them (point numbers are necessary to identify points when they are in the drawing). Until you have found that out, then I cannot help you.

Hi Eldon,

Maybe I chose a bad example. I get the co-ordinates from my Total station normally. At Monday morning I'll be at office and I'll send the proper file.

Good bye for the present.

Try this link

http://www.jefferypsanders.com/autolisp_IMPORTXYZ.html

This one will import from a text file or directly from an Excel file.