<div dir="ltr">Hi Willem,<div><br></div><div>Thanks for responding!</div><div><br></div><div>Oddly, that dive was one of the dives that _was_ importing correctly. However, I got things working. I re-exported everything again, then re-imported it. That seems to have taken care of things. I think the reason I got that weird duration is that I imported the CSV into Google Sheets for editing and Google Sheets re-formatted the duration into 00:00:00 format. I fixed that.</div><div><br></div><div>Anyway, thanks!</div><div><br></div><div>Mark</div></div><br><div class="gmail_quote"><div dir="ltr">On Wed, Jan 23, 2019 at 5:57 AM Willem Ferguson <<a href="mailto:willemferguson@zoology.up.ac.za">willemferguson@zoology.up.ac.za</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF">
<div class="gmail-m_-6828841879351691362moz-cite-prefix">On 2019/01/23 15:37, Willem Ferguson
wrote:<br>
</div>
<blockquote type="cite">
<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" target="_blank">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" target="_blank">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>
</div>
<br>
<div style="font-family:Arial,Helvetica,sans-serif"><span style="font-size:10pt;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/services/it/documentation/docs/004167.pdf</a> </span><span style="font-size:10pt;line-height:105%;font-family:Tahoma,sans-serif">for
full details.</span></div></blockquote></div>