EQSL.CC INBOX DOWNLOADING PROCEDURE revised 09 Oct 2024 (see bottom of document for changes) Any questions or problems may be directed to Dave Morris, N5UP, E-mail to Dave@eQSL.cc SYNOPSIS Users of the eQSL.cc system normally log into the web site with a username and password in order to retrieve their new incoming eQSLs (from the InBox). Some logging software authors have expressed an interest in being able to download a portion or all of the InBox. For this purpose, the DownloadInBox.cfm program was created. HOW TO USE THE "DownloadInBox.cfm" PROGRAM This web page is actually an interactive ColdFusion "form" processor that accepts parameters to control its operation. It returns a response HTML page containing 2 hyperlinks to files in which the ADIF formatted InBox data is stored. It must be mentioned at this time that the InBox does NOT contain anything like the contents of the user's station log. These are the INCOMING cards, and not the Outgoing ones. It is crucial to understand the difference and what effect that will have on things like Callsign and RST tags. You can call the program with the following parameters in the URL: UserName = Callsign (mandatory if not logged in; Ignored if already logged in) Password = Password (mandatory if not logged in; Ignored if already logged in) QTHNickname = QTH Nickname (if not logged in, if multiple accounts with same callsign) (Note that if you are already logged in, Username and Password will be ignored, and you will be getting the InBox of the account you are logged into.) Optional LimitDateLo = Earliest QSO date to download (oddly, in MM/DD/YYYY format with escape code 2F for slashes), optionally append HH:MM otherwise the default is 00:00 LimitDateHi = Latest QSO date to download (oddly, in MM/DD/YYYY format with escape code 2F), optionally append HH:MM otherwise the default is 23:59 to include the entire day RcvdSince = (YYYYMMDDHHMM) Everything that was entered into the database on or after this date/time (Valid range 01/01/1900 - 12/31/2078) ConfirmedOnly = Set to any value in the URL to signify you only want to download Inbox items you HAVE confirmed UnconfirmedOnly = Set to any value in the URL to signify you only want to download Inbox items you have NOT confirmed Archive = 1 for Archived records ONLY; 0 for Inbox (non-archived) ONLY; omit this parameter to retrieve ALL records in Inbox and Archive HamOnly = anything, filters out all SWL contacts Remember that special characters such as brackets <> and colons : should be escaped. Ampersands & and question marks ? have special meaning to our programs and should be escaped when they appear in the data itself. The following example downloads the contents of the InBox for the user Test-SWL with all cards received since February 1, 2005: https://www.eQSL.cc/qslcard/DownloadInBox.cfm?UserName=Test%2DSWL&Password=TestPswd&RcvdSince=20050201 The following example downloads only unconfirmed InBox items for the user Test-SWL with all cards received since February 1, 2005: https://www.eQSL.cc/qslcard/DownloadInBox.cfm?UserName=Test%2DSWL&Password=TestPswd&RcvdSince=20050201&UnconfirmedOnly=1 RETURN PAGE FORMAT: Look for the string "Your ADIF log file has been built" in the returned page to indicate success. Somewhere on the page after that that will be two A HREF hyperlinks. The files contain identical contents, but one has an ADI extension, while the other has a TXT extension. This is solely for the benefit of browser access and automatic file type associations. If you are reading the ADIF file with software, you can choose either file. The files will stay on the system for a few hours and are then deleted, so you should retrieve the file as soon as you can. NOTE AS OF OCTOBER 22, 2019: The hyperlinks should be followed to the location of the file. We moved the DownloadedFiles folder to be above the QSLCard folder on October 22, 2019. Any external programs that had hardcoded the folder structure might not find the files! As of 25Sep2014, the results page is much shorter, having eliminated all the left column and bottom copyright notices. ADIF HEADER CONTENTS: The ADIF header will contain something like the following: ADIF 3 Export from eQSL.cc Received eQSLs for TEST-SWL for QSOs between 16-Jun-2002 and 08-Jun-2011 Generated on Monday, November 26, 2007 at 7:28:05 PM GMT eQSL.cc DownloadInBox 3.0.4 ADIF BODY CONTENTS: The following ADIF tags will be exported: CALL QSO_DATE TIME_ON BAND MODE SUBMODE (tag only present if non-blank) PROP_MODE (tag only present if non-blank) RST_SENT (will be the sender's RST Sent, not yours) RST_RCVD (we do not capture this in uploads, so will normally be 0 length) QSL_SENT (always Y) QSL_SENT_VIA (always E) QSLMSG (if non-null and containing only valid printable ASCII characters) QSLMSG_INTL (if non-null and containing international characters - see ADIF V3 specs) APP_EQSL_SWL (tag only present if sender is SWL and then always Y) APP_EQSL_AG (tag only present if sender has Authenticity Guaranteed status and then always Y) GRIDSQUARE (tag only present if non-blank and at least 4 long) If we have stored the date this record was added to our eQSL.cc database, then these 2 will be present: EQSL_QSL_RCVD (always Y) EQSL_QSLRDATE (yyyymmdd date) MODIFICATIONS TO THIS DOCUMENT OR TO SPECIFICATIONS 26 Nov 2007 First draft 18 Mar 2008 Added UnconfirmedOnly parameter 22 May 2008 Added Archive parameter 05 Mar 2009 Added ConfirmedOnly parameter 21 Jan 2014 Added APP_EQSL_AG and documented the tags supported in the body 06 Sep 2014 Added GRIDSQUARE field if non-blank 25 Sep 2014 Removed left column and copyright notice 07 Mar 2015 Add QSLMSG_INTL tag if international characters outside the ASCII range are present in comments 19 May 2015 Add HamOnly flag 12 Jul 2017 Add PROP_MODE tag if non-blank 20 Jul 2017 Add SUBMODE tag if non-blank and make output conform to ADIF V3.0.4 where MODE and SUBMODE are concerned 28 Apr 2018 Clarification on RST_SENT and RST_RCVD 29 Apr 2018 Clarified valid range for RcvdSince parameter 01 Dec 2018 Optionally include HH:MM in both LimitDateLo and LimitDateHi, and the default for LimitDateHi is 23:59 if not specified 22 Oct 2019 Moved DownloadedFiles folder above QSLCard folder 29 Jun 2022 Corrected PropMode INTERNET being erroneously exported as INT 28 Sep 2023 All WRITEs done using Java string buffer mechanism for superb speed improvement over previous version 09 Oct 2024 EQSL_QSL_RCVD and EQSL_QSLRDATE added if record was uploaded 2005 or later