开云体育

This ia s C program to query sBITX log db and export selected data in an ADIF format file for use in another logger, upload to LOTW, etc. This should be easier to incorporate in an sBITX release and doesn't have the size limits the Python program had.
Run this from a terminal and it will prompt the user for start and end QSO IDs to process. Exports are written to the file export.adi and echoed to the screen.

Get it here:

See the readme file for more details.
I labeled this as a prerelease. Let me know how it works for you.

--

73

??? Bob? KD8CGH

Added start and end node numbers to export file name. Also stopped echoing file writes to terminal.
--
73
??? Bob? KD8CGH

Lately, I have tested several LOG programs and I have an interesting observation regarding time recording.
In the attached images, you can see that LotW uses 6 characters, while eQSL uses 4 characters and the log2adi converter uses 5 characters to record the time.
LotW gives a status report, no version number.
eQSL adif v3.1.0 and log2adi adif v3.1.4.
LotW adi has a different structure, but Adif Master handles it well.
Does this matter? Could this cause confusion?
I'm just curious about other people's opinions.
--
Gyula HA3HZ

Gyula
? Thanks for the feedback.
? I didn't see the same result from Log2adi if I just look at the export file. Turns out I had the ADIF field length wrong.The sBITX times all end in "00". I added the "00" because, although it is optional in the standard, ARRL LOTW examples included it.
For the 1.2 release I just dropped the "00".
--
73
??? Bob? KD8CGH

Bob -

Thanks for the C program to export the logbook.? I d/l from github today, compiled the program without errors or warning, and then ran against my V3 logbook.? It exported 18 records.

Next I uploaded to QRZ logbook on the web.? Only 12 of the records were accepted.

I noticed on the QRZ logbook screen, none of the 12 accepted records contained a timestamp.

How can I proceed to further understand and correct this issue???

Thanks

Further investigation reveals what I think is the issue.? From my export file I show 2 entries.
Each entry appears to define the data as 1 element too small.? Freq as 4, it is 5 counting the decimal? Time is 6.

The QSO frequency in the QRZ logbook is shown as 7.070 rather than 7.074
The QSO time appears to be ignored on upload and is shown as 0000

Unfortunately (and foolishly) I cleaned up the QRZ logbook without getting a screen shot.

<FREQ:4>7.074
<TIME_ON:5>194900

73

Roy,
don't upload it to qrz.com, but to LotW with tqsl, then import it from LotW on qrz.com. It works fine for me.
--
Gyula HA3HZ

Did you use the latest release

or the pre-release?
--
73
??? Bob? KD8CGH

Geez
DOH

OK, stupid guy got the 6 month old version.

Thanks for setting me straight.

73

On Sat, Dec 23, 2023 at 05:08 PM, HA3HZ wrote:

don't upload it to qrz.com, but to LotW with tqsl, then import it from LotW on qrz.com. It works fine for me.

I tried this exact approach, and found that LotW only stores certain fields and drops others.??
In my case after a lot of debugging I determined it was dropping the signal strength report.
I liked having this info so I could see how strong/weak some of the FT8 signals I worked were.

?says:

?Logbook of The World does not store the entire contact record that you (or we on your behalf) send them.

It then goes on to list the fields it keeps.

So, you can use that approach but you better check to make sure it is not dropping fields you care about.

Note also that page gives??as a reference on the ADIF standard, hopefully it can help resolve any issues.

I hope this info is helpful.
?
--
Regards,
Dave, N1AI

Because of the 7" screen, I searched for and tested several LOG programs.
The one I am currently using was created by its creator at the beginning of 2005 mainly for cw and ssb modes.
Currently, at my request, the author has made it possible for RSTs and RSTr cell.
Since I use it, I discovered a few things that need to be modified.
Unfortunately, the author is busy with his work and finds it difficult to devote free time to this.

I recommended uploading LotW first, because it works correctly for me and the frequency is visible.
When I use this external LOG program and upload it to LotW, the frequency is not visible due to the lack of FREQ storage. There is only BAND recording.
When I uploaded the same adif file directly to the qrz, there was freq and there were places where it was not. Why, I don't know.
Therefore, I deleted the incomplete data uploaded to qrz and another time I loaded data converted from sbitx.db with log1adi (v1.2) into LotW,
then after importing LotW from qrz.com all data was displayed correctly. That's why I suggested the above.

I hope I was able to describe it clearly.
--
Gyula HA3HZ

rdg
? Sorry about the confusion.
Gyula
? I’m not a QRZ log user so I couldn’t test that.?

? Are you saying that a log db converted to adif format by V1.2 won’t load properly into QRZ?
??
--
73
??? Bob? KD8CGH

Thanks
--
73
??? Bob? KD8CGH

I tried to run this today, but I'm running into a problem. (I'm not super familiar with git, so I'm guessing I've messed something up).? First I ran this to get the file:

sudo wget

Then following the readme:
gcc -Wall -o "log2adi" "log2adi.c" -lsqlite3

And I get this error (just the first line or so):
log2adi.c:1:1: error: expected identifier or '(' before '{' token? {"payload":{"allShortcutsEnabled":false,"fileTree":{"":{"items":[{"name":"LICENSE","path":"LICENSE","contentType":"file"},{"name":"README.md","path":"README.md","contentType":"file"},{"name":"log2adi.c","path

What am I doing wrong?

Thanks for the help!

Hi jefe_de_stado,
I will answer your question.
When I installed it, I created a folder called RPi /Home/pi/log2adi. I copied the github content here:
log2adi.c, LICENSE and README files.
Entering here, I completed the translation with the compiler after calling the terminal.
After that, it can be used with the ./log2adi command.
Note that linux and its peers like to use the terminal to start operations.
--
Gyula HA3HZ

Hi Bob,
I will answer your question. Yes, I am using v1.2 and the uploading problem was not caused by an error in the program.
Because I started using an external LOG program that was made about 15 years ago for cw and ssb modes.
It is capable of multiple actions, I tried this with the LotW upload.
That's when I realized that there is no FREQ input and recording (there is BAND input and recording),
which is why the data column missing from the uploaded adif file is not visible at qrz.com either.
I used the qrz.com log by calling it from LotW.
After noticing this, I tried to fix the missing data by uploading it again.
Where the log content is visible, it is fine.

I think I have managed to convey the essence.
--
Gyula HA3HZ

On Sun, Dec 24, 2023 at 10:41 PM, <jefe_de_estado@...> wrote:

What am I doing wrong?

I can't tell you why your way did not work, but I tried your 'wget' command and got the same bad result as you did.

As others are suggesting you can use the green "Code <>" button on his github page to download a zip file.

Or you can open a terminal window on the sbitx pi and use the following commands:

git clone
cd sBITX-log2adi
gcc -Wall -o "log2adi" "log2adi.c" -lsqlite3

which will build the log2adi program.
?
--
Regards,
Dave, N1AI