Date   

Re: SQL Syntax Question

Dave AA6YQ
 

+ AA6YQ comments below

Worked like a charm! Guess I need to learn more about SQL language and syntax.

 

+ This section of the Reference Documentation provides an introduction:

https://www.dxlabsuite.com/dxkeeper/Help/SQL.htm

 

+ At the end of the section, you’ll find URLs for two online SQL references.

    73,

 

           Dave, AA6YQ


Re: SQL Syntax Question

n2_ss
 

Yep, MYQTHID='' worked. When I was trying it I was not including  “ID”

Thanks,

Tony N2SS

 

 

 

On 11/16/21, 2:46 PM, "ND9G Mike" <DXLab@groups.io on behalf of mike.nd9g@...> wrote:

 

MTQTHID=''  works fine for me.

 

Those are two single quotes, not a single double quote.

 

73,

Mike ND9G

 

 

On Tue, Nov 16, 2021 at 1:24 PM n2_ss <n2ss@...> wrote:

I have multiple MYQTH locations and I have some QSO’s in my log where the MYQTH entry is blank (somehow some got dropped when transferring from another logging program). I would like to do a custom sort to identify blank MYQTH boxes so that I can fix them. I’ve tried using apostrophe’s and quotation marks both with and without spaces in between; I’ve tried using the term NULL. Can’t get anything to generate just the blank MYQTH entries. Obviously, I’ve got something wrong in the SQL syntax. Suggestions?

 

Thanks,

Tony N2SS


Re: SQL Syntax Question

n2_ss
 

Worked like a charm! Guess I need to learn more about SQL language and syntax. Thanks, Dave.

Tony N2SS

 

 

On 11/16/21, 2:43 PM, "Dave AA6YQ" <DXLab@groups.io on behalf of aa6yq@...> wrote:

 

+ I have multiple MYQTH locations and I have some QSO’s in my log where the MYQTH entry is blank (somehow some got dropped when transferring from another logging program). I would like to do a custom sort to identify blank MYQTH boxes so that I can fix them. I’ve tried using apostrophe’s and quotation marks both with and without spaces in between; I’ve tried using the term NULL. Can’t get anything to generate just the blank MYQTH entries. Obviously, I’ve got something wrong in the SQL syntax. Suggestions?

 

+ Try this:

 

LEN(MYQTHID)=0

 

    73,

 

           Dave, AA6YQ

 

 

 

 

 

 


Re: SQL Syntax Question

W9MR Mike
 

MTQTHID=''  works fine for me.

Those are two single quotes, not a single double quote.

73,
Mike ND9G


On Tue, Nov 16, 2021 at 1:24 PM n2_ss <n2ss@...> wrote:

I have multiple MYQTH locations and I have some QSO’s in my log where the MYQTH entry is blank (somehow some got dropped when transferring from another logging program). I would like to do a custom sort to identify blank MYQTH boxes so that I can fix them. I’ve tried using apostrophe’s and quotation marks both with and without spaces in between; I’ve tried using the term NULL. Can’t get anything to generate just the blank MYQTH entries. Obviously, I’ve got something wrong in the SQL syntax. Suggestions?

 

Thanks,

Tony N2SS


Re: SQL Syntax Question

Dave AA6YQ
 

+ I have multiple MYQTH locations and I have some QSO’s in my log where the MYQTH entry is blank (somehow some got dropped when transferring from another logging program). I would like to do a custom sort to identify blank MYQTH boxes so that I can fix them. I’ve tried using apostrophe’s and quotation marks both with and without spaces in between; I’ve tried using the term NULL. Can’t get anything to generate just the blank MYQTH entries. Obviously, I’ve got something wrong in the SQL syntax. Suggestions?

+ Try this:

LEN(MYQTHID)=0

73,

Dave, AA6YQ


SQL Syntax Question

n2_ss
 

I have multiple MYQTH locations and I have some QSO’s in my log where the MYQTH entry is blank (somehow some got dropped when transferring from another logging program). I would like to do a custom sort to identify blank MYQTH boxes so that I can fix them. I’ve tried using apostrophe’s and quotation marks both with and without spaces in between; I’ve tried using the term NULL. Can’t get anything to generate just the blank MYQTH entries. Obviously, I’ve got something wrong in the SQL syntax. Suggestions?

 

Thanks,

Tony N2SS


Nicknames and QRZ-based callbooks

Dave AA6YQ
 

DXKeeper can obtain callbook data from QRZ in two ways:

1. If you have a free QRZ account and are running Pathfinder, DXKeeper can direct Pathfinder to extract callbook data from a callsign’s QRZ page. This is referred to as “QRZ via Pathfinder”. This is relatively slow, because Pathfinder must display QRZ’s advertisements, and because the rate is limited to one lookup every 4 seconds. But it’s entirely free.

 

2. If you have subscribed to QRZ’s “XML Data” service, DXKeeper can use it to obtain callbook data without Pathfinder having to be running. No advertisements are rendered and the lookup rate is unlimited; it’s fast, but not free.

 

Back in September 2020, QRZ added the ability for  the owner of a callsign to specify a nickname, e.g. “Dave” instead of “David”. Jay WBØL reported that “QRZ via Pathfinder” failed to return name and address information for callsigns that specified a nickname. Because “QRZ via Pathfinder” works by extracting information from a QRZ web page, any change in the content or format of that information can break the extraction process. I updated Pathfinder 5.2.6 to handle the presence of a nickname, and report it as the callsign owner’s “first name”.

Recently, Andy K0AF reported that “QRZ via Pathfinder” had stopped handling nicknames correctly. That’s because QRZ changed their web page design to render nicknames in bold font. I have updated the next version of Pathfinder to compensate for this change in display format; this new version also includes changes that ensure the correct handling of multiple requests from other applications, as thus requires additional testing before a public release. If you are using “QRZ via Pathfinder” and are willing to help with this testing, please send email to me via

 

aa6yq (at) ambersoft.com

 

The first three to respond will receive instructions on obtaining this new version.

 

Andy and I also noticed that QRZ’s “XML Data” service is also including nickname information in the callbook data it reports. I have extended the next version of DXKeeper to use a reported nickname in place of the reported first name.

       73,

 

              Dave, AA6YQ

 


Re: PstRotor

Dave AA6YQ
 

+ AA6YQ comments below

 

N1MM Rotor does the trick for me and I have no issues with it at all

 

I just happened to see a post about PST which got my curiosity and wanted to play with it and compare. 

 

The other attractive feature with Pst is the remote control for the SteppIR. I do currently have SteppIR tracking all 4 radios connected to DXLab but I would like the idea of having a remote control of the controller on the screen as well 

 

+ Thanks, Saad!

       73,

 

            Dave, AA6YQ


Re: PstRotor

Saad Mahaini
 

Hi Dave , sorry for the late response

N1MM Rotor does the trick for me and I have no issues with it at all

I just happened to see a post about PST which got my curiosity and wanted to play with it and compare. 

The other attractive feature with Pst is the remote control for the SteppIR. I do currently have SteppIR tracking all 4 radios connected to DXLab but I would like the idea of having a remote control of the controller on the screen as well 

73 Saad N5FF 




On Nov 14, 2021, at 4:39 PM, Dave AA6YQ <aa6yq@...> wrote:

+ AA6YQ comments below
I'm using N1MM Rotor software as an intermediate interface between DXLab and multiple rotors. 
 
I like to experiment with PstRotor Az software to do the same, but i dont see that option in DXView/Config/Rotor control.
 
PstRotor shows DXLab as a logging program that it supports

+ PSTRotor's ability to interoperate with DXView is described on page 34 of its user manual:

http://www.pstrotator.com/ANT/PstRotator%20User%20Manual.p

+ If  DXView interoperating with "N1MM Rotor" is not meeting your needs, please explain the deficiencies. Thanks!

      73,

             Dave, AA6YQ


Re: Commander - Yaesu 991A - DT GAIN

Bruce N7XGR
 

Whoops there, sorry about that Chief.
He might try EX1614 to see if anything reads back with this command.
This is from the FT891 CAT manual, sometimes they forget to include
a command or two.  This is the DATA DATA GAIN in the main menu.
The value is between 0 and 100.

Bruce  N7XGR


On Mon, Nov 15, 2021 at 7:13 PM Dave AA6YQ <aa6yq@...> wrote:

+ AA^YQ comments below

 

Ralf,  I just did a PDF search (gain) that had 136 results in the FT991A manual and found this, on page 24 right side under the display picture there is this, DT-G (DT GAIN). They apparently at Yaesu have no idea on how to do a simple search in their PDF manuals.

Black and White period.

 

+ Ralf has been seeking a CAT command to control DT Gain.

 

        73,

 

               Dave, AA6YQ


Re: Commander - Yaesu 991A - DT GAIN

Dave AA6YQ
 

+ AA^YQ comments below

 

Ralf,  I just did a PDF search (gain) that had 136 results in the FT991A manual and found this, on page 24 right side under the display picture there is this, DT-G (DT GAIN). They apparently at Yaesu have no idea on how to do a simple search in their PDF manuals.

Black and White period.

 

+ Ralf has been seeking a CAT command to control DT Gain.

 

        73,

 

               Dave, AA6YQ


Re: Commander - Yaesu 991A - DT GAIN

Bruce N7XGR
 

Ralf,  I just did a PDF search (gain) that had 136 results in the FT991A manual and found this,
on page 24 right side under the display picture there is this, DT-G (DT GAIN).
They apparently at Yaesu have no idea on how to do a simple search in their PDF manuals.
Black and White period.

Bruce  N7XGR


On Mon, Nov 15, 2021 at 5:10 PM Ralf Bender <rlfbender@...> wrote:
Today I received the first answer:

Thank you for contacting Yaesu regarding your FT-991A.

I have just checked the CAT manual and you are correct; it does not have an entry for “DT Gain”.

I will see if this can be looked at.

--
73 Ralf
--
DO5RBB
DL0103SWL
https://www.youtube.com/c/RalfBender/


Re: PF lookup aborting

Dave AA6YQ
 

+ AA6YQ comments below

Disregard my question. I have the QRZ XML Logbook Data subscription. It looks like the features you described require the Premium Subscriber Package subscription.

+ Not so. The "QRZ XML Logbook Data subscription" is all you need.

73,

Dave, AA6YQ


Re: MSCOMCTL.OCX

Dave AA6YQ
 

+ AA6YQ comment below

Thanks Dave for you directions all fixed!

+ Great! This would be a good time to review

https://www.dxlabsuite.com/dxlabwiki/HardwareSoftwareUpgrades

73,

Dave, AA6YQ


Re: Can DX Labs run on Windows 11 on ARM

Fredric T. Serota
 

I am running DXLab on an new HP desktop minitower with I7 processor and solid state drive with Win 11 Home without any issues so far. Am controlling 2 transceivers with each following the other. What a fantastic feature.

 

Fred


Re: Commander - Yaesu 991A - DT GAIN

Ralf Bender
 

Today I received the first answer:

Thank you for contacting Yaesu regarding your FT-991A.

I have just checked the CAT manual and you are correct; it does not have an entry for “DT Gain”.

I will see if this can be looked at.

--
73 Ralf
--
DO5RBB
DL0103SWL
https://www.youtube.com/c/RalfBender/


Re: PF lookup aborting

Dave AA6YQ
 

+ AA6YQ comments below

I installed the new version and replied to you by email. I have a question though regarding your comment "They (QRZ) do provide an optional (for a price) XML data service that is completely insensitive to user interface changes, isn't limited to one lookup every 4 seconds, and is faster because there are not advertisements to render."

I have the QRZ paid XML service. Did I miss a setting in DXLabs so that it isn't making use of the paid XML service?

+ Yes: see the "Configuring DXKeeper to use an Online Callbook Service" section in

https://www.dxlabsuite.com/dxlabwiki/CallbookLookup

73,

Dave, AA6YQ


Re: PF lookup aborting

Andy - K0AF
 

Dave,

Disregard my question. I have the QRZ XML Logbook Data subscription. It looks like the features you described require the Premium Subscriber Package subscription.

Thanks Dave.
--
Andy - KØAF


Re: MSCOMCTL.OCX

W7HPW Radio
 

Thanks Dave for you directions all fixed!

Mark
W7HPW

Real Radios Glow in the Dark

-----Original Message-----
From: DXLab@groups.io [mailto:DXLab@groups.io] On Behalf Of Dave AA6YQ
Sent: Monday, November 15, 2021 2:23 PM
To: DXLab@groups.io
Subject: Re: [DXLab] MSCOMCTL.OCX

+ AA6YQ comments below

The file is still on my system in C;/WindowsSysWOW64

Tried RedSvr32.exe got the following error

The module "C:\Windows\SysWOW64\MSCOMCTL.OCX wos loaded but the call to DllRegisterServer failed with error code 0x8002801c

+ See

https://answers.microsoft.com/en-us/windows/forum/all/dllregisterserver-failed-with-error-code-0x8002801/403ee0d0-895b-e011-8dfc-68b599b31bf5?auth=1

73,

Dave, AA6YQ


Re: PF lookup aborting

 

Yep!


-----Original Message-----
From: Andy - K0AF <folkjunk0@...>
To: DXLab@groups.io
Sent: Mon, Nov 15, 2021 4:56 pm
Subject: Re: [DXLab] PF lookup aborting

Hi Dave,

I installed the new version and replied to you by email. I have a question though regarding your comment "They (QRZ) do provide an optional (for a price) XML data service that is completely insensitive to user interface changes, isn't limited to one lookup every 4 seconds, and is faster because there are not advertisements to render."

I have the QRZ paid XML service. Did I miss a setting in DXLabs so that it isn't making use of the paid XML service?

Thanks Dave!
--
Andy - KØAF

4281 - 4300 of 208719