Topics

Double in the log...

Steph Collas <f5nzy@...>
 

Hi all,

 

Since I sync my log with lotw, eqsl and clublog, I have double in my log.

 

I can delete them, one by one, but is it a possibility to delete all the double entries, by the soft ?

 

73 de Steph, F5NZY

Tom Wylie
 

Its not in the log but the previous qso window??? The callsigns are the same, but the QSO time is different, so maybe the PC sees it as a different QSO????


Tom

On 11/09/2019 20:20, Steph Collas via Groups.Io wrote:
Hi all,
Since I sync my log with lotw, eqsl and clublog, I have double in my log.
I can delete them, one by one, but is it a possibility to delete all the
double entries, by the soft ?
73 de Steph, F5NZY

Steph Collas <f5nzy@...>
 

It is in my .ADI Logbook, but with <RST_SENT:3>599, but no <RST_RCVD:3>

The "blank" <RST_RCVD:3> appears in both previous qso and logbook

Yes the PC sees it as a diffrerent QSO, but I don't undersant why?

Except if, after synch with lotw, eqsl and clublog, I am in my QSO's Logbook
op with a diff QTR

73 de Stephane, F5NZY

-----Message d'origine-----
De : hamlogger@groups.io <hamlogger@groups.io> De la part de Tom Wylie
Envoyé : mercredi 11 septembre 2019 22:12
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

Its not in the log but the previous qso window??? The callsigns are
the same, but the QSO time is different, so maybe the PC sees it as a
different QSO????


Tom

On 11/09/2019 20:20, Steph Collas via Groups.Io wrote:
Hi all,



Since I sync my log with lotw, eqsl and clublog, I have double in my log.



I can delete them, one by one, but is it a possibility to delete all the
double entries, by the soft ?



73 de Steph, F5NZY




Bob
 

Steph, LoTW sync and eQSL sync does not write QSOs to the logbook . If it finds a QSO that is not in the logbook that ADIF record is put in the BAD.ADI files and a QSO is not added to your logbook. If you have duplicate QSOs in the logbook they come from somewhere else. What have you done? Please send me a small piece of your ADIF file that shows these duplicate QSOs.  There is no way in Logger32 to remove duplicate QSOs automatically (because there should be none :). SeventyThree(s).

On September 11, 2019 at 3:20 PM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Since I sync my log with lotw, eqsl and clublog, I have double in my log.

 

I can delete them, one by one, but is it a possibility to delete all the double entries, by the soft ?

 

73 de Steph, F5NZY


 


 

Steph Collas <f5nzy@...>
 

Bob,

 

The problem is certainly coming to the fact I several times import ADIF files.

 

73

 

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 12:59
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, LoTW sync and eQSL sync does not write QSOs to the logbook . If it finds a QSO that is not in the logbook that ADIF record is put in the BAD.ADI files and a QSO is not added to your logbook. If you have duplicate QSOs in the logbook they come from somewhere else. What have you done? Please send me a small piece of your ADIF file that shows these duplicate QSOs.  There is no way in Logger32 to remove duplicate QSOs automatically (because there should be none :). SeventyThree(s).

On September 11, 2019 at 3:20 PM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Since I sync my log with lotw, eqsl and clublog, I have double in my log.

 

I can delete them, one by one, but is it a possibility to delete all the double entries, by the soft ?

 

73 de Steph, F5NZY


 


 

Bob
 

Steph, Looking at the ADIF data you sent, looked at 'duplicate' QSOs like this:


Line 30139:
<BAND:3>80M
<CALL:5>G3NCN
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<FREQ:8>3.500000
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<QSL_RCVD:1>Y
<QSLRDATE:8>20141007
<QSO_DATE:8:D>20091209
<TIME_ON:6>173900
<RST_RCVD:3>599
<RST_SENT:3>599
<TIME_OFF:6>173900
<TX_PWR:3>100
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15066
<COUNTRY:7>England
<EOR>

Line 30141:
<BAND:3>80M
<CALL:5>G3NCN
<COMMENT:19>ts590, 100w, windom
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<APP_LOGGER32_QSL:1>Y
<QSL_SENT:1>Y
<QSO_DATE:8:D>20091209
<TIME_ON:6>174300
<QTH:5>Berks
<RST_SENT:3>599
<TEN_TEN:4>1996
<TIME_OFF:6>174300
<eQSL_QSL_SENT:1>Y
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15067
<COUNTRY:7>England
<EOR>


Two QSOs with G3NCN four minutes apart. You will notice that the two ADIF records are quite different ... One has a comment field describing the station, on has a QTH, one has a QSLRDATE, one has a TEN_TEN number, one has a FREQ, etc. Looks to me like you taken an LoTW or eQSL sync file and imported it to Logger32 ... So, one of the QSOs has data from your QSO with G3NCN, the other QSO has data from G3NCNs QSO with you.


Not Kosher, Halal, or Haram. SeventyThree(s).


On September 12, 2019 at 6:59 AM Bob <k4cy@...> wrote:

Steph, LoTW sync and eQSL sync does not write QSOs to the logbook . If it finds a QSO that is not in the logbook that ADIF record is put in the BAD.ADI files and a QSO is not added to your logbook. If you have duplicate QSOs in the logbook they come from somewhere else. What have you done? Please send me a small piece of your ADIF file that shows these duplicate QSOs.  There is no way in Logger32 to remove duplicate QSOs automatically (because there should be none :). SeventyThree(s).

On September 11, 2019 at 3:20 PM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Since I sync my log with lotw, eqsl and clublog, I have double in my log.

 

I can delete them, one by one, but is it a possibility to delete all the double entries, by the soft ?

 

73 de Steph, F5NZY


 


 


 


 

Steph Collas <f5nzy@...>
 

Hi Bob,

 

OK, but how I can solve it?

 

If I delete manually the entries, how could I sync my entries from eqsl or lotw?

 

Actually, what I do is:

 

  1. I download report from lotw, for exemple (lotwreport.adi)
  2. I syncrhronize lotw from an ADIF file.

 

Am I right?

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 13:35
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, Looking at the ADIF data you sent, looked at 'duplicate' QSOs like this:

 

Line 30139:
<BAND:3>80M
<CALL:5>G3NCN
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<FREQ:8>3.500000
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<QSL_RCVD:1>Y
<QSLRDATE:8>20141007
<QSO_DATE:8:D>20091209
<TIME_ON:6>173900
<RST_RCVD:3>599
<RST_SENT:3>599
<TIME_OFF:6>173900
<TX_PWR:3>100
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15066
<COUNTRY:7>England
<EOR>

Line 30141:
<BAND:3>80M
<CALL:5>G3NCN
<COMMENT:19>ts590, 100w, windom
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<APP_LOGGER32_QSL:1>Y
<QSL_SENT:1>Y
<QSO_DATE:8:D>20091209
<TIME_ON:6>174300
<QTH:5>Berks
<RST_SENT:3>599
<TEN_TEN:4>1996
<TIME_OFF:6>174300
<eQSL_QSL_SENT:1>Y
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15067
<COUNTRY:7>England
<EOR>

 

Two QSOs with G3NCN four minutes apart. You will notice that the two ADIF records are quite different ... One has a comment field describing the station, on has a QTH, one has a QSLRDATE, one has a TEN_TEN number, one has a FREQ, etc. Looks to me like you taken an LoTW or eQSL sync file and imported it to Logger32 ... So, one of the QSOs has data from your QSO with G3NCN, the other QSO has data from G3NCNs QSO with you.

 

Not Kosher, Halal, or Haram. SeventyThree(s).

 

On September 12, 2019 at 6:59 AM Bob <k4cy@...> wrote:

Steph, LoTW sync and eQSL sync does not write QSOs to the logbook . If it finds a QSO that is not in the logbook that ADIF record is put in the BAD.ADI files and a QSO is not added to your logbook. If you have duplicate QSOs in the logbook they come from somewhere else. What have you done? Please send me a small piece of your ADIF file that shows these duplicate QSOs.  There is no way in Logger32 to remove duplicate QSOs automatically (because there should be none :). SeventyThree(s).

On September 11, 2019 at 3:20 PM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Since I sync my log with lotw, eqsl and clublog, I have double in my log.

 

I can delete them, one by one, but is it a possibility to delete all the double entries, by the soft ?

 

73 de Steph, F5NZY


 


 


 


 

Bob
 

Steph, that is the correct way to synchronize with LoTW. I think that you have made a mistake once, and imported the file and not synchronized it. 73.

On September 12, 2019 at 8:14 AM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi Bob,

 

OK, but how I can solve it?

 

If I delete manually the entries, how could I sync my entries from eqsl or lotw?

 

Actually, what I do is:

 

  1. I download report from lotw, for exemple (lotwreport.adi)
  2. I syncrhronize lotw from an ADIF file.

 

Am I right?

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 13:35
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, Looking at the ADIF data you sent, looked at 'duplicate' QSOs like this:

 

Line 30139:
<BAND:3>80M
<CALL:5>G3NCN
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<FREQ:8>3.500000
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<QSL_RCVD:1>Y
<QSLRDATE:8>20141007
<QSO_DATE:8:D>20091209
<TIME_ON:6>173900
<RST_RCVD:3>599
<RST_SENT:3>599
<TIME_OFF:6>173900
<TX_PWR:3>100
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15066
<COUNTRY:7>England
<EOR>

Line 30141:
<BAND:3>80M
<CALL:5>G3NCN
<COMMENT:19>ts590, 100w, windom
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<APP_LOGGER32_QSL:1>Y
<QSL_SENT:1>Y
<QSO_DATE:8:D>20091209
<TIME_ON:6>174300
<QTH:5>Berks
<RST_SENT:3>599
<TEN_TEN:4>1996
<TIME_OFF:6>174300
<eQSL_QSL_SENT:1>Y
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15067
<COUNTRY:7>England
<EOR>

 

Two QSOs with G3NCN four minutes apart. You will notice that the two ADIF records are quite different ... One has a comment field describing the station, on has a QTH, one has a QSLRDATE, one has a TEN_TEN number, one has a FREQ, etc. Looks to me like you taken an LoTW or eQSL sync file and imported it to Logger32 ... So, one of the QSOs has data from your QSO with G3NCN, the other QSO has data from G3NCNs QSO with you.

 

Not Kosher, Halal, or Haram. SeventyThree(s).

 

On September 12, 2019 at 6:59 AM Bob <k4cy@...> wrote:

Steph, LoTW sync and eQSL sync does not write QSOs to the logbook . If it finds a QSO that is not in the logbook that ADIF record is put in the BAD.ADI files and a QSO is not added to your logbook. If you have duplicate QSOs in the logbook they come from somewhere else. What have you done? Please send me a small piece of your ADIF file that shows these duplicate QSOs.  There is no way in Logger32 to remove duplicate QSOs automatically (because there should be none :). SeventyThree(s).

On September 11, 2019 at 3:20 PM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Since I sync my log with lotw, eqsl and clublog, I have double in my log.

 

I can delete them, one by one, but is it a possibility to delete all the double entries, by the soft ?

 

73 de Steph, F5NZY


 


 


 


 

 



 


 

Steph Collas <f5nzy@...>
 

Hi Bob,

 

I understand.

 

I will remberber the lesson for the next time…

 

😊

 

Tks for your support, as usual…

 

Merci.

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 14:19
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, that is the correct way to synchronize with LoTW. I think that you have made a mistake once, and imported the file and not synchronized it. 73.

On September 12, 2019 at 8:14 AM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi Bob,

 

OK, but how I can solve it?

 

If I delete manually the entries, how could I sync my entries from eqsl or lotw?

 

Actually, what I do is:

 

  1. I download report from lotw, for exemple (lotwreport.adi)
  2. I syncrhronize lotw from an ADIF file.

 

Am I right?

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 13:35
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, Looking at the ADIF data you sent, looked at 'duplicate' QSOs like this:

 

Line 30139:
<BAND:3>80M
<CALL:5>G3NCN
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<FREQ:8>3.500000
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<QSL_RCVD:1>Y
<QSLRDATE:8>20141007
<QSO_DATE:8:D>20091209
<TIME_ON:6>173900
<RST_RCVD:3>599
<RST_SENT:3>599
<TIME_OFF:6>173900
<TX_PWR:3>100
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15066
<COUNTRY:7>England
<EOR>

Line 30141:
<BAND:3>80M
<CALL:5>G3NCN
<COMMENT:19>ts590, 100w, windom
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<APP_LOGGER32_QSL:1>Y
<QSL_SENT:1>Y
<QSO_DATE:8:D>20091209
<TIME_ON:6>174300
<QTH:5>Berks
<RST_SENT:3>599
<TEN_TEN:4>1996
<TIME_OFF:6>174300
<eQSL_QSL_SENT:1>Y
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15067
<COUNTRY:7>England
<EOR>

 

Two QSOs with G3NCN four minutes apart. You will notice that the two ADIF records are quite different ... One has a comment field describing the station, on has a QTH, one has a QSLRDATE, one has a TEN_TEN number, one has a FREQ, etc. Looks to me like you taken an LoTW or eQSL sync file and imported it to Logger32 ... So, one of the QSOs has data from your QSO with G3NCN, the other QSO has data from G3NCNs QSO with you.

 

Not Kosher, Halal, or Haram. SeventyThree(s).

 

On September 12, 2019 at 6:59 AM Bob <k4cy@...> wrote:

Steph, LoTW sync and eQSL sync does not write QSOs to the logbook . If it finds a QSO that is not in the logbook that ADIF record is put in the BAD.ADI files and a QSO is not added to your logbook. If you have duplicate QSOs in the logbook they come from somewhere else. What have you done? Please send me a small piece of your ADIF file that shows these duplicate QSOs.  There is no way in Logger32 to remove duplicate QSOs automatically (because there should be none :). SeventyThree(s).

On September 11, 2019 at 3:20 PM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Since I sync my log with lotw, eqsl and clublog, I have double in my log.

 

I can delete them, one by one, but is it a possibility to delete all the double entries, by the soft ?

 

73 de Steph, F5NZY


 


 


 


 

 

 


 


 

Steph Collas <f5nzy@...>
 

Hi all,

 

Never Say Die!

 

I found how to proceed to remove my double entries in my LogBook and to get back with a clean one.

 

I studied my .ADI file and noticed, that for the wrong entries, the field <RST_RCVD:3> was missing.

 

So, easy to solve it!

 

I use Cygwin, a Linux Emulator on Windows 10, (https://cygwin.com/).

 

The way to proceed is as follow:

 

  • Export your full LogBook in .ADI file
  • With Cygwin, type the commands: cat your_file.ADI | grep "<RST_RCVD:3>" >your_file-corrected.ADI
  • Create a new LogBook
  • Import your new LogBook-corrected.ADI file
  • I rebuilt the database

 

I lost more than 5,000 entries in my LogBook, but now, it is Clean!

 

😉

 

Hope it helps!

 

73 de Steph, F5NZY

 

PS: Of course, you can do the same thing with a text editor, like notepad, but I prefer Cygwin.

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Steph Collas via Groups.Io
Envoyé : jeudi 12 septembre 2019 14:54
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Hi Bob,

 

I understand.

 

I will remberber the lesson for the next time…

 

😊

 

Tks for your support, as usual…

 

Merci.

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 14:19
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, that is the correct way to synchronize with LoTW. I think that you have made a mistake once, and imported the file and not synchronized it. 73.

On September 12, 2019 at 8:14 AM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi Bob,

 

OK, but how I can solve it?

 

If I delete manually the entries, how could I sync my entries from eqsl or lotw?

 

Actually, what I do is:

 

  1. I download report from lotw, for exemple (lotwreport.adi)
  2. I syncrhronize lotw from an ADIF file.

 

Am I right?

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 13:35
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, Looking at the ADIF data you sent, looked at 'duplicate' QSOs like this:

 

Line 30139:
<BAND:3>80M
<CALL:5>G3NCN
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<FREQ:8>3.500000
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<QSL_RCVD:1>Y
<QSLRDATE:8>20141007
<QSO_DATE:8:D>20091209
<TIME_ON:6>173900
<RST_RCVD:3>599
<RST_SENT:3>599
<TIME_OFF:6>173900
<TX_PWR:3>100
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15066
<COUNTRY:7>England
<EOR>

Line 30141:
<BAND:3>80M
<CALL:5>G3NCN
<COMMENT:19>ts590, 100w, windom
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<APP_LOGGER32_QSL:1>Y
<QSL_SENT:1>Y
<QSO_DATE:8:D>20091209
<TIME_ON:6>174300
<QTH:5>Berks
<RST_SENT:3>599
<TEN_TEN:4>1996
<TIME_OFF:6>174300
<eQSL_QSL_SENT:1>Y
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15067
<COUNTRY:7>England
<EOR>

 

Two QSOs with G3NCN four minutes apart. You will notice that the two ADIF records are quite different ... One has a comment field describing the station, on has a QTH, one has a QSLRDATE, one has a TEN_TEN number, one has a FREQ, etc. Looks to me like you taken an LoTW or eQSL sync file and imported it to Logger32 ... So, one of the QSOs has data from your QSO with G3NCN, the other QSO has data from G3NCNs QSO with you.

 

Not Kosher, Halal, or Haram. SeventyThree(s).

 

On September 12, 2019 at 6:59 AM Bob <k4cy@...> wrote:

Steph, LoTW sync and eQSL sync does not write QSOs to the logbook . If it finds a QSO that is not in the logbook that ADIF record is put in the BAD.ADI files and a QSO is not added to your logbook. If you have duplicate QSOs in the logbook they come from somewhere else. What have you done? Please send me a small piece of your ADIF file that shows these duplicate QSOs.  There is no way in Logger32 to remove duplicate QSOs automatically (because there should be none :). SeventyThree(s).

On September 11, 2019 at 3:20 PM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Since I sync my log with lotw, eqsl and clublog, I have double in my log.

 

I can delete them, one by one, but is it a possibility to delete all the double entries, by the soft ?

 

73 de Steph, F5NZY


 


 


 


 

 

 


 


 

Bob
 

Steph, are you sure? Look in your logbook and see what is in the RST_RCVD field. SeventyThree(s).

On October 9, 2019 at 8:48 AM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Never Say Die!

 

I found how to proceed to remove my double entries in my LogBook and to get back with a clean one.

 

I studied my .ADI file and noticed, that for the wrong entries, the field <RST_RCVD:3> was missing.

 

So, easy to solve it!

 

I use Cygwin, a Linux Emulator on Windows 10, (https://cygwin.com/).

 

The way to proceed is as follow:

 

  • Export your full LogBook in .ADI file
  • With Cygwin, type the commands: cat your_file.ADI | grep "<RST_RCVD:3>" >your_file-corrected.ADI
  • Create a new LogBook
  • Import your new LogBook-corrected.ADI file
  • I rebuilt the database

 

I lost more than 5,000 entries in my LogBook, but now, it is Clean!

 

😉

 

Hope it helps!

 

73 de Steph, F5NZY

 

PS: Of course, you can do the same thing with a text editor, like notepad, but I prefer Cygwin.

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Steph Collas via Groups.Io
Envoyé : jeudi 12 septembre 2019 14:54
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Hi Bob,

 

I understand.

 

I will remberber the lesson for the next time…

 

😊

 

Tks for your support, as usual…

 

Merci.

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 14:19
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, that is the correct way to synchronize with LoTW. I think that you have made a mistake once, and imported the file and not synchronized it. 73.

On September 12, 2019 at 8:14 AM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi Bob,

 

OK, but how I can solve it?

 

If I delete manually the entries, how could I sync my entries from eqsl or lotw?

 

Actually, what I do is:

 

  1. I download report from lotw, for exemple (lotwreport.adi)
  2. I syncrhronize lotw from an ADIF file.

 

Am I right?

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 13:35
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, Looking at the ADIF data you sent, looked at 'duplicate' QSOs like this:

 

Line 30139:
<BAND:3>80M
<CALL:5>G3NCN
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<FREQ:8>3.500000
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<QSL_RCVD:1>Y
<QSLRDATE:8>20141007
<QSO_DATE:8:D>20091209
<TIME_ON:6>173900
<RST_RCVD:3>599
<RST_SENT:3>599
<TIME_OFF:6>173900
<TX_PWR:3>100
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15066
<COUNTRY:7>England
<EOR>

Line 30141:
<BAND:3>80M
<CALL:5>G3NCN
<COMMENT:19>ts590, 100w, windom
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<APP_LOGGER32_QSL:1>Y
<QSL_SENT:1>Y
<QSO_DATE:8:D>20091209
<TIME_ON:6>174300
<QTH:5>Berks
<RST_SENT:3>599
<TEN_TEN:4>1996
<TIME_OFF:6>174300
<eQSL_QSL_SENT:1>Y
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15067
<COUNTRY:7>England
<EOR>

 

Two QSOs with G3NCN four minutes apart. You will notice that the two ADIF records are quite different ... One has a comment field describing the station, on has a QTH, one has a QSLRDATE, one has a TEN_TEN number, one has a FREQ, etc. Looks to me like you taken an LoTW or eQSL sync file and imported it to Logger32 ... So, one of the QSOs has data from your QSO with G3NCN, the other QSO has data from G3NCNs QSO with you.

 

Not Kosher, Halal, or Haram. SeventyThree(s).

 

On September 12, 2019 at 6:59 AM Bob <k4cy@...> wrote:

Steph, LoTW sync and eQSL sync does not write QSOs to the logbook . If it finds a QSO that is not in the logbook that ADIF record is put in the BAD.ADI files and a QSO is not added to your logbook. If you have duplicate QSOs in the logbook they come from somewhere else. What have you done? Please send me a small piece of your ADIF file that shows these duplicate QSOs.  There is no way in Logger32 to remove duplicate QSOs automatically (because there should be none :). SeventyThree(s).

On September 11, 2019 at 3:20 PM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Since I sync my log with lotw, eqsl and clublog, I have double in my log.

 

I can delete them, one by one, but is it a possibility to delete all the double entries, by the soft ?

 

73 de Steph, F5NZY


 


 


 


 

 

 


 


 

 



 


 

Steph Collas <f5nzy@...>
 

Bob,

 

It Is corresponding to the received RST.

 

When I had double entries in my logbook, the value was empty.

 

Since the description of what I did, have no more such double entries.

 

It is not correct?

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : mercredi 9 octobre 2019 17:16
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, are you sure? Look in your logbook and see what is in the RST_RCVD field. SeventyThree(s).

On October 9, 2019 at 8:48 AM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Never Say Die!

 

I found how to proceed to remove my double entries in my LogBook and to get back with a clean one.

 

I studied my .ADI file and noticed, that for the wrong entries, the field <RST_RCVD:3> was missing.

 

So, easy to solve it!

 

I use Cygwin, a Linux Emulator on Windows 10, (https://cygwin.com/).

 

The way to proceed is as follow:

 

  • Export your full LogBook in .ADI file
  • With Cygwin, type the commands: cat your_file.ADI | grep "<RST_RCVD:3>" >your_file-corrected.ADI
  • Create a new LogBook
  • Import your new LogBook-corrected.ADI file
  • I rebuilt the database

 

I lost more than 5,000 entries in my LogBook, but now, it is Clean!

 

😉

 

Hope it helps!

 

73 de Steph, F5NZY

 

PS: Of course, you can do the same thing with a text editor, like notepad, but I prefer Cygwin.

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Steph Collas via Groups.Io
Envoyé : jeudi 12 septembre 2019 14:54
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Hi Bob,

 

I understand.

 

I will remberber the lesson for the next time…

 

😊

 

Tks for your support, as usual…

 

Merci.

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 14:19
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, that is the correct way to synchronize with LoTW. I think that you have made a mistake once, and imported the file and not synchronized it. 73.

On September 12, 2019 at 8:14 AM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi Bob,

 

OK, but how I can solve it?

 

If I delete manually the entries, how could I sync my entries from eqsl or lotw?

 

Actually, what I do is:

 

  1. I download report from lotw, for exemple (lotwreport.adi)
  2. I syncrhronize lotw from an ADIF file.

 

Am I right?

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 13:35
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, Looking at the ADIF data you sent, looked at 'duplicate' QSOs like this:

 

Line 30139:
<BAND:3>80M
<CALL:5>G3NCN
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<FREQ:8>3.500000
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<QSL_RCVD:1>Y
<QSLRDATE:8>20141007
<QSO_DATE:8:D>20091209
<TIME_ON:6>173900
<RST_RCVD:3>599
<RST_SENT:3>599
<TIME_OFF:6>173900
<TX_PWR:3>100
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15066
<COUNTRY:7>England
<EOR>

Line 30141:
<BAND:3>80M
<CALL:5>G3NCN
<COMMENT:19>ts590, 100w, windom
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<APP_LOGGER32_QSL:1>Y
<QSL_SENT:1>Y
<QSO_DATE:8:D>20091209
<TIME_ON:6>174300
<QTH:5>Berks
<RST_SENT:3>599
<TEN_TEN:4>1996
<TIME_OFF:6>174300
<eQSL_QSL_SENT:1>Y
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15067
<COUNTRY:7>England
<EOR>

 

Two QSOs with G3NCN four minutes apart. You will notice that the two ADIF records are quite different ... One has a comment field describing the station, on has a QTH, one has a QSLRDATE, one has a TEN_TEN number, one has a FREQ, etc. Looks to me like you taken an LoTW or eQSL sync file and imported it to Logger32 ... So, one of the QSOs has data from your QSO with G3NCN, the other QSO has data from G3NCNs QSO with you.

 

Not Kosher, Halal, or Haram. SeventyThree(s).

 

On September 12, 2019 at 6:59 AM Bob <k4cy@...> wrote:

Steph, LoTW sync and eQSL sync does not write QSOs to the logbook . If it finds a QSO that is not in the logbook that ADIF record is put in the BAD.ADI files and a QSO is not added to your logbook. If you have duplicate QSOs in the logbook they come from somewhere else. What have you done? Please send me a small piece of your ADIF file that shows these duplicate QSOs.  There is no way in Logger32 to remove duplicate QSOs automatically (because there should be none :). SeventyThree(s).

On September 11, 2019 at 3:20 PM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Since I sync my log with lotw, eqsl and clublog, I have double in my log.

 

I can delete them, one by one, but is it a possibility to delete all the double entries, by the soft ?

 

73 de Steph, F5NZY


 


 


 


 

 

 


 


 

 

 


 


 

Bob
 

If you add <RST_RCVD:3> to the QSO record, the RST_RCVD will be the next three characters after <RST_RCVD:3> For example, it the QSO record is <RST_RCVD:3> CALL:5>F5NZY .... then RCD_RCVD is read as " CA". SeventyThree(s).

On October 9, 2019 at 12:41 PM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Bob,

 

It Is corresponding to the received RST.

 

When I had double entries in my logbook, the value was empty.

 

Since the description of what I did, have no more such double entries.

 

It is not correct?

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : mercredi 9 octobre 2019 17:16
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, are you sure? Look in your logbook and see what is in the RST_RCVD field. SeventyThree(s).

On October 9, 2019 at 8:48 AM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Never Say Die!

 

I found how to proceed to remove my double entries in my LogBook and to get back with a clean one.

 

I studied my .ADI file and noticed, that for the wrong entries, the field <RST_RCVD:3> was missing.

 

So, easy to solve it!

 

I use Cygwin, a Linux Emulator on Windows 10, (https://cygwin.com/).

 

The way to proceed is as follow:

 

  • Export your full LogBook in .ADI file
  • With Cygwin, type the commands: cat your_file.ADI | grep "<RST_RCVD:3>" >your_file-corrected.ADI
  • Create a new LogBook
  • Import your new LogBook-corrected.ADI file
  • I rebuilt the database

 

I lost more than 5,000 entries in my LogBook, but now, it is Clean!

 

😉

 

Hope it helps!

 

73 de Steph, F5NZY

 

PS: Of course, you can do the same thing with a text editor, like notepad, but I prefer Cygwin.

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Steph Collas via Groups.Io
Envoyé : jeudi 12 septembre 2019 14:54
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Hi Bob,

 

I understand.

 

I will remberber the lesson for the next time…

 

😊

 

Tks for your support, as usual…

 

Merci.

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 14:19
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, that is the correct way to synchronize with LoTW. I think that you have made a mistake once, and imported the file and not synchronized it. 73.

On September 12, 2019 at 8:14 AM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi Bob,

 

OK, but how I can solve it?

 

If I delete manually the entries, how could I sync my entries from eqsl or lotw?

 

Actually, what I do is:

 

  1. I download report from lotw, for exemple (lotwreport.adi)
  2. I syncrhronize lotw from an ADIF file.

 

Am I right?

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 13:35
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, Looking at the ADIF data you sent, looked at 'duplicate' QSOs like this:

 

Line 30139:
<BAND:3>80M
<CALL:5>G3NCN
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<FREQ:8>3.500000
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<QSL_RCVD:1>Y
<QSLRDATE:8>20141007
<QSO_DATE:8:D>20091209
<TIME_ON:6>173900
<RST_RCVD:3>599
<RST_SENT:3>599
<TIME_OFF:6>173900
<TX_PWR:3>100
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15066
<COUNTRY:7>England
<EOR>

Line 30141:
<BAND:3>80M
<CALL:5>G3NCN
<COMMENT:19>ts590, 100w, windom
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<APP_LOGGER32_QSL:1>Y
<QSL_SENT:1>Y
<QSO_DATE:8:D>20091209
<TIME_ON:6>174300
<QTH:5>Berks
<RST_SENT:3>599
<TEN_TEN:4>1996
<TIME_OFF:6>174300
<eQSL_QSL_SENT:1>Y
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15067
<COUNTRY:7>England
<EOR>

 

Two QSOs with G3NCN four minutes apart. You will notice that the two ADIF records are quite different ... One has a comment field describing the station, on has a QTH, one has a QSLRDATE, one has a TEN_TEN number, one has a FREQ, etc. Looks to me like you taken an LoTW or eQSL sync file and imported it to Logger32 ... So, one of the QSOs has data from your QSO with G3NCN, the other QSO has data from G3NCNs QSO with you.

 

Not Kosher, Halal, or Haram. SeventyThree(s).

 

On September 12, 2019 at 6:59 AM Bob <k4cy@...> wrote:

Steph, LoTW sync and eQSL sync does not write QSOs to the logbook . If it finds a QSO that is not in the logbook that ADIF record is put in the BAD.ADI files and a QSO is not added to your logbook. If you have duplicate QSOs in the logbook they come from somewhere else. What have you done? Please send me a small piece of your ADIF file that shows these duplicate QSOs.  There is no way in Logger32 to remove duplicate QSOs automatically (because there should be none :). SeventyThree(s).

On September 11, 2019 at 3:20 PM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Since I sync my log with lotw, eqsl and clublog, I have double in my log.

 

I can delete them, one by one, but is it a possibility to delete all the double entries, by the soft ?

 

73 de Steph, F5NZY


 


 


 


 

 

 


 


 

 

 


 


 

 



 


 

Steph Collas <f5nzy@...>
 

Hi Bob,

 

I can not contradict you, technically, but I am pragmatic and what I have described, in my case at least works perfectly.

 

The double entries have been deleted (+5000 entries).

 

But mebbe there is a confusion…

 

In my .ADI file, some fields <RST_RCVD:3>, was missing.

 

The “empty” fields was in the Previous Logbook page.

 

When I GREP only the <RST_RCVD:3> from my “original” Logbook.ADI file, then exported into a Logbook-corrected.ADI, then created a new Logbook, then import the Logbook-corrected.ADI file, the double entries in the Previous.

 

I don’t know if I am clear?

 

73 de Steph, F5NZY

 

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : mercredi 9 octobre 2019 18:50
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

If you add <RST_RCVD:3> to the QSO record, the RST_RCVD will be the next three characters after <RST_RCVD:3> For example, it the QSO record is <RST_RCVD:3> CALL:5>F5NZY .... then RCD_RCVD is read as " CA". SeventyThree(s).

On October 9, 2019 at 12:41 PM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Bob,

 

It Is corresponding to the received RST.

 

When I had double entries in my logbook, the value was empty.

 

Since the description of what I did, have no more such double entries.

 

It is not correct?

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : mercredi 9 octobre 2019 17:16
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, are you sure? Look in your logbook and see what is in the RST_RCVD field. SeventyThree(s).

On October 9, 2019 at 8:48 AM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Never Say Die!

 

I found how to proceed to remove my double entries in my LogBook and to get back with a clean one.

 

I studied my .ADI file and noticed, that for the wrong entries, the field <RST_RCVD:3> was missing.

 

So, easy to solve it!

 

I use Cygwin, a Linux Emulator on Windows 10, (https://cygwin.com/).

 

The way to proceed is as follow:

 

  • Export your full LogBook in .ADI file
  • With Cygwin, type the commands: cat your_file.ADI | grep "<RST_RCVD:3>" >your_file-corrected.ADI
  • Create a new LogBook
  • Import your new LogBook-corrected.ADI file
  • I rebuilt the database

 

I lost more than 5,000 entries in my LogBook, but now, it is Clean!

 

😉

 

Hope it helps!

 

73 de Steph, F5NZY

 

PS: Of course, you can do the same thing with a text editor, like notepad, but I prefer Cygwin.

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Steph Collas via Groups.Io
Envoyé : jeudi 12 septembre 2019 14:54
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Hi Bob,

 

I understand.

 

I will remberber the lesson for the next time…

 

😊

 

Tks for your support, as usual…

 

Merci.

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 14:19
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, that is the correct way to synchronize with LoTW. I think that you have made a mistake once, and imported the file and not synchronized it. 73.

On September 12, 2019 at 8:14 AM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi Bob,

 

OK, but how I can solve it?

 

If I delete manually the entries, how could I sync my entries from eqsl or lotw?

 

Actually, what I do is:

 

  1. I download report from lotw, for exemple (lotwreport.adi)
  2. I syncrhronize lotw from an ADIF file.

 

Am I right?

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 13:35
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, Looking at the ADIF data you sent, looked at 'duplicate' QSOs like this:

 

Line 30139:
<BAND:3>80M
<CALL:5>G3NCN
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<FREQ:8>3.500000
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<QSL_RCVD:1>Y
<QSLRDATE:8>20141007
<QSO_DATE:8:D>20091209
<TIME_ON:6>173900
<RST_RCVD:3>599
<RST_SENT:3>599
<TIME_OFF:6>173900
<TX_PWR:3>100
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15066
<COUNTRY:7>England
<EOR>

Line 30141:
<BAND:3>80M
<CALL:5>G3NCN
<COMMENT:19>ts590, 100w, windom
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<APP_LOGGER32_QSL:1>Y
<QSL_SENT:1>Y
<QSO_DATE:8:D>20091209
<TIME_ON:6>174300
<QTH:5>Berks
<RST_SENT:3>599
<TEN_TEN:4>1996
<TIME_OFF:6>174300
<eQSL_QSL_SENT:1>Y
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15067
<COUNTRY:7>England
<EOR>

 

Two QSOs with G3NCN four minutes apart. You will notice that the two ADIF records are quite different ... One has a comment field describing the station, on has a QTH, one has a QSLRDATE, one has a TEN_TEN number, one has a FREQ, etc. Looks to me like you taken an LoTW or eQSL sync file and imported it to Logger32 ... So, one of the QSOs has data from your QSO with G3NCN, the other QSO has data from G3NCNs QSO with you.

 

Not Kosher, Halal, or Haram. SeventyThree(s).

 

On September 12, 2019 at 6:59 AM Bob <k4cy@...> wrote:

Steph, LoTW sync and eQSL sync does not write QSOs to the logbook . If it finds a QSO that is not in the logbook that ADIF record is put in the BAD.ADI files and a QSO is not added to your logbook. If you have duplicate QSOs in the logbook they come from somewhere else. What have you done? Please send me a small piece of your ADIF file that shows these duplicate QSOs.  There is no way in Logger32 to remove duplicate QSOs automatically (because there should be none :). SeventyThree(s).

On September 11, 2019 at 3:20 PM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Since I sync my log with lotw, eqsl and clublog, I have double in my log.

 

I can delete them, one by one, but is it a possibility to delete all the double entries, by the soft ?

 

73 de Steph, F5NZY


 


 


 


 

 

 


 


 

 

 


 


 

 

 


 


 

Paul Evans W4/VP9KF
 

You are correct. I don't think Bob knows about *NIX command line commands.......................

Bob
 

Steph, if it works, enjoy. SeventyThree(s).

On October 9, 2019 at 3:02 PM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi Bob,

 

I can not contradict you, technically, but I am pragmatic and what I have described, in my case at least works perfectly.

 

The double entries have been deleted (+5000 entries).

 

But mebbe there is a confusion…

 

In my .ADI file, some fields <RST_RCVD:3>, was missing.

 

The “empty” fields was in the Previous Logbook page.

 

When I GREP only the <RST_RCVD:3> from my “original” Logbook.ADI file, then exported into a Logbook-corrected.ADI, then created a new Logbook, then import the Logbook-corrected.ADI file, the double entries in the Previous.

 

I don’t know if I am clear?

 

73 de Steph, F5NZY

 

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : mercredi 9 octobre 2019 18:50
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

If you add <RST_RCVD:3> to the QSO record, the RST_RCVD will be the next three characters after <RST_RCVD:3> For example, it the QSO record is <RST_RCVD:3> CALL:5>F5NZY .... then RCD_RCVD is read as " CA". SeventyThree(s).

On October 9, 2019 at 12:41 PM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Bob,

 

It Is corresponding to the received RST.

 

When I had double entries in my logbook, the value was empty.

 

Since the description of what I did, have no more such double entries.

 

It is not correct?

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : mercredi 9 octobre 2019 17:16
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, are you sure? Look in your logbook and see what is in the RST_RCVD field. SeventyThree(s).

On October 9, 2019 at 8:48 AM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Never Say Die!

 

I found how to proceed to remove my double entries in my LogBook and to get back with a clean one.

 

I studied my .ADI file and noticed, that for the wrong entries, the field <RST_RCVD:3> was missing.

 

So, easy to solve it!

 

I use Cygwin, a Linux Emulator on Windows 10, (https://cygwin.com/).

 

The way to proceed is as follow:

 

  • Export your full LogBook in .ADI file
  • With Cygwin, type the commands: cat your_file.ADI | grep "<RST_RCVD:3>" >your_file-corrected.ADI
  • Create a new LogBook
  • Import your new LogBook-corrected.ADI file
  • I rebuilt the database

 

I lost more than 5,000 entries in my LogBook, but now, it is Clean!

 

😉

 

Hope it helps!

 

73 de Steph, F5NZY

 

PS: Of course, you can do the same thing with a text editor, like notepad, but I prefer Cygwin.

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Steph Collas via Groups.Io
Envoyé : jeudi 12 septembre 2019 14:54
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Hi Bob,

 

I understand.

 

I will remberber the lesson for the next time…

 

😊

 

Tks for your support, as usual…

 

Merci.

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 14:19
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, that is the correct way to synchronize with LoTW. I think that you have made a mistake once, and imported the file and not synchronized it. 73.

On September 12, 2019 at 8:14 AM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi Bob,

 

OK, but how I can solve it?

 

If I delete manually the entries, how could I sync my entries from eqsl or lotw?

 

Actually, what I do is:

 

  1. I download report from lotw, for exemple (lotwreport.adi)
  2. I syncrhronize lotw from an ADIF file.

 

Am I right?

 

73

 

De : hamlogger@groups.io <hamlogger@groups.io> De la part de Bob
Envoyé : jeudi 12 septembre 2019 13:35
À : hamlogger@groups.io
Objet : Re: [hamlogger] Double in the log...

 

Steph, Looking at the ADIF data you sent, looked at 'duplicate' QSOs like this:

 

Line 30139:
<BAND:3>80M
<CALL:5>G3NCN
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<FREQ:8>3.500000
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<QSL_RCVD:1>Y
<QSLRDATE:8>20141007
<QSO_DATE:8:D>20091209
<TIME_ON:6>173900
<RST_RCVD:3>599
<RST_SENT:3>599
<TIME_OFF:6>173900
<TX_PWR:3>100
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15066
<COUNTRY:7>England
<EOR>

Line 30141:
<BAND:3>80M
<CALL:5>G3NCN
<COMMENT:19>ts590, 100w, windom
<CONT:2>EU
<CQZ:2>14
<DXCC:3>223
<GRIDSQUARE:6>IO91ok
<ITUZ:2>27
<MODE:2>CW
<NAME:4>John
<OPERATOR:5>F5NZY
<PFX:2>G3
<APP_LOGGER32_QSL:1>Y
<QSL_SENT:1>Y
<QSO_DATE:8:D>20091209
<TIME_ON:6>174300
<QTH:5>Berks
<RST_SENT:3>599
<TEN_TEN:4>1996
<TIME_OFF:6>174300
<eQSL_QSL_SENT:1>Y
<eQSL_QSL_RCVD:1>Y
<LOTW_QSL_SENT:1>Y
<LOTW_QSL_RCVD:1>Y
<APP_LOGGER32_QSO_NUMBER:5>15067
<COUNTRY:7>England
<EOR>

 

Two QSOs with G3NCN four minutes apart. You will notice that the two ADIF records are quite different ... One has a comment field describing the station, on has a QTH, one has a QSLRDATE, one has a TEN_TEN number, one has a FREQ, etc. Looks to me like you taken an LoTW or eQSL sync file and imported it to Logger32 ... So, one of the QSOs has data from your QSO with G3NCN, the other QSO has data from G3NCNs QSO with you.

 

Not Kosher, Halal, or Haram. SeventyThree(s).

 

On September 12, 2019 at 6:59 AM Bob <k4cy@...> wrote:

Steph, LoTW sync and eQSL sync does not write QSOs to the logbook . If it finds a QSO that is not in the logbook that ADIF record is put in the BAD.ADI files and a QSO is not added to your logbook. If you have duplicate QSOs in the logbook they come from somewhere else. What have you done? Please send me a small piece of your ADIF file that shows these duplicate QSOs.  There is no way in Logger32 to remove duplicate QSOs automatically (because there should be none :). SeventyThree(s).

On September 11, 2019 at 3:20 PM "Steph Collas via Groups.Io" <f5nzy@...> wrote:

Hi all,

 

Since I sync my log with lotw, eqsl and clublog, I have double in my log.

 

I can delete them, one by one, but is it a possibility to delete all the double entries, by the soft ?

 

73 de Steph, F5NZY