<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 2019/01/23 15:37, Willem Ferguson
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CANyyeo3=4jN7Tt0dLEQ0qaNANENAaa5ws6wNpzTZW7zzOs7J-A@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<br>
<div class="gmail_quote">
<div dir="ltr">---------- Forwarded message ---------<br>
From: <strong class="gmail_sendername" dir="auto">Mark
Schlagenhauf</strong> <span dir="ltr"><<a
href="mailto:mark.schlagenhauf@gmail.com"
moz-do-not-send="true">mark.schlagenhauf@gmail.com</a>></span><br>
Date: Wed, 23 Jan 2019, 06:24<br>
Subject: Difficulty with CSV import<br>
To: <<a href="mailto:subsurface@subsurface-divelog.org"
moz-do-not-send="true">subsurface@subsurface-divelog.org</a>><br>
</div>
<br>
<br>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">Hi,
<div><br>
</div>
<div>I started using subsurface recently and really like
it. It works really well with my Eon Core.</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>As a test, I exported my dives, added a dive, then
tried to re-import them. But, some dives don't show up.</div>
<div><br>
</div>
<div>My test file is as follows:</div>
<div>
<div>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</div>
<div>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</div>
<div>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</div>
<div>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</div>
<div>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</div>
<div>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</div>
</div>
<div><br>
</div>
<br>
<div>Thank you.</div>
<div><br>
</div>
<div>Mark</div>
</div>
</div>
</div>
</div>
</blockquote>
<p>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.</p>
<p>Kind regards,</p>
<p>willem</p>
<p><br>
</p>
</body>
</html>
<br>
<div style="font-family:Arial,Helvetica,sans-serif"><span style="font-size:10.0pt;line-height:105%;font-family:"Segoe UI",sans-serif">This message and attachments are subject to a disclaimer.<br>
Please refer to <a href="http://upnet.up.ac.za/services/it/documentation/docs/004167.pdf" target="_blank">http://upnet.up.ac.za/<wbr>services/it/documentation/<wbr>docs/004167.pdf</a> </span><span style="font-size:10pt;line-height:105%;font-family:Tahoma,sans-serif">for
full details.</span></div>