Page 1 of 1

Bad dates on CSV import from Aeris Elite T3

Posted: Mon Nov 03, 2014 1:34 am
by pnebauer
Hi all.

I just purchased MacDive 2.3.5 and I'm having issues while trying to import dive data from two Aeris T3 computers that were exported from the Aeris ACI app on Windows. The data was exported in Oceanic CSV/Text format.

When I import the dives into MacDive, all the dates are incorrect, and it looks like the month and day are switched on most dives. Strangely it is showing that I have completed dives in the future (2015) on my computer, but my spouse's computer does not, even though we did all the same dives.

I think the dive number was imported correctly, so at least I am able to sort by chronological order, but since I don't have correct dates it makes it very difficult to try and correlate each dive with an actual date.

Here is a sample of the data I'm importing. This one shows up as 5/12/15 in MacDive.

Code: Select all

Life Time Dive #: 157
DC Model: ELITE T3
DC Serial #: 2306
DC Dive #: 17
Dive Date: 29/12/2013
Dive Time: 10:21
Dive Mode: Normal
Surface Interval: 16:44
Max. Depth: 44 FT
Elapsed Dive Time: 81 min.
Min. Temperature: 79 F
Any suggestions on how to fix this problem?

Thanks,
-Pete

Re: Bad dates on CSV import from Aeris Elite T3

Posted: Mon Nov 03, 2014 1:54 am
by nick
Basically the issue is that there isn't really any context in those files as to how the date is stored - it's based on your locale settings. MacDive has to guess whether it's in dd/mm or mm/dd. In this case you look to have european style dates, but the other data is stored in imperial. So it's importing the dates the wrong way around, giving you strange results. While this particular date is obviously in dd/mm, that won't be the case for other dates (6/6, for example).

These files are unfortunately very annoying to read. You could try making sure your locale settings match, by changing to metric and exporting (or ensuring your date is in mm/dd). If that's a hassle, then you can email me the files. I'll import them with the dates in the correct order and send you back something more useful.

Bad dates on CSV import from Aeris Elite T3

Posted: Sat Dec 13, 2014 2:56 am
by ParabikMiPhep
Hi,

the csv export functionality exports only the current page, not the whole report information if the report has 100 pages, csv exports only 1 current page. How do i change it, so the csv exports the whole list..?

Thank you.