aidR: mylife export format

The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

Overview

A mylife export is a single semicolon-delimited .csv file with eight columns:

"Tag";"Datum";"Uhrzeit";"Ereignis";"Wert";"Einheit";"Information";"Notiz"
"Fr.";"16.01.26";"08:01";"Boost";" 46 min.";;"Dauer:  46 min.Startzeit: 08:01 | Endzeit: 08:47";
"Fr.";"16.01.26";"09:05";"Kohlenhydrate";"42";"g KH";;
"Fr.";"16.01.26";"09:06";"Bolus";"4,40";"U";"Bolusvorschlag: 4.40 U";
"Fr.";"16.01.26";"09:22";"Bolus";"4,40";"U";"Bolusvorschlag: 4.40 U";
"Fr.";"16.01.26";"09:22";"Kohlenhydrate";"42";"g KH";;
"Fr.";"16.01.26";"10.00";"Auto mode An";"N/A";;"Startdatum: 16.01.26 10.00Endtermin: 16.01.26 19:44";
"Fr.";"16.01.26";"11:29";"Ease-off";" 30 min.";;"Dauer:  30 min.Startzeit: 11:29 | Endzeit: 11:59";
"Fr.";"16.01.26";"12:17";"Bolus";"6,60";"U";"Bolusvorschlag: 5.60 U";
"Fr.";"16.01.26";"12:17";"Kohlenhydrate";"60";"g KH";;

Each event represents a single row. Both the column headers and the event labels are language-specific and vary with the language of the user’s account (the example above is in German).

How aidR detects this format

Because the headers in a mylife export are language-specific, aidR cannot identify a file from its header names. It relies instead on the structure of the header row, which is delimited by semicolons ; and must split into exactly eight columns. For the same reason, event types are not matched by their labels either: bolus rows are recognized by a unit starting with U, and carbohydrate rows by a unit starting with g.

Entries and the data types they produce

To inspect the raw entries, we parse the export with clean = FALSE, which returns the full information provided by mylife:

data <- parse_data(id = "1", paths = path, clean = FALSE)
#> Parsing data for id 1...

All entries are preserved as-is under their original, language-specific label, so nothing in the export is lost. Possible labels include:

Bolus entries: insulin boluses. German label e.g. Bolus; unit U.

head(data$Bolus)
            timestamp  type amount units            information note
1 2026-01-16 09:06:00 Bolus   4,40     U Bolusvorschlag: 4.40 U   NA
2 2026-01-16 09:22:00 Bolus   4,40     U Bolusvorschlag: 4.40 U   NA
3 2026-01-16 12:17:00 Bolus   6,60     U Bolusvorschlag: 5.60 U   NA
4 2026-01-16 15:43:00 Bolus   3,55     U Bolusvorschlag: 3.90 U   NA
5 2026-01-16 15:48:00 Bolus   3,55     U Bolusvorschlag: 3.90 U   NA
6 2026-01-16 16:02:00 Bolus   1,70     U Bolusvorschlag: 1.70 U   NA

Carbohydrate entries: carbohydrate intake communicated to the pump. German label e.g. Kohlenhydrate; unit g.

head(data$Kohlenhydrate)
            timestamp          type amount units information note
1 2026-01-16 09:05:00 Kohlenhydrate     42  g KH          NA   NA
2 2026-01-16 09:22:00 Kohlenhydrate     42  g KH          NA   NA
3 2026-01-16 12:17:00 Kohlenhydrate     60  g KH          NA   NA
4 2026-01-16 15:43:00 Kohlenhydrate     45  g KH          NA   NA
5 2026-01-16 16:02:00 Kohlenhydrate     15  g KH          NA   NA
6 2026-01-16 18:01:00 Kohlenhydrate     30  g KH          NA   NA

Manual blood glucose entries: self-monitored blood glucose (SMBG). German label e.g. Blutzucker manuelle Eingabe; unit mg/dL or mmol/L.

head(data$`Blutzucker manuelle Eingabe`)
            timestamp                        type amount units information note
1 2026-01-16 18:07:00 Blutzucker manuelle Eingabe    190 mg/dL          NA   NA

Ease-off (Ease-off): start and duration of Ease-off mode.
Boost (Boost): start and duration of Boost mode.
Hypo carbohydrate entries: carbohydrates taken to treat hypoglycemia. German label e.g. Hypo Kohlenhydrate; unit g.
Auto mode on: start and duration of Auto mode. German label e.g. Auto mode An.
Slowly resorbing: carbohydrate intake recorded as slowly resorbing. German label e.g. langsam resorbierbar; unit g.
Auto mode loading: start and end of Auto mode loading, including the reason for any interruption. German label e.g. Auto mode lädt.

Note that a mylife export contains no CGM or basal data - bolus, carbs, and SMBG are the only core data types available from this platform.

Cleaning files

When parse_data is run with clean = TRUE, the cleaned data types are built from the following raw files and attributes:

Cleaned data type	Used files	Used attributes
`bolus`	`mylife_example.csv`	All entries whose unit is `U`, i.e. bolus entries.
`carbs`	`mylife_example.csv`	All entries whose unit is `g`, including regular carbohydrates, slowly resorbing carbohydrates, and hypo carbohydrate entries.
`SMBG`	`mylife_example.csv`	All entries whose unit is `mg/dL` or `mmol/L`, i.e. manual blood glucose entries.
`total_bolus`	`mylife_example.csv`	The cleaned `bolus` data, summed per day.

Notes

SMBG values may be reported in mg/dL or mmol/L depending on the account settings; aidR converts them to mg/dL automatically.
timezone_offset is always NA, since mylife exports report only local (wall-clock) time.
There is no total_basal, since a mylife export contains no basal data. total_bolus is summed from the cleaned bolus data and carries source = "summed".
estimated_absorption_duration is parsed out of the free-text information column for slowly resorbing carbs (e.g. "... 2h ...") and is NA when not stated.
is_hypo_treatment is likewise derived from the information column, by looking for the marker HypoTreatment.
label retains the original, language-specific event label, so the source of each carbohydrate entry stays traceable after merging across platforms.
link_id is always NA for bolus and carbs: the export does not record which carbohydrate entry triggered which bolus. Matching them by timestamp and amount is not implemented.

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.