Page 1 of 1
export gear as csv
Posted: Thu Jun 28, 2012 4:03 am
by jeroenda
Few questions that would make this nice product even nicer:
q1: when I do an export, "purchase price" is in the header but it isn't exported. Can I fix that ?
q2: "weight" of the gear is not in the exported data, nor in the header. Can I fix that?
q3: same for "purchased from" and "warranty"
q4: it would be nice to be able to list both the dry weight (for transport) and the underwater weight (to make trimming easier when using different gear)
q5: it would be nice to be able to harmonize the x-scale of the dive graph. So far my dives vary between 15 and 45 minutes. I would set the scale max to 45 or 60 instead having it floating, if possible.
Thanks, Jeroen.
Re: export gear as csv
Posted: Thu Jun 28, 2012 4:09 am
by nick
jeroenda wrote:Few questions that would make this nice product even nicer:
q1: when I do an export, "purchase price" is in the header but it isn't exported. Can I fix that ?
q2: "weight" of the gear is not in the exported data, nor in the header. Can I fix that?
q3: same for "purchased from" and "warranty"
q4: it would be nice to be able to list both the dry weight (for transport) and the underwater weight (to make trimming easier when using different gear)
I'll look at these.
q5: it would be nice to be able to harmonize the x-scale of the dive graph. So far my dives vary between 15 and 45 minutes. I would set the scale max to 45 or 60 instead having it floating, if possible.
Thanks, Jeroen.
View -> Normalise Profile Depth
This will normalise all profile scales to the maximum depth in the currently selected playlist.
Edit: Oops, sorry, X, not Y

I'll put it on the list.
Re: export gear as csv
Posted: Sun Nov 24, 2013 10:03 pm
by jeroenda
Hi Nick, the underneath in following up on last years wishes :
Q1 : works fine now.
Q2/Q3 : it would be nice to be able to select the items you want to export in a dropdown menue, like it is with the export of dives.
Q4 : still open / still a nice feature for me.
Q5 : still open / still a nice feature for me .. adding 'Normalize Profile Time' would work out perfect for me
Additional request:
Q6 : The average sac rate graph would improve from 2 enhancements I believe:
- Normalize Y axis between lowest and highest value in the selection (iso between 0 and highest);
- Enable seeing the graph in full screen mode.
Furthermore I came across a problem with importing the CSV files in a spreadsheet :
When I import the csv in Excel, the " stay in the columns whatever I do. Every cell is treated as text.
When I import the csv in LibreOffice, the " disappear and dates are recognized as dates. Numbers (Purchase price) are still seen as text however. If I change the numbers (123 instead of 123.00) LibreOffice treats them as numbers.
I am using the Dutch versions of Excel and LibreOffice
Regards, Jeroenda
Re: export gear as csv
Posted: Mon Nov 25, 2013 3:30 am
by nick
I will have a look in to these issues. Some of them are easily addressed.
Re: export gear as csv
Posted: Sat Nov 30, 2013 7:34 am
by nick
For the next release, I have added Weight, Purchased From/Shop, Warranty. I also removed the quotes from Price, which should hopefully help with one of your apps.
Not sure what you mean about price isn't exported - I see it in mine. Maybe this was to do with the quotes, try the new release once it's out and we'll go from there.
Re: export gear as csv
Posted: Mon Jan 27, 2014 8:01 pm
by jeroenda
Hi Nick,
just finished exploring the new release, nice update!
re my earlier questions:
Q1, Q2 and Q3 have now been resolved, thanks.
Q4, Q5, Q6 remain on my wishlist, especially 5 and 6.
As to the other 2 issues:
I can't get rid of the "" in excel. In the first column they disappear but in the other columns they remain.
In Libre Office the "" disappear as expected.
I resolved the numbers/text issue by changing the number format from EU standard to US standard. No issue.
Regards, Jeroen.
Re: export gear as csv
Posted: Tue Jan 28, 2014 6:29 am
by nick
I'll take a look at the rest. I have some other users with some features requests also, so I'll do what I can!