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 API key here https://twinzo.atlassian.net/wiki/spaces/PUBD/pages/53805121 and paste it after the creation,

Client Guid - you can find this Guid here https://twinzo.atlassian.net/wiki/spaces/PUBD/pages/260636729 and paste it here.

Branch Guid - you can find this Guid here https://twinzo.atlassian.net/wiki/spaces/PUBD/pages/53379129 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 Open
Every row is sent to the sensor selected in the Sensor ID Open	All rows are sent to the sensor selected in the name of the sheet. Open

URL- between Enterprise or Platform. When you log in to the portal with the URL:
https://portal.twinzo.eu - Enterprise
https://platform.twinzo.com - 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 it 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.

Open

The AOS Dashboard is designed to display basic information about orders in an easy-to-read format. It provides a clear and concise overview of key data points and metrics, allowing you to quickly grasp the essentials at a glance.

Open

Dashboard screen

The Dashboard tab is divided into four parts:

1. Count of the orders in the last 24 hours.

2. Chart of the AOS actions per member.

3. Chart of the Actions per role.

4. Chart of the Currently assigned orders per device.

twinzo Excels for download:

Open