Load Data

This section provides an overview of how to load data into Supervisor. For a more detailed explanation of all possible settings, see Data Loader Component.

Point Data or Block Data types can be loaded into Supervisor manually through the Menus, Toolbars or Project Tree. Data can be loaded in automatically by dragging and dropping supported files directly from an explorer window into the Project Tree. The loading process varies slightly depending on whether you load text data or SQL data.

Load Text Data

  1. In the Home menu, select [Point Data or Block Data] » [Data Type].

    The file explorer screen opens.

  2. Navigate to the data file and click Open.

    Note: Multiple files can be opened at once.

  3. Select which columns to import by checking the associated boxes in the Import Column in the Column Definition Table.
  4. Select the appropriate Mapping Type for each column.
  5. Set up the data grouping by selecting the grouping Name in the Configure the Loader Tab.

    Note: More complex grouping can be achieved by manually configuring the Grouping Table.

  6. Click Load Data in the Loader tab.

    The Load Summary Window displays.

    Note: After you load the data the information in the entries in the Column Definition Table is saved in the Column Definitions Window of the . This means that next time you import data the Data Loader recognises columns with the same name and restores the settings from the library.

  7. Assess and manage errors highlighted in yellow and red in the Load Summary Window.

Load SQL Data

Note: Data cannot be changed in Supervisor and written back to the data source. For example, data that is loaded from SQL server and modified in Supervisor is not written back to the original SQL server database.

  1. In the main toolbar, select Add Data » [Point Data or Block Data] » [Data Type].

    The SQL tab displays in the Property Panel.

  2. Enter the Sql Server in the SQL tab.
  3. Enter the SQL Username and Password or Use Windows Credentials.
  4. Enter the Connection String, if required.
  5. Click Connect to Sql Server.
  6. Select the Database.
  7. Select the Table within the Database.
  8. Enter the Where clause to select specific rows at the server side. If highlighted, then the loaded data and filter are out-of-sync.
  9. Click Load Data.