3
Data transfer and storing
When the app and the device have a connection, all data written into the device memory will be
transferred in compressed packets to the phone. This transfer only happens for full files. The
progress of transferring the files is indicated by the progress bar in the app.
If the device memory has a lot of stored data, the transfer might take quite long. In the case
where the Bluetooth connection has been broken for a long time, please leave the app on
and give the files time to transfer when connecting.
Any collected data will be written into an sqlite database that is stored in the phone under the
directory
/sdcard/PulseOnOHR/
. The database file is always named
pulseon_ohr.sqlite.
This database
includes three different tables:
RawData
,
ContinuousData and AdlData
. Please see chapter 4 for
clarification on the different tables and the values written into them.
In certain phone models and Android OS versions the application might not be able to write
into the database if another app accessing the SD-card is open in the background. Please
close all file explorers etc while using the PulseOn recorder app.
The database is being written whenever there is a connection and transferrable data. When
collecting raw data, please be careful not to enable raw data recording while not measuring.
This will result in collecting unwanted data.
In
sampled mode
, the
ContinuousData
is written only when it changes from its previous
values. If only recording
HR
data in
sampled mode
, the value might not change often and
thus the transferrable packets will fill slower. In this case, a file might take up to hours to fill
up before it is shown in the phone’s database.
To reset the database, the sqlite-file (or even the whole containing folder) can be deleted from the
phone memory. If no such file or folder exist, the app will create them by itself. It is advised to also
delete the database after updating the app to a newer version.
3.1
Exporting the database as a CSV-file
In the app, the upper-right menu has an option labelled
Export DB
. This creates a separate CSV-file
from each table in the sqlite database into
/sdcard/PulseOnOHR/csvexport/
subfolder. The files will
be named as YYYYMMDD_time-raw/cont/adl.csv.