Topics

DXKeeper missing SFI info

Sam Morgan
 

Looking back through my log I see that I am missing some of the entries for SFI/A/K. Is there any way to acquire and enter this old info?

I need a few fill ins as far back as 1991.

Starting with 2006 I seem to have most entries logged. until 2014 then I seem to have another large group of entries with no info.

I think many of the log entries with no SFI/A/K info are from imported contest logs and or other logging programs /me hangs head in shame, hi hi.

There was a script on ok4bx's blog, that could accomplish what I want to do, but it seems to only cover 1997-2013 and also I see aa6yq has some for 1997-2011 in the list's files section.


TIA


73 & GB

Sam K5OAI

Dave AA6YQ
 

AA6YQ comments below
-----Original Message-----
From: dxlab@... [mailto:dxlab@...]
Sent: Sunday, January 10, 2016 9:44 PM
To: dxlab@...
Subject: [dxlab] DXKeeper missing SFI info

Looking back through my log I see that I am missing some of the entries for SFI/A/K. Is there any way to acquire and enter this old info?

I need a few fill ins as far back as 1991.

Starting with 2006 I seem to have most entries logged. until 2014 then I seem to have another large group of entries with no info.

I think many of the log entries with no SFI/A/K info are from imported contest logs and or other logging programs /me hangs head in shame, hi hi.

There was a script on ok4bx's blog, that could accomplish what I want to do, but it seems to only cover 1997-2013 and also I see aa6yq has some for 1997-2011 in the list's files section.

I don't know of a way to do this other than to develop an applications that examines each QSO your log that lacks SFI/A/K data, looks up the SFI/A/K data for that QSO's date from a local database, and uses the resulting data to update the QSO.
73,

Dave, AA6YQ

Sam Morgan
 

It wouldn't need to find the ones missing the info, it could just over write all the years sfi/a/k info like the scripts do that are in the files section. I just don't know how to write a script to cover 2014 and 2015. The pre 1997 data I guess I can just forget about.

On 1/10/2016 9:24 PM, ' Dave AA6YQ' @AA6YQ [dxlab] wrote:
AA6YQ comments below
Looking back through my log I see that I am missing some of the
entries for SFI/A/K. Is there any way to acquire and enter this old
info?

I need a few fill ins as far back as 1991.

Starting with 2006 I seem to have most entries logged. until 2014
then I seem to have another large group of entries with no info.

I think many of the log entries with no SFI/A/K info are from
imported contest logs and or other logging programs /me hangs head in
shame, hi hi.

There was a script on ok4bx's blog, that could accomplish what I want
to do, but it seems to only cover 1997-2013 and also I see aa6yq has
some for 1997-2011 in the list's files section.

I don't know of a way to do this other than to develop an
applications that examines each QSO your log that lacks SFI/A/K
data, looks up the SFI/A/K data for that QSO's date from a
local database, and uses the resulting data to update the QSO.
73,

Dave, AA6YQ
--
GB & 73
K5OAI
Sam Morgan
John 3:16 Ephesians 2:8-9 1 Peter 2:24 Acts 2:38

Dave AA6YQ
 

AA6YQ comments below
-----Original Message-----
From: dxlab@... [mailto:dxlab@...]
Sent: Sunday, January 10, 2016 10:59 PM
To: dxlab@...
Subject: Re: [dxlab] DXKeeper missing SFI info

It wouldn't need to find the ones missing the info, it could just over write all the years sfi/a/k info like the scripts do that are in the files section. I just don't know how to write a script to cover 2014 and 2015.

There is no way to fill in missing SFI/A/K information using a DXKeeper script.
73,

Dave, AA6YQ

Sam Morgan
 

On 1/11/2016 8:57 AM, ' Dave AA6YQ' @AA6YQ [dxlab] wrote:
AA6YQ comments below
There is no way to fill in missing SFI/A/K information using a
DXKeeper script.
73,
Dave, AA6YQ
I beg to differ Dave, go to the files section file: DXK_Solar.zip

contains text files/scripts that will do what you say can't be done
but they are only for the years 1997 - 2011

here is an example of the script:

<quote>
Filter QSO_Begin BETWEEN #2011-01-01 0:00# and #2011-01-01 23:59#
Modify SFI 91
Modify A_INDEX 3
Filter QSO_Begin BETWEEN #2011-01-01 0:00# and #2011-01-01 9:00#
Modify K_INDEX 0
Filter QSO_Begin BETWEEN #2011-01-01 9:00# and #2011-01-01 21:00#
Modify K_INDEX 1
Filter QSO_Begin BETWEEN #2011-01-01 21:00# and #2011-01-01 23:59#
Modify K_INDEX 2
Filter QSO_Begin BETWEEN #2011-01-02 0:00# and #2011-01-02 23:59#
Modify SFI 91
Modify A_INDEX 3
Filter QSO_Begin BETWEEN #2011-01-02 0:00# and #2011-01-02 6:00#
Modify K_INDEX 1
Filter QSO_Begin BETWEEN #2011-01-02 6:00# and #2011-01-02 12:00#
Modify K_INDEX 0
Filter QSO_Begin BETWEEN #2011-01-02 12:00# and #2011-01-02 18:00#
Modify K_INDEX 1
Filter QSO_Begin BETWEEN #2011-01-02 18:00# and #2011-01-02 21:00#
Modify K_INDEX 0
Filter QSO_Begin BETWEEN #2011-01-02 21:00# and #2011-01-02 23:59#
Modify K_INDEX 1
Filter QSO_Begin BETWEEN #2011-01-03 0:00# and #2011-01-03 23:59#
Modify SFI 92
Modify A_INDEX 4
Filter QSO_Begin BETWEEN #2011-01-03 0:00# and #2011-01-03 12:00#
Modify K_INDEX 0
Filter QSO_Begin BETWEEN #2011-01-03 12:00# and #2011-01-03 15:00#
Modify K_INDEX 1
Filter QSO_Begin BETWEEN #2011-01-03 15:00# and #2011-01-03 23:59#
Modify K_INDEX 2
</quote>


here is a snip from the scripts resulting log file:

<quote>
Filter QSO_Begin BETWEEN #2010-01-30 0:00# and #2010-01-30 23:59#
Selected 23 QSOs

Modify SFI 75
Modified 23 QSOs
Selected 23 QSOs

Modify A_INDEX 4
Modified 23 QSOs
Selected 23 QSOs

Filter QSO_Begin BETWEEN #2010-01-30 0:00# and #2010-01-30 9:00#
Selected 0 QSOs

Modify K_INDEX 1
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-30 9:00# and #2010-01-30 12:00#
Selected 6 QSOs

Modify K_INDEX 0
Modified 6 QSOs
Selected 6 QSOs

Filter QSO_Begin BETWEEN #2010-01-30 12:00# and #2010-01-30 21:00#
Selected 17 QSOs

Modify K_INDEX 1
Modified 17 QSOs
Selected 17 QSOs

Filter QSO_Begin BETWEEN #2010-01-30 21:00# and #2010-01-30 23:59#
Selected 0 QSOs

Modify K_INDEX 2
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-31 0:00# and #2010-01-31 23:59#
Selected 14 QSOs

Modify SFI 75
Modified 14 QSOs
Selected 14 QSOs

Modify A_INDEX 3
Modified 14 QSOs
Selected 14 QSOs

Filter QSO_Begin BETWEEN #2010-01-31 0:00# and #2010-01-31 3:00#
Selected 0 QSOs

Modify K_INDEX 2
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-31 3:00# and #2010-01-31 6:00#
Selected 0 QSOs

Modify K_INDEX 1
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-31 6:00# and #2010-01-31 9:00#
Selected 0 QSOs

Modify K_INDEX 0
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-31 9:00# and #2010-01-31 15:00#
Selected 14 QSOs

Modify K_INDEX 1
Modified 14 QSOs
Selected 14 QSOs

Filter QSO_Begin BETWEEN #2010-01-31 15:00# and #2010-01-31 18:00#
Selected 0 QSOs

Modify K_INDEX 0
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-31 18:00# and #2010-01-31 23:59#
Selected 0 QSOs

Modify K_INDEX 1
no QSOs selected, so none modified
</quote>


I just don't know how to write a script for 2014 & 2015. Nor do I know where the data was found to inject into the script when it is written. I'm sorry if this is going beyond the scope of what the list is for. I was just in hopes that someone on the list might take interest and be able to fulfill me dream, hi hi. Feel free to just drop the thread if you like.

--
GB & 73
K5OAI
Sam Morgan
John 3:16 Ephesians 2:8-9 1 Peter 2:24 Acts 2:38

Dave AA6YQ
 

You're right, Sam, the modification can be accomplished with a script.

However, the only practical way to generate a script that updates SFI, A, and K for 730 days is with a program.

73,

Dave, AA6YQ

-----Original Message-----
From: dxlab@... [mailto:dxlab@...]
Sent: Monday, January 11, 2016 11:20 AM
To: dxlab@...
Subject: Re: [dxlab] DXKeeper missing SFI info

On 1/11/2016 8:57 AM, ' Dave AA6YQ' @AA6YQ [dxlab] wrote:
>>>> AA6YQ comments below
>>>> There is no way to fill in missing SFI/A/K information using a >>>> DXKeeper script.
> 73,
> Dave, AA6YQ

I beg to differ Dave, go to the files section file: DXK_Solar.zip

contains text files/scripts that will do what you say can't be done but they are only for the years 1997 - 2011

here is an example of the script:

<quote>
Filter QSO_Begin BETWEEN #2011-01-01 0:00# and #2011-01-01 23:59# Modify SFI 91 Modify A_INDEX 3 Filter QSO_Begin BETWEEN #2011-01-01 0:00# and #2011-01-01 9:00# Modify K_INDEX 0 Filter QSO_Begin BETWEEN #2011-01-01 9:00# and #2011-01-01 21:00# Modify K_INDEX 1 Filter QSO_Begin BETWEEN #2011-01-01 21:00# and #2011-01-01 23:59# Modify K_INDEX 2 Filter QSO_Begin BETWEEN #2011-01-02 0:00# and #2011-01-02 23:59# Modify SFI 91 Modify A_INDEX 3 Filter QSO_Begin BETWEEN #2011-01-02 0:00# and #2011-01-02 6:00# Modify K_INDEX 1 Filter QSO_Begin BETWEEN #2011-01-02 6:00# and #2011-01-02 12:00# Modify K_INDEX 0 Filter QSO_Begin BETWEEN #2011-01-02 12:00# and #2011-01-02 18:00# Modify K_INDEX 1 Filter QSO_Begin BETWEEN #2011-01-02 18:00# and #2011-01-02 21:00# Modify K_INDEX 0 Filter QSO_Begin BETWEEN #2011-01-02 21:00# and #2011-01-02 23:59# Modify K_INDEX 1 Filter QSO_Begin BETWEEN #2011-01-03 0:00# and #2011-01-03 23:59# Modify SFI 92 Modify A_INDEX 4 Filter QSO_Begin BETWEEN #2011-01-03 0:00# and #2011-01-03 12:00# Modify K_INDEX 0 Filter QSO_Begin BETWEEN #2011-01-03 12:00# and #2011-01-03 15:00# Modify K_INDEX 1 Filter QSO_Begin BETWEEN #2011-01-03 15:00# and #2011-01-03 23:59# Modify K_INDEX 2 </quote>


here is a snip from the scripts resulting log file:

<quote>
Filter QSO_Begin BETWEEN #2010-01-30 0:00# and #2010-01-30 23:59#
Selected 23 QSOs

Modify SFI 75
Modified 23 QSOs
Selected 23 QSOs

Modify A_INDEX 4
Modified 23 QSOs
Selected 23 QSOs

Filter QSO_Begin BETWEEN #2010-01-30 0:00# and #2010-01-30 9:00#
Selected 0 QSOs

Modify K_INDEX 1
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-30 9:00# and #2010-01-30 12:00#
Selected 6 QSOs

Modify K_INDEX 0
Modified 6 QSOs
Selected 6 QSOs

Filter QSO_Begin BETWEEN #2010-01-30 12:00# and #2010-01-30 21:00#
Selected 17 QSOs

Modify K_INDEX 1
Modified 17 QSOs
Selected 17 QSOs

Filter QSO_Begin BETWEEN #2010-01-30 21:00# and #2010-01-30 23:59#
Selected 0 QSOs

Modify K_INDEX 2
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-31 0:00# and #2010-01-31 23:59#
Selected 14 QSOs

Modify SFI 75
Modified 14 QSOs
Selected 14 QSOs

Modify A_INDEX 3
Modified 14 QSOs
Selected 14 QSOs

Filter QSO_Begin BETWEEN #2010-01-31 0:00# and #2010-01-31 3:00#
Selected 0 QSOs

Modify K_INDEX 2
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-31 3:00# and #2010-01-31 6:00#
Selected 0 QSOs

Modify K_INDEX 1
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-31 6:00# and #2010-01-31 9:00#
Selected 0 QSOs

Modify K_INDEX 0
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-31 9:00# and #2010-01-31 15:00#
Selected 14 QSOs

Modify K_INDEX 1
Modified 14 QSOs
Selected 14 QSOs

Filter QSO_Begin BETWEEN #2010-01-31 15:00# and #2010-01-31 18:00#
Selected 0 QSOs

Modify K_INDEX 0
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-31 18:00# and #2010-01-31 23:59#
Selected 0 QSOs

Modify K_INDEX 1
no QSOs selected, so none modified
</quote>


I just don't know how to write a script for 2014 & 2015. Nor do I know where the data was found to inject into the script when it is written.
I'm sorry if this is going beyond the scope of what the list is for. I was just in hopes that someone on the list might take interest and be able to fulfill me dream, hi hi. Feel free to just drop the thread if you like.

--
GB & 73
K5OAI
Sam Morgan
John 3:16 Ephesians 2:8-9 1 Peter 2:24 Acts 2:38


------------------------------------
Posted by: Sam Morgan <k5oai.sam@...>
------------------------------------


------------------------------------

Yahoo Groups Links

Mike - AA1AR
 

Sam & Dave,

Since I wasn’t seeing any new data on ok4bx’s site, I had already created these scripts for the first 11 months of 2015.

I’ll do Dec. in the next day or two.

I had 2014 done last year but already deleted it.  I may still have the data in Excel.

73, Mike – AA1AR

 

 

From: dxlab@... [mailto:dxlab@...]
Sent: Monday, January 11, 2016 11:28 AM
To: dxlab@...
Subject: RE: [dxlab] DXKeeper missing SFI info

 

 

You're right, Sam, the modification can be accomplished with a script.

However, the only practical way to generate a script that updates SFI, A, and K for 730 days is with a program.

73,

Dave, AA6YQ

-----Original Message-----
From: dxlab@... [mailto:dxlab@...]
Sent: Monday, January 11, 2016 11:20 AM
To: dxlab@...
Subject: Re: [dxlab] DXKeeper missing SFI info

On 1/11/2016 8:57 AM, ' Dave AA6YQ' aa6yq@... [dxlab] wrote:
>>>> AA6YQ comments below
>>>> There is no way to fill in missing SFI/A/K information using a >>>> DXKeeper script.
> 73,
> Dave, AA6YQ

I beg to differ Dave, go to the files section file: DXK_Solar.zip

contains text files/scripts that will do what you say can't be done but they are only for the years 1997 - 2011

here is an example of the script:


Filter QSO_Begin BETWEEN #2011-01-01 0:00# and #2011-01-01 23:59# Modify SFI 91 Modify A_INDEX 3 Filter QSO_Begin BETWEEN #2011-01-01 0:00# and #2011-01-01 9:00# Modify K_INDEX 0 Filter QSO_Begin BETWEEN #2011-01-01 9:00# and #2011-01-01 21:00# Modify K_INDEX 1 Filter QSO_Begin BETWEEN #2011-01-01 21:00# and #2011-01-01 23:59# Modify K_INDEX 2 Filter QSO_Begin BETWEEN #2011-01-02 0:00# and #2011-01-02 23:59# Modify SFI 91 Modify A_INDEX 3 Filter QSO_Begin BETWEEN #2011-01-02 0:00# and #2011-01-02 6:00# Modify K_INDEX 1 Filter QSO_Begin BETWEEN #2011-01-02 6:00# and #2011-01-02 12:00# Modify K_INDEX 0 Filter QSO_Begin BETWEEN #2011-01-02 12:00# and #2011-01-02 18:00# Modify K_INDEX 1 Filter QSO_Begin BETWEEN #2011-01-02 18:00# and #2011-01-02 21:00# Modify K_INDEX 0 Filter QSO_Begin BETWEEN #2011-01-02 21:00# and #2011-01-02 23:59# Modify K_INDEX 1 Filter QSO_Begin BETWEEN #2011-01-03 0:00# and #2011-01-03 23:59# Modify SFI 92 Modify A_INDEX 4 Filter QSO_Begin BETWEEN #2011-01-03 0:00# and #2011-01-03 12:00# Modify K_INDEX 0 Filter QSO_Begin BETWEEN #2011-01-03 12:00# and #2011-01-03 15:00# Modify K_INDEX 1 Filter QSO_Begin BETWEEN #2011-01-03 15:00# and #2011-01-03 23:59# Modify K_INDEX 2

here is a snip from the scripts resulting log file:


Filter QSO_Begin BETWEEN #2010-01-30 0:00# and #2010-01-30 23:59#
Selected 23 QSOs

Modify SFI 75
Modified 23 QSOs
Selected 23 QSOs

Modify A_INDEX 4
Modified 23 QSOs
Selected 23 QSOs

Filter QSO_Begin BETWEEN #2010-01-30 0:00# and #2010-01-30 9:00#
Selected 0 QSOs

Modify K_INDEX 1
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-30 9:00# and #2010-01-30 12:00#
Selected 6 QSOs

Modify K_INDEX 0
Modified 6 QSOs
Selected 6 QSOs

Filter QSO_Begin BETWEEN #2010-01-30 12:00# and #2010-01-30 21:00#
Selected 17 QSOs

Modify K_INDEX 1
Modified 17 QSOs
Selected 17 QSOs

Filter QSO_Begin BETWEEN #2010-01-30 21:00# and #2010-01-30 23:59#
Selected 0 QSOs

Modify K_INDEX 2
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-31 0:00# and #2010-01-31 23:59#
Selected 14 QSOs

Modify SFI 75
Modified 14 QSOs
Selected 14 QSOs

Modify A_INDEX 3
Modified 14 QSOs
Selected 14 QSOs

Filter QSO_Begin BETWEEN #2010-01-31 0:00# and #2010-01-31 3:00#
Selected 0 QSOs

Modify K_INDEX 2
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-31 3:00# and #2010-01-31 6:00#
Selected 0 QSOs

Modify K_INDEX 1
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-31 6:00# and #2010-01-31 9:00#
Selected 0 QSOs

Modify K_INDEX 0
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-31 9:00# and #2010-01-31 15:00#
Selected 14 QSOs

Modify K_INDEX 1
Modified 14 QSOs
Selected 14 QSOs

Filter QSO_Begin BETWEEN #2010-01-31 15:00# and #2010-01-31 18:00#
Selected 0 QSOs

Modify K_INDEX 0
no QSOs selected, so none modified

Filter QSO_Begin BETWEEN #2010-01-31 18:00# and #2010-01-31 23:59#
Selected 0 QSOs

Modify K_INDEX 1
no QSOs selected, so none modified


I just don't know how to write a script for 2014 & 2015. Nor do I know where the data was found to inject into the script when it is written.
I'm sorry if this is going beyond the scope of what the list is for. I was just in hopes that someone on the list might take interest and be able to fulfill me dream, hi hi. Feel free to just drop the thread if you like.

--
GB & 73
K5OAI
Sam Morgan
John 3:16 Ephesians 2:8-9 1 Peter 2:24 Acts 2:38

------------------------------------
Posted by: Sam Morgan <k5oai.sam@...>
------------------------------------

------------------------------------

Yahoo Groups Links