Data is missing

[atusiniida]

Dear colleagues,

when I downloaded data spaning several month, I found that data is a part of the period is missing.
for example, whien I download data from 2023-07-31, day summery data from 2023-09-09 to 2023-09-24 is missing in the sql table.
I found daily_summary_***.json files but the values in the files are null.
I comfimed that in Garmin Gonnect record, the data is correectly recored in that period.
Could you give me help ?
(If neccesay, I can share my account for debugging)

Best,
Atsushi

[tcgoetz]

If you redownload the data for that period, is it still null? There are options for redownload.

[atusiniida]

Thank you for your responce.

you mean that there are comand options for redownload?
could you give an example of the command?

I tired download reveral times and comfirm the phenomenon is reproducible.

[atusiniida]

I am getting the data by vivosmart 5. when I was getting data by vivosmart 4, I am not face such a problem. it is possible that the problem is dependent on the device type?

[tcgoetz]

`orion:GarminDB_develop tgoetz$ garmindb_cli.py --help
usage: garmindb_cli.py [-h] [-v] [-t TRACE] [-b] [-d] [-c] [-i] [--analyze] [--rebuild_db] [--delete_db] [-e EXPORT_ACTIVITY] [--basecamp-activity BASECAMP_ACTIVITY] [-g GOOGLE_EARTH_ACTIVITY] [-A] [-a] [-m] [-r] [-s] [-w] [-l] [-o]

optional arguments:
-h, --help show this help message and exit
-v, --version print the program's version
-t TRACE, --trace TRACE
Turn on debug tracing

Modes:
-b, --backup Backup the database files.
-d, --download Download data from Garmin Connect for the chosen stats.
-c, --copy copy data from a connected device
-i, --import Import data for the chosen stats
--analyze Analyze data in the db and create summary and derived tables.
--rebuild_db Delete Garmin DB db files and rebuild the database.
--delete_db Delete Garmin DB db files for the selected activities.
-e EXPORT_ACTIVITY, --export-activity EXPORT_ACTIVITY
Export an activity to a TCX file based on the activity's id
--basecamp-activity BASECAMP_ACTIVITY
Export an activity to Garmin BaseCamp
-g GOOGLE_EARTH_ACTIVITY, --google-earth-activity GOOGLE_EARTH_ACTIVITY
Export an activity to Google Earth

Statistics:
-A, --all Download and/or import data for all enabled stats.
-a, --activities Download and/or import activities data.
-m, --monitoring Download and/or import monitoring data.
-r, --rhr Download and/or import resting heart rate data.
-s, --sleep Download and/or import sleep data.
-w, --weight Download and/or import weight data.

Modifiers:
-l, --latest Only download and/or import the latest data.
-o, --overwrite Overwite existing files when downloading. The default is to only download missing files.`

You need the --download flag and the --overwrite flag. The harder parts is specifying a limited date range. You can redownload only monitoring data with --monitoring. So:

garmindb_cli.py --monitoring --download --overwrite

[atusiniida]

I ried redownload by "garmindb_cli.py --monitoring --download --overwrite".
However, the data for that period, is it still null.
Thank you for your more help.

[tcgoetz]

If you look at the file dates after the redownload, were the data files in question replaced?

[atusiniida]

Yes, time created indicated that the data files is replaced.