Fwd: Difficulty with CSV import

[Willem Ferguson]

On 2019/01/23 15:37, Willem Ferguson wrote:
>
> ---------- Forwarded message ---------
> From: *Mark Schlagenhauf* <mark.schlagenhauf at gmail.com 
> <mailto:mark.schlagenhauf at gmail.com>>
> Date: Wed, 23 Jan 2019, 06:24
> Subject: Difficulty with CSV import
> To: <subsurface at subsurface-divelog.org 
> <mailto:subsurface at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.subsurface-divelog.org/pipermail/subsurface/attachments/20190123/2bb31d05/attachment-0001.html>