Tags: extract convert upload import suunto dive manager old dives sde cvs xml zip howto
This is how I did it:
0. First and foremost: Backup the dives you did logged with you divecomputer using SDM's backup function
menu:
Action>Backup database
Copy the resulting *.bak file to a safe place and learn how to restore before you go to the stuff below
menu:
Action>Restore database
1a. Export one dive with a lot of filled out fields from SDM. This will result in a *.SDE file.
menu:
File>Export...
b. Rename that file changing the extension from SDE to ZIP.
c. Open the resulting file with WinZip or similar tool.
d. You'll now see a XML file which you can open with any text-editor such as Notepad.
e. You'll get something like:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
<?xml version="1.0" encoding="ISO-8859-15" ?>
<SUUNTO><HEADER><MSGNAME>SDM001A</MSGNAME>
<MSGPACKING>1</MSGPACKING>
</HEADER>
..........
..........
<MSG><WRISTOPID>0</WRISTOPID>
<SAMPLECNT>0</SAMPLECNT>
<DATE>06.08.2001</DATE>
<TIME>11:30:00</TIME>
<MAXDEPTH>5</MAXDEPTH>
<MEANDEPTH>0</MEANDEPTH>
<SAMPLEINTERVAL>20</SAMPLEINTERVAL>
<LOGTITLE>212. ~</LOGTITLE>
<LOGNOTES></LOGNOTES>
<FOLDER></FOLDER>
<LOCATION>Egypt</LOCATION>
<SITE>Naama Bay</SITE>
<WEATHER></WEATHER>
<WATERVISIBILITY>0</WATERVISIBILITY>
..........
..........
..........
..........
..........
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
2a. On each line after the header you'll see two so called XML-tags with a value in between sometimes. Notice the difference between before and after tags!! Figure out which tags you need by comparing with what's in SDM.
b. Have your old dives available in Excel format (back it up!!) and flank each column with two new ones containing the appropriate tags
So
...Egypt Naama Bay..
...Egypt Naama Bay..
...Egypt Naama Bay..
Will become
...<LOCATION>Egypt</LOCATION> <SITE>Naama Bay</SITE>...
...<LOCATION>Egypt</LOCATION> <SITE>Naama Bay</SITE>...
...<LOCATION>Egypt</LOCATION> <SITE>Naama Bay</SITE>...
c. Just be sure to include the following tags
<DATE>06.08.2001</DATE> format MM-DD-YYYY !!!!
<TIME>14:30:00</TIME>
<MAXDEPTH>5</MAXDEPTH>
<LOCATION>Egypt</LOCATION>
<SITE>Naama Bay</SITE>
<DIVENUMBER>1</DIVENUMBER>
<DIVETIMESEC>0</DIVETIMESEC> Yes that's your divetime in seconds!
and do NOT use
<LOGTITLE>212. ~</LOGTITLE>
(because it probably messes up the order in the resulting merger of old and new dives)
d. Add this as your first column:
<?xml version="1.0" encoding="ISO-8859-15" ?><SUUNTO><HEADER><MSGNAME>SDM001A</MSGNAME><MSGPACKING>1</MSGPACKING></HEADER><MSG>
and </MSG></SUUNTO> your last
e. Save the newly created Excel-file with a different name.
f. Create a folder folder such as "OldDives"
3a. Now copy/paste one row(representing one dive) into a text editor.
(b.) You do NOT need to take the following steps to achieve the format you had in the exported XML file
I. Maintain tag order
II. Remove spaces/tabs between tags and values
III. Wrap <TAG><<Value>></TAG> to vertical
c. Save as <<Divenumber>>.XML into newly created folder ("OldDives")
(Yes you have to repeat this for each dive. Putting more than one into an XML-file will result in just one dive being imported. Believe me I tried..)
d. Repeat steps a. and c. for each row in your Excel-sheet.
4a. You now have folder "OldDives" containing a bunch of XML files w/ names indicating the dive they contain.
Example:
001.XML
002.XML
...
...
012.XML
013.XML
014.XML
...
...
b. Zip all XML-files into an archive called OldDives.zip (be sure not to have anything else in the created archive).
c. Rename OldDives.zip to OldDives.SDE
d. Import OldDives.SDE with SDM
File>Import...
And there you have 'em. Check to see all dives and all fields got imported and that your have them in the correct order.
If not then see where the problem lies and try again from step 1. after you restore SDM as you learned in step 0. (or didn't you..?)
