Updating of semantics from file Microsoft Office Excel (*.XLS)

Update semantics mode serves for change of semantic characteristics of map objects from file Microsoft Office Excel (*.XLS). This mode allows to add new semantic characteristics or to change values of already existing semantics.  

For an execution of the given mode it is necessary:  

1. To set a name of the open map.  

2. To set name of file Microsoft Office Excel (*.xls).  

3. To specify number of first and last row of the table, containing data.

4. To specify type of link of map's object and data from a file:

- by semantics (by the unique name of the semantic characteristic from the map classifier);

- by number of object.

5. To specify parameters of link:

- for type of link by semantics it is necessary to set up conformity between the name of the semantic characteristic and a standard name of a column of file Microsoft Office Excel (A, B, C …), containing value of the given characteristic. Values of the given column should coincide with values of semantics of objects during the moment of specifying the link.

- for type of link by number of object it is necessary to set a standard name of a column of file Microsoft Office Excel (A, B, C …),containing the value of object number.

6. To form the list of semantic characteristics for updating:  

- to press Add button. Into the list of semantic characteristics the record will be added in which the value of fields: Semantic name and Column name are Unknown

- to choose values of fields: Semantic name and Column name. The name of semantics (Column name) is selected from the list which becomes accessible after pressing the left mouse button of in the given field

At the included button: For selected objects in updating semantics the selected objects of a map are considered only.  

Append always mode allows to add some semantics with an identical code.  

In Append if absent mode one value of semantics is added.  

At the included button: Update at presence the values of already existing semantics will be changed (the button is active in a mode: Append if absent).  

With a view of increase in speed at stream updating of semantics of objects it is recommended to not write down the information into transactions log.  

The type of link of map objects and record of the data table should be established as one to one.  

If all parameters are filled correctly OK button becomes active.