Excel Worksheet Import Configuration dialog for importing station data

This dialog appears when you do the following:

1. Start the Trimble 4D Control Server UI with Windows administrator rights.
2. From a station data dialog, such as the Station Information (GNSS) dialog, select the Import > Excel Worksheet command for importing station data. A Windows file importer dialog opens.
3. Select and open an Excel file containing station data in data formats which Trimble 4D Control Server support.

Use the 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 station data.

Tip - Imported station data 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 station data to be recognized and imported

• Station data must follow each other in rows.
• Stations have to be identified by a unique station code and a station name.
• Column headers may be arbitrary. As long as the content of a column matches a station property, the column headers are not important. In this case, one assigns the columns of the Excel worksheet to the properties.
• However, all columns with headers that are identical to station property names can be assigned to the respective properties in one step.
• The number of worksheet columns is arbitrary; the worksheet may contain more or less information than is needed for the station to be set up.
• The station information can be split up into several worksheets, which can be imported in arbitrary order. If a data file contains less information than is required, the missing data can be imported in a next step.
• Trimble 4D Control Server must support the data formats and value ranges of the station properties given in the Excel file. If for a property the data format or the value does not conform to the Trimble 4D Control Server rules, the cell validation results in an error. Its contents will not be imported. Errors (and warnings) are output in a log file (see below).

List of valid parameters and settings for station 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 station properties

The Excel Worksheet Import Configuration dialog displays two tables.

• The left-side table contains the single Excel Worksheet Column column displaying the header names of all columns in the selected worksheet.
• The right-side table is a list of all settable station properties. When one first imports an Excel worksheet, the second column of that table, the Excel Column Assignment column, is empty. An asterisk marks those properties, which are required to be available in the import file.

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

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

• If one, several, or all column headers of the Excel worksheet match one, several, or all property names, click Default All. This automatically fills the Excel Column Assignment column of the right table with the matching column headers.
• For assigning a single column to a single property, set the focus onto the column header name in the right table and drag it to the matching row in the left table. This fills the Excel Column Assignment column of the left table with the selected column header.
• For assigning several columns to several consecutive properties, use the default Windows selection methods, such as left-clicking in combination with the Ctrl and Shift keys, then drag the selected items to the first matching property row in the right table.

  Tip - When dragging several items, they are assigned to consecutive Property rows.

• For removing all assignments from the left table, click Empty All. For removing the assignments of selected properties, click Empty Selected.

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 station data

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

1. 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. This file contains output messages of the INFO, WARN(ing), and ERRO(r) types. Use this file for a first information source on how well the import has succeeded.
2. One of the following happens:
   • If for all imported stations only identical station information is found in the global station list, importing is skipped.
   • In any other case, the Station Data Import dialog appears for the first differing or new station. Use it to add new stations or update existing ones.