DiveLog in MS Access 2000

[jvoets]

As a learning project, I'm currently working on an MS Access 2000 database that will import CSV files from the Suunto Dive Manager software (you know, the stinger, mosquito etc...).

Goal of this application will be for me to learn the ins & outs of Access 2000 and to have some nice statistical overviews that are not available in the Suunto software itself, like nr of dives per month. Or distribution of depths of freedives.

Anyone interested in this database?
Or any good ideas for reports ?

 

[Jesper Juul]

I already made it

Hi

I've made such at tool already. It reads the CSV files, and creates a new CSV with extended statistics. eg. total apnea time of the day, "vertical distance" and so on.

Perhaps you should take a look at my project website.

http://hfk.dk/logbook

Contact me if you need the VB6 source for parsing the Suunto CSV's

Br
Jesper Juul Pedersen
Copenhagen, Denmark

 

[jvoets]

Hi Jesper,

looks good. I'm certainly interested in your software.
There are so many new divelogs around, all of them with their good & bad things. The scubanet logbook that was in the Deeper Blue mailing also looks very impressive.

 

[jvoets]

Not finished at all yet. But a workable version of my homegrown database can be found here .

It's presuming you stored everything in metric units and that every dive contains a site / location field.

 

[Jesper Juul]

Updated software

I have now completed my HTML based logbook tool. The tool can now be downloaded from this website:

http://hfk.dk/logbook

Please take a look at it. I will enjoy to receive feedback about the project.

Best regards
Jesper

 

[Jesper Juul]

Feedback

If some of you tried the logbook at http://hfk.dk/logbook, could you please post a reply if it worked for you?

Btw. I have updated the stuff on the webpage.

Br
Jesper

 

[jvoets]

Hi Jesper

I just installed and ran your logbook software. Works fine.
I have some remarks though.
1) my scuba profiles appear in the freedive series too
2) looks like you have hardcoded the depth range to 0-25 meters
and the time range 0-3500 (in tenths of seconds?)
my dives are a lot shallower and less long so the lines in the graphs are very much attracted to x-axis

what did you write the software in? is it C?

 

[Jesper Juul]

Hi Jvoets

-
UPDATE: A new version that ignores SCUBA dives can now be downloaded from www.hfk.dk/logbook
-

I am now working on functionality to ignore the SCUBA dives, and I think I have found a solution. But since I have not used my Mosquito for SCUBA at all, I am not able to test this function.

Could I please ask you to email your 4 .csv files that contain both SCUBA and FREE dive data to jesper@hfk.dk

Then I am able to test if the "ignore scuba" function works on real data.

The ranges that is used for drawing the graphics, is your deepest and longest dives. Since your SCUBA dives is very long (and deep), these ranges does not work well on your data. That is what messes up the x-axis (and y-axis).

The program is coded in Visual Basic 6.

Br.
Jesper

 

[jvoets]

Hi Jesper

to distinguish between free- and scuba dives, you can use the 5th field in the exported CSV file (the main one, without the $ in the name).
If this field contains the value -1 it is a freedive, otherwise it is the incremented scuba dive nr.

Another nice option would be to have the maximum depth & time in each graph set according to the maximums found in that particular series, instead of the maximum of all dives