Date   
More on Synchronizing DB

Morris WA4MIT
 

Hello 

Chris I sent you an email about my attempts at synchronizing earlier today after installing your Relay software. After reading here about the other users and it taking a longer than expected time I decided to let the process run and it did for over an hour it was still going when I stopped it with task manager. This time it has installed 21000 of my HRD log of over 23000 contacts. What is in the Relay DB is all of my JT contacts and more so I may just let it ride. I can also report successfully using Relay tonight and logging 2 QSO`s into HRD 6.4.0.647 Chris this is just great. Appreciate greatly you sharing your programming skills with us. Chris do you know if I try to synchronize again will it resume where it left off or start again?

Thanks very much

73 Morris WA4MIT

Re: Frequency Error

py3og@...
 

Hi Chris,

Here a few elements to try you see the problem.

MY WSJT_LOG.ADI   (1 line)

<call:6>PY3ADQ <gridsquare:4>GF38 <mode:4>JT65 <rst_sent:3>-01 <rst_rcvd:3>-01 <qso_date:8>20170503 <time_on:4>0138 <band:3>20m <freq:9>14.077005 <station_callsign:5>PY3OG <my_gridsquare:6>GF38uf <comment:17><eor>

HRD LOGBOOK- ADD LOG ENTRY WINDOW



HRD LOGBOOK QSO



73, Clovis- PY3OG

moderated Re: Synchronise Databases

Chris VK2BYI
 

Hi Mike and David,

I am not happy with the times you quote and believe some work needs to be done on my part to improve the sync times.

During testing we were getting figures of a minute or two, with about 4000 QSOs.  However, my colleagues and I are using Microsoft SQL Server for the HRD Logbook database, and that may make a difference.  So, forgive me for being a little optimistic with my statement in the documentation

However, 10 minutes is way too long.  I will start profiling the Sync Database code and see what I can do to improve it, but it will take sometime (no pun intended).

In the meantime, it is only necessary to do a Sync Database just before you do a Scan Log and Update in JTAlertX to update its Wanted Alert requirements, which depending upon your operating habits might only be daily or even weekly.

73 Chris
VK2BYI

moderated Re: New to this group, install questions

Bob Davet
 

Made the mistake of not creating the SQLite database. Now that I have that done It syncs and entries come up in the Delete Entry box.

But.......Not all of my calls are in there?? I have 1757 entries. That earliest is from 2007 and the last is from 2015. Where did all my 2016 and 2017 ones go?

My SQLite database is only showing 1128kb and the HRD log is showing 3216kb. I know that HRD is Access and SQLite is something else.

But where are all of my other entries?


Bob

Re: Frequency Error

Chris VK2BYI
 

Hi Clovis,

The QSO data coming from JTAlertX contains the Freq value in MHZ as per the ADIF standard.  It is stored in the QSO Relay SQLite file as KHz which is how Log4OM stores it, and it is relayed to HRD as Hz which is how is it stored there.

We cannot reproduce the problem you report, and no other users have reported anything similar as well.  So all I can suggest at the moment is that the frequency was not obtained correctly from your transceiver via CAT control by WSJT-X.

You could open the WSJT-X log directory by selecting 'Open log directory' from the 'File' menu, and open the 'wsjtx.log' file and see what frequency was logged there for that QSO.  Here is a sample from my 'wsjtx.log' file:

    2017-Apr-03,05:09,4W/YB3LZ,PI21,14.078307,JT65,-17,-17,,JT65  Sent: -17  Rcvd: -17,

And here is the same contact from my 'wsjtx_log.adi' file:

    <call:8>4W/YB3LZ <gridsquare:4>PI21 <mode:4>JT65 <rst_sent:3>-17 <rst_rcvd:3>-17 <qso_date:8>20170403 <time_on:4>0509 <band:3>20m <freq:9>14.078307 <station_callsign:6>VK2BYI <my_gridsquare:6>QF55mx <comment:26>JT65  Sent: -17  Rcvd: -17 <eor>

As you can see the frequency is in MHz, and it was for a 20m contact on a calcuated RF frequency of 14.078307 MHz (my rig was tuned to 14.077).  This has been converted to 14077 KHz and stored in the QSO Relay SQLite file, and was then converted to 14077000 HZ and stored in HRD Logbook which is displayed as 14.077.000.

If you wish, you can send my your 'wsjtx.log' or 'wsjtx_log.adi' files, along with the QSO Relay SQLite file and I will take a look for you.

73 Chris



moderated Re: Synchronise Databases

Mike Steiner
 

David,


Don't get me wrong... I was just surprised of how long it took, when it says less than a minute, and mine too awhile. Love the program, and now enjoying the new features that JTAlert add since stopped at 2.8.7.


73 Mike

K7QDX




From: vk2byi-qsorelay@groups.io <vk2byi-qsorelay@groups.io> on behalf of D S Smith <dss@...>
Sent: Tuesday, May 2, 2017 4:56 PM
To: vk2byi-qsorelay@groups.io
Subject: Re: [vk2byi-qsorelay] Synchronise Databases
 

Hello all

 

I was pleased to see another user comment on the sync time, no issues here for time as 20000 + in log and a very useful resource.

 

Thank you again

 

73 David

MM0HVU

 

Privacy & Confidentiality

This e-mail message and any attachments are only for the use of the intended recipient and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient, any disclosure, distribution or other use of this e-mail message or attachments is prohibited. If you have received this e-mail message in error, please delete and

notify the sender immediately. All information is retained for the sole purposes of verification and identification & is securely deleted when verified in all cases.Mobile:07912871685

 

moderated Re: Synchronise Databases

D S Smith <dss@...>
 

Hello all

 

I was pleased to see another user comment on the sync time, no issues here for time as 20000 + in log and a very useful resource.

 

Thank you again

 

73 David

MM0HVU

 

Privacy & Confidentiality

This e-mail message and any attachments are only for the use of the intended recipient and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient, any disclosure, distribution or other use of this e-mail message or attachments is prohibited. If you have received this e-mail message in error, please delete and

notify the sender immediately. All information is retained for the sole purposes of verification and identification & is securely deleted when verified in all cases.Mobile:07912871685

 

Frequency Error

py3og@...
 

I noticed the following problem when using Relay QSO:
-The log in a QSO made on 15 meters, 21.076, noticed that the frequency passed to the HRD Logbook was 21.47.483.647 format and on the 13 cm band.
Obviously there's something wrong. Any help will be welcome.


73, Clovis- PY3OG

moderated Synchronise Databases

Mike Steiner
 

Just wanted to say that, "Synchronize Databases" took way longer than I thought it should've taken, after reading what it said in the install PDF. It took well over 10 minutes for more than 6,000 QSO's. However the program is working great and I'm trying to enjoy the new features of JT Alert since I stopped with the old version.

73

Mike K7QDX

 

moderated Re: New to this group, install questions

Bruce VK2RT
 

You need to select "Synchronise Databases", this will then mirror your HRD Logbook in the SQLite database.

Bruce VK2RT

moderated New to this group, install questions

Bob Davet
 

Just downloaded QSORelay and manuals.

Have it installed. Have my HRD logbook selected(access).

Have synchronized it and it worked.

Tried to pull of the delete entry section to just look and nothing comes up in that section.

What have I done wrong?? What settings have I not set up correctly??

I am running JTalert 2.8.7 right now. Did not want to upgrade till I knew that QSORelay was working.

I am running the HRD 6.4.0.647


Thanks

Bob

W8RID

moderated New file uploaded to vk2byi-qsorelay@groups.io

vk2byi-qsorelay@groups.io Notification <vk2byi-qsorelay+notification@...>
 

Hello,

This email message is a notification to let you know that a file has been uploaded to the Files area of the vk2byi-qsorelay@groups.io group.

File: Terms and Conditions for vk2byi-qsorelay@...

Uploaded By: Chris

Description:
Terms and Conditions for membership of the vk2byi-qsorelay@groups.io group.

You can access this file at the URL:
https://groups.io/g/vk2byi-qsorelay/files/Terms%20and%20Conditions%20for%20vk2byi-qsorelay@...

Cheers,
The Groups.io Team