This block can be used to track and display sessions in an Exosphere database, such as wallbox charging.
Table des matières
Entrées↑
| Abréviation | Résumé | Description | Valeurs |
|---|---|---|---|
| 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 | - |
Sorties↑
| Abréviation | Résumé | Description | Valeurs |
|---|---|---|---|
| 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 | Connecteur intélligent basé sur l'API. API Commands |
- |
Paramètres↑
| Abréviation | Résumé | Description | Unité | Valeurs | Valeur défaut |
|---|---|---|---|---|---|
| Td | Trigger Delay | Delays write to database after trigger to make sure all inputs are set | ms | ∞ | 0 |
Propriétés↑
| Résumé | Description | Valeur défaut |
|---|---|---|
| Contenu de la colonne | Modifier le contenu de la colonne. Spécifiez les données qui doivent être écrites dans les colonnes de la base de données. | - |
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."
