Data export

Background

Data export is handled through the web application: https://app.sens.dk/r/login. We recommend using a browser like Mozilla Firefox on your computer.

Exporting data can be done in several ways. This article provides help on exporting data as:

• CSV format directly from the Patient Overview
• PDF files
• Raw data
• CSV file from accelerometer data

Below is a guide to the different file options you have in your project. At the bottom of the page is a guide to downloading files to your device.

Export in CSV format directly from the Patient overview on the web page

If you wish to export data in a CSV file, this can be done directly from the 'Patients' tab.

1) Click on the grey icon with an arrow to the left of the patient's name.

A pop-up box will then open where you can choose how you want the data to be summarized.

2) There are three options:

1. Summarized every hour
2. Summarized for every 15 min.
3. Summarized every 5. seconds (not summarized)

Choose the summation option you find most useful.

Note: Please note that you can only export data using this approach if you have set a specific start and end date for the patient.

3) You can now download the files from the "Files" menu.

Export data as PDF files

There are three possible ways to export as PDF files:

1. Weekly report 
2. PDF Average Report
3. PDF Extended Report

All reports can show a maximum overview of 14 days. The PDF reports are also particularly suitable for handing out to patients themselves. 

Export Weekly report from the Sensor page

Select which sensor you want to export data from under the 'Sensors' tab.

1) Press the Export button.

 

2) Select PDF Report.

3) Select the export period.

 

4) You can now download the files from the "Files" menu.

Below is an example of a weekly report. It shows a concise overview of the physical activity within the exported period. 

(Example of a weekly report)

Reports from patient profile

From a patient profile it is possible to download two different reports showing a summary of the patient's activity. It shows the patient's average physical activity pr. day in the period. It includes a pie- and barchart for every day of the period. 

                   (Summary of each category and a donut/pie chart)                                                         (Bar chart for each day of the period)

 

Export a PDF report by following these instructions:

1) Open the patient menu. Klik the grey icon next to the patient's name.

2) Select the chosen PDF report. PDF Average Report only shows the summary page. PDF Extended Report also shows the weekly report where the physical activity hour by hour for every day of the period. 

3) You can now download the files from the "Files" menu

Export raw data

Select which sensor you want to export data from under the 'Sensors' tab

1) Select "Accelerometer" from the menu.

2) Click "Export".

3) Here you can choose a CSV file or Raw. To export raw data, select 'Raw'. 

4) Select the export period.

Note: Please note that only 14 days can be exported at a time due to the large amount of data.

 

5) Select whether you want Hex or Binary as export format.

The overall data format is the same for the two. For the Hex file the byte values are formatted as ASCII Hex with a new-line for each 12 bytes. You can view the Hex file in a text editor.

The Binary format is more compact an can be parsed in Python, R or similar. The format is:

 

6 bytes = Unix timestamp i ms

2 bytes = X, signed 16 bit integer x 0.0078125 G

2 bytes = Y, signed 16 bit integer x 0.0078125 G

2 bytes = Z, signed 16 bit integer x 0.0078125 G

Range: -4G to +4G, 10 bit resolution

 

Example:

016C87D85F170022FFD9FFAC

016C87D85F6E0022FFD9FFAC

016C87D85FC50022FFD9FFAC

6) You can now download the files from the "Files" menu

 

Export CSV file from accelerometer data

Select which sensor you want to export data from under the 'Sensors' tab.

1) Select "Accelerometer" in the menu.

2) Press the "Export" button.

3) Here you can select a CSV file or Raw. Here you choose CSV.

4) Select the export period.

Note: Please note that only 2 days can be exported at a time due to the large amount of data.

5) You can now download the files from the "Files" menu

Downloading data

1) After initiating file generation, your files will appear in the "Files" menu.

You can follow see the status of the file processing in the progress bar. You may open and close the "Files" menu as you wish in order to generate several files simultaneously. 

2) Once your files are generated and ready for download, a blue dot will appear next to the "Files" button . Click "Download File" to download a file to your device.

Your file should now be downloaded to your device.