The tSheet feature is the one of the most easy way how to import data into twinzo. It require zero programmers knowledge.
...
simplest methods for importing data into Twinzo, requiring no programming knowledge. This user-friendly tool allows anyone to easily integrate data into the system without the need for technical expertise.
| Table of Contents | ||
|---|---|---|
|
| Note | ||||||
|---|---|---|---|---|---|---|
For accurate display of sensor data in the 3D app, it is crucial to establish a connection between the https://twinzo.atlassian.net/l/cp/1YUoXf3T and their corresponding https://twinzo.atlassian.net/l/cp/10jmkWmG. | ||||||
| Panel | ||||||
| ||||||
Connect your sensors with the Area for showing sensors data in 3D app!Detailed instructions and further information on how to set up this connection can be found in the relevant section of our documentation. |
Before we start, make your copy of public tSheet
...
| Include Page | ||||
|---|---|---|---|---|
|
The tSheet contains 3 sheet: twinzo connection, send single data and send multiple data.
...
twinzo connection
This sheet serves us to established the connection with the twinzo server.
In the upper part you should insert your credentials. The credential section of the interface, enter your credentials, which are the same as those used for the portal or 3D app. :
Client- your : Your client identifier.
Login- your : Your login username.
Password - your : Your password.
API URL - : The URL address to for the API endpoint. The default is pre-filled address is on and points to the public API for cloud solutions. In case If you are using an on-premise solution, enter input your own specific URL to the API endpoint.
Below these fields, you'll find the Connect with
...
Twinzo button. Click this to
...
initiate the request to connect.
...
The first run of the script will require permissions
...
, and a step-by-step manual on how to
...
grant these permissions is available here
...
→ https://spreadsheet.dev/authorizing-an-apps-script
The Connection
...
Established indicator will show whether your connection is
...
successfully made.
...
This connection
...
is required only once or
...
whenever data changes.
...
...
Send single data
This sheet serves for importing single data. It means, when you have only 1 value or sensor, you can use this sheet. You also can send more sensors information in one step for different sensors or different quantities.
...
Timestamp - date and time when the data was collected. Please insert valid datetime format. For help with date and time follow: Troubleshooting with date and time.
Quantity - quantity of the value.
Value - collected value. It can be number, decimal number, True/False, String, negative number,…
Unit - unit of the value.
DataType - according to the value, select correct DataType. More info about DataType: https://twinzo.atlassian.net/wiki/spaces/PUBD/pages/72646664/Sensors+Data#Data-types.
Import data - button to import data.
Output in twinzo portal
...
Send multiple data
This sheet serves for importing many data for the same sensors and quantity. It means, when you have multiple data the of the same sensor and quantity, you can use this sheet.
...
Timestamp - date and time when the data was collected. Please insert valid datetime format. For help with date and time follow: Troubleshooting with date and time.
Value - collected value. It can be number, decimal number, True/False, String, negative number,…
Output in the twinzo portal
...
Icon by Iconduck