My script to import from openScale

[qqii]

I wanted to try this app, so here are some commands you can run in termux to convert an openscale.db:

pkg install sqlite
sqlite3 openScale.db "SELECT strftime('%Y-%m-%dT%H:%M:00.000', datetime / 1000, 'unixepoch') || ' ' || weight FROM 'scaleMeasurements'" > trale.txt

It seems that openScale does not store the seconds or ms, so those have been hard coded to 0.

---

I really love the UI, and I would love if this app supported more fields (body fat, water, waist) and importing from other apps like openScale!

[braniii]

@gwosd how about adding this to the Readme in an FAQ section?

[markushhh]

In termux, you have to setup storage first. Run termux-setup-storage and then cd storage into the dir where the db is stored before the conversion.

[braniii]

It should be possible to import the openScale csv export into trale directly. Is there any benefit of using the sqlite database?

[markushhh]

Looks like it's the same.

[qqii]

That's great! Closed by #227.