Date   
Re: Thanks from the UK

Chris VK2BYI
 

Hi Mike, Thank you for the feedback and we are glad to hear that you find QSO Relay useful. 73 Chris, VK2BYI and Bruce, VK2RT

Re: Contact was not logged in QSORelay SQLite database

snack@...
 
Edited

I check this and correct file was pointed.. anyway i got this finally work, i read your post from JTDX FB group. And YES my regional settings uses "," COMMA for the decimal symbol, if i change to "." DOT, restart JTDX JTalertx and QSORelay everything works fine no problemes at all. If i use default value on decimal symbol (COMMA) and restart JTDX JTalertx and QSORelay.. it wont work anymore

So i hope that QSORelay will support my default symbol COMMA in future versions. To be honest i thought some place this problem that it may be something in regional settings what can do this, but i did not test change any of them silly me =)

Anyway, to me problem have now "work around solution" but i hope that you fix this in future version soon or later. Thank you for your support

Mikko, OH8EJW

Re: QSO Relay

snack@...
 
Edited

Hi Arnolds,

Try change your default decimal symbol form "COMMA" to "DOT" in windows regional settings, to me that trick works. AND do not forget restart your JT program JTalertx and QSORelay

- Mikko

Re: QSO Relay

Arnolds Preiss
 

Thank you very much Mikko, yes  it work now, tnx. GL 73

Arnolds

YL2CA

Re: HRD needs refresh after logging .

f1vev@...
 

Thank you to all and that did the trick polling / sharing was not set 73s to everyone who answered

Re: QSO Relay

snack@...
 

Thanks goes to Bruce, i got this hint from him in FB group. Anyway nice to know, this works

- Mikko

QSO Relay Logging Issue to do with Windows Regional Settings - Please Read

Bruce VK2RT
 

There is currently an issue with Windows Regional Settings where a comma "," is being used as the Mhz separator as shown in the WSJT-X/JTDX etc. frequency window.

Quick FIx - if your Windows Regional Setting is a comma "," change it to is a dot "."

A new release of QSO Relay will be available shortly that fixes this issue.


DE Bruce

VK2RT

Stopped logging to HRD

Ian Morrow
 

Hello

I would like to say that you software is great and doing a great job.  I am new to JT65 and have been using you software all day. I set it up to your quick setup guide and it worked right away.  Everything was logging 100% until about 12 midday and then it stopped logging to HRD but it was still logging to the QSORelay SQLite database. I have 4 contacts in my log since the last one to log in HRD ,but they will not come over to my HRD log.  I have tried to synchronise Databases a few times but it still has not helped. Hope you can help in some way?  I have changed no setting since I first set it up and it was working.

 

If you need access to my setup , I have TeamViewer on my computer.

 

Best Regards

MI1CCU Ian


Re: Stopped logging to HRD

Bruce VK2RT
 

Hi Ian,

Please look in the AppData folder for the application - C:\Users\<your username>\AppData\Roaming\VK2BYI\QSORelay, and see if any exceptions have occurred during the sync.

If there is an exception log there (Exception yyyy-mm-dd.log), can you send it to me via bruce@...

Also, what JT software are you using (WSJT-X/JTDX etc), and what versions of JTAlertX and HRD.


DE Bruce

VK2RT

moderated Re: New to this group, install questions

Chris VK2BYI
 

Hi Bob,

I have had chance to register your database in HRD Logbook and configure QSO Relay to work with it.  I then created a new QSO Relay SQLite database file and performed a database sync which ran for about 30 odd seconds.

Everything worked without issue - all of your contacts came down and without any errors or warnings.  So, at this stage I would suggest you re-boot/re-install QSO Relay and try again.

The next release will include an enhancement that will display the number of rows in the SQLite database in the Delete a Contact... dialog, along with a Search for Contact feature.

We are working on this release and hope to have it ready in the next couple of days time permitting.

73 Chris
VK2BYI

Not showing all contacts in delete box.

Bob Davet
 

Chris:


Thanks for looking into that for me.

I uninstalled QSORelay completely. I even deleted all files and folders.

Reinstalled it and created the appropriate files.

Synchronized the databases. Ran for 30-40 seconds.

When I pull up the Delete entry box I get the exact same info I did before. I am missing contacts. It stops at 2015. Nothing past that.

I have attached 3 files today for you to check out. I included the SQL file also.

Both the HRD and SQL files should be identical correct? If so, how do I check the SQL file? I have never used that type of file before that I know of.

Thanks


Bob

W8RID

Re: Not showing all contacts in delete box.

Chris VK2BYI
 

Hi Bob,

I opened the Access and SQLite databases you provided and they both contain 1,258 rows.  So all of the rows that are in your Access database have been synchronized in QSO Relay.

I wrote two queries to break down the number of contacts per year for each database, and here are the results for Access and SQLite respectively:

      

As you can see the number of contacts per year are identical.  So I am confident that all of contacts have been sync'ed.

QSO Relay only selects rows from, and inserts rows into, HRD Logbook - it does not delete HRD rows.  The Delete Contact feature only deletes rows one at a time from the QSO Relay database.


So I would have to assume you may have accidently deleted all contacts made after the contact with VK3ERW on 2015-05-29 12:25:15.


HRD Logbook creates automatic backups of your database periodically, so you should be able to recover your lost rows if you can locate the archive made immediately before the data loss.


73 Chris

VK2BYI


Re: Not showing all contacts in delete box.

Bob Davet
 

Chris:

 

I have contacts that I made in 2016 and 2017 that do not show.

 

Why are these not there?

 

Bob

W8RID

 

From: vk2byi-qsorelay@groups.io [mailto:vk2byi-qsorelay@groups.io] On Behalf Of Chris
Sent: Friday, May 05, 2017 11:01 AM
To: vk2byi-qsorelay@groups.io
Subject: Re: [vk2byi-qsorelay] Not showing all contacts in delete box.

 

Hi Bob,

I opened the Access and SQLite databases you provided and they both contain 1,258 rows.  So all of the rows that are in your Access database have been synchronized in QSO Relay.

I wrote two queries to break down the number of contacts per year for each database, and here are the results for Access and SQLite respectively:

      

As you can see the number of contacts per year are identical.  So I am confident that all of contacts have been sync'ed.

QSO Relay only selects rows from, and inserts rows into, HRD Logbook - it does not delete HRD rows.  The Delete Contact feature only deletes rows one at a time from the QSO Relay database.



So I would have to assume you may have accidently deleted all contacts made after the contact with VK3ERW on 2015-05-29 12:25:15.

 

HRD Logbook creates automatic backups of your database periodically, so you should be able to recover your lost rows if you can locate the archive made immediately before the data loss.


73 Chris

VK2BYI

 


Virus-free. www.avast.com

Re: Not showing all contacts in delete box.

Bob Davet
 

Chris:

 

My HRD logbook Shows all my contacts.

I will be sending you my last 2 backups. In a few minutes.

 

Bob

W8RID

 

From: vk2byi-qsorelay@groups.io [mailto:vk2byi-qsorelay@groups.io] On Behalf Of Chris
Sent: Friday, May 05, 2017 11:01 AM
To: vk2byi-qsorelay@groups.io
Subject: Re: [vk2byi-qsorelay] Not showing all contacts in delete box.

 

Hi Bob,

I opened the Access and SQLite databases you provided and they both contain 1,258 rows.  So all of the rows that are in your Access database have been synchronized in QSO Relay.

I wrote two queries to break down the number of contacts per year for each database, and here are the results for Access and SQLite respectively:

      

As you can see the number of contacts per year are identical.  So I am confident that all of contacts have been sync'ed.

QSO Relay only selects rows from, and inserts rows into, HRD Logbook - it does not delete HRD rows.  The Delete Contact feature only deletes rows one at a time from the QSO Relay database.



So I would have to assume you may have accidently deleted all contacts made after the contact with VK3ERW on 2015-05-29 12:25:15.

 

HRD Logbook creates automatic backups of your database periodically, so you should be able to recover your lost rows if you can locate the archive made immediately before the data loss.


73 Chris

VK2BYI

 


Virus-free. www.avast.com

Backups

Bob Davet
 

Here are the last 2 back ups.

Bob

W8RID

Re: Backups

Chris VK2BYI
 

Hi Bob,

The following screen capture shows the the 'Access - W8RID' database tab for the ODBC definition I created to open your Access .mdb file, and after I restored the latest XML backup file you sent, it now contains all of your 1,754 contacts up to 2017-04-30 21:28:30:

However, the .mdb file you sent me previously only had 1,258 contacts up to 2015-05-29 12:25:15 as previously posted in your 'not_showing_all_contacts_in' topic.

So, I believe that you may have selected the wrong HRD Logbook database in the QSO Relay configuration settings, as it appears as though QSO Relay is fetching the 1,258 rows from a different Access database file.

The text on the tab of the open database in HRD Logbook - Access - W8RID', comes from the Title in Logbook Databases dialog in HRD:

As you can see in the following screen capture, the Logbook Database: drop down listbox In the QSO Relay configuration dialog lists of the database titles defined in HRD Logbook:

You need to make that the selected database in QSO Relay matches the same database that is currently being used in HRD Logbook.  I believe you should then be ready to go, as I was able to successfully synchronize all 1,754 contacts this time.

This is the new Delete Contact dialog that will be in the new release coming shortly.  It displays the row count in the caption and also provides an incremental search by QsoDate or Call facility that will make it much easier to locate a row if the one you want to delete is not the most recent:


73 Chris
VK2BYI

Re: Backups

Bob Davet
 

Chris:

 

I really appreciate all your help.

 

I have tried selecting other log books in HRD and QSORelay. All the results come out the same. They stop at that 2015 Date.

 

I am on my way out the door to go to work. I’m a Firefighter/Paramedic. I will be on my 24hr shift and out of communication with my home computer.

I have a couple things I want to try when I get home. So don’t think I’m ignoring you.

 

All the log books I have (3) all read the same data. They have all the QSO’s, but when I try and sync them they only go thru 2015.

 

Talk to you when I get back.

 

Bob

W8RID

 

From: vk2byi-qsorelay@groups.io [mailto:vk2byi-qsorelay@groups.io] On Behalf Of Chris
Sent: Friday, May 05, 2017 11:22 PM
To: vk2byi-qsorelay@groups.io
Subject: Re: [vk2byi-qsorelay] Backups

 

Hi Bob,

The following screen capture shows the the 'Access - W8RID' database tab for the ODBC definition I created to open your Access .mdb file, and after I restored the latest XML backup file you sent, it now contains all of your 1,754 contacts up to 2017-04-30 21:28:30:

However, the .mdb file you sent me previously only had 1,258 contacts up to 2015-05-29 12:25:15 as previously posted in your 'not_showing_all_contacts_in' topic.

So, I believe that you may have selected the wrong HRD Logbook database in the QSO Relay configuration settings, as it appears as though QSO Relay is fetching the 1,258 rows from a different Access database file.

The text on the tab of the open database in HRD Logbook - Access - W8RID', comes from the Title in Logbook Databases dialog in HRD:

As you can see in the following screen capture, the Logbook Database: drop down listbox In the QSO Relay configuration dialog lists of the database titles defined in HRD Logbook:

You need to make that the selected database in QSO Relay matches the same database that is currently being used in HRD Logbook.  I believe you should then be ready to go, as I was able to successfully synchronize all 1,754 contacts this time.

This is the new Delete Contact dialog that will be in the new release coming shortly.  It displays the row count in the caption and also provides an incremental search by QsoDate or Call facility that will make it much easier to locate a row if the one you want to delete is not the most recent:

73 Chris
VK2BYI


Virus-free. www.avast.com

Re: Backups

Chris VK2BYI
 

No problem at all Bob.  Happy to help.

Chris
VK2BYI

Re: Backups

Bob Davet
 

Chris:

 

OK. I have deleted all my logs that were in there.

Created a new one and restored all the data. It is all there.

 

Configured it with the new log. Test connection successful.

 

Synchronize the data base and get the same issue. Last entry in the QSORelay SQLite db is 5/29/2015. There are entries for 2016 and 2017 that are not showing up in the Delete Contact box.

 

Hope you have some more ideas?

 

Bob

W8RID

 

From: vk2byi-qsorelay@groups.io [mailto:vk2byi-qsorelay@groups.io] On Behalf Of Chris
Sent: Saturday, May 06, 2017 7:56 AM
To: vk2byi-qsorelay@groups.io
Subject: Re: [vk2byi-qsorelay] Backups

 

No problem at all Bob.  Happy to help.

Chris
VK2BYI


Virus-free. www.avast.com

QSORELAY and error msg

Morris WA4MIT
 

It seems that after a few hours use that qsorelay and or jtalert is loosing contact with the DB I am getting error QSO not logged msg when in reality the contact is logged. This has happened couple of times now. yesterday I left JTDX, JTAlert and QSORELAY all on but JTDX was stopped from decoding when I came back to computer it had lost contact and would not log QSO`s on same msg restarted the softwares all OK again. Really do appreciate the software being able to use latest HRD is great thanks guys. 73 Morris WA4MIT