Google Sheet for data import
The tSheet feature is one of the 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.
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. 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
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 section of the interface, enter your credentials, which are the same as those used for the portal or 3D app:
Client: Your client identifier.
Login: Your login username.
Password: Your password.
API URL: Select the type of your license. When you user self-onboarding -use Platform (https://platform.twinzo.eu/), in case your colleagues invite you, use Enterprise (https://portal.twinzo.eu/). If you are using an on-premise solution select “Custom - Enter your API URL below:” and input your specific URL.
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.
SensorLogin - select one of your already created sensors. If you write login of not existing sensor (the new sensor should be added into the last row - image bellow), new sensor will be added. Then reconnect yourself (in “twinzo connection” sheet) for downloading new list of sensors.
Timestamp - date and time when the data was collected. Please insert valid datetime format. For help with date and time follow: Troubleshooting.
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: 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.
In the top of the sheet enter information about sensor you want to import.
SensorLogin - select one of your already created sensors. If you write login of not existing sensor, new sensor will be added.
Quantity - quantity of the value.
Unit - unit of the value.
DataType - according to the value, select correct DataType. More info about DataType: Sensors Data | Data types.
Import data - button to import data.
There is the place for paste your collected information below.
Timestamp - date and time when the data was collected. Please insert valid datetime format. For help with date and time follow: Troubleshooting.
Value - collected value. It can be number, decimal number, True/False, String, negative number,…
Output in the twinzo portal
Icon by Iconduck
If you encounter any issues or need assistance with using this product, please do not hesitate to reach out for support. Our team is here to help you resolve any problems and answer any questions you may have.
To create a support ticket, visit our support portal at https://partner.twinzo.eu/helpdesk/customer-care-1