Import csv Divelog

[Balazs]

Hello,

I want to import a dead simple csv, 3 columns

1 time in seconds

2 depth in m

3 Temp in C

I drag sample time on the first column (it stays time)
I drag sample depth on the second column (it changes from empty to sample depth)

I drag sample temperarature on the 3rd column (it stays Water temperature).

When I press import it creates around 500 seperate dives, even if I merge only garbage was imported.

Any ideas? A csv file cannot be much simpler than this.

[Darrell Barabash]

Maybe the .CSV file format has extra or unusual characters? Do a hexdump of the file. I find that tab field delimiters (0x09) and linefeed (0x0a) for the record delimiters parses fine. Just tried again after making a small file like you describe and no issue. Try the attached file and see it it works for you.

[Dirk Hohndel]

Please check the user manual, especially https://subsurface-divelog.org/subsurface-user-manual/#S_ImportingCSVDives
There are two different types of CSV imports. One imports a list of dives, the other imports a single dive with samples. It looks like you tried to import a single dive with depth samples as a list of dives, with predictably unsatisfactory results.

/D

[Balazs]

Hello,

I checked with a hex editor and didn't find any unusual character. The csv can be cleanly imported into libre office. Your test file works with subsurface.

When I add as first line this:

Time (sec),Depth,Water Temp

it stops working.
I removed this first line from the csv and it works.

Thanks for your help, it seems subsurface doesn't like column headings.

The issue is resolved for me.

[Darrell Barabash]

Glad you got it sorted. It does work with headings too. I use "" around the strings and tab delimited. As Dirk mentioned, is it possible that you accidentally selected "Import Dive Sites" which is next in the list? You could try ctrl-I which will launch the "import log files" directly.

Glad it's working for you. Subsurface Divelog is one absolutely awesome application. It never fails to blow my mind what a few key volunteer developers, with help from the community, can do. I certainly appreciate all their efforts.

--

You received this message because you are subscribed to the Google Groups "Subsurface Divelog" group.

To unsubscribe from this group and stop receiving emails from it, send an email to

subsurface-dive...@googlegroups.com

.

To view this discussion visit

https://groups.google.com/d/msgid/subsurface-divelog/56c353c2-bc8c-48ee-b683-82618ad72e6bn%40googlegroups.com

.