Problem importing from Oceanlog

Discussions about Diving Log 6.0 - questions and hints
Post Reply
Johnnt
Posts: 11
Joined: Thu Sep 06, 2007 11:15
Location: Ashurst Wood UK

Problem importing from Oceanlog

Post by Johnnt »

I have sent this by email, sorry if I am repeating myself.

I have a strange problem with importing data from Oceanlog. When the dive has been imported, it seems to have transposed some of the data.

At 30 second intervals, Oceanlog reports my depth to be 2.1m 8.8m 17.7m but in Diving Log it is listed as 2.13m, 17.68m, 8.84m.

This makes my profile look like I bounced up from 17.7m to 8.8m then continued my decent.

On investigation of the Oceanlog database file I wonder if it could it be possible that your import query does not take DIVEDETAILS.ORDNO into account?

The raw data seems to hold the data in the order that it is displayed in Diving log, but if I run the query below the data is displayed in the correct order.

SELECT DIVEDATA.LIFETIMEDIVENO, DIVEDATA.DIVEID, DIVEDETAILS.DEPTH, DIVEDETAILS.BTIME, DIVEDETAILS.ORDNO
FROM DIVEDATA INNER JOIN DIVEDETAILS ON DIVEDATA.DIVEID = DIVEDETAILS.DIVEID
WHERE (((DIVEDATA.LIFETIMEDIVENO)=10))
ORDER BY DIVEDATA.LIFETIMEDIVENO, DIVEDETAILS.BTIME, DIVEDETAILS.ORDNO;

Is there any way to prevent this?

John.
divinglog
Site Admin
Posts: 5768
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Post by divinglog »

Hi John

I haven't got an email from you regarding this problem. Can you send me your Oceanlog logbook file and the dive number (or date) of the dive you're talking above? I think you're right, it should be only a SQL problem. Thank you for the query, I'll compare that with mine and if there is a part missing, I'll fix it.

Kind regards,
Sven
Johnnt
Posts: 11
Joined: Thu Sep 06, 2007 11:15
Location: Ashurst Wood UK

Post by Johnnt »

Can you confirm the address I should send it to please.

John.
divinglog
Site Admin
Posts: 5768
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Post by divinglog »

You can use info@divinglog.de
Johnnt
Posts: 11
Joined: Thu Sep 06, 2007 11:15
Location: Ashurst Wood UK

Post by Johnnt »

Email has been sent with requested file.

Thank you,

John.
divinglog
Site Admin
Posts: 5768
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Post by divinglog »

Thank you, got it. I'll take a look into it.
divinglog
Site Admin
Posts: 5768
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Post by divinglog »

You're right, I sort only the column BTIME, but in this case there are 2 samples at the same time (60 seconds), so I have to sort also the ORDNO column. I'll fix this with the next update. In the meantime you can change the 2 depth values in the profile data tab of the logbook after importing.

Kind regards,
Sven
Johnnt
Posts: 11
Joined: Thu Sep 06, 2007 11:15
Location: Ashurst Wood UK

Post by Johnnt »

That is great. I will look forward to the next release.

Thank you.

John.
Johnnt
Posts: 11
Joined: Thu Sep 06, 2007 11:15
Location: Ashurst Wood UK

Post by Johnnt »

Just out of interest, when you you plan to release the next version?

Roughly, of course :)
divinglog
Site Admin
Posts: 5768
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Post by divinglog »

I think it will take 3 or 4 weeks, because I'm working on some bigger changes. Do you need the fix soon? I think the problem shouldn't appear on many dives?
Johnnt
Posts: 11
Joined: Thu Sep 06, 2007 11:15
Location: Ashurst Wood UK

Post by Johnnt »

I am not in a rush, I was just curious.

John.
Post Reply