Date issue with biolovision txt export

[TonyRinaud]

Hi!

I just started again to import some data from biolovision.net to ebird using your brilliant tool but I always get issues with the date when loading the txt file in english into biolovision2ebird. If its > of the 12th of the month it doesn't cast a date and if it's < of the 12th of the month the date is reversed (month is day and day is month). Looks like the date is read in reverse hence 13th of the month doesnt match a month number. The column date in the .txt file shows mm.dd.yyyy before upload btw. What do you think about that?

Cheers, Tony

[Rafnuss]

Hi @TonyRinaud , Thanks for reporting this bug. I've just checked on my side and the date exported is dd.mm.yyyy. Can you re-export the txt file and check the format again (and do not open in in excel)? Are you based in the US/other country using the (strange) mm.dd.yyyy format?

[TonyRinaud]

Hi, Ah ok, so that not normal to have dates as mm.dd.yyyy when exporting data from biolovision in the first place? I am back in France and this issue appeared in the text file prior to opening with excel. However, I noticed that I have used an atlas code from Switzerland, hence the headed of the txt file has ornitho.ch in it. Could it be that? Anyway, not your problem then ;) I'll attach the file, in case you still have some ideas.

EXPORT_UNIVERSAL_2024.txt

[Rafnuss]

Intresting, just to make sure. Is this where you're downloading this data:

Maybe just change the langue on the top right of the page to FR or DE or anything else than EN

It seems to be the issue for me.

[TonyRinaud]

Yep, this is it. I tried to leave it in french and the date is fine then but I can't load it to your page, it keeps loading forever, probably because the headers are in french. I'll keep poking around on biolovision website but I am done with the conversion now anyway.

[TonyRinaud]

Another thing is that I am pretty sure this is a new behaviour since I already exported data in english from biolovision in the same setup a couple of weeks ago and it worked fine.

[Rafnuss]

Yes, it also seems to me that this is the case. I think I remember that it was only working in english. Let me have a look at it. Maybe they've changed the default date format for EN? Why are you not using the default JSON format? This should be working fine.

[TonyRinaud]

Going on with a recent ebird upload, I had the same issue with date in english from Biolovision, so I came back here! Sadly, biolovision doesn't allow JSON as output format. Only txt, and two excel versions. I think biolovision changed from dd.mm.yyyy to mm.dd.yyyy in the output. Tony

[Rafnuss]

Thanks for raising this @TonyRinaud. It sems that I've overlooked the problem in May. I've just change the parsing of the date to your suggection. Can you check with the new version if its works as expected?

[TonyRinaud]

No, b2b still doesn't read mm.dd.yyyy dates with english txt output from biolovision.

Now, even the palindromic dates are not read (e.g. 05.05.2024) but they were earlier today.

[Rafnuss]

Yeah, my mistake to not check on my side. Please check that you are using v2.3.5 (see in footer). It should now work.

[TonyRinaud]

Brilliant, it works perferctly now! Thanks a lot!