Use iCMTGIS PRO to export Feature data to Excel file

“I have a client that uses the Arrow 100 device connected to his Laptop computer. I was inquiring about capturing lat/long coordinates in Excel and they sent me to you and your software. My client records thousands of coordinates and loads them 1 by 1 into an Excel spreadsheet along with some other data. The ideal process we would like to set up is to have each measurement captured in real time by the device uploaded into Excel immediately. Is there a way to accomplish this with your software?”

iCMTGIS III and iCMTGIS PRO will let you record additional information with each GPS position in real time and save it to a Job file. When done collecting data for a bunch of points, you can export all the data to an Excel file. It does not save each record directly to Excel in real time. For Point Features, you can also export the data to a text file.

Advertisements

How to use iCMTGIS PRO to collect the points I require and then export the X, Y and Z data in a spread sheet?

1. Make sure your Arrow device is paired and connected with your iPhone/iPad as per the manufacturer’s instructions.

2. Under Setup – GPS mark the check box for Enable the external GPS, select the EOS GNSS receiver and use the protocol named com.eos-gnss.positioningsource.

Setup the threshold values accordingly (PDOP, RMS, etc) based on required accuracy.

Tap on the GPS icon at the top and select Turn GPS On. This will connect the app to the GPS receiver.

When prompted, select “Allow”.

3. Tap on the Topic Menu icon at the top and select New Topic.
Change the Topic Name to “GCP” for example.

Tap the Add button and change the Field Name to Control Number.
Tap the Add button then tap the little pull down arrow and select Position_X.

Tap the Add button then tap the little pull down arrow and select Position_Y.

Tap the Add button then tap the little pull down arrow and select Elev_Z.

Tap on OK.

4. Tap on the GPS icon at the top and select Collect.

5. Tap on the New button then tap on the little pull-down arrow and select your Topic Name (e.g. GCP).

6. The longer you occupy a station, the better the accuracy of the averaged position. Default is 20 seconds. This means you will stay at that location for 20 seconds without moving the GPS receiver.
Tap on OK.

7. Double-tap the Control Number field and enter the GCP number.

8. Tap the Store button. The app will start collecting GPS fixes.
At the end of the session it will store the point location.

9. Go to the next GCP and Tap the Store button to record that point.

10. When done recording all the points, tap the Exit button.

Tap the right-most icon at the top to display Sheet View.
This is the data you will be able to export.

Tap on Main Menu and select Job then select Export.
Select the Excel file format.

If you would like to export data to a text file, then tap the Topic Menu icon at the top then select Export Text File.

Tap the Export Preview button to see what you will be getting in the text file. Tap on OK to complete the export.

Farming GPS GIS III updated to version 1.0.1

This update fixes a bug found in the Export Excel file function.

Forester GPS GIS III updated to version 1.0.1

This update fixes a bug found in the Export Excel file function.

iCMTGIS III now supports iPhone mode

We are pleased to announce the release of iCMTGIS III version 1.1.0.
This update has an Export to Excel file bug fixed.
It also provides support for universal devices. Now you should be able to run this app on your iPad as well as on your iPhone.

Farming GPS GIS III for iPad released

Farming GPS GIS III provides the functionality of the Farming GPS GIS II app plus a number of new functions. Most of these new functions were ported over from the PC-GIS PRO office software.

1. Additional data import and export formats

You will also be able to import and export data in Excel and KML formats.
Point Features can be imported and exported via a text file.

2. Contour / Volume

You will be able to create a contour map based on elevation or an attribute.
The contour information will enable you to compute volumes.

3. Load GeoTiff image

You will be able to load a Geotiff image for use as background map.
Such a background map does not require wi-fi connection.
The .tif map image can be used in the Moving Map mode for data collection.

4. Classify

You will be able to classify the Features and place them on sub-layers.

5. Insert or delete nodes

Now you will be able to modify the shape of a Line or Area Feature.
by deleting some nodes or adding some nodes then moving the nodes.

6. Go to and Sort

Jump to a Feature record by specifying the search criterion.
You will also be able to sort the Features based on an Attribute.

7. Report statistics

You will be able to view the statistics for a numeric Attribute of a Feature.

8. Batch delete by text file
You will be able to delete specific Feature records based on a text file.

9. Disconnect Feature

You will be able to easily disconnect Line or Area Feature into Points.
You will be able to disconnect a Line or an Area Feature into Lines.
You will be able to disconnect an Area Feature into two sub-areas.

10. Join Features

You will be able to join Points into a Line or Area Feature.
You will be able join two Lines together to form a new Line.
You will also be able join two Areas together to form a new Area.
(This function replaces the Combine function of Farming GPS GIS II).

Forester GPS GIS III for iPad released

We are pleased to announce the release of Forester GPS GIS III.

In addition to the functionality of the Forester GPS GIS II app, this app provides the following additional capabilities:

1. Additional data import and export formats

You will also be able to import and export data in Excel and KML formats.
Point Features can be imported and exported via a text file.

2. Contour / Volume

You will be able to create a contour map based on elevation or an attribute.
The contour information will enable you to compute volumes.

3. Load GeoTiff image

You will be able to load a Geotiff image for use as background map.
Such a background map does not require wi-fi connection.
The .tif map image can be used in the Moving Map mode for data collection.

4. Classify

You will be able to classify the Features and place them on sub-layers.

5. Insert or delete nodes

Now you will be able to modify the shape of a Line or Area Feature.
by deleting some nodes or adding some nodes then moving the nodes.

6. Go to and Sort

Jump to a Feature record by specifying the search criterion.
You will also be able to sort the Features based on an Attribute.

7. Report statistics

You will be able to view the statistics for a numeric Attribute of a Feature.

8. Batch delete by text file
You will be able to delete specific Feature records based on a text file.

9. Disconnect Feature

You will be able to easily disconnect Line or Area Feature into Points.
You will be able to disconnect a Line or an Area Feature into Lines.
You will be able to disconnect an Area Feature into two sub-areas.

10. Join Features

You will be able to join Points into a Line or Area Feature.
You will be able join two Lines together to form a new Line.
You will also be able join two Areas together to form a new Area.
(This function replaces the Combine function of Forester GPS GIS II).