Needed QSL

Need help? - Post here and we will find a solution for you.
Locked
User avatar
CT1BXX
Old Man
Posts: 460
Joined: 21 Jan 2013, 15:27

Needed QSL

Post by CT1BXX »

Hi,
I would like to ask your help in order to get some information about Awards.
In "Statistics and Awards in "RSGB" I have "Not confirmed 14/829"
I would like to have also the possibility to see only the 14 Iota not confirmed. Is there any way to make it?
The idea is to have a listing where we can have an information about the qsls we need and so we could see if we need to send a second card.
Many thanks for your attention.
73
Manuel Fernando - CT1BXX
73 Manuel Fernando CT1BXX
User avatar
G4POP
Log4OM Alpha Team
Posts: 10802
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Needed QSL

Post by G4POP »

Hi Manuel,
This is something that I have requested for both IOTA and the ARRL awards and it is on the Mantis list, at this time the solution is not elegent but it does work.

Step 1 - Layout

In the QSO Archive manager arrange the layout of the columns so that the IOTA number and QSL Recived Status are next to each other and visible - See attached graphic. Check the enable updates box.

Step 2 - Search list

To display just the IOTA entries use 'Search parameters' and search the IOTA field with a search parameter of '!=(not equal to)' but leave the window where you normally insert the item to search for blank.

Insert a second search parameter 'QSL Rcvd Status' LIKE (starts with) and insert 'N' in the data field. See images below.

This has the effect of searching the IOTA field for every one which is not blank, therefore it only lists QSO's with an IOTA reference and just displays those which you have not received a card for.

Step 3 - Select QSO's

Sort the list into the order required and then select all of the entries..

Step 4 - Print or save a CSV

Now you can print the selected QSO's or save it to a CSV file.

Hope this helps until we have a statistics choice.
Attachments
IOTA.jpg
IOTA.jpg (272.24 KiB) Viewed 4869 times
IOTA filter.jpg
IOTA filter.jpg (60.01 KiB) Viewed 4869 times
73 Terry G4POP
User avatar
G4POP
Log4OM Alpha Team
Posts: 10802
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Needed QSL

Post by G4POP »

Manuel,
I have amended the instructions in my last post to simplify the process.
73 Terry G4POP
User avatar
CT1BXX
Old Man
Posts: 460
Joined: 21 Jan 2013, 15:27

Re: Needed QSL

Post by CT1BXX »

G4POP wrote:Manuel,
I have amended the instructions in my last post to simplify the process.
Thanks Terry for information. It works nicely, for me it is very good, now I have the information I need.
Thanks for the attention. :D

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

Re: Needed QSL

Post by IW3HMH »

please note this way can be used to dig into your database in all possible ways.
You can, as example, extract all the QSL with OM that have "Daniele" in the name, or "Venezia" in the address and whatever you like.

In a short future we will provide full query support to those data structures

73
Daniele
Daniele Pistollato - IW3HMH
Locked