Importing CSV file

[Danila Mansfield]

Hi, told you I'd be back! 

I hope to recreate past dives and import into Subsurface desktop. I created a test file, with 3 dives, see attached. In Excel, saved as CSV. When I import into Subsurface, it only imports one dive, number 3, with a "default" date of 31 Dec 1999.

I read Appendix D of the Subsurface user manual, and changed the list separator to TAB as suggested, but that didn't show all the columns in the import box, so I changed it back to ,

Any suggestions please?

Here's a screenshot of the import:

[JB2Cool]

I wonder if it needs a time associated with the dives. Could be worth putting in nominal times like 8am, 11am and 2pm to see if that helps. Not something I've tried before.

JB

--
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 on the web visit https://groups.google.com/d/msgid/subsurface-divelog/8486613a-a1f1-4a69-aa94-97ed231a446f%40googlegroups.com.

[Miika Turkia]

The date has to be in format we understand for it to be parsed correctly. There are 3 options that you can look from the configuration drop-down menu, and the year has to be 4 digits.

I did a quick test and it seems that max depth is required for all the dives to be imported. I will take a look probably next week to see why the max depth is required. I guess I thought that everybody has some idea of depth of a dive when I wrote the importer - yet another false assumption :D

[Danila Mansfield]

Hi Jason,

good thought, tried it, but it didn't work. Still just importing only 1 dive.

---

Read my travel blog: www.notdunroamin.com

Click here to follow:  https://www.notdunroamin.com/subscribe-to-newsletter/ 

To view this discussion on the web visit https://groups.google.com/d/msgid/subsurface-divelog/CACuYfN7XTaD91DTzs4ia%3DMe4At04_h6vXoUfhRfDtAck5fjHUg%40mail.gmail.com.

[Danila Mansfield]

Hi Miika,

ok, I changed the date format, and now it's importing the correct date, hooray! 

I added a max depth, and different times for each dive, but it's still only importing one dive.

Yes, of course we should know the max dive depth :D but I'm try to recreate nearly 900 dives, since I stopped logging 6 years ago, and have to "guess" details!

Any other suggestions please?

[Danila Mansfield]

sorry meant to paste the latest screenshot:

On Monday, 9 March 2020 12:35:03 UTC, Danila Mansfield wrote:

[JB2Cool]

Try the format like this, this seems to work for me and imports 3 dives

--
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 on the web visit https://groups.google.com/d/msgid/subsurface-divelog/3372a33a-4d41-457e-ad99-2e8900c7a004%40googlegroups.com.

[Danila Mansfield]

ah brilliant, thanks so much! I've been fiddling with it myself, and was just going to post that it seems to import all 3, in fact I tried 6: 2 different dates, 3 dives each, and it imported just fine! The issue seems to be not putting in the same depth for each dive.

But now... yeah, there's always a but! I'm not able to renumber the dives. So I have existing dives 1-60, then new dives 1-6. They'll renumber if I highlight ALL the dives, but not just if I have the cursor on the latest. That however is a pretty minor issue!

I'm getting there, now I just have to scour my brain for diving over the past 24 years!

Thanks SO much!!

On Monday, 9 March 2020 14:50:11 UTC, JB2Cool wrote:

Try the format like this, this seems to work for me and imports 3 dives

On Mon, 9 Mar 2020 at 14:18, Danila Mansfield <danilama...@gmail.com> wrote:

sorry meant to paste the latest screenshot:

On Monday, 9 March 2020 12:35:03 UTC, Danila Mansfield wrote:

Hi, told you I'd be back! 

I hope to recreate past dives and import into Subsurface desktop. I created a test file, with 3 dives, see attached. In Excel, saved as CSV. When I import into Subsurface, it only imports one dive, number 3, with a "default" date of 31 Dec 1999.

I read Appendix D of the Subsurface user manual, and changed the list separator to TAB as suggested, but that didn't show all the columns in the import box, so I changed it back to ,

Any suggestions please?

Here's a screenshot of the import:

--
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-divelog+unsub...@googlegroups.com.

[Jason Bramwell]

I didn’t test fully but I thinking it was the duration that was throwing it off, yours seemed to be in the format 00:00:00 so that’s hours, minutes and seconds, that might have been confusing it.

 

JB

 

Sent from Mail for Windows 10

 

From: Danila Mansfield
Sent: 09 March 2020 15:18
To: Subsurface Divelog
Subject: Re: Importing CSV file

 

ah brilliant, thanks so much! I've been fiddling with it myself, and was just going to post that it seems to import all 3, in fact I tried 6: 2 different dates, 3 dives each, and it imported just fine! The issue seems to be not putting in the same depth for each dive.

But now... yeah, there's always a but! I'm not able to renumber the dives. So I have existing dives 1-60, then new dives 1-6. They'll renumber if I highlight ALL the dives, but not just if I have the cursor on the latest. That however is a pretty minor issue!

I'm getting there, now I just have to scour my brain for diving over the past 24 years!

Thanks SO much!!

On Monday, 9 March 2020 14:50:11 UTC, JB2Cool wrote:

Try the format like this, this seems to work for me and imports 3 dives

 

On Mon, 9 Mar 2020 at 14:18, Danila Mansfield <danilama...@gmail.com> wrote:

sorry meant to paste the latest screenshot:

 

 

 

 

On Monday, 9 March 2020 12:35:03 UTC, Danila Mansfield wrote:

Hi, told you I'd be back! 

I hope to recreate past dives and import into Subsurface desktop. I created a test file, with 3 dives, see attached. In Excel, saved as CSV. When I import into Subsurface, it only imports one dive, number 3, with a "default" date of 31 Dec 1999.

I read Appendix D of the Subsurface user manual, and changed the list separator to TAB as suggested, but that didn't show all the columns in the import box, so I changed it back to ,

Any suggestions please?

Here's a screenshot of the import:

 

--
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 on the web visit https://groups.google.com/d/msgid/subsurface-divelog/3372a33a-4d41-457e-ad99-2e8900c7a004%40googlegroups.com.

--

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 on the web visit https://groups.google.com/d/msgid/subsurface-divelog/42d99a8c-d49f-4c24-91a4-fa3d18816f40%40googlegroups.com.

 

[Danila Mansfield]

ah yes well spotted, I've now added some 60 hour long dives! oops!

---

Read my travel blog: www.notdunroamin.com

Click here to follow:  https://www.notdunroamin.com/subscribe-to-newsletter/ 

To view this discussion on the web visit https://groups.google.com/d/msgid/subsurface-divelog/5e666f4c.1c69fb81.7db83.ac70%40mx.google.com.