QSL Field Discrepancy After ADIF Import

3 posts / 0 new
Last post
w0zw
QSL Field Discrepancy After ADIF Import

<p>I am using CQRlog 2.5.2 (001) on a Linux Mint machine. I am testing importing ADIF files from my DXLab DXKeeper application. I am finding the DXCC CFM total presented on the CQRlog QSO List window is much lower in value than what I expected. I discovered that the QSL_R and QSL_S fields do not seem to be populating correctly.</p>
<p>&nbsp;</p>
<p>For example, here is one of the ADIF records I imported from DXKeeper:</p>
<p>&nbsp;</p>
<p>&lt;Band:3&gt;20M &lt;Call:5&gt;3B8CF &lt;APP_DXKEEPER_DXCCPREFIX:3&gt;3B8 &lt;DXCC:3&gt;165 &lt;Mode:2&gt;CW &lt;N</p>
<p>ame:5&gt;Jacky &lt;Operator:4&gt;W0ZW &lt;QSL_Rcvd:1&gt;V &lt;QSL_Sent:1&gt;Y &lt;QSO_DATE:8&gt;20030110 &lt;TIM</p>
<p>E_OFF:6&gt;034300 &lt;TIME_ON:6&gt;034300 &lt;QTH:16&gt;Mauritius Island &lt;RST_Rcvd:3&gt;559 &lt;TX_PWR:</p>
<p>5&gt;100.0 &lt;QSLRDATE:8&gt;20061210 &lt;CONT:2&gt;AF &lt;ITUZ:2&gt;53 &lt;CQZ:2&gt;39 &lt;IOTA:6&gt;AF-049 &lt;PFX:3</p>
<p>&gt;3B8 &lt;STATION_CALLSIGN:4&gt;W0ZW &lt;OWNER_CALLSIGN:4&gt;W0ZW &lt;APP_DXKeeper_SELECT:1&gt;N &lt;EQS</p>
<p>L_QSL_SENT:1&gt;R &lt;LOTW_QSL_SENT:1&gt;Y &lt;LOTW_QSL_RCVD:1&gt;R &lt;LOTW_QSLSDATE:8&gt;20181031 &lt;AP</p>
<p>P_DXKeeper_QSL_Rcvd_Save:1&gt;V &lt;APP_DXKeeper_QRZcom_LogID:2&gt;-1 &lt;APP_DXKeeper_DXCCCre</p>
<p>ditNumber:11&gt;1099587372C &lt;CREDIT_GRANTED:41&gt;DXCC:CARD, DXCC_BAND:CARD, DXCC_MODE:C</p>
<p>ARD &lt;APP_DXKEEPER_MY_QTHID:12&gt;San Patricio &lt;EOR&gt;</p>
<p>Notice the CREDIT_GRANTED field indicates I have DXCC, Band and Mode credit for this QSO by having submitted a card. However the CQRlog qsl_r field is blank. I expected it to show "V". In addition, the qsl_s field indicates "B". I expected it to show "Y". Can you explain this behavior please? Am I using the import feature correctly? How can I obtain more correct DXCC CFM totals? I would very much like to replace DXKeeper with CQRlog. Thanks.</p>
<p>Wayne, W0ZW</p>

w0zw
QSL Field Discrepancy After ADIF Import

Upon further research, it appears that when I replace the "V" with "Y" in the qsl_r field of the ADIF file and import that file into a new CQRlog database the DXCC CFM total appears to now be correct. So my ADIF file V 3.0.9 should not use the "V" and instead let the CREDIT_GRANTED field provide the confirmation information.

Now a new issue with my ADIF import: Why does the qsl_s field default to "B"? Can this behavior be changed to "D" and if so how?

Thanks so much.

Wayne, W0ZW

oh1kh
QSL Field Discrepancy After ADIF Import

Hi Wayne!

Cqrlog (any version) does not have full ADIF support.
"CREDIT" is one of non supported tags. Supporting all tags, of all versions of ADIF, with follow up to their changes is an endless job.

Usually problems arise when ADIF file from another program than Cqrlog is imported to Cqrlog. There are lots of tags not having corresponding database columns and that leads to need of conversions for import and export that adds the workload of handling all ADIF properly.

More trouble for import is caused by other programs that put UTF8 type characters in ADIF tags (that should contain only 7bit ASCII). One routine more to check this kind of trouble.

I do not remember (so long time) what kind of adif routines there are in 2.5.2. I have done lot of work with those since 2.5.2 and those changes appear in CqrlogAlpha (a Cqrlog clone) but even there the CREDIT is not supported.
Checking https://adif.org while writing this I noticed that they have again made a new version release 3.1.5. I hope it does not have any major changed that that should be counted on.

Linux has many powerful command console tools for text files. (awk, sed, tr, iconv etc...) For example "sed" is one that can easily change tag names or values in whole adif file before using the file for import to Cqrlog.
With them you can do all needed changes before import.

--
Saku
OH1KH