Page 1 of 1

QSOManager CSV export missing date / time

Posted: 03 Mar 2025, 04:34
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

Re: QSOManager CSV export missing date / time

Posted: 03 Mar 2025, 08:29
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.

Re: QSOManager CSV export missing date / time

Posted: 03 Mar 2025, 08:56
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.

Re: QSOManager CSV export missing date / time

Posted: 03 Mar 2025, 10:39
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 3717 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.

Re: QSOManager CSV export missing date / time

Posted: 05 Mar 2025, 02:32
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.

Re: QSOManager CSV export missing date / time

Posted: 05 Mar 2025, 10:57
by G4POP
Did you try a completely clean install?

Check the windows date format