Bad date import from Oceanic .txt file

[mstevens]

I'm using MacDive 2.3.0 and trying to import nearly a thousand dives from 3 different logs in Aeris ACI 2.3.2 (analogous to Oceanic Oceanlog 2.4.3). I've exported the dives in the form of CSV .txt files then imported them into MacDive.

Mostly, this seems to go OK. I could deal with manually assigning location data, diver, etc. However, dates are REALLY screwed up.

For example, I now have a lot of dives in MacDive that show purported dates in 2015, 2016, 2018, and 2019 (but none, oddly, in 2017). This means I can't correlate the dives in MacDive with those in ACI in order to correct them. Times are messed up as well, as evidenced by lots of dives in the middle of the night or other very implausible times.

It's not easy to tell if there's any consistent pattern to the incorrect dates and times. Even if I were able to correlate dives between MacDive and ACI, I really don't relish the notion of hand-correcting many hundreds of dates and times.

I can't test importing the files back into ACI since the current version (and the current version of Oceanlog) doesn't support import of CSV files, only DL7 .zxu files and Pelagic's proprietary .dlg format.

Any ideas what I can do about this?

[nick]

Email me a few sample files so I can take a look.

[mstevens]

Thanks for the quick response. I've emailed some CSV files.

[nick]

Yep, got 'em. Thanks - as per my email I'll get back to you as soon as I get home from work and figure out what's going wrong.

[nick]

New beta sent which should resolve the issue. The files vary from version to version (from Oceanlog) and they store the dates a number of different ways. Turns out when I was "improving" that recently I was looking at a very obscure file, possibly from an old version, that had the dates in a completely different format.

Should handle all of the cases I've seen now, so sorry about that.

[mstevens]

Now I'm at work on Monday morning so I'll see what's up when I get home.

I've got to say that quite some support: a few hours from problem report to beta version in my email!

[nick]

I try and provide fixed versions as soon as possible, nothing worse than things not working. Generally it's a bit quicker, you just caught me the second I was walking out the door for the day job so I didn't have time to fix it before I left!