Suunto-Convert CSV-File to SDL-File /SDE-File

[sarcon]

Hi,

is it possible to convert an csv-File into SDL-File/SDE-File (Suunto Dive Manager)??
It could be maybe indirectly??? for example:

csv-File >>>> xxx-File >>>SDL-File/SDE-File

I would appreciate too much, if someone could give me a indication.

[DuboisP]

Hi,
is it possible to convert an csv-File into SDL-File/SDE-File (Suunto Dive Manager)??
It could be maybe indirectly??? for example:

csv-File >>>> xxx-File >>>SDL-File/SDE-File

I would appreciate too much, if someone could give me a indication.

Hello
for Suunto Dive Manager 2 :
In fact the file exported by SDM 2 ( SDE file) is a ZIP file containing a XML file.
By renaming the SDE file to ZIP, you can open it and see the XML.
You can view the XML structure.
If you convert your CSV file to the correspondant XML and do the reverse, i think you can import your dive.
And no, I don't have the programm to do it directly !

[CIBDiving]

It's not that hard - provided you know what format the csv uses.

get this - CSVed at http://home.hccnet.nl/s.j.francke/t2t/text2table.htm

convert your data to XML then see how that compares with suunto's format. It would be fairly simple to build a 'translator' from that.

[rjvencken]

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..?)

[rjvencken]

Now I have a little tool for batch importing dives from before you had the DC into Suunto Dive Manager.
Just PM me to get it:
padi.974663@gmail.com
Read all about it here:
Robert Jan Vencken - hyves.nl

More keywords: extract SDM migrate upload convert export zip SDE CSV