tcgoetz / GarminDB

Download and parse data from Garmin Connect or a Garmin watch, FitBit CSV, and MS Health CSV files into and analyze data in Sqlite serverless databases with Jupyter notebooks.
GNU General Public License v2.0
1.18k stars 142 forks source link

Activity stop_time shows as "NULL" #73

Closed skrasnow closed 4 years ago

skrasnow commented 4 years ago

Describe the bug Since 7/31/2020 the stop time for my walking activities shows as NULL (in the SQLite DB) and therefore (I suppose) the elapsed time showing up in the SQLite DB is highly incorrect. I am running the latest version of the software (1.7). I am wondering if this is caused by Garmin or is the error somewhere else. Thank you.

To Reproduce Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior A clear and concise description of what you expected to happen.

Logs Please include a copy of screen logging and garmin.log.

Please run bugreport.sh and attach bugreport.zip.

Additional context Add any other context about the problem here.

tcgoetz commented 4 years ago

I see the same thing. I will look into it.

tcgoetz commented 4 years ago

Please test something for me. Please go to one of your activities that is wrong in the DB and choose "export original" from the drop down menu from the cog icon. Does it work?

Screen Shot 2020-08-02 at 8 21 26 PM

tcgoetz commented 4 years ago

Discussion of the issue: https://www.reddit.com/r/Garmin/comments/i1p3z1/garmin_connect_export_original/

skrasnow commented 4 years ago

Thank you, Tom. I'm not sure I understand what you want, but attached is a CSV of today's activity which is incorrect in the SQLite Db, but it has the correct elapsed time on the Garmin site.

Stan Krasnow | わ | email: skrasnow@gmail.com | telephone: +1-914-282-1430 | skype: stanleyk |

On Sun, Aug 2, 2020 at 8:23 PM Tom Goetz notifications@github.com wrote:

Please test something for me. Please go to one of your activities that is wrong in the DB and choose "export original" from the drop down menu from the cog icon. Does it work?

[image: Screen Shot 2020-08-02 at 8 21 26 PM] https://user-images.githubusercontent.com/15090876/89135787-ed396f00-d4fd-11ea-912f-c22fb3c85d1e.jpg

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/tcgoetz/GarminDB/issues/73#issuecomment-667745526, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOJZ5Y3TVBOJ2FZSMCGDC2DR6X7QHANCNFSM4PSWIVPQ .

tcgoetz commented 4 years ago

I was asking if , on the Garmin Connect website, whether "Export Original" works for you fro the activities that are having issues. I does not for me. I get a 400 web error. Same as a lot of other people per the article sited above.

skrasnow commented 4 years ago

Thank you, Tom; yes, I got a "400 Bad request" as well.

Stan Krasnow | わ | email: skrasnow@gmail.com | telephone: +1-914-282-1430 | skype: stanleyk |

On Mon, Aug 3, 2020 at 6:52 AM Tom Goetz notifications@github.com wrote:

I was asking if , on the Garmin Connect website, whether "Export Original" works for you fro the activities that are having issues. I does not for me. I get a 400 web error. Same as a lot of other people per the article sited above.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/tcgoetz/GarminDB/issues/73#issuecomment-667955139, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOJZ5Y5FXMIO34AVHZAXAYLR62JINANCNFSM4PSWIVPQ .

tcgoetz commented 4 years ago

It's working again. Runt hew following to download any activities files that were not previously downloaded: garmin.py --activities --download

skrasnow commented 4 years ago

Thank you, Tom! Agreed - the elapsed times are now in the DB correctly.

Stan Krasnow | わ | email: skrasnow@gmail.com | telephone: +1-914-282-1430 | skype: stanleyk |

On Wed, Aug 5, 2020 at 7:37 AM Tom Goetz notifications@github.com wrote:

It's working again. Runt hew following to download any activities files that were not previously downloaded: garmin.py --activities --download

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/tcgoetz/GarminDB/issues/73#issuecomment-669143261, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOJZ5Y74VZP4AXP5DTXZ3RTR7E77JANCNFSM4PSWIVPQ .