How to import sensor data with the twinzo Excel?

If you want to import some of your data to our Web Portal, you can use our twinzo Excel configured to import your data.

Open

tExcel

twinzo authorization

API Key - you can create your own API key here API Keys and paste it after the creation,

Client Guid - you can find this Guid here Client and paste it here.

Branch Guid - you can find this Guid here Branches and paste it here.

Modes

Login - select the mode of data import. You can choose between a column or a sheet.

you can choose between a column or a sheet. This is the mode of data import. The sheet will import a whole sheet with the Sensor Login name and the column will import only the row with the name of the Sensor Login name.

Column	Sheet

Column	Sheet
It is used for sending various quantities to different sensors.	It is used for sending multiple records from the same quantity or multiple records for different quantities to a single sensor.
In Modes → Login select column Open	In Modes → Login select sheet
Every row is sent to the sensor selected in Sensor ID	All rows are sent to the sensor selected in the name of the sheet.

URL- between Enterprise or Platform. When you log in into portal with the URL:
https://portal.twinzo.eu - Enterprise
https://platform.twinzo.eu - Platform

Time source - this is just a source of time, you can choose between current time or data. The current time will automatically add a time of import to every entry and in the data option, you have to specify the date of entry obtained from the sensor.

Time format - this specifies the format of a time if it is UNIX (1682329824) or DateTime (24. 04. 2023 11:50:24)

Columns indexing

This is used just for indexing columns in the sheet. It is better not to change as it can break twinzo Excel data import.

Data types

• Int32 - for whole numbers

• Decimal - for decimal numbers

• String - for string

Run import

After filling out all explained above, you can click this button ‘Run import’. The data, that were in the second sheet you will see in a while in the portal.

twinzo Excels for download:

Open