User defined CSV export formats
You can define the CSV format to export point related measurement data in Penmap Project Manager.
Once the project is complete and uploaded to Trimble Connect, you can use the CSV format you have defined at download.
The defined CSV format can also be used to export the project from Penmap for Android.
To define the CSV export format
- Select the Trimble Connect project in Penmap Project Manager.
- Click Settings.
- Select the User defined CSV formats tab.
- Click Add.
- Edit the Format string field as required:
- Remove any parameters not needed.
- Make sure the order of parameters is correct. You can change the order of parameters if required.
Make sure each parameter is followed by a separator. By default this is a comma.
For more information, see the following sections: Example format string and Available format string parameters.
- Select the Add format as a header line to export file check box.
- Click Save.
To export CSV files from the project
- Select the Trimble Connect project in Penmap Project Manager.
- Click Download.
- In the Export field, select the required CSV format.
Example format string
Refer to the following example format string for a GNSS point with all parameters:
[PointId],[FeatureCode],[Northing:Meter:3],[Easting:Meter:3],[Elevation:Meter:3],[Latitude:Degree:9],[Longitude:Degree:9],[EllipsoidHeight:Meter:3],[Pdop],[Rms3D:Meter:3],[Rms2D:Meter:3],[SatEpochs],[SatCount],[SatQuality],[CorrectionMode],[AntHeight:Meter:3],[AntOffset:Meter:3],[UtcDateTime],[PointType]
This format string gives the following export result:
7,3,5807299.068,32529273.978,54.337,52.415131,9.430413,97.218,2,1.148,0.68,5,11,Float,Ntrip,2.065,0.065,2020-11-18 13:08:04Z,GPSPoint
Available format string parameters
Each parameter is written inside square brackets "[ ]".
Units and parameters are not case sensitive.
The following parameters are supported only for GNSS points:
[Latitude],[Longitude],[EllipsoidHeight],[Pdop],[Rms3D],[Rms2D],[SatEpochs],[SatCount],[SatQuality],[CorrectionMode],[AntHeight],[AntOffset],[UtcDateTime]
Available units
For some parameters, units and decimals can be set using the format string. For example, [Northing:UsFeet:2] will export northing with 2 decimals in US Feet coordinates.
Meter, UsFeet, Feet can be used for:
[Northing:Meter:3],[Easting:Meter:3],[Elevation:Meter:3]
[EllipsoidHeight:Meter:3]
[Rms3D:Meter:3],[Rms2D:Meter:3],[AntHeight:Meter:3],[AntOffset:Meter:3]
Degree is only for:
[Latitude:Degree:15],[Longitude:Degree:15]
UtcDateTime is the UTC time exported in the format yyyy-MM-dd hh:mm:ss Z, for example 2008-03-09 16:05:07Z.
Using the parameter without defining the units or decimals, or if the unit value is not recognized, will export the default values as described in the example string. For example [Northing] is exported in meters with 3 decimals.
Value separator
The values are separated as written in the format string:
[PointId],[FeatureCode],[Northing:Meter:3],[Easting:Meter:3]
7,3,5807299.068,32529273.978
If you prefer a different separator, for example “;” you just have to replace the “,”
[PointId];[FeatureCode];[Northing:Meter:3];[Easting:Meter:3]
7;3;5807299.068;32529273.978
The decimal separator is set to “.”. You can change this separator in your CSV file editing software. For example, in Excel select the Data tab, then select Get Data / From File to import your csv file and adjust the separator if needed.
Parameters with special values
| Parameter | Description | Possible export values |
|---|---|---|
| PointID | Point number | |
| FeatureCode | Code stored to the point, for example from the iFeature | |
| SatQuality | Quality of the GNSS measurement |
|
| CorrectionMode | Received type of correction data |
|
| PointType | Type of point generation |
|
