You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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="5c578e86-dff0-4c62-b879-c0c2d28df84a"><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="975ce72f-9dfc-43b6-891a-515f2b500d86"><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:

  • No labels