In this section, you will learn how to import RXD file, attach CAN DBC file and write data into the InfluxDB database for creating a Dashboard.

Writing Data from a Single File

• Open Dashboard Writer Tool.

• Click on the Single File Tab.

• Click On Select RXD File Button and choose the RXD file from your PC.

• Click On the Select CAN 0 DBC File Button to choose the DBC file for your CAN 0 Bus from your PC.

• (Optional) If the RXD file contains data from multiple CAN buses, select the DBC file for CAN 1 by clicking Select CAN 1 DBC File.

• Enter the name of the Bucket to which the data will be written.

• Click the Write To Database Button to start the writing process.

Writing Data from Multiple Files

• Open Dashboard Writer Tool.

• Click on the Multiple File Tab.

• Click On Select Folder Button and choose the Folder from your PC with the RXD files.

• Click On the Select CAN 0 DBC File Button to choose the DBC file for your CAN 0 Bus from your PC.

• (Optional) If the RXD file contains data from multiple CAN buses, select the DBC file for CAN 1 by clicking Select CAN 1 DBC File.

• Enter the name of the Bucket to which the data will be written.

• Click the Write To Database Button to start the writing process.

If you are an existing user of Grafana and InfluxDB, you can proceed to Influx Tools Installation.

Sign in to Grafana

To sign in to Grafana for the first time:

1. Open your web browser and go to http://localhost:3000/.

2. On the sign-in page, enter admin in the section for username and password.

3. Click Sign in.

   If successful, you will see a prompt to change the password.

4. Click OK on the prompt and change your password.

Configure the data source

To access the data source configuration page:

1. Hover the cursor over the Configuration (gear) icon.

2. Select Data Sources.

3. Select the InfluxDB data source.

Set the data source’s basic configuration options carefully:

• Set a name for your Data Source, like InfluxDB-Flux.

• Select Query Language as Flux.

• Enter the URL as http://localhost:8086

Configuring Flux Query Related Setting:

Configure these options under InfluxDB details after you select the Flux query language:

• Click Save & Test.

You can download the Grafana® Windows installer package from the following link.

• Select a Grafana version you want to install.

• The most recent Grafana® version is selected by default.

• Select OSS version

• Click Windows.

• Click Download the installer under Windows installer.

• Open and run the installer.

You can download the InfluxDB® Windows Binaries from the following link.

• Select the Latest version.

• Select Windows Binaries.

• Copy the PowerShell commands displayed on the page.

• Run Windows PowerShell as administrator.

• Paste and run the copied contents.

• You have now successfully installed InfluDB on your Laptop/PC

Dashboard Writer uses the InfluxDB Cli application to write data into InfluxDB. In this step, we will configure this tool with the information gathered from the InfluxDB UI.

• Open the Dashboard Writer tool.

• Click on the Configure InfluxDB Writer Tab.

• Enter Configuration Name.

• Enter the following information obtained from the InfluxDB UI.

• .

• Secret .

• .

Configure InfluxDB for first use

• Open the Influx Dashboard Writer application.

• Click on Run InfluxDB.

• Visit localhost:8086 in a browser to access InfluxDB UI.

• Setup Initial User.

• Enter a New Username, Password, Organization Name, and Bucket Name.

Gathering information to configure the Dashboard Writer tool

URL

For Local installation, the URL is http://localhost:8086

Token

• Visit localhost:8086 in a browser to log in and access the InfluxDB UI.

• Navigate to Load Data > API Tokens using the left navigation bar.

• Click + GENERATE API TOKEN and select All Access API Token.

• Enter a description for the API token and click SAVE.

• Copy the generated token and store it for configuring the Dashboard writer tool.

Organization ID

After logging in to the InfluxDB UI, your organization ID appears in the URL.

In the below example, 03a2bbf46249a000 is the Organization ID

http://localhost:8086/orgs/03a2bbf46249a000/...

This section will teach you how to create a New Dashboard in Grafana and Query data from the InfluxDB Database.

Creating your first dashboard:

• Open your web browser and go to http://localhost:3000/

• Sign in with your credentials.

• Click the New Dashboard item under the Dashboards icon in the side menu.

• On the dashboard, click Add an empty panel.

• Go to the Query tab in the New Dashboard/Edit panel view.

• Select your Data Source in the Query options.

• Use the following Flux Query to query the data from the InfluxDB Database (Bucket)

from(bucket: v.defaultBucket)
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> aggregateWindow(every: v.windowPeriod, fn: mean)
  |> filter(fn: (r) => r["_measurement"] == "<Device_Serial>")
  |> filter(fn: (r) => r["signal"] == "Engine_speed")
  |> yield(name: "mean")

• Select the Time Range for which the data has to be viewed.

You will be able to view the data in the Graphical View.

Repeat the process by adding new Panels and Editing the CAN Signal Name.

ReXdesk Convert Tool

This tool is required to convert RXD data into InfluxDB-supported CSV format after linking the CAN DBC file.

Download Link

Dashboard Writer Tool

This tool will select and push single or multiple RXD file data into InfluxDB for viewing in the Dashboard.

Download Link