Requirements: (1) Back-up (Very Important!!) - both your 2007 Refdata.mdb file and your 2007 Logbook.mdb file. (2) You have already obtained and installed the TQSL Certificate(s) for the CALLSIGN(s) you will be signing. And, you have all of your PASSWORDS available for signing and for logging-into the ARRL LoTW website. (3) Check your TQSL program to ensure that you are using Version 1.11 (which is the current version available from the ARRL LoTW website at): TQSL program Download webpage (4) You "always" Upload "ALL" of your Valid QSOs to the LoTW website; and, you "always" allow the QSLS column of your logbook to be updated - showing that the QSO(s) have been uploaded to the LoTW website. (a) NOTE here!!! You have always generated your ADIF file from within DXbase. And, you will always use AutoLoTW to generate the ADIF file!! This - so that the QSLS column "will" be updated with the fact that you have uploaded the QSO(s) to LoTW. (5) You "always" Download "ALL" of your LoTW confirmations; and, you "always" allow the CFM column of your logbook to be updated - reflecting that the QSO(s) have been confirmed via LoTW. (6) You are aware of how to handle a ZIP file (downloading it) - and, then "extracting and saving" the file(s) within the ZIP file to the proper directory. (7) You "can find" the "Location" for each of your CALLSIGNS from the TQSL program. An EXAMPLE of my own TQSL program/Main Menu/Station/Edit locations is available at my website on this webpage . Note: This is ONLY an example of what MY OWN "Location" looks like. Your information probably is different. The example is only meant to provide a guide as to where the beginning and ending is of the "location" info. This is one of the most critical steps!! The entry that you will make on my programs SETUP/OPTIONS window has to be "EXACT" -- therefore, the spacing, uppercase, lowercase, etc - must be perfect for this part of the AUTOMATIC process to work properly. Also, I have a BUTTON on the SETUP/OPTIONS window that says "Example". This LINK will take you to the screen-capture I made of my own Edit Locations window. What will Joe's AutoLoTW program do for you: (1) When the information needed for the SETUP/OPTIONS window is correct, the ONLY entries you will have to make on this SETUP/OPTIONS window will be your CALLSIGN(s) and Location(s) that you will be signing and making a TQ8 file for. And, the CALLSIGN(s) that you use to LOG-Into the ARRL LoTW website with.. THAT's it .. the rest of info is "auto-populated" for you. (2) Once you press the OK button on the SETUP/OPTIONS window, the CALLSIGN(s) and Location(s) info is automatically saved to a *.dat file (3) To make sure that this program is as "User Friendly" as can be, I made the PATH (Directory) for the location of the files we will use as your DXbase 2007 Directory. (4) On the UPLOAD side of the program window (left side): (a) When you press the "LoTW Upload" button, the program goes through your logbook and reads all of the QSO(s) - for the OPRCALL you have "Selected" - that are "VALID" and "Do NOT" have LoTW or Both in the QSLS column. (b) ALSO - automatically, the program will highlight/copy the Path and Filename to your computer's "clipboard" - making it available for you to PASTE (Ctrl-V) to the ARRL LoTW website's "File to Upload" dialog textbox. (c) The "blue" colored checkmarks on my programs main window will allow you to follow along with what is happening. (d) Once the ADIF file is created (automatically), my program will automatically bring up the TQSL.exe program. This will be the very first time that you as the user will have to make an entry in the program's main window. If your "signing" process is PASSWORD protected, the program will wait for you to "type-in" your PASSWORD. Note: If you DO NOT have a PASSWORD for the "signing" of your ADIF file, then the TQSL.exe program will be "fully automatic" and you might not even see it come up!! (e) Once you type-in your PASSWORD for "signing", the TQSL.exe program will make the TQ8 file and the TQSL.exe program will automatically CLOSE!! (f) ALL while this is going on - my program will OPEN up your "default" web-browser program - to the ARRL LoTW "LogON" webpage -- this is again "one more" place where you will have to "type-in" your PASSWORD that you use to enter the ARRL LoTW website. If you are already "logged-in" the website - then you will be "at" the "File to Upload" webpage. (g) Once at the File to Upload webpage - you will simply PASTE (Ctrl-V) the PATH/FILENAME that was copied into your computer's clipboard - into the dialog textbox for "File to Upload" -- then press the "Upload File" button. (h) Your UPLOAD is done!! (5) On the DOWNLOAD side of the program window (right side): (a) For the FIRST time using the Download part of my program, RADIO Button the "Download ALL QSLs" selection. (b) Press the "#1 - Download from LoTW" button. Your "default" web-browser will come up and will start the download of your "confirmations" from LoTW. LogOn the ARRL LoTW website (if you aren't already logged-in). Depending on your web-browser program, a "small dialog window" will come up and you should select "Save it to disk" - Press OK .. (c) NOTE!! When you clicked on my program's "#1 - Download from LoTW" button, I copied the Path/Filename of the downloaded file to your computer's "clipboard". (d) When the "Enter name of file to save to..." comes up, you SIMPLY PASTE (Ctrl-V) the Path/Filename from your computer's clipboard - to the "File name:" dialog textbox of this window. Press the Save button. (e) Once the downloaded "confirmations" ADIF file is saved to your computer, PRESS the "#2 - LoTW Import" button.. My program will automatically IMPORT the ADIF file you downloaded. (f) During the IMPORT process, the small textbox, to the right of the words "Only fm last QSL >", will be UPDATED automatically with the DATE of the very last confirmation on the LOTW website for your OPRCALL. Press the "Save Date" button that is underneath that textbox and that DATE will be saved to a *.dat file (for the next time you callup the program). (g) There are STATS available on my program's main window - so that you will know how many were read and how many were used. (6) If my AutoLoTW program is not to your liking, or my program just simply doesn't work for you - even after going through all of the above instructions, please "bring-back" the copy of your SAVED logbook mdb file - so that your logbook mdb file is exactly as it was before, delete my program autolotw22.exe file, the autolotw.dat, and autolotw2.dat files. You will be back to the point where you were at - before you tried to use my program. Then - for the sake of LoTW uploading/downloading, use the method that you have always used before. (7) Here are some screen-captures - taken in the sequence of my actions used during each step of the Upload and Download process: