How to export steps by day from gadgetbridge database sqlite to csv or excel
1) Open gadgetbridge database with SQLite
2) Click on Execute SQL
3) Do the following query in order to have grouped steps by day.
You have now the oportunity to select all and copy to another file as a csv.
2) Click on Execute SQL
3) Do the following query in order to have grouped steps by day.
select dates, steps from (select strftime('%Y.%m.%d', datetime(timestamp, 'unixepoch')) as dates,sum(STEPS)as steps from MI_BAND_ACTIVITY_SAMPLE group by dates) order by dates asc
You have now the oportunity to select all and copy to another file as a csv.
Comentaris
Publica un comentari a l'entrada