Date   

Re: Create SQL Filter From Current Button Selections

Scott Stembaugh
 

Hasan,

There are 4 banks of 8 SQL filter buttons available.  CTRL-Click on the bottom row of buttons brings up the editor.  See https://www.dxlabsuite.com/spotcollector/Help/SpotDatabase.htm#Filtering%20with%20SQL%20expressions
on how to combine standard filters with custom SQL.

73,
--scott


On Tue, Mar 24, 2020 at 6:57 AM Hasan Schiers N0AN <hbasri.schiers6@...> wrote:
It might be interesting to have a way to automatically generate a compound SQL Filter from Current Filter Settings.

I am currently using Band and Mode and Origin

To show Spots from North America, 6 meters, MSK144 only. (with the Buttons already provided)

It would be nice to combine any currently existing set of button filters into a single SQL expression and save it for use as a Button.

...just an idea, and not very important, but it struck me as useful.

73, N0AN

Hasan


Create SQL Filter From Current Button Selections

Hasan Schiers N0AN
 

It might be interesting to have a way to automatically generate a compound SQL Filter from Current Filter Settings.

I am currently using Band and Mode and Origin

To show Spots from North America, 6 meters, MSK144 only. (with the Buttons already provided)

It would be nice to combine any currently existing set of button filters into a single SQL expression and save it for use as a Button.

...just an idea, and not very important, but it struck me as useful.

73, N0AN

Hasan


Compound Spot Filter

Hasan Schiers N0AN
 

I have an SQL filter set for Mode='MSK144'

and it works fine, but it is showing Spots from EU which are not useful on 6 meters.

I tried: Mode='MSK144' AND Origin="NA-M"
...and that didn't work, spots were found.

How do I create an SQL Filter that shows only spots for MSK144 and Spots originating from USA, Canada and Mexico?  (for example)

Or, I could filter by spot source, since my spots for 6m MSK144 are generated by my copy of WSJT-X.

I know I could use the Origin and Mode buttons, but I wanted a one click solution.
 
TIA, N0AN,


Hasan


Joe KC2TN

Dave AA6YQ
 

Is anyone in touch with Joe? I've sent him a couple of email messages without a receiving a response.

73,

Dave, AA6YQ


Re: FT8 and SPOTCOLLECTOR

Dave AA6YQ
 

+ AA6YQ comments below

Given the fact that my spots are of course all LOCAL from WSJT feeding Spotcollector, is it...or can it be possible to be able to 'click' on the SC spot and have WSJT TX on the station's freq just like CW/RTTY/SSB etc?

OR..is this TX frequency not accurately captured and provided to SC to make this happen?

+ Hi Jose!

+ WSJT-X does not provide the programmatic interface necessary to do that because its developers do not want to facilitate unattended operation -- a decision I support.

73,

Dave, AA6YQ


FT8 and SPOTCOLLECTOR

Jose
 

Given the fact that my spots are of course all LOCAL from WSJT feeding Spotcollector, is it...or can it be possible to be able to 'click' on the SC spot and have WSJT TX on the station's freq just like CW/RTTY/SSB etc?

OR..is this TX frequency not accurately captured and provided to SC to make this happen?

Thanks,
Jose
N4BAA


Re: DXLAB Hijacks Cursor

Dave AA6YQ
 

+ AA6YQ comments below

If you haven't deleted them yet, previous versions you've had installed are located within your DxLab\Commander folder.

+ Given that the filenames of these versions include a version number, you may need to configure your anti-malware application to consider them to be "safe".

+ If you've deleted these previous Commander versions, let me know and I'll send them to you.

73,

Dave, AA6YQ


Re: DXLAB Hijacks Cursor

Dave AA6YQ
 

+ AA6YQ comments below

Questions
1) A little more detail about the symptoms of this Hijacking? What other programs cant get access to the cursor ( mouse?)
2) When did you first notice the problem? Immediately after installing or several days later?
3) What operating system are you using?


I am running DX Lab 14.4 under WIN-10 Pro ( latest update) along with Firefox, JTDX, JT Alert, VSPE, Excel and a few others and have
no problems?. I typically dont have the entire lab suite open ..just DXKeeper, Commander , Spot Collector and DXView

+ Since no one else is reporting this behavior, we're trying to help Jim determine what on his system is responsible. The first step
is to determine whether this behavior was "enabled" by a particular version of Commander. I'd like Jim to run a version of Commander
from a time when he is certain that cursor-theft was not occurring. If cursor-theft does not now occur with this version, then we
know the behavior was enabled by a subsequent change to Commander.

73,

Dave, AA6YQ


Re: DXLAB Hijacks Cursor

Dave / NR1DX
 

Jim

Questions
1) A little more detail about the symptoms of this Hijacking? What other programs cant get access to the cursor ( mouse?)
2) When did you first notice the problem? Immediately after installing or several days later?
3) What operating system are you using?


I am running DX Lab 14.4 under WIN-10 Pro ( latest update) along with Firefox, JTDX, JT Alert, VSPE, Excel and a few others and have no problems?. I typically dont have the entire lab suite open ..just DXKeeper, Commander , Spot Collector and DXView


Dave
NR1DX

On 3/23/2020 2:14 PM, Jim NO0B wrote:
I have 14.4.0 and I guess I can work backward until the problem goes away.  It's pretty easy to replicate.  Where can I find the download files for previous releases?
--
Jim NO0B
--
Dave
Manuals@...
www.ArtekManuals.com
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


Re: DXLAB Hijacks Cursor

ND9G Mike
 

If you haven't deleted them yet, previous versions you've had installed are located within your DxLab\Commander folder.

73,
Mike ND9G


On Mon, Mar 23, 2020 at 1:14 PM Jim NO0B <jnmeade@...> wrote:
I have 14.4.0 and I guess I can work backward until the problem goes away.  It's pretty easy to replicate.  Where can I find the download files for previous releases?
--
Jim NO0B


Re: DXLAB Hijacks Cursor

 

I have 14.4.0 and I guess I can work backward until the problem goes away.  It's pretty easy to replicate.  Where can I find the download files for previous releases?
--
Jim NO0B


Re: Count of Satellite QSO's

Jeff Schwartz
 

PROP_MODE = ‘SAT’



On Mar 23, 2020, at 11:31 AM, John Kludt <johnnykludt@...> wrote:


Group,

I probably should know how to do this having read the manual but I am stumped at the detail level.  I am curious to know how many satellite QSO's I have made.  Nothing fancy just in pseudo code "Count for Propagation equals SAT."

Thanks,

John


Re: Count of Satellite QSO's

Dave AA6YQ
 

+ AA6YQ comments below

I probably should know how to do this having read the manual but I am stumped at the detail level. I am curious to know how many satellite QSO's I have made. Nothing fancy just in pseudo code "Count for Propagation equals SAT."

+ In the Filter panel at the bottom of the Main window's "Log QSOs" tab, type

prop_mode='sat'

+ and then depress your keyboard's CTRL key while clicking its S key. This will filter the Log Page Display to show only satellite QSOs. The number of satellite QSOs will be shown in the Main window's title bar.

+ If you'll be doing this frequently, you can create a user-defined SQL filter for it. See

"Invoking SQL Query Filters from the Filter panel"

+ in

<https://www.dxlabsuite.com/dxkeeper/Help/FilterLog.htm>

73,

Dave, AA6YQ


Count of Satellite QSO's

John Kludt
 

Group,

I probably should know how to do this having read the manual but I am stumped at the detail level.  I am curious to know how many satellite QSO's I have made.  Nothing fancy just in pseudo code "Count for Propagation equals SAT."

Thanks,

John


Re: Time on my hands DXLab "maintenance" chores?

Dave AA6YQ
 

+ AA6YQ comments below

There are a few oddball QSOs that show up in "Requested" that I have to uncheck before doing an LotW upload - I'm going to do an "En Masse" change with scripting, as have more time right now! Been doing that with drippy faucets, loose railing, etc. around the house - going to do so for the shack, too.

Made me think of other regular maintenance I could do on DXLabs - pruning/compressing spottling log is one. Are there any other areas anyone can recommend?

+ Unless you routinely delete lots of logged QSOs, there is no need to compact your log.

One area: if I do a synch QSLs with LotW, it takes a very long time to get activity back - usually indicated by the Notepad file coming up listing if there were any exciting new confirmations. Is that just a function of log size, or is there some parameter/setting I could tweak?

+ To see if an anti-malware application is responsible for the delay,

1. reboot Windows into "Safe mode with networking"

2. start DXKeeper, an initiate "Sync LoTW QSLs". Any difference in response time?

73,

Dave, AA6YQ


Time on my hands DXLab "maintenance" chores?

John K3TN
 

There are a few oddball QSOs that show up in "Requested" that I have to uncheck before doing an LotW upload - I'm going to do an "En Masse" change with scripting, as have more time right now! Been doing that with drippy faucets, loose railing, etc. around the house - going to do so for the shack, too.

Made me think of other regular maintenance I could do on DXLabs - pruning/compressing spottling log is one. Are there any other areas anyone can recommend?

One area: if I do a synch QSLs with LotW, it takes a very long time to get activity back - usually indicated by the Notepad file coming up listing if there were any exciting new confirmations. Is that just a function of log size, or is there some parameter/setting I could tweak?

Thanks and 73 John K3TN


Re: IC-7300 clock set

Dave AA6YQ
 

+ AA6YQ comments below

I have had my 7300 powered down for a while primarily using my IC-7600 on FT8. When I powered up today the clock had lost it's time which will happen if no power is applied to the radio for an extended period. I started Commander thinking it would reset the clock but it didn't happen. I have the Set UTC time at startup box checked in the general configuration. I also tried clicking on the Set Time box with no effect. My computer is connected to the radio using the legacy CI-V port. No issues with Commander otherwise.

Any suggestions?

+ I used its menu system to set my IC-7300's clock to the wrong time, and then click Commander's "Set Time" button; the IC-7300 immediately displayed the correct time. There are no reports from other users of Commander not setting the correct time in any transceiver that accepts it.

+ If you manually set your IC-7300's date and time, does it correctly keep time?

73,

Dave, AA6YQ


Re: LoTW Upload popup

Dave AA6YQ
 

+ AA6YQ comment below

While I writing this post, pop-up disappeared... So it looks like DXKeeper actually was doing something, despite the statement that all QSOs were signed and uploaded...

+ DXKeeper was checking for the creation of the file that TQSL creates when the submission operation is complete.

+ If the long delay recurs, I would suspect interference from a misconfigured anti-malware application; you can test for this by booting Windows into "Safe Mode with networking" and then attempting to submit some QSOs to LoTW; if the delay disappears, then an application being started by Windows when booted normally is responsible.

73,

Dave, AA6YQ


IC-7300 clock set

Allen Jones
 

I have had my 7300 powered down for a while primarily using my IC-7600 on FT8.  When I powered up today the clock had lost it's time which will happen if no power is applied to the radio for an extended period.  I started Commander thinking it would reset the clock but it didn't happen. I have the Set UTC time at startup box checked in the general configuration.  I also tried clicking on the Set Time box with no effect.  My computer is connected to the radio using the legacy CI-V port.   No issues with Commander otherwise.

Any suggestions?

Allen, W9DZ


Re: LoTW Upload popup

Gene
 

While I writing this post, pop-up disappeared... So it looks like DXKeeper actually was doing something, despite the statement that all QSOs were signed and uploaded...