This block can be used to transfer and display events, such as billing, in an Exosphere database.
Table des matières
Entrées↑
| Abréviation | Résumé | Description | Valeurs |
|---|---|---|---|
| ETr | Trigger | Pulse on input triggers 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 |
|---|---|---|
| Log | Log output | Log output on every write to the database |
| 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 food and beverage billing for employees is recorded in a database.
A database must be created in Exosphere and integrated into the configuration using the "Database".
With the "Event 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 input "ETr" is triggered when a user is successfully authenticated via the NFC Code Touch. On every rising edge of this input, data is written to the database.
The ID of the authenticated user is transferred to the "Uid" input, and with additional logic on "CI1" and "CI2", the food and beverage type as well as the respective price are transferred.
