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
Needed QSL
- G4POP
- Log4OM Alpha Team
- Posts: 10803
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: Needed QSL
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.
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 (272.24 KiB) Viewed 4872 times
-
- IOTA filter.jpg (60.01 KiB) Viewed 4872 times
73 Terry G4POP
- G4POP
- Log4OM Alpha Team
- Posts: 10803
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: Needed QSL
Manuel,
I have amended the instructions in my last post to simplify the process.
I have amended the instructions in my last post to simplify the process.
73 Terry G4POP
Re: Needed QSL
Thanks Terry for information. It works nicely, for me it is very good, now I have the information I need.G4POP wrote:Manuel,
I have amended the instructions in my last post to simplify the process.
Thanks for the attention.
73 Manuel Fernando CT1BXX
73 Manuel Fernando CT1BXX
- IW3HMH
- Site Admin
- Posts: 2926
- Joined: 21 Jan 2013, 14:20
- Location: Quarto d'Altino - Venezia (ITA)
- Contact:
Re: Needed QSL
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
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