On 2019/01/23 15:37, Willem Ferguson wrote:
---------- Forwarded message ---------
From: *Mark Schlagenhauf* <mark.schlagenh...@gmail.com
<mailto:mark.schlagenh...@gmail.com>>
Date: Wed, 23 Jan 2019, 06:24
Subject: Difficulty with CSV import
To: <subsurface@subsurface-divelog.org
<mailto:subsurface@subsurface-divelog.org>>
Hi,
I started using subsurface recently and really like it. It works
really well with my Eon Core.
I'm trying to manually add all my old dives, but I want to just
populate a spreadsheet and import rather than trying to use the UI.
But, the import isn't working.
As a test, I exported my dives, added a dive, then tried to re-import
them. But, some dives don't show up.
My test file is as follows:
dive number,date,time,duration (min),maxdepth (ft),avgdepth
(ft),airtemp (F),watertemp (F),cylinder size (cuft),startpressure
(psi),endpressure (psi),o2 (%),he
(%),location,gps,divemaster,buddy,suit,rating,visibility,notes,weight
(lbs),tags
37,2019-01-03,9:10:10,47:10:00,81.69,53.67,,81,80,3118,421,,,Elbow -
Belize,,Ed,Shannon and Alex,3.5 mil Waterproof W3,,,,10.01,boat
38,2019-01-03,11:22:56,68:21:00,69.62,40.68,,81,80,3031,609,,,The Zoo
- Belize,,Ed,Shannon and Alex,3.5 mil Waterproof W3,,,,10.01,boat
39,2019-01-04,8:17:22,62:23:00,71.59,45.01,,81,80,3046,508,,,The
Pennicle - Belize,,Ed,Shannon and Alex,3.5 mil Waterproof W3,,,,10.01,boat
40,2019-01-04,11:23:21,69:11:00,66.9,42.98,,81,80,3031,638,,,The Wild
Side - Blackbird Caye - Belize,,Ed,Shannon and Alex,3.5 mil Waterproof
W3,,,,10.01,boat
41,2019-01-04,14:49:54,61:00:00,42.36,32.84,,81,80,2988,1001,,,Majestic
Alley - Blackbird Caye - Belize,,Cardinal,Shannon and Alex,3.5 mil
Waterproof W3,,,,10.01,boat
Thank you.
Mark
Your time durations are wrong. The first dive (#37) is indicated as
47:10:00. That is 47 hours long!!. It should be 00:47:10, that is 47
minutes long. Correct your times and you should be ok.
Kind regards,
willem
--
This message and attachments are subject to a disclaimer.
Please refer to
http://upnet.up.ac.za/services/it/documentation/docs/004167.pdf
<http://upnet.up.ac.za/services/it/documentation/docs/004167.pdf> for
full
details.
_______________________________________________
subsurface mailing list
subsurface@subsurface-divelog.org
http://lists.subsurface-divelog.org/cgi-bin/mailman/listinfo/subsurface