Skip to content

LoTW Import & Export Documentation

Peter Goodhall edited this page Nov 9, 2021 · 10 revisions

Cloudlog allows full interaction with the ARRL Logbook of the World system, both for uploading and downloading of QSOs, this is accessed via Admin -> LoTW via the main menu and you will see something similar to the screenshot below.

Lotw Main Screen

If you haven't uploaded any certificates you will get a notification to upload once this is done you will get a table with some basic fields

  • Callsign
  • DXCC
  • Date Created (Date the certificate was created)
  • Date Expires (Date your certificate expires)
  • Status - This has multiple items, from badges to tell you that the cert is valid to when an upload happened, this is likely to be expanded over time.

Downloading QSO Matches

There are two methods of importing data from LOTW, the first requires an ADIF file to exported from the LOTW website then uploaded to Cloudlog for checking. The second method pulls data directly from the LOTW website. This is accessed via the LoTW Import button.

If you'd prefer it was automatic if you run the sync cron details below it will automatically download matches.

P12 File Uploading

You must upload the certificate .p12 file, this is exported from TQSL

  • Open TQSL & go to the Callsign Certificates Tab
  • Right-click on the desired Callsign
  • Click "Save Callsign Certificate File" and do not add a password

QSO Uploading

Cloudlog builds the TQ8 file based on data you provide with the Station Location area, so if you are operating from a new area, just create the profile and when the script is run to upload to LoTW it will check that the Station Location has a valid certificate and upload, all on the fly no messing around.

Background Processes

Uploading to Logbook of the World is done by firing off the PHP script that reads all the Station Locations and looks for matches in certificates, its not recommended to run this script in real-time, this adds unnecessary pressure on LoTW's servers so I'd suggest every hour or two.

0 */1 * * * curl --silent <URL-To-Cloudlog->/index.php/lotw/lotw_upload &>/dev/null

Scripts Functions

  • Uploads any new QSOs to LoTW
  • Downloads any matches available at the time.

Notes for certain regions

United States of America Users

  • Station Location County must be exactly as LoTW would set it for example state OR and county Deschutes

Canada

  • Canadian Provinces is now supported, make sure you select your province via the state drop-down in the Station Location area.

Currently not supported station location fields

  • Parks on the Air
Clone this wiki locally