Hi Willem, Thanks for responding!
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. Anyway, thanks! Mark On Wed, Jan 23, 2019 at 5:57 AM Willem Ferguson < [email protected]> wrote: > On 2019/01/23 15:37, Willem Ferguson wrote: > > > ---------- Forwarded message --------- > From: Mark Schlagenhauf <[email protected]> > Date: Wed, 23 Jan 2019, 06:24 > Subject: Difficulty with CSV import > To: <[email protected]> > > > 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 for full > details. >
_______________________________________________ subsurface mailing list [email protected] http://lists.subsurface-divelog.org/cgi-bin/mailman/listinfo/subsurface
