Previous Topic

Next Topic

Book Contents

Book Index

Excel Worksheet Import Configuration dialog for importing GNSS Receiver data

This dialog appears when you do the following:

  1. Start the Trimble 4D Control Server UI with Windows administrator rights.
  2. From the File menu, select the Import Excel command for importing GNSS receiver data. A Windows file importer dialog opens.
  3. Select and open an Excel file containing receiver information in data formats which Trimble 4D Control Server supports.

Use the Excel Worksheet Import Configuration dialog to select a worksheet from the import file, to assign Excel column headers to Trimble 4D Control Server properties, and to start the import of receiver data. The receiver data will either update existing GNSS Receiver modules with current information. If for a receiver a GNSS Receiver module does not yet exist, a new GNSS Receiver module will be created and automatically added to the parent that is specified in the Excel data.

Tip - Imported GNSS Receiver modules will be available throughout the Trimble 4D Control Server system, independently of the currently active system configuration.

Warning - If previously any Excel file was not closed correctly and has to be recovered, the import might not function at once. First make sure that Excel is working as designed to.

Requirements for a valid Excel worksheet for GNSS receiver data to be recognized and imported

List of valid parameters and settings for receiver data to be imported from an Excel worksheet

Examples

Selecting the worksheet to be imported

Use the Excel Worksheet selection field for selecting the matching worksheet, if an Excel file contains more than one worksheets. By default, the first worksheet of an Excel file is selected.

Assigning Worksheet columns to GNSS Receiver properties

The Excel Worksheet Import Configuration dialog displays two tables.

For the importer to assign the data of the worksheet to the GNSS Receiver module, it must know which Excel worksheet columns match the GNSS Receiver module properties.

For assigning columns of the Excel worksheet to properties, do one of the following:

If you later re-import data from an Excel worksheet whose column headers match those already assigned to properties, the Excel Column Assignment column of the right table will automatically be pre-filled with the matching column header.

Starting the import of GNSS Receiver data

For reading in the data of the selected worksheet and starting the assignment of worksheet columns to GNSS Receiver properties, accept the dialog. The following happens:

  1. A progress window appears as long as the import is executed.
  2. When the import has finished, your standard text editor opens with the <Excel file name>.import.Log file displayed. This log file resides in your <User name>/AppData/Roaming folder. It contains output messages of the INFO, WARN(ing), and ERRO(r) types.
  3. Carefully read this log file, since it is your main information source on how well the import has succeeded.

Result of the data import

When the data import has finished the following has occurred:

See Also

Importing station and receiver data into the system

Excel Worksheet Import Configuration dialog for importing station data

Use of station data from IGS site logs

System properties

GNSS Receiver

Device Manager