Fwd: Difficulty with CSV import

Mark Schlagenhauf mark.schlagenhauf at gmail.com
Wed Jan 23 18:17:37 PST 2019


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 <
willemferguson at zoology.up.ac.za> wrote:

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


More information about the subsurface mailing list