Suunto Dive Manager 3.0 (SDM)
Suunto has chosen not to make their dive manager database public accessible. However all the data you enter (be it automatic using your dive computer or just manual inserting your old logbook dives) is YOUR data, isn't it??? If you are convenient in using databases, then this is for you.
The database is MS Access compatible. It's protected with a password. I'm not sure if I'm allowed to tell it, but there are plenty of recovery tools available to get it (so don't ask me!). Further I only explain stuff that I was interested in, so it's not complete.
Database tables:
Items
Lists
Items
Field |
|
|
||
ItemID |
|
0=user, 3=dive, 8=dive_shortcut |
||
IconID |
|
|
||
Parent |
|
|
||
Name |
|
|
||
StartTime |
|
|
||
EndTime |
|
|
||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="2492a361-e071-4c9b-b3a5-3e1be1c2423b"><ac:plain-text-body><![CDATA[ |
Distance |
DiveTime |
[seconds] |
]]></ac:plain-text-body></ac:structured-macro> |
Memo |
|
|
||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="b455e90e-2b6c-4d54-9bd1-dee340cee4e8"><ac:plain-text-body><![CDATA[ |
d_custom9 |
MaxDepth |
[minutes] |
]]></ac:plain-text-body></ac:structured-macro> |
t_custom3 |
Location |
Bonaire |
||
t_custom4 |
Site |
Karpata |
||
t_custom6 |
Boatname |
|
||
t_custom8 |
Dive buddy |
|
||
t_custom10 |
avg/good? |
|
||
t_custom11 |
avg/good? |
|
||
t_custom12 |
Custom 1 |
Night Dive |
Structure of ItemID <- ParentID:
1 < User <- Category
-1 |
User |
|
46 |
|
|
|
All Dives |
47 |
|
|
|
My Dives |
48 |
|
|
|
Locations |
49 |
|
|
|
Dive Gear |
50 |
|
|
|
Simulations |
51 |
|
Example SQL queries:
AllDives
SELECT Items.ItemID, Items.Type, Items.IconID, Items.Parent, Items.UserID, Items.Name, Items.StartTime, Items.EndTime, Items.Distance, Items.Notes, Items.d_custom9, Items.memo
FROM Items
WHERE Items.Parent = <All Dives item of the user>
ORDER BY StartTime;
Resources used to get this information
Of course it took some time doing my own investigation, but some info helped:
- JonP wrote some fields