Updating LoTW QSL Confirmations in Log4OM database

[N5INP]

I was trying to understand how ClubLog shows what QSls you have confirmed and they said something about some LoTW adif parameters that it looks at in your uploaded file. Then I got to looking at the QSL informations in my QSO's Log4OM stores. I do upload to LoTW outside of Log4OM, but I have not been updating the confirmations in Log4OM for LoTW manually.

What I'm not sure about is how to get all the QSO's I have now, updated with the confirmations from LoTW easily. Am I supposed to manually do it for each QSO, or is there some way to get a file from LoTW and have Log4OM update all the LoTW confirmations?

I did look at the manual but I'm just lost right now because of the complexity of all these interacting web sites, and now I am afraid to do anything with any of the settings other than the QSl line which I guess has to do with paper QSLs (I've been updating that one myself).

I guess while we're at it, how does the eQSL confirmations get updated?

Thanks.

[G4POP]

Watch the video

http://m.youtube.com/watch?v=yLT3UuMlocc

[N5INP]

Ok I watched it and I'm trying to set up uploading to LoTW but I'm stuck. I know the password I use to log into thet LoTW website, but what is the "TQSL Private Pass" I have no idea what that is or when I used it to set up LoTW.

Can you tell me where I can find it because I have no idea whatsoever what it is.

Edit: ALso I can't find a path like that shown in the manual for "Temporary Path"

[G4POP]

Ok I watched it and I'm trying to set up uploading to LoTW but I'm stuck. I know the password I use to log into thet LoTW website, but what is the "TQSL Private Pass" I have no idea what that is or when I used it to set up LoTW.

Can you tell me where I can find it because I have no idea whatsoever what it is.

Edit: ALso I can't find a path like that shown in the manual for "Temporary Path"

1. Hopefully you have downloaded the LOTW TQSL.exe program and installed it to your computer - If so find the program, right click on the program icon, go to 'Properties' and you should see the path to where the program is installed - Alternatively search for TQSL.exe.

2. If you have not installed it then you must do so

3. If you have TQSL.exe installed you should try the TQSL program and make sure that you can upload to LOTW from it

4. The temporary path should be as shown below but of course the user name will be specific to your computer so perhaps your call sign, your name, home or something similar - Again only you can find this.

C:\Users\Your user name\AppData\Roaming\LogOM\LOTW

4. As for the private password only you will know if you used one and if you did exactly what it is - If you forgot then perhaps LOTW could help you?

[N5INP]

1. Hopefully you have downloaded the LOTW TQSL.exe program...

Yes I have Tqsl installed and working, I've been using it OK for months. I simply have no idea what "TQSL private password is. Where did it come from? Where is it now? I have no idea, but the program uploads OK and all is well with LoTW, so I'm stuck at this point.

4. The temporary path should be as shown below but of course the user name will be specific to your computer so perhaps your call sign, your name, home or something similar - Again only you can find this.

C:\Users\Your user name\AppData\Roaming\LogOM\LOTW

I can find no path like that. I can get to the part with my user name

C:\Users\Mike\...

but there is simply no "AppData" after my username in the list of paths after that. It is not there. So I'm also stuck at that point. This is not fun.

4. As for the private password only you will know if you used one and if you did exactly what it is - If you forgot then perhaps LOTW could help you?

I know the password to log onto LoTW, but I know of no other password, so I cannot set up that part of the Log4OM program. If anyone knows where I can get the "TQSL private password" or where it came from, please let me know.

Right now my head hurts from all this. Thanks for helping but right now I'm frustrated and haven't done any ham radio at all today. I've literally spent hours trying to get this to work, and right now I have to go out for a walk to settle down.

[G4POP]

I simply have no idea what "TQSL private password is. Where did it come from? Where is it now? I have no idea, but the program uploads OK and all is well with LoTW, so I'm stuck at this point.

As I said only you would know but you could try

1.Assume that you did not set a private password and leave it blank
2. Try the same password for the private password as your normal password

I can find no path like that. I can get to the part with my user name

Then just type in the path substituting "Mike" for "Your user name" (without the inverted commas of course) it should work even though you are unable to find the path - You can't see the path because you have your windows settings set to not show hidden files and folders.

Right now my head hurts from all this. Thanks for helping but right now I'm frustrated and haven't done any ham radio at all today. I've literally spent hours trying to get this to work, and right now I have to go out for a walk to settle down.

Remember this is a hobby so getting yourself screwed up is pointless, just take your time and let us work you through your problem because it does work fine as our users will confirm.

[N5INP]

I simply have no idea what "TQSL private password is. Where did it come from? Where is it now? I have no idea, but the program uploads OK and all is well with LoTW, so I'm stuck at this point.

As I said only you would know but you could try

1.Assume that you did not set a private password and leave it blank
2. Try the same password for the private password as your normal password

From the ARRL website -

What are all of these passwords for?

There are up to four passwords that may be associated with a single callsign. The short answer to "why so many?" is that each password protects a different aspect of the LoTW system.

The first password you will deal with is one that you create. It protects your Private Key. You create this password when you create your certificate request for your primary call. It can be any number of characters, and it is case sensitive. Be sure if you use mixed capital letters and small letters that you write this password down exactly as you create it. You must keep track of this password because it is the most important part of the LoTW system. It is used to sign your log data, request additional certificates, and make back-up copies of your certificate for safekeeping or for use on another computer. We will not know this password, and cannot tell you what it is. If you lose it and forget it, your certificate will become useless.

The second password you will see is the 8-character password that comes to you on your postcard if you are in the U.S. Participants outside the U.S. will not get this postcard or password. For U.S. participants, you will need this password in the initial stage of setting-up LoTW when you go to the LoTW Page on the ARRL Web site and follow the link in the yellow box to go to the page where you enter the password (this tells us you received postal mail at the address listed with the FCC). Once you have successfully entered this password, you will not use this password again.

The third password you will see in the body of the email containing your certificate. This email will also contain your username (usually your callsign, and sometimes your callsign with a number at the end). You will use your username and the password to access the Logbook User Web site. This is the only place you can use this password. Once you have gained access to this site you can change your password.

The fourth password, if you choose to use it, is one you can create when you save/back-up your certificate (and private key) to a floppy disk (or another hard drive, or CD, etc.). Saving your certificate is something you absolutely need to do--both to serve as a back-up in case your computer crashes, or to use if you want to install the certificate on another computer (see Part 5 of Getting Started). In TQSLCert, click on the certificate in the certificate list to select it, then choose the Certificate menu's Save command. Before you save the certificate, you will be prompted to create a password that protects the private key that is saved on the floppy or other medium. It is not required to use/create this password. The idea behind this password is that if your floppy were ever lost or stolen, no one would be able to steal your private key from the floppy. After this stage, you will then be prompted to supply your Private Key password (the first, and most important password in LoTW), which is necessary to allow the program to save your private key with your certificate. Then you can save the certificate file and copy it to a floppy disk or other off-line medium.

https://lotw.arrl.org/cgi-bin/lotw_page/faq#certrenew

I just do not know which password you all are referring to. Forget what the password actually is at the moment - please tell me which of the FOUR passwords stated above you are talking about when you say "TQSL trusted password"

The ONLY password I use from day to day with TqsL is the one to log onto the LoTW website. I do not everter any password when actually using the TQSL program daiily, hence, I have no idea what password you are talking about!

Remember this is a hobby so getting yourself screwed up is pointless, just take your time and let us work you through your problem because it does work fine as our users will confirm.

Yes and it's a hobby that requires all these programs to really get the confirmations and logging done, and so I have little choice except to make them work. I never said this aspect of the software didn't work, I just want to know how I can make it work! It's very confusing and it's taking literally most of the day just for this setup alone. I have talked to no other ham today because of trying to set this up. Sorry but I'm exasperated right now.

[G4POP]

Contact me by email and I will give you my Skype name and then talk you through this on Skype

[G4POP]

I simply have no idea what "TQSL private password is. Where did it come from? Where is it now? I have no idea, but the program uploads OK and all is well with LoTW, so I'm stuck at this point.

As I said only you would know but you could try

1.Assume that you did not set a private password and leave it blank
2. Try the same password for the private password as your normal password

From the ARRL website -

What are all of these passwords for?

There are up to four passwords that may be associated with a single callsign. The short answer to "why so many?" is that each password protects a different aspect of the LoTW system.

The first password you will deal with is one that you create. It protects your Private Key. You create this password when you create your certificate request for your primary call. It can be any number of characters, and it is case sensitive. Be sure if you use mixed capital letters and small letters that you write this password down exactly as you create it. You must keep track of this password because it is the most important part of the LoTW system. It is used to sign your log data, request additional certificates, and make back-up copies of your certificate for safekeeping or for use on another computer. We will not know this password, and cannot tell you what it is. If you lose it and forget it, your certificate will become useless.

The second password you will see is the 8-character password that comes to you on your postcard if you are in the U.S. Participants outside the U.S. will not get this postcard or password. For U.S. participants, you will need this password in the initial stage of setting-up LoTW when you go to the LoTW Page on the ARRL Web site and follow the link in the yellow box to go to the page where you enter the password (this tells us you received postal mail at the address listed with the FCC). Once you have successfully entered this password, you will not use this password again.

The third password you will see in the body of the email containing your certificate. This email will also contain your username (usually your callsign, and sometimes your callsign with a number at the end). You will use your username and the password to access the Logbook User Web site. This is the only place you can use this password. Once you have gained access to this site you can change your password.

The fourth password, if you choose to use it, is one you can create when you save/back-up your certificate (and private key) to a floppy disk (or another hard drive, or CD, etc.). Saving your certificate is something you absolutely need to do--both to serve as a back-up in case your computer crashes, or to use if you want to install the certificate on another computer (see Part 5 of Getting Started). In TQSLCert, click on the certificate in the certificate list to select it, then choose the Certificate menu's Save command. Before you save the certificate, you will be prompted to create a password that protects the private key that is saved on the floppy or other medium. It is not required to use/create this password. The idea behind this password is that if your floppy were ever lost or stolen, no one would be able to steal your private key from the floppy. After this stage, you will then be prompted to supply your Private Key password (the first, and most important password in LoTW), which is necessary to allow the program to save your private key with your certificate. Then you can save the certificate file and copy it to a floppy disk or other off-line medium.

https://lotw.arrl.org/cgi-bin/lotw_page/faq#certrenew

I just do not know which password you all are referring to. Forget what the password actually is at the moment - please tell me which of the FOUR passwords stated above you are talking about when you say "TQSL trusted password"

The ONLY password I use from day to day with TqsL is the one to log onto the LoTW website. I do not everter any password when actually using the TQSL program daiily, hence, I have no idea what password you are talking about!

Remember this is a hobby so getting yourself screwed up is pointless, just take your time and let us work you through your problem because it does work fine as our users will confirm.

Yes and it's a hobby that requires all these programs to really get the confirmations and logging done, and so I have little choice except to make them work. I never said this aspect of the software didn't work, I just want to know how I can make it work! It's very confusing and it's taking literally most of the day just for this setup alone. I have talked to no other ham today because of trying to set this up. Sorry but I'm exasperated right now.

"THE" password is the one you use to log into LOTW

Your user name is probably your call sign

The private password may or may not have been set/use by you

If you did not use a private password then leave it blank in Log4om

If like me you used the log in password for LOTW as the private password use that in the private password field

[N5INP]

"THE" password is the one you use to log into LOTW

I know that password.

Your user name is probably your call sign

Yep.

The private password may or may not have been set/use by you

If you did not use a private password then leave it blank in Log4om

I dunno, I know of only one password I use - that's to log into the LoTW website and look at my reports.

If like me you used the log in password for LOTW as the private password use that in the private password field

I'm taking you up on your offer to walk me through this, so I'll either PM you here or email you. I really want this behind me, and if there are other people as dumb as I seem to be about this, perhaps the manual needs clarifying also. I've spent literally hours on this whereas setting up the entire Log4OM program was much easier!

I'm going to send you a PM /or email right now. Thanks.