Format File Leica 1200

if you import to LGO, look for the small icon on the bottom left of the import window. it looks like a small text icon with a capital 'A' on it. that is a copy text button. these can be dropped into text files or spreadsheets.

if not, check your technical reference manual for writing custom format files.

it can be done, it just might take some reading and trials

> Hi,
>
> I was wondering whether it is possible to group Points (Point ID). So say I measured points 1, 2, 3 repeatedly would it be possible to export these in a gsi file from the instrument grouped. So all points 1 in one table, all 2 points in a second table etc?
>
> Point ID Hz A Vz A Slope Distance
> 1 150.5 89.25 23.2
> 1 150.5 89.25 23.2
> 1 150.5 89.25 23.2
> 1 150.5 89.25 23.2
> 1 150.5 89.25 23.2
> 1 150.5 89.25 23.2
>
> Point ID Hz A Vz A Slope Distance
> 2 180.5 92.25 26.2
> 2 180.5 92.25 26.2
> 2 180.5 92.25 26.2
> 2 180.5 92.25 26.2
> 2 180.5 92.25 26.2
> 2 180.5 92.25 26.2
>
>
>
> Much obliged in advance,
>
> Andreas

Andreas,

write your format file to export each TPS measurement in the format you show above. import your job into LGO. use the export ascii option and change the settings: choose the path to the format file you wrote, make sure you choose to sort by 'point id' not 'time' and make the only export the 'measured' class and none of the others. your file will look like what you posted above except for the table headers. you can paste those in yourself.

there is probably a way to export the table headers by using one of the data block export format strings as a dummy but it's not worth your time.

Hi Moe,

Thanks for the response, wasn't really expecting one till tomorrow.
Early bird catches the worm I suppose and all that. 🙂
Useful to know about the copy text button. But thats ok if all the surveyors using it have access to a Leica Geo Office which they don't unfortunately. We have created some spreadsheets where it would be useful to cut and paste from the GSI files directly into them. This is why I need to create a custom format file.
Which technical reference manual were you referring too, if you meant the one to the
Total Station, I checked it but not much in the way of custom format files there. Also the help in Leica format manager is a bit limited. It took me a while to discover enter was needed in the export format string for the file to list my points. The export preview showed a gap between points, it was only when I tested it I realised there was no gap, but if I didn't press enter the export preview showed exactly how I wanted my list. So was trying to avoid the whole searching, reading, trial and error before figuring out how to create the file I needed 😀
I welcome any further ideas though,

Thanks

Andreas

Hi Conrad,

Thanks, is it possible then to create a format file which I can transfer onto my Total Station so that it exports the data directly in that format, without having to do anything in Geo Office? That is, after I have created the format file in Geo Office and transferred it to the total station 🙂

Andreas

Format file export on total station.

> Hi Conrad,
>
> Thanks, is it possible then to create a format file which I can transfer onto my Total Station so that it exports the data directly in that format, without having to do anything in Geo Office? That is, after I have created the format file in Geo Office and transferred it to the total station 🙂
>
> Andreas

yes Andreas, you can transfer the format file (make a field one, not office) to the total station and export the file there.

now because you won't be able to edit the file on the total station you can produce the headers with the dummy string. in the format manager write your export file so that the measurements (Pt, Hz, V, SD) come out of the 'points (measured by TPS)' data block. you will use the plain 'points' data block to produce the header that you want to appear over the measurement groups. you will just enter the header as plain text. write it as you want it to appear in each of the headers using spaces to align the columns titles over the measurement data. put a carriage return above the header string to separate the last measurement from the next group header string. be sure to put a carriage return after the measurement blocks and the dummy headers, otherwise your file will just run on to one gigantic line of text.

when exporting ascii files you can apply the filter [F4] and choose to sort by 'ascend point id' and filter by 'class'; you want to show 'avge' and 'meas' only.

Format file export on total station.

Hi Conrad,

In all these years of surveying never saw that filter 🙂

Even so regardless I still only get the data in the below format, any ideas?

====================================================================================
Calibrations and Verifications
====================================================================================

Point ID Time HZ angle VZ Angle Slope Distance
----- -- ---- -------- -------- --------------
0001 14: 2:28 97.7789 67.5710 3.7898
0002 14: 2:49 103.4403 71.2287 4.2402
0003 14: 3: 8 107.8441 74.3112 4.7256
0001 14: 3:29 97.9183 67.5307 3.7862
0002 14: 3:48 103.5520 71.1992 4.2361
0003 14: 4: 5 107.8557 74.3261 4.7283
0001 14: 4:18 97.8534 67.5380 3.7863
0002 14: 4:35 103.5012 71.1898 4.2347
0003 14: 4:51 107.8539 74.3026 4.7240

====================================================================================
End of Data
====================================================================================

Its easy enough problem to fix once in Excel, I'm just trying to maximise efficiency 🙂

Do you think creating a code list would help sorting the data.

Format file export on total station.

i created a dummy job got mine to export exactly the way you were looking for. the header string is written from: data export>export formatstrings>data blocks>points. the measurements themselves come from data export>export formatstrings>data blocks>points (measured by TPS). they do not come from 'TPS measurements' just in case you are using it.

on the instrument during export ascii the filter [F4] settings are-
Sort: Ascend Point ID
Filter: Class
ctrl: hide
adj: hide
ref: hide
avge: show
meas: show
nav: hide
est: hide
none: hide

now the reason this should produce the correct order is it will sort out the point numbers first and display them in groups. the classes should order from highest to lowest within each group, 'avge' being higher than 'meas'. the 'points' export, which is used for the headers will print every time there is an average class point, and that should appear for every group of same point numbers. the measurements should fall below the group headers.

edit - my dummy job had a codelist but it was empty; no codes were attached to the points.

Format file export on total station.

Everyone is definitely on the right track about the details of the format file. There is one thing to add...

It looks like these are values that are coming straight from the Survey application. The stored points can be exported by Points, Points Only from TPS and Points only from GPS. I always used the Points export just to have a generic format file but a specific one like this one I would probably just select the export string group for TPS Points (measured by TPS).

Be sure that once you have your export strings selected and they are appearing in the top/middle window... double click on the export strings as they are shown with double,green brackets. This will open up the Formatting Options for the string you selected. You can choose allot of formatting options but be sure you select the correct Unit of Measure at the bottom for strings that have measurement values.

One thing I always forget is to go to the end of each string and select the enter key once to drop it down on line (you can have multiple line spaces if you want). If you do not do this the export will come out in one continuous line.

To transfer the format file to a System1200 instrument place the format file in the Convert folder on the CF card and place it back in the instrument. Then...

1. From main menu go to 6 Tools...
2. Next select 2 Transfer Objects..
3. The select 06 Format Files
4. Transfer from CF Card to System RAM

The format file is now on-board and can be ready to use. You can test these on the simulator or the instrument. Either way when you are tweaking out a format file and need to get a revised version on the equipment you can overwrite it in the steps above or delete it when viewing the list of format files.

Format file export on total station.

Bang on the Money 😀

It must have been the Points (Measured by TPS) as I had selected measured by TPS,

I now actually pay attention to the information displayed regarding the coding 🙂

Thanks Conrad

Format file export on total station.

Thanks for the reply,

Took me a while to figure out that with the enter (especially as the preview, displays it incorrectly), I mentioned it in a previous reply. Yes I'd worked that out with the formatting or my time wouldn't be displayed as nicely 🙂 I also work in Gons, so that was something I'd previously worked out. Conrad has given me the solution now, which works splendidly, but if you have any suggestions of how to achieve the same result without me having to use the filter, that would be tremendous.

Andreas

Format file export on total station.

> Bang on the Money 😀
>
> It must have been the Points (Measured by TPS) as I had selected measured by TPS,
>
> I now actually pay attention to the information displayed regarding the coding 🙂
>
> Thanks Conrad

no worries at all.

this situation is exactly what the filter is for. you will not be able to do without it because what you are doing is precisely, sorting and filtering.