[Dx4win] FFMA in Custom Database

Mon Jun 21 01:56:51 EDT 2021

Hi all,

I spent some time this weekend making the 2012 vintage program more user
friendly (runnable by you)

It is run via the Command Prompt.  Takes two arguments:
  1) the source (DX4WIN8) .DXQ file for the log in question
  2) The .CSV destination file (specifying a "." will use the .DXQ file
name and change the extension to .CSV)

You can read the .CSV file in Excel and sort it, print it, etc.

I "think" with more time, I can generate a .DXQ file with the Award set to
FFMA and Award Value set to the 4 character Grid.
It would ONLY do this when there is no Award already specified for the QSO.
Then, after backing up your current .DXL file, you could "Import" the .DXQ
file I generate and update the 6m QSOs in your .DXL file.

If you are interested in the program as it exists now and/or the added
option to enter the Award information into your .DXL log,
please email me and I'll send you the program as an attachment now and info
about the .DXL updating version when I get it done.

73,
Lee  N7NU

On Thu, Jun 17, 2021 at 9:58 AM Lee Hallin <hallinl at lanecc.edu> wrote:

> 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
>>
>