Import many points together

[peshobe]

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.

[Strix]

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

[Bill Tillman]

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.

[peshobe]

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?

[eldon]

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?

[peshobe]

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?!

[eldon]

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.

[peshobe]

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

[eldon]

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

[peshobe]

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