QSO Totals and WSJT-X imports
Posted: 18 Jan 2021, 12:02
This may be two issues, but I discovered the second whilst trying to figure out the 1st, but I'll start a second topic if it will help.
I'm using Log4OM 2 v2.11.0.0
Windows 10 Home v1909 OsBuild 18363.1256
The first problem I discovered whilst trying to see how many contacts, in total, I have made using Phone, CW or Digital modes. I used the Filter option in QSO Manager to provide totals for the three different categories. These were as follows;
Phone = 3248
CW = 3894
Digital = 2059
Total = 9201 However, on the main screen the total number of logged contacts was 9221, a discrepancy of 20 contacts.
So, I started to try and find out why there were missing contacts. I checked through the 'modes' in the various categories to see if, at some point in the past, I had used some strange mode that did not appear in the lists of modes counted in the three categories. I could not find anything by just looking through a few contacts so I exported a CSV file of some basic data (Date, Callsign, Mode) and loaded it into a spreadsheet. After sorting by 'Ascending' mode type and scrolling down to see if I could find 20 contacts with some strange mode I didn't find any mode that did not appear in the lists of modes used (I found a post on here telling me where to find the file that contains the modes used by Log4OM) so I did some more digging.
I decided to sort all my contacts by callsign, to see if I'd managed to log some strange call that was not valid, and I found that, for a large number of contacts, mainly FT8 contacts, I had duplicates on the same day (at this point I had not looked at the times for the contact...) so I started to check through these duplicates.
After about a days work I had found over 500 duplicated contacts, mainly FT8, where the date was the same but the time logged was just a few seconds different. Usually 15 seconds different, which of course is one period for FT8 in either TX or RX.
So, I worked through my database using QSO Manager, inputting each callsign and deleting the second logged entry. Had I known this was going to involve removing so many I might have asked for help earlier... Anyway, it's done now and I'll watch the imports from WSJT-X in future to make sure I don't get duplicate entries. That showed up another slight issue. After searching for about 30 callsigns, and deleting one of the duplicates, the search seemed to slow down significantly and I found I had to close Log4OM and then restart it. Then do about 30 more deletions and restart Log4OM again. I guess the search function was never designed for someone wanting to find and delete over 500 records manually?
Anyway, back to the main issue. I went back to see how many CW, Phone, Digital contacts I had made. Now the totals were;
Phone = 3242
CW = 3894
Digital = 1507
Total = 8643
Looking at the total contacts logged Log4OM is showing a total of 8663 contacts, so I'm still 20 contacts short...
Any ideas what these missing 20 might be please?
Thanks - Dave (G0DJA)
I'm using Log4OM 2 v2.11.0.0
Windows 10 Home v1909 OsBuild 18363.1256
The first problem I discovered whilst trying to see how many contacts, in total, I have made using Phone, CW or Digital modes. I used the Filter option in QSO Manager to provide totals for the three different categories. These were as follows;
Phone = 3248
CW = 3894
Digital = 2059
Total = 9201 However, on the main screen the total number of logged contacts was 9221, a discrepancy of 20 contacts.
So, I started to try and find out why there were missing contacts. I checked through the 'modes' in the various categories to see if, at some point in the past, I had used some strange mode that did not appear in the lists of modes counted in the three categories. I could not find anything by just looking through a few contacts so I exported a CSV file of some basic data (Date, Callsign, Mode) and loaded it into a spreadsheet. After sorting by 'Ascending' mode type and scrolling down to see if I could find 20 contacts with some strange mode I didn't find any mode that did not appear in the lists of modes used (I found a post on here telling me where to find the file that contains the modes used by Log4OM) so I did some more digging.
I decided to sort all my contacts by callsign, to see if I'd managed to log some strange call that was not valid, and I found that, for a large number of contacts, mainly FT8 contacts, I had duplicates on the same day (at this point I had not looked at the times for the contact...) so I started to check through these duplicates.
After about a days work I had found over 500 duplicated contacts, mainly FT8, where the date was the same but the time logged was just a few seconds different. Usually 15 seconds different, which of course is one period for FT8 in either TX or RX.
So, I worked through my database using QSO Manager, inputting each callsign and deleting the second logged entry. Had I known this was going to involve removing so many I might have asked for help earlier... Anyway, it's done now and I'll watch the imports from WSJT-X in future to make sure I don't get duplicate entries. That showed up another slight issue. After searching for about 30 callsigns, and deleting one of the duplicates, the search seemed to slow down significantly and I found I had to close Log4OM and then restart it. Then do about 30 more deletions and restart Log4OM again. I guess the search function was never designed for someone wanting to find and delete over 500 records manually?
Anyway, back to the main issue. I went back to see how many CW, Phone, Digital contacts I had made. Now the totals were;
Phone = 3242
CW = 3894
Digital = 1507
Total = 8643
Looking at the total contacts logged Log4OM is showing a total of 8663 contacts, so I'm still 20 contacts short...
Any ideas what these missing 20 might be please?
Thanks - Dave (G0DJA)