Appendix

WebUI Historical data interface

WebUI historical data interface is a rich HTML5 interface used for visualizing historical data. This section of N3uron allows users to configure various parameters in order to monitor the historical data of selected tags.

The following properties can be configured:

• Tag list: A tree menu that shows all available historized tags. In order to visualize a tag’s historical data, drag and drop the tags in the Selected tags area.
• Configuration: Visualization parameters available in Configuration area:
  • Date mode: Allows for different ways of specifying the start and end dates for displayed data.
    • Relative: Allows users to select the start and end date according to the current date.
    • Absolute: Allows users to select a start and end date as absolute dates.
    • Current: Allows users to select an interval between the current moment and a previous moment defined by the offset.
  • Date: Configuration for the different Date modes:
    • Relative: Start and end dates are configured using an offset in days or weeks and a time offset in milliseconds
      • Offset: Offset relative to current moment.
      • Time: Absolute offset over the relative offset.
    • Absolute: Allows dates to be specified as absolute values. 
      • Start: Absolute start date.
      • End: Absolute end date.
    • Current: Allows the date to be specified between a selected negative offset and the current moment.
      • Offset: Negative offset from current date.
      • Units: Offset units (seconds, minutes, or hours).
  • Mode: Configuration of data representations.
    • Aggregated: Allows users to aggregate data using different methods.
    • Raw: Presents data as per how it is stored in the historical database.
    • Delta: Only presents values when they have changed more than the deadband value. Includes all values after the change.
    • Filter: Only presents values when they have changed more than the deadband value. Includes all values before and after the change.
  • Mode configuration: Configuration properties for the different modes.
    • Aggregated:
      • Aggregation method: Aggregation type applied to the data. Choose between:
        • Tag configuration: Value configured within the tag.
        • Avg: Weighted-time average for the selected aggregation interval.
        • Min: Minimum value for the selected aggregation interval.
        • Max: Maximum value for the selected aggregation interval.
        • First: First value for the selected aggregation interval.
        • Last: Last value for the selected aggregation interval.
    • Aggregation interval: Interval for the aggregated data:
      • Value: Interval value.
      • Units: Value units.
    • Raw: No special configuration, raw values.
    • Delta and Filter:
      • Deadband: Defines the data change threshold.
  • User presets: Configuration properties can be saved as presets. Previously saved presets can be loaded via this parameter.

After applying the retrieval parameters in Configuration, the WebUI shows the historical data of the selected tags with the following options:

• Autoreload: Enables a periodic reload of the data.
• Return to configuration view.
• Reload selected tags.
• Download: Downloads a CSV file containing historical data.
• Data visualization: Data can be visualized in two ways: a chart or a table with date/value representation.

Connecting Historian to MongoDB Atlas

The following steps will help you connect your Historian instance to an Atlas Cluster in a matter of minutes.

Prerequisites

• An Atlas account.
• An organization and project with an account's user who has permission to create clusters.
• An active cluster created in this account.
• An IP address added to your IP access list.
• A Database user on your cluster.

Take a look at the MongoDB Documentation for more information.

Getting the Connection String from Atlas

You'll need to get your cluster's connection string from Atlas to connect your N3uron's Historian instance to the cluster using the Node.js driver.

• Step 1: Click on Connect:
  • Click on Databases in the top-left corner of Atlas.
  • In the Database Deployments view, click on Connect for the database deployment to which you want to connect.

• Step 2: Click on Connect your application:
  

• Step 3: Select Node.js and 2.2.12 or later from the Driver and Version menus respectively:

Configuring N3uron

• Step 4: Copy the first substring of the connection string as shown below, head to WebUI, and paste it into the Host configuration field of your Historian instance.

• Step 5: Copy the second substring of the connection string as shown above, head to WebUI, and in the Database name configuration field enter the name of the database you are going to use to store historical data, followed by a question mark and the string you've just copied. Once you are done, your configuration should be similar to the one shown in the image below.

• Step 6: Save the changes. 

If everything has been configured properly, once you configure some tags to store their historical values in your Atlas Cluster, you should be able to see how the data is automatically pushed from N3uron.

Renaming Tags

It is possible to change tag names while keeping the historical data of the time series. To do this, it is necessary to follow these steps:

• Step 1: Prepare a CSV file named tags_rename.csv with the following format: 

/oldName1,/newName1
/oldName2,/newName2
/oldName3,/newName3

• Step 2: Stop the Historian module. (If data is received through links and Historian is configured with 'Pause links while unavailable'), remote nodes will pause sending data and will store it via S&F).
• Step 3: Don't forget to make a backup of the module's configuration and the database.
• Step 4: Make the corresponding changes in the data model and save them. 
• Step 5: Save the CSV file (tags_rename.csv) to the Historian module folder inside data (On Windows: C:/Program Files/N3uron/data/Historian and on Linux: /opt/n3uron/data/Historian).
  Note:

  If the Historian instance to be renamed is different, then it should be stored in C:/Program Files/N3uron/data/<Historian module name> or /opt/n3uron/data/<Historian module name>.
• Step 6: Restart the Historian module.

Historian Full Product Details