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 <hall...@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 <w...@sbcglobal.net> wrote: > >> Thanks, Jim. >> >> >> >> From: Jim Reisert AD1C <jjreis...@alum.mit.edu> >> Sent: Thursday, June 17, 2021 8:52 AM >> To: Larry Burke <w...@sbcglobal.net> >> Cc: Mike Cizek W0VTT <mgci...@gmail.com>; DX4WIN Reflector < >> DX4WIN@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 <w...@sbcglobal.net <mailto: >> w...@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 <mgci...@gmail.com <mailto:mgci...@gmail.com> > >> Sent: Thursday, June 17, 2021 8:15 AM >> To: 'Larry Burke' <w...@sbcglobal.net <mailto:w...@sbcglobal.net> >; >> DX4WIN@mailman.qth.net <mailto:DX4WIN@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-boun...@mailman.qth.net <mailto: >> dx4win-boun...@mailman.qth.net> <dx4win-boun...@mailman.qth.net <mailto: >> dx4win-boun...@mailman.qth.net> > On >> Behalf Of Larry Burke >> Sent: Thursday, 17 June, 2021 07:57 >> To: DX4WIN@mailman.qth.net <mailto:DX4WIN@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@mailman.qth.net <mailto:DX4WIN@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@mailman.qth.net <mailto:DX4WIN@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, <jjreis...@alum.mit.edu <mailto:jjreis...@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@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@mailman.qth.net This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
