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.
Problem importing from Oceanlog
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
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
You can use info@divinglog.de
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
Kind regards,
Sven