Tom Goetz

It should: ` @classmethod def get_years(cls, db): """Return a list of the unique years present in the time column.""" with db.managed_session() as session: return cls._rows_to_ints_not_none(session.query(extract('year', cls.time_col)).distinct().all())` _rows_to_ints_not_none should do that....

I'm not able to duplicate that. What kind of activities are these? 

Still can't duplicate this. Need more information or I won't be able to fix it. Maybe share the json file for one of the activities showing this behavior?

I believe the calories for an activity, field=calories, is the activities contribution to active calories. I think you should just use the calories field.

I don't think you need to fork. Feel free to offer a pull request with the needed functionality. GarminDb releis heavily on SqlAlchemy. If SqlAchemy support DuckDB, then adding support...

Can you share 647637184_ACTIVITY.fit with me? Upload it to something like dropbox and share a link?

> Here are the files for the activity you mentioned: > [https://wormhole.app/a3aYj#EH_hRhpZGw98PKuj5lbx5A](url) Looks like that share link expires in 24 hours and I didn't get to it in time. Do...

What can you tell me about this file? I can see that it was made by a ForeRunner 230, but where there additional sensors or a customer app involved? Data...

It was possible. I don't think anyone has tried it for a while. It might still work, but not sure.

@alexjmccoy if you have a write-up on how to do this, that you would like me to add to the wiki, I would be happy to do that. I no...