[Dx4win] FFMA in Custom Database

[Lee Hallin]

Years ago (2012) I wrote a program for someone that wanted to chase FFMA.

It includes one line for each possible FFMA gridsquare (488) and is output
in .CSV format.
The following sample is in space delimited format but the column alignment
is a bit "off".
View it with a fixed width font and it should look better.

Num QCnt Grid St Call        QSO Date  Conf LoTW   ConfCnt LotwCnt
   1   0 CM79
   2   0 CM86
   3  24 CM87 CA N6MM        6/17/2021 Y    Y            6      9
   4   4 CM88 CA WD6FTB      6/17/2021 N    Y                   2
   5   0 CM89
   6   0 CM93
 488   0 FN67
    3107                               135  230      135     230

If there is interest, I will work on making it user executable.  It reads a
.DXQ file and creates the stats from that.
It will likely be a while (month or 2) before I have time to make the
program user executable.  If you want something sooner, feel free to send
me your .DXL file (possibly with only 6m QSOs) and I will send you back a
.CSV file with the output file.

73,
Lee  N7NU

On Thu, Jun 17, 2021 at 6:54 AM Larry Burke <wi5a at sbcglobal.net> wrote:

> Thanks, Jim.
>
>
>
> From: Jim Reisert AD1C <jjreisert at alum.mit.edu>
> Sent: Thursday, June 17, 2021 8:52 AM
> To: Larry Burke <wi5a at sbcglobal.net>
> Cc: Mike Cizek W0VTT <mgcizek at gmail.com>; DX4WIN Reflector <
> DX4WIN at mailman.qth.net>
> Subject: Re: [Dx4win] FFMA in Custom Database
>
>
>
> This might help:
>
>
>
> https://dx4win.ad1c.us/VUCC/
>
>
>
> I am still working on it.
>
>
>
>
>
> On Thu, Jun 17, 2021 at 7:19 AM Larry Burke <wi5a at sbcglobal.net <mailto:
> wi5a at sbcglobal.net> > wrote:
>
> Thanks, Mike. If that's the case, you're right. DX4WIN seems pretty useless
> for FFMA tracking. I'm familiar with Lance's spreadsheet and KV5W's
> database. I was hoping for something more "automated" based on my log.
>
> Larry
>
> -----Original Message-----
> From: Mike Cizek W0VTT <mgcizek at gmail.com <mailto:mgcizek at gmail.com> >
> Sent: Thursday, June 17, 2021 8:15 AM
> To: 'Larry Burke' <wi5a at sbcglobal.net <mailto:wi5a at sbcglobal.net> >;
> DX4WIN at mailman.qth.net <mailto:DX4WIN at mailman.qth.net>
> Subject: RE: [Dx4win] FFMA in Custom Database
>
> Hello Larry,
>
> There are better tools for tracking FFMA.  When you use one of the custom
> awards in dx4win, you must first tell the program to apply a QSO to a
> custom
> award.  So, for every 6m QSO, you would need to go back and fill in the
> Custom Award (FFMA) and Custom Award Value (grid square) for each QSO
> individually.
>
> W7GJ has a tracking program on his web site: http://www.bigskyspaces.com/
> and KV5W maintains an on line database for FFMA chasers.  Info on his QRZ
> page.  These are probably the most convenient tools to use.
>
> GL with the chase.
>
> ----
> 73,
> Mike Cizek W0VTT
>
> -----Original Message-----
> From: dx4win-bounces at mailman.qth.net <mailto:
> dx4win-bounces at mailman.qth.net>  <dx4win-bounces at mailman.qth.net <mailto:
> dx4win-bounces at mailman.qth.net> > On
> Behalf Of Larry Burke
> Sent: Thursday, 17 June, 2021 07:57
> To: DX4WIN at mailman.qth.net <mailto:DX4WIN at mailman.qth.net>
> Subject: [Dx4win] FFMA in Custom Database
>
> I'm feeling a bit ignorant on how to create a report showing the grids I
> have worked for credit towards the Fred Fish Memorial Award (488 US
> mainland
> grids).  I've never had the need to create a custom report until now, so
> this part of my DX4WIN experience is lacking.
>
>
>
> I have the Custom Award Database (v 21.3 2021/04/03 21:44:03) in my "save"
> directory and can generate a report showing the grids that are in the
> program, but that report is not populated with the grids I have worked. It
> actually shows no grids worked.
>
>
>
> I am missing something somewhere. Can someone walk me through,
> step-by-step,
> the process of  getting a report that shows FFMA award status using logbook
> data?
>
>
>
> Larry K5RK
>
> ______________________________________________________________
> DX4WIN mailing list
> Home: http://mailman.qth.net/mailman/listinfo/dx4win
> Help: http://mailman.qth.net/mmfaq.htm
> Post: mailto:DX4WIN at mailman.qth.net <mailto:DX4WIN at mailman.qth.net>
>
> This list hosted by: http://www.qsl.net
> Please help support this email list: http://www.qsl.net/donate.html
>
> ______________________________________________________________
> DX4WIN mailing list
> Home: http://mailman.qth.net/mailman/listinfo/dx4win
> Help: http://mailman.qth.net/mmfaq.htm
> Post: mailto:DX4WIN at mailman.qth.net <mailto:DX4WIN at mailman.qth.net>
>
> This list hosted by: http://www.qsl.net
> Please help support this email list: http://www.qsl.net/donate.html
>
>
>
> --
>
> Jim Reisert AD1C, <jjreisert at alum.mit.edu <mailto:jjreisert at alum.mit.edu>
> >, https://www.ad1c.us <http://www.ad1c.us>
>
> ______________________________________________________________
> DX4WIN mailing list
> Home: http://mailman.qth.net/mailman/listinfo/dx4win
> Help: http://mailman.qth.net/mmfaq.htm
> Post: mailto:DX4WIN at mailman.qth.net
>
> This list hosted by: http://www.qsl.net
> Please help support this email list: http://www.qsl.net/donate.html
>