Bad date import from Oceanic .txt file
Posted: Mon Feb 03, 2014 2:15 am
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?
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?