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
QSOManager CSV export missing date / time
- 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
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.
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
Re: QSOManager CSV export missing date / time
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.
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
- 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
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:
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.
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
Re: QSOManager CSV export missing date / time
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.
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.
- 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
Did you try a completely clean install?
Check the windows date format
Check the windows date format
73 Terry G4POP