Export to XLS or CSV, gasses not exported and no Buddy names

Discussions about Diving Log 6.0 - questions and hints
Post Reply
Buceador
Posts: 27
Joined: Mon Apr 01, 2013 19:46

Export to XLS or CSV, gasses not exported and no Buddy names

Post by Buceador » Tue Sep 11, 2018 19:32

Hi,

Two questions

Exporting my dives to XLS or CSV does not give the possibility to list the different gasses used. Just the main one. Do I oversee anyhing?
Second. The column of Buddies only contains a single number, probably an ID of the first buddy. Is there an other way to export this to the spreadsheet?

Thanks!

divinglog
Site Admin
Posts: 4963
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: Export to XLS or CSV, gasses not exported and no Buddy names

Post by divinglog » Sat Sep 15, 2018 00:22

Hi

Yes, you can only export the dive table (one dive per row), so yes, the additional tanks are missing in the Excel export right now. Regarding Buddy: I guess you've exported the column BuddyID, not Buddy? When you select "Buddy", it should contain the name.

Kind regards,
Sven

Buceador
Posts: 27
Joined: Mon Apr 01, 2013 19:46

Re: Export to XLS or CSV, gasses not exported and no Buddy names

Post by Buceador » Wed Sep 19, 2018 11:14

Hi Sven,

I did use the column Buddy. For some dives the buddy name is exported, however in most cases only a number is shown.

divinglog
Site Admin
Posts: 4963
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: Export to XLS or CSV, gasses not exported and no Buddy names

Post by divinglog » Wed Sep 19, 2018 11:52

Can you have a look into the logbook table window to see if the buddy name is contained in the buddy column for these dives? Please send me also your logbook file and which dives are affected. I've just tested it and the buddy name is exported for me when the "Buddy" column is selected. Only the BuddyID column normally contains a number.

divinglog
Site Admin
Posts: 4963
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: Export to XLS or CSV, gasses not exported and no Buddy names

Post by divinglog » Thu Sep 20, 2018 12:04

Thank you for the files. You are exporting to CSV, not Excel, that's an important difference. CSV is a comma separated text file. Buddies are separated by comma, that's why it does not work as expected. You can change the separator in the export settings. Or you can simply export directly to Excel format.

Buceador
Posts: 27
Joined: Mon Apr 01, 2013 19:46

Re: Export to XLS or CSV, gasses not exported and no Buddy names

Post by Buceador » Thu Sep 20, 2018 12:13

Thanks! Stupid mistake. The depth most of the times has a comma in it, which caused to shift the decimal to the next column, which happend to be DiveBudddy...
p.s. I do not use Excel but Calc (open Office), then the program cannot export to XLS.

divinglog
Site Admin
Posts: 4963
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: Export to XLS or CSV, gasses not exported and no Buddy names

Post by divinglog » Thu Sep 20, 2018 12:20

Ahh thanks, that makes sense! Yes, the Excel export needs Excel to be installed. I should have used a different CSV separator by default, I haven't thought about the comma in numbers and buddies. I'll change that in the next update. In the meantime, just click on "Settings" in the CSV export and change it to a semicolon. Thanks for the feedback!

Post Reply