QSOManager CSV export missing date / time

V2 error reports
Post Reply
VK3IU
Novice Class
Posts: 5
Joined: 15 Jan 2022, 10:47
Contact:

QSOManager CSV export missing date / time

Post by VK3IU »

QSOManager CSV export missing date / time

Exporting selected contacts from the QSO Manager produces for some random contacts a missing date and time in the entry row.
The missing date/time information seems to be connected to the CSV Field selection of "qsl_via".
When "qsl_via" is selected some contacts missing the date/time information, while when "qsl_via" is not connected the date/time information is present in all exported connections.

Log4OM Version 2.35.1.0
User avatar
G4POP
Log4OM Alpha Team
Posts: 11570
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: QSOManager CSV export missing date / time

Post by G4POP »

I cant emulate this issue can you post a screen shot showing QSO's with missing time and also with correct time please

I would also like a complete list of the fields selected in the export because it could ba a combination of a couple of fields selected causing the problem.
73 Terry G4POP
VK3IU
Novice Class
Posts: 5
Joined: 15 Jan 2022, 10:47
Contact:

Re: QSOManager CSV export missing date / time

Post by VK3IU »

Hi thanks for the reply.

I added two files which might help in a ZIPED file
a) ADIF export of a 8 contacts
b) Excel file created from the CSV file, the header showes the field selected.

I tried to attach the whole SQL log but its to big, if it is required let me know.
Attachments
Log4OM_CSV_as excel error and no error.zip
(11.99 KiB) Downloaded 36 times
User avatar
G4POP
Log4OM Alpha Team
Posts: 11570
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: QSOManager CSV export missing date / time

Post by G4POP »

Using your ADIF file imported into a new database and with the field selection exactly as your Excel file in our QSO Manager Excel export routine I get a perfect result, see below:

Aus Test ADIF.png
Aus Test ADIF.png (30.38 KiB) Viewed 3706 times
I think that perhaps you have a coruption of some QSO's in your current database so my advice would be to:

try settings/maintenance/perform DB maintenance first but if that does not fix it then do the following

1. Export the logbook to an ADIF file
2. Create a new empty database
3. Import the ADIF file created in step 1 above - BUT - Skip Quality check corrections and no award check in the ADIF import window before importing.
73 Terry G4POP
VK3IU
Novice Class
Posts: 5
Joined: 15 Jan 2022, 10:47
Contact:

Re: QSOManager CSV export missing date / time

Post by VK3IU »

Dear Terry, thanks for looking into this for me.

I tried as you suggested no success, I also did the same with the ADIF extract I provided you and uploaded it into a new DB with the same result when exporting to CSV.

Could it be some settings somewhere in my setup?

I can work around the issue as the trigger for dropping the date/time field is only one field selection.
User avatar
G4POP
Log4OM Alpha Team
Posts: 11570
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: QSOManager CSV export missing date / time

Post by G4POP »

Did you try a completely clean install?

Check the windows date format
73 Terry G4POP
Post Reply