SOTA CSV upload

V2 error reports
Post Reply
sp9wpn
Advanced Class
Posts: 30
Joined: 27 May 2019, 22:52

SOTA CSV upload

Post by sp9wpn »

I've generated CSV for SOTA upload, but SOTA website says:
Error on Line 1: Incorrect date format (dd/mm/yyyy)
Original CSV file is:

Code: Select all

V2,SP9WPN/P,SP/BZ-068,20-05-2020,0857,145.55MHz,FM,SP9AMH
V2,SP9WPN/P,SP/BZ-068,20-05-2020,0858,145.55MHz,FM,SQ9KCX
V2,SP9WPN/P,SP/BZ-068,20-05-2020,0859,145.55MHz,FM,SQ9KCN
V2,SP9WPN/P,SP/BZ-068,20-05-2020,0900,145.55MHz,FM,SQ9IAW
V2,SP9WPN/P,SP/BZ-068,20-05-2020,0902,145.55MHz,FM,SP9PJ
V2,SP9WPN/P,SP/BZ-068,20-05-2020,0921,145.55MHz,FM,SP9MOV
V2,SP9WPN/P,SP/BZ-068,20-05-2020,0923,145.55MHz,FM,SQ9PPT
V2,SP9WPN/P,SP/BZ-068,20-05-2020,0933,145.55MHz,FM,SQ9NKX
When I correct date to "20/05/2020", file passes ok.

73,
Wojtek
User avatar
IW3HMH
Site Admin
Posts: 2925
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: SOTA CSV upload

Post by IW3HMH »

Hi Wojtek,
that's the original file not passed through excel or other application?
Because the code clearly states that the format should be dd/MM/yyyy so it's very strange and i need to try reproducing...
Let me know, thanks
Daniele Pistollato - IW3HMH
User avatar
G4POP
Log4OM Alpha Team
Posts: 10752
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: SOTA CSV upload

Post by G4POP »

Did you perhaps open the csv file in a spreadsheet and resave it?

I just did a SOTA CSV export and this is the result

V2,G4POP,,25/04/2014,0919,5.3985MHz,SSB,G0EVV/P,G/LD-048
V2,G4POP,,02/05/2014,1009,5.4035MHz,SSB,G4ASA/P,G/TW-004
V2,G4POP,,05/05/2014,0920,5.4035MHz,SSB,M0IML/P,G/SE-015
V2,G4POP,,14/05/2014,1333,5.3985MHz,SSB,G8TMV/P,G/SE-013
V2,G4POP,,26/08/2014,0701,5.3985MHz,SSB,GM4MD/P,GM/CS-11

As you can see the date format is correct!
73 Terry G4POP
sp9wpn
Advanced Class
Posts: 30
Joined: 27 May 2019, 22:52

Re: SOTA CSV upload

Post by sp9wpn »

I didn't touch the file. I suspect Log4OM uses Windows locale setting and this causes dates to look different in your and mine exports.

73,
Wojtek
User avatar
G4POP
Log4OM Alpha Team
Posts: 10752
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: SOTA CSV upload

Post by G4POP »

sp9wpn wrote: 21 May 2020, 14:00 I didn't touch the file. I suspect Log4OM uses Windows locale setting and this causes dates to look different in your and mine exports.

73,
Wojtek
Wojtek,
My apologies!

Apparently it either is not hard coded or the code is wrong because you are perfectly correct the date format changes in accordance with the format set in Windows.

I will see if anything can be done about this but for now please use the other windows time format
73 Terry G4POP
HB9BRJ
Old Man
Posts: 173
Joined: 23 Nov 2014, 10:46
Location: Schaffhausen

Re: SOTA CSV upload

Post by HB9BRJ »

This is part of my activation done 2 days ago, exported as CSV:

Code: Select all

V2,HB9BRJ/P,HB/AI-009,19.05.2020,1036,14.0585MHz,CW,DL1ASA
V2,HB9BRJ/P,HB/AI-009,19.05.2020,1037,14.0585MHz,CW,HB9AGH
V2,HB9BRJ/P,HB/AI-009,19.05.2020,1038,14.0585MHz,CW,EA2DT
V2,HB9BRJ/P,HB/AI-009,19.05.2020,1038,14.0585MHz,CW,HB9DDZ
V2,HB9BRJ/P,HB/AI-009,19.05.2020,1039,14.0585MHz,CW,K4DY
V2,HB9BRJ/P,HB/AI-009,19.05.2020,1040,14.0585MHz,CW,OZ7JZ
V2,HB9BRJ/P,HB/AI-009,19.05.2020,1040,14.0585MHz,CW,YO6CFB
The date format is not accepted by the SOTA database. Since SOTA started to accept ADIF uploads, I never used CSV again.

73, Markus HB9BRJ
User avatar
G4POP
Log4OM Alpha Team
Posts: 10752
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: SOTA CSV upload

Post by G4POP »

HB9BRJ wrote: 21 May 2020, 15:04 This is part of my activation done 2 days ago, exported as CSV:

Code: Select all

V2,HB9BRJ/P,HB/AI-009,19.05.2020,1036,14.0585MHz,CW,DL1ASA
V2,HB9BRJ/P,HB/AI-009,19.05.2020,1037,14.0585MHz,CW,HB9AGH
V2,HB9BRJ/P,HB/AI-009,19.05.2020,1038,14.0585MHz,CW,EA2DT
V2,HB9BRJ/P,HB/AI-009,19.05.2020,1038,14.0585MHz,CW,HB9DDZ
V2,HB9BRJ/P,HB/AI-009,19.05.2020,1039,14.0585MHz,CW,K4DY
V2,HB9BRJ/P,HB/AI-009,19.05.2020,1040,14.0585MHz,CW,OZ7JZ
V2,HB9BRJ/P,HB/AI-009,19.05.2020,1040,14.0585MHz,CW,YO6CFB
The date format is not accepted by the SOTA database. Since SOTA started to accept ADIF uploads, I never used CSV again.

73, Markus HB9BRJ
Markus,
See my post above you need to change the windows date format to dd/mm/yyyy like 21/05/2020
73 Terry G4POP
HB9BRJ
Old Man
Posts: 173
Joined: 23 Nov 2014, 10:46
Location: Schaffhausen

Re: SOTA CSV upload

Post by HB9BRJ »

Thanks Gerry, fully understood. My message was:
Why tinker with date formats and CSV when ADIF works fine?

73, Markus HB9BRJ
Post Reply