This block can be used to track and display sessions in an Exosphere database, such as wallbox charging.
Table of Contents
Inputs↑
| Abbreviation | Summary | Description | Value Range |
|---|---|---|---|
| SStart | Session start | Pulse at input triggers a start of a session. | 0/1 |
| SEnd | Session end | Pulse at input triggers the end of a session and a write to the database. | 0/1 |
| Uid | User-ID | User-ID. If set before triggered, user-fields of the user with this id can be used | - |
| CI1 | Custom input 1 | Additional custom input 1 | - |
| CI2 | Custom input 2 | Additional custom input 2 | - |
| CI3 | Custom input 3 | Additional custom input 3 | - |
| CI4 | Custom input 4 | Additional custom input 4 | - |
| CI5 | Custom input 5 | Additional custom input 5 | - |
| CI6 | Custom input 6 | Additional custom input 6 | - |
| CI7 | Custom input 7 | Additional custom input 7 | - |
| CI8 | Custom input 8 | Additional custom input 8 | - |
Outputs↑
| Abbreviation | Summary | Description | Value Range |
|---|---|---|---|
| Log | Log output | Log output on every write to the database | - |
| Sa | Session active | Active when there is a session currently active | 0/1 |
| AC | API Connector | Intelligent API based connector. API Commands |
- |
Parameters↑
| Abbreviation | Summary | Description | Unit | Value Range | Default Value |
|---|---|---|---|---|---|
| Td | Trigger Delay | Delays write to database after trigger to make sure all inputs are set | ms | ∞ | 0 |
Properties↑
| Summary | Description | Default Value |
|---|---|---|
| Column content | Edit column content. Specify the data that should be written to the database columns. | - |
Programming example↑
In this example, a Wallbox charging billing is recorded in an Exosphere database.
A database must be created in Exosphere and integrated into the configuration using the "Database".
With the "Session Database Connector" block, the database can now be populated with data.
Double-clicking on the block opens the "Database Connector Configuration". Here, the contents of the columns can be defined.
If an option is grayed out, the datatype is not compatible with it.
Additionally, the block inputs "CI1-CI8" can be named. These will be displayed in the configuration but not in the Exosphere database.
The start and end of a charging session are transferred to the inputs "SStart" and "SEnd". The charging user is forwarded to the block via the "Uid" input.
The price of the charging session is transmitted to the input "CI1."
