Step 2 to get the MiBand connected to the gadgetbridge requires a bit of effort, but is well documented here<\/a>. This is essential to move on.<\/p>\n\n\n\n The result will be, that the MiBand is now connected to the gadgetbridge App.<\/p>\n\n\n\n 2 settings on the gadgetbridge app are required:<\/p>\n\n\n\n This set in motion will fetch the data from the device, and export to a sqlite Database.<\/p>\n\n\n\n Using the folder-sync app for Android the Database file can be copied over to a local PC\/Server in regular intervals.<\/p>\n\n\n\n The initial idea was to use the sqlite Database file directly via a sqlite node on Node-RED. This failed due to the fact that the DB-file name never changes and Node-RED always uses the inital version of the DB-file.<\/p>\n\n\n\n Plan B required to first of all export the Data on the database to a csv file.<\/p>\n\n\n\n To do this an SQL-statement needs to be stored and excecuted on a regular basis. This sql code was stored in a file called steps_q.sql. It gets the steps recorded for the last 7 days.<\/p>\n\n\n\n To export this to a csv file the following sqlite3 statement can be used:<\/p>\n\n\n\n sqlite3 -header -csv \/mnt\/1TBTOSHIBA\/files\/transfer\/miband\/db < \/mnt\/1TBTOSHIBA\/files\/transfer\/miband\/steps_q.sql > \/mnt\/1TBTOSHIBA\/files\/transfer\/miband\/steps.csv<\/p>\n\n\n\n sqlite3 -header -csv is the command The excecution of this file was set up as a cron job:<\/p>\n\n\n\n 45 * * * * pi sqlite3 -header -csv \/mnt\/1TBTOSHIBA\/files\/transfer\/miband\/db < \/mnt\/1TBTOSHIBA\/files\/transfer\/miband\/steps_q.sql > \/mnt\/1TBTOSHIBA\/files\/transfer\/miband\/steps.csv<\/p>\n\n\n\n Every hour at the 45th minute the user “pi” exectues the statement and updates the csv file with the latest amount of steps.<\/p>\n\n\n\n The Node-RED flow after this is very simple: An inject that runs on an interval, the csv-file, the csv-node and the UI table export.<\/p>\n\n\n\n Result on the Node-RED Dashboard:<\/p>\n\n\n\n Mi-Band 5Smartphone: Nokia 5.3OS on smartphone: Android 10Apps on smartphone required: Gadgetbridge, FolderSyncServer: Raspberry Pi 4OS: Raspbian GNU\/Linux 10 (buster)ioBroker: 4.0.10node-red Adapter: 2.3.0node-red version: 1.3.5 The idea was to display the steps recorded by the Mi-Band 5 on the node-RED Dashboard. The Mi-Band comes with a closed source App for the Smartphone that cant export… Read More »Mi-Band steps on node-RED Dashboard<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[13],"tags":[],"class_list":["post-58","post","type-post","status-publish","format-standard","hentry","category-node-red"],"_links":{"self":[{"href":"https:\/\/www.servo-server.net\/index.php?rest_route=\/wp\/v2\/posts\/58","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.servo-server.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.servo-server.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.servo-server.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.servo-server.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=58"}],"version-history":[{"count":8,"href":"https:\/\/www.servo-server.net\/index.php?rest_route=\/wp\/v2\/posts\/58\/revisions"}],"predecessor-version":[{"id":70,"href":"https:\/\/www.servo-server.net\/index.php?rest_route=\/wp\/v2\/posts\/58\/revisions\/70"}],"wp:attachment":[{"href":"https:\/\/www.servo-server.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=58"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.servo-server.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=58"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.servo-server.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=58"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/www.servo-server.net\/wp-content\/uploads\/2021\/06\/Screenshot_20210625-082722-461x1024.png\"){kind=spacer}
<\/figure>\n\n\n\n
<\/p>\n\n\n\n![\"\"](\"https:\/\/www.servo-server.net\/wp-content\/uploads\/2021\/06\/Screenshot_20210625-082809-461x1024.png\"){kind=spacer}
<\/figure>\n\n\n\nSELECT \nDatum \n,sum(schritte) as Schritte \nFROM \n( \nSELECT \n\n\ndate(MB.TIMESTAMP, 'unixepoch') as Datum \n,sum(MB.STEPS) as Schritte \n\nfrom MI_BAND_ACTIVITY_SAMPLE MB\n\ngroup by MB.TIMESTAMP \n\n) \n\ngroup by Datum \norder by Datum DESC \nLIMIT 7<\/pre>\n\n\n\n
\/mnt\/1TBTOSHIBA\/files\/transfer\/miband\/db is the sqlite Database
< \/mnt\/1TBTOSHIBA\/files\/transfer\/miband\/steps_q.sql is the SQL code stored in a file
>\/mnt\/1TBTOSHIBA\/files\/transfer\/miband\/steps.csv is the destination csv-file<\/p>\n\n\n\n![\"\"](\"https:\/\/www.servo-server.net\/wp-content\/uploads\/2021\/06\/miband_sql_node_red.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.servo-server.net\/wp-content\/uploads\/2021\/06\/mi_band_ui.png\")
<\/figure>\n","protected":false},"excerpt":{"rendered":"