Automated Exports

🚀 Available from Core version 2025.2.

Automatic exports enable automated data collection and reporting from your TapHome system. This functionality stores all export parameters and allows you to:

• Configure automatic data fetching in Google Sheets and Microsoft Excel (or other tools)
• Manually download predefined reports from the app for the most recent period
• Manually download custom reports for selected time ranges

Data are stored in cloud storage at https://data.taphome.com/api/export/profile/<token>/ and are available in CSV, JSON, XLSX, or XML formats.

Export types

Automatic exports support three different data types:

Device values

Export of sensor values, device states, and calculated statistics (temperature, energy consumption, etc.). This is the most commonly used export type.

How it works

1. Data Sources (Columns)

Specify from which devices and which values you want to export:

• Device: e.g. Thermostat, Temperature sensor
• Value type: e.g. Set temperature, Current temperature
• Aggregate function: Average , Minimum , Maximum

The statistics are calculated and stored continuously for each device. Disabling them will prevent generating a complete export, as historical data cannot be recalculated later.

2. Sampling Interval (Rows)

Specifies how frequently data are recorded. Each row in the export represents one sampling interval.

Available intervals: 5 minutes, 10 minutes, 15 minutes, 30 minutes, 1 hour, 12 hours, 1 day, 1 week, 1 month, 1 quarter (3 months), 1 year.

Example: With an interval of 1 hour, the export will contain one row per hour.

3. Export Range

Defines how much data is generated for each export (how much historical data).

If you set:

• Export range: 3 days
• Sampling interval: 1 hour

The export will contain: 72 rows (3 days × 24 hours = 72 rows)

4. Live data update

Set when new data are generated.

• Every day : e.g. every 2 days at 14:30
• Every week : e.g. every 3 weeks, on Monday at 09:00
• Every month : e.g. every month, on the 15th at 12:00
• Every year : e.g. every year, on 25.12 at 18:00

Step by step: Create an export

Step 1: Create a new export

1. Open the exports list
2. Click Define a new export
3. Enter the export Name

Step 2: Set data sources

1. In the Data Sources (Columns) section, click Add column
2. Select the device (e.g. Thermostat)
3. Select the value type (e.g. Set temperature)
4. Select the aggregate function (Average , Minimum , Maximum )
5. Repeat for all required columns

Example: Each row contains: Thermostat Set Temperature (1h average), Thermostat Temperature (1h minimum), Light Sensor Brightness (1h maximum).

Step 3: Set the sampling interval

1. In the Sampling Interval (Rows) section, choose the interval
2. Recommendations:
   • 5–15 min – for detailed data (large export)
   • 1 hour – for general use
   • 1 day/week – for long-term trends (small export)

Step 4: Set the export range

1. In the Export Range section, enter the number of periods
2. Check the number of rows in the summary
3. Warning: The export must not exceed 100 000 rows

Example: Exported data will contain 1286 rows for a 3-day period.

Step 5: Set automatic updates

1. In the Live data update section, enable the export (Enabled )
2. Set the generation frequency (e.g. every month, on the 1st day at 00:00)
3. Save the export

Step 6: Get the export URL

After saving, the app will automatically generate the URL:

1
2
3
4

https://data.taphome.com/api/export/profile/<token>/data.csv
https://data.taphome.com/api/export/profile/<token>/data.json
https://data.taphome.com/api/export/profile/<token>/data.xlsx
https://data.taphome.com/api/export/profile/<token>/data.xml

The token is generated automatically by the app.

Important notices

• Activation of statistics: When you save the export configuration, the system automatically enables all required statistics for the exported devices. These statistics are calculated and stored continuously. Important: Statistics cannot be calculated retroactively — if you disable them, historical data will be permanently lost.

• Internet connection: The control unit can store data for several hours without an internet connection. In the event of a long outage, older data must be deleted to avoid memory overrun.

• Critical data: For critical data, we recommend using an alternative data collection solution.

• Row limit: The maximum number of rows in an export is 100 000.

Access system

The access log export generates a chronological record of events – who, when, and on which reader was accepted or denied, and the reason.

What the export contains

Each row in the export represents a single access system event with the following data:

• User – full name
• Date and time – exact time of the event
• Card reader – name and location of the reader
• Result – Allowed / Denied
• Reason – reason for denial (if relevant)

Export configuration

1. Create a new export of type Access log
2. Enter the export Name
3. Choose the time period for the export (export range)
4. Set automatic updates (optional)
5. Save the export and obtain the download URL

The export is available in CSV, JSON, XLSX, or XML formats.

Attendance

The attendance export, based on data from the access system, generates a clear report showing when employees arrived and left, and how many hours they worked.

Prerequisites

You must have readers configured as “check-in” (building entry) and “check-out” (building exit). There must be at least one card reader.

Users must have access cards assigned with their name.

Export configuration

1. Create a new export of type Attendance

2. Enter the export Name

3. Check-in card readers :

   • Select the readers used for entering the building (entrance readers)

4. Check-out card readers :

   • Select the readers used for exiting the building (exit readers)

5. Choose the time period for the export

6. Set automatic updates (optional)

7. Save the export and obtain the URL

What the export contains

Each row represents one working day for an employee:

• Date – working day
• Name – employee
• First check-in – time of first entry into the building
• Last check-out – time of last exit from the building
• Time inside [hh:mm] – total time spent inside the building
• Time outside [hh:mm] – total time of breaks outside the building

Time calculation

If the access card has an assigned user and the user entered the building on that day using a reader, a row is created in the table. Only records with successful access are considered.

• Time inside [hh:mm] – sum of time differences between arrivals and departures. If the user had an arrival (without a departure) or a departure (without an arrival) several times in a row, only the first is considered.

• First arrival – time of the first arrival into the building.

• Last departure – time of the last departure from the building.

• Time outside [hh:mm] – sum of time differences between exits and entrances.

In standard cases, when an arrival is followed by an exit and after the exit there is a pair of arrival–exit (or more pairs), the following holds:

Time inside + Time outside = Last departure – First arrival

Format

The export is available in XLSX format (recommended) and includes a preformatted table ready for further processing.

Integrations

All three export types (Device Values, Access System, Attendance) can be integrated with Google Sheets and Microsoft Excel using the URLs generated by the app.

Google Sheets

1

=IMPORTXML("https://data.taphome.com/api/export/profile/<token>/data.xml", "//row/timestamp")

1

=IMPORTXML("https://data.taphome.com/api/export/profile/<token>/data.xml", "//row/v001")

1

=IMPORTXML("https://data.taphome.com/api/export/profile/<token>/data.xml", "//row/v002")

Microsoft Excel