Importing Dive Data from a CSV file

Anton Lundin glance at acc.umu.se
Fri Sep 23 11:28:54 PDT 2016


On 22 September, 2016 - Nick wrote:

> Hi, I have some old dive data in an Excel spreadsheet that I want to import
> into SubSurface, but am having some problems with some of the data. I have a
> number of dives that are longer than 60 minutes, and these are held in the
> CSV file in HH:MM:SS format. One dive for example is 1:09:00 (69 minutes)
> but when importing the duration is showing as 1m09s.
> 
>  
> 
> How can I import these correctly?
> 

You can rewrite your time to be on the format MM:SS , ie 69:09. That
a working workaround.


There is a bug in the csv import code. As far as i can read the bug is
at xslt/csv2xml.xslt:99 

<xsl:value-of select="concat(substring($time, 2, 2), ':', substring($time, 4, 2))"/>

To me that looks very much like "Take minutes and seconds, and don't
care about anything else. Also substring in xslt is 1-indexed, so we
throw away something in the beginning. Sense this makes none.


Miika: Am i just reading it wrong or how is this ment to work?


//Anton


-- 
Anton Lundin	+46702-161604


More information about the subsurface mailing list