export data to make SQL cards

4 posts / 0 new
Last post
eb3dva
eb3dva's picture
export data to make SQL cards

Hi again
I'm trying to download a list of contacts who haven't received confirmation via lotw or eqsl.
In fact, I wish I could play with this list to see if there is any way to get to send a qsl direct or via manager. I don’t work with any amateur radio association, at the moment.

I can't find any filter that works for me.

Has anyone been able to make a filter to extract this listing?

73 from Catalonia

oh1kh
export data to make SQL cards

Hi!

Have you tried filter QSL / Eqsl/S/Y LOTW/S/Y that should list all stations that HAVE received eQSL or LoTW confirmation.

When tested that add to this filter at the bottom side of filter window a checkbox "Reverse filter (NOT)" checked. Test that. It should make opposite effect I.E. list stations that HAVE NOT received eQSL or LoTW confirmation.

Does that work?

--
Saku
OH1KH

eb3dva
eb3dva's picture
Well, I was already doing

Well, I was already doing this kind of search, and I always get some that if they have eQSL or Lotw. In the end I tried the simplest.
I just marked that “no” had neither eQSL nor Lotw, and enough. And it seems to have worked.
I found it strange that this worked, because the rest of the parameters I thought would interfere and the result would be 0, but no, 844 pending contacts have come out.

I exported the result to ADIF, and then with a tool called "adif to csv" I was able to open it with CALC, and filter conveniently.

Thanks SAKU.

File: 

oh1kh
export data to make SQL cards

OK!

Interesting, but main thing is that you got it working.

If I select eQSL and LoTW sent to "N" I have 19 qsos. If I select eQSL and LoTW sent to "Y" and check "Reverse filter(NOT)" I have same result 19 qsos.
Reversing with this option is not very clever as you can select "N", but in some other selections it may be useful.

--
Saku
OH1KH