Configure Data Visibility

Configure Data Visibility

DSWeb provides multiple layers of control over the publishing and visibility of data in your DataSight database. Generally, the steps to configure data visibility are:

  1. Select databases that DSWeb will publish. You may have multiple DataSight Enterprise databases. This option allows you to connect or disconnect each database to web browser access via DSWeb.
  2. Select stations (Level 3 in DataSight Enterprise) within each database that will be published.
  3. Select the variables from each station that will be published.
  4. Create user accounts.
  5. Select the stations that each user is permitted to view (User Stations).
  6. If desired, control visibility of specific data records by their DataSight flag status (Flags) and user permission (User Flags).

Add Database Wizard

This wizard provides a stepped process to add visibility of a new database, plus its stations and variables. To start, click Add Database Wizard from the Administrator Menu.

 

Step 1: Add Database

  1. From the DataSight Database dropdown list, select the database that you wish to add. If your desired database is not shown in this list, it is likely that appropriate SQL Server privileges have not been configured.
  2. Edit the database details as required (alias name, description, etc) and click Next.

 

Step 2: Add Stations

  1. Enable visibility of specific stations via the check boxes in the Select column. Click Next.

 

Step 3: Add Variables

  1. Select a station from the station list by clicking the Select    button.
  2. Enable visibility of specific variables from that station via the check boxes in the Select
  3. Click Add Selected Variables at the bottom of the variable list to save these settings.
  4. Repeat the previous 3 steps for each additional station. When done, click Finish.

Databases

This page provides controls for:

  • Database connections: Add or delete DSWeb connections to DataSight Enterprise databases.
  • Alias name: the name that will appear in the data tree instead of the actual SQL Server database name.
  • Description: a description of the database that will appear as a tooltip pop-up when the mouse is held over the database alias name in the data tree.
  • Banner: the banner to be displayed with a specific database.
  • Logo: the logo/image to be displayed with a specific database.

 Note:

When you delete or remove a database from DSWeb it only deletes or removes the access link, not the actual DataSight SQL Server database.

 

Edit an existing database connection

  1. Select the exiting database connection by clicking the Select    button in the list of databases.
  2. In the Selected Record panel, edit details as required.
  3. Click the Save Record    button.

 

Add a new database connection

  1. Click the New Record    button in the Selected Record panel.
  2. From the DataSight Database dropdown list, select the desired database.
  3. Edit the New Record details as required.
  4. Click the Save Record    button.
  5. Alternatively, use the Add Database Wizard on the main Administrator menu to create a new database connection and work through other configuration steps.

 

Delete an existing database connection

  1. Select the database connection by clicking the Select    button in the list of databases.
  2. Click the Delete Record    button.
  3. Click OK to confirm deletion.

Levels

DSWeb will only display data from 'visible' stations. To allow data from a station to be visible via DSWeb, proceed as follows:

  1. In the Administrator Menu, click Levels.
  2. Select the DataSight database from the dropdown list. All levels in that database will then be listed.
  3. Enable or disable station visibility via the check boxes in the Select column.
  4. Select a standard, if applicable, to apply to the station data. This will allow any exceeding values to show as red in the corresponding variable graphs.
  5. Choose the range of time, in hours, over which the pin will remain alarmed as red on the site map before reset to the default blue colour.
  6. Click Save.

This process effectively gives DSWeb permission to publish data from the selected levels. However, additional security and visibility settings are required for variables and users.

Variables

DSWeb will only display data from 'visible' variables. To allow specific variable data from a station to be visible via DSWeb, proceed as follows:

  1. In the Administrator Menu, click Variables.
  2. Select the DataSight database from the dropdown list.
  3. Select the station from the Stations dropdown list.
  4. Enable or disable variable visibility via the check boxes in the Select column.
  5. If you also want this variable to appear as a graph on the Overview Page, check the box in the Overview column. Also check the Graph Invert option if the graph is to be inverted.
  6. Click Save.
  7. Repeat the above steps for each station.

Users

This page provides controls for user accounts, including:

  • Log-in credentials - User names and passwords
  • User level - Standard User or Administrator
  • Overview page visibility and data import permissions

Additional settings for users are found under User Stations and User Flags.

 

The DSWeb user list is independent of the DataSight Enterprise or SQL Server users. Creating, deleting or editing a DSWeb user will not delete or change any user information in the DataSight Enterprise configuration.

 

To add a new user

  1. Click the New Record    button in the Selected Record panel.
  2. In the Selected Record panel, enter the user details.
  3. Click on the Save Record    button.

 

To edit an existing user

  1. Select the exiting user by clicking the Select    button in the list of users.
  2. In the Selected Record panel, edit details as required.
  3. Click the Save Record    button.

 

To delete an existing user

  1. Select the user by clicking the Select    button in the list of users.
  2. Click the Delete Record    button.
  3. Click OK to confirm deletion.

User Access to Levels

A DSWeb user must have permission to view each level. To set the stations that will be visible to each user, proceed as follows:

  1. In the Administrator Menu, click User Access to Levels.
  2. Select the User from the dropdown list.
  3. Enable or disable station visibility via the check boxes in the Select column.
  4. Click Save.
  5. Repeat the above steps for each user.

Flags

DataSight allows custom data flags to be applied to data records. For example, data that has been fully quality assured and approved for reporting and publishing might be flagged as "Approved for publishing". Such flags in the DataSight database present an additional opportunity to restrict data visibility via DSWeb. Continuing the above example, DSWeb might be configured to only display data that has the "Approved for publishing" flag.

 

To permit DSWeb to use flags that exist in a database, proceed as follows:

  1. In the Administrator Menu, click Flags.
  2. Select the DataSight database from the dropdown list. All flags in that database will then be listed.
  3. Enable or disable flag use via the check boxes in the Select column.
  4. Click Save.
  5. Repeat the above steps for each database.
  6. Proceed to User Flags to restrict/permit visibility of flagged data by user.

User Access to Flags

  1. In the Administrator Menu, click User Access to Flags.
  2. Select the User from the dropdown list.
  3. Enable or disable visibility of data with specific flags FOR THAT USER via the check boxes in the Select column.
  4. Click Save.
  5. Repeat the above steps for each user.
    • Related Articles

    • Import Data

      Open a desired Station Table. Click Import Data. Select Manual Data Entry or Import Data File. Manual Data Entry Enter date, time and your variable value. Click Save. Import Data File Browse to your file and select Open, then click Upload. Configure ...
    • Data Collection

      Your data collection history can be stored in DataSight together with the measured data. Any person who has been involved in the collection of data can be entered into your database using the Person grid view. The type of equipment used to capture ...
    • Configure your Web Server

      You can configure your web server as per your authentication details using IIS to run DSWeb 3. See Install IIS for more details. Install DSWeb 3. Open IIS of your computer. In the Connections panel, double-click your Computer. Then double-click ...
    • Refresh Data

      It is recommended, prior to leaving for the field, that you check the FTP connection is working and refresh the DataSight data being supplied in your linked files. The name of the linked DSApp Report is displayed on the Collect tab together with the ...
    • Data QA/QC

      Several DataSight features can be used to undertake quality assurance and quality control (QA/QC) of your data (refer also to Analyse Your Data). Standards and Flags are two tools that assist in managing your data validity and integrity. You should ...