Convert from "S Health" to GPX (v1.1 2015.10.16) - Samsung Gear S

Hi!
1) Pull from phone file /opt/usr/apps/com.samsung.shealth/data/.shealth.db
2) Open this file in SQLiteStudio
3) Open editor (Alt+E)
4) Add in editor the following:
Code:
select exerciseId, datetime(substr(startTimeStamp,1,10), 'unixepoch') as startTime from shealth_exercise_history order by startTimeStamp;
Select all (Crtl+A) and execute (F9).
You'll see all your trainings. Remember the value "exerciseId" of the desired training. For example "5".
5) Replace the contents of the editor by doing the following:
Code:
select '<?xml version="1.0" encoding="UTF-8" standalone="no" ?><gpx xmlns="http://www.topografix.com/GPX/1/1" xmlns:gpxx="http://www.garmin.com/xmlschemas/GpxExtensions/v3" xmlns:gpxtrkx="http://www.garmin.com/xmlschemas/TrackStatsExtension/v1" xmlns:wptx1="http://www.garmin.com/xmlschemas/WaypointExtension/v1" xmlns:gpxtpx="http://www.garmin.com/xmlschemas/TrackPointExtension/v1" xmlns:gpxpx="http://www.garmin.com/xmlschemas/PowerExtension/v1" creator="Samsung Gear S with Barometer" version="1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.topografix.com/GPX/1/1 http://www.topografix.com/GPX/1/1/gpx.xsd http://www.garmin.com/xmlschemas/GpxExtensions/v3 http://www8.garmin.com/xmlschemas/GpxExtensionsv3.xsd http://www.garmin.com/xmlschemas/TrackStatsExtension/v1 http://www8.garmin.com/xmlschemas/TrackStatsExtension.xsd http://www.garmin.com/xmlschemas/WaypointExtension/v1 http://www8.garmin.com/xmlschemas/WaypointExtensionv1.xsd http://www.garmin.com/xmlschemas/TrackPointExtension/v1 http://www.garmin.com/xmlschemas/TrackPointExtensionv1.xsd http://www.garmin.com/xmlschemas/PowerExtension/v1 http://www.garmin.com/xmlschemas/PowerExtensionv1.xsd"><metadata><link href="http://www.index3.ru"><text>iNDEX3</text></link><time>'||strftime('%Y-%m-%dT%H:%M:%SZ', datetime(substr(gh.startTimeStamp,1,10), 'unixepoch'))||'</time></metadata><trk><name>'||datetime(substr(gh.startTimeStamp,1,10), 'unixepoch')||' Auto</name><extensions><gpxx:TrackExtension><gpxx:DisplayColor>Cyan</gpxx:DisplayColor></gpxx:TrackExtension></extensions><trkseg>' as gps
from shealth_exercise_history gh where gh.exerciseId=XX
union all
select
'<trkpt lat="'||g.latitude||'" lon="'||g.longitude||'"><ele>'||g.altitude||'</ele><time>'||strftime('%Y-%m-%dT%H:%M:%SZ', datetime(substr(g.timeStamp,1,10), 'unixepoch'))||'</time><extensions><gpxtpx:TrackPointExtension><gpxtpx:hr>'||h.heartrate||'</gpxtpx:hr></gpxtpx:TrackPointExtension></extensions></trkpt>' as gpx
from shealth_exercise_gps_info g
left join (
select gt.timeStamp as g_timeStamp
, (select max(ht.timeStamp) from shealth_exercise_hrm_logging ht where ht.timeStamp<=gt.timeStamp and ht.exerciseId=gt.exerciseId) as h_timeStamp
, gt.exerciseId
from shealth_exercise_gps_info gt
) tsm on tsm.g_timeStamp=g.timeStamp and tsm.exerciseId=g.exerciseId
left join shealth_exercise_hrm_logging h on h.timeStamp=tsm.h_timeStamp
where g.latitude <> 200 and g.exerciseId=XX
union all
select '</trkseg></trk></gpx>';
Find in text "exerciseId=XX" and replace to value ("XX") to the value of your exerciseId ("5").
Select all (Crtl+A) and execute (F9).
6) Save result in txt file with extension ".gpx".
Enjoy
I have collected all scripts into one package:
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
1) Unzip and run "0.start.bat"
2) Enjoy x2
Update:
v1.1 Added option "Save all trainings"
[DOWNLOAD v1.1]

---

iNDEX3 said:
Hi!
1) Pull from phone file /opt/usr/apps/com.samsung.shealth/data/.shealth.db
2) Open this file in SQLiteStudio
3) Open editor (Alt+E)
4) Add in editor the following:
Code:
select exerciseId, datetime(substr(startTimeStamp,1,10), 'unixepoch') as startTime from shealth_exercise_history order by startTimeStamp;
....
Click to expand...
Click to collapse
Dear iNDEX3,
Would you mind explaining what GPX does, what are the benefits in comparing with S Health...etc.
--------------
PS: I'm a huge fan of 4pda.ru, although I know just a little Russian (enough to read the captcha when login, lol). I see that you guys have this cool tool called 'RogersTools' - allowing us to backup Gear S, but I don't understand it well (due to my limited understanding of Russian).
Would you guys mind sharing this awesome tools to us here at XDA? :good::good::good:

---

This is very interesting. Thanks for sharing.

---

hadobac said:
Would you mind explaining what GPX does, what are the benefits in comparing with S
Click to expand...
Click to collapse
For example, I load my tracks in strava. This is the first time.
hadobac said:
Would you guys mind sharing this awesome tools to us here at XDA?
Click to expand...
Click to collapse
I conveyed the request of the developer RogersTool

---

iNDEX3 said:
I conveyed the request of the developer RogersTool
Click to expand...
Click to collapse
Thanks bro. Way to go!
Also, is running this tool here as easy as ClockWorkMod, or TitaniumBackup?

---

hadobac said:
Also, is running this tool here as easy as ClockWorkMod, or TitaniumBackup?
Click to expand...
Click to collapse
Yes, it is very easy to use and reliable application. All actions are done in one click.
It pull .shealth.db file from the phone.
Instead, you can use commands SDB (Smart Development Bridge):
Code:
>sdb root on
>sdb pull /opt/usr/apps/com.samsung.shealth/data/.shealth.db

---

iNDEX3 said:
Yes, it is very easy to use and reliable application. All actions are done in one click.
It pull .shealth.db file from the phone.
Click to expand...
Click to collapse
The question was about the BACKUP, RESTORE (not only) for smart HOURS SAMSUNG GEAR S WITH ROOT FIRMWARE.

---

Shum Channel said:
The question was about the BACKUP, RESTORE (not only) for smart HOURS SAMSUNG GEAR S WITH ROOT FIRMWARE.
Click to expand...
Click to collapse
I did not understand the question
But I use this utility for backup. And it's brilliant!

---

Add package in the first post

---

how to use the script
Hi,
is there any way to get .shealth.db from the phone? I don't want to root the watch.

---

Sorry, i don't know how to get .shealth.db from the phone without root

---

.shealth.db file
Hello,
I have rooted note2 phone with root explorer, but cannot find .shealth.db file.
There is no directory: /opt/usr/apps/com.samsung.shealth/data/.shealth.db
I found /Android/data/com.sec.android.app.shealth/files but there is no database file.
Where can I find it on Kitkat 4.4.2?