healthkit-to-sqlite
healthkit-to-sqlite copied to clipboard
dogsheep
Convert an Apple Healthkit export zip to a SQLite database
Columns `duration`, `totalDistance` and `totalEnergyBurned` should be converted to float. https://github.com/dogsheep/healthkit-to-sqlite/blob/71e36e1cf034b96de2a8e6652265d782d3fdf63b/healthkit_to_sqlite/utils.py#L50-L57
I'm getting an error on my initial attempt to import data: ```console $ healthkit-to-sqlite 20201119\ healthkit\ export.zip healthkit.db Importing from HealthKit [###################################-] 98% 00:00:01 Traceback (most recent call last): File...
This solves a weird issue when there is record with metadata key that is only different in letter cases. See the test for details.
This closes #21. When there are metadata entries with the same case insensitive string, then there is an error when trying to create a new column for that metadata entry...
Hey, thank you for this repo! When I try to convert my export, I get a multiple column error. Here is the stack trace: ```sh (.venv) (base) computer:bodyweight_app user$ healthkit-to-sqlite...
Sorting that by date makes sense for seeing most recent points, and my DB has 2.5m points in so it's an expensive sort!
Parses the datetime columns so they are subsequently properly recognized as datetime. Fixes https://github.com/dogsheep/healthkit-to-sqlite/issues/17
Currently, the datetimes are formatted in a way that is not recognized by datasette-vega for plotting with a `Date/time` type for the axis. For example, if you have datasette running...
Fixes https://github.com/dogsheep/healthkit-to-sqlite/issues/14
to keep the data write from failing if it came across an error during processing. In particular when trying to convert my HealthKit zip file (and that of my wife's)...
