Importing from QRZ

I looked through the forums and couldn’t find the same problem so forgive me if I’m repeating a question/problem.

When I go to manually import the ADI file from QRZ to WRL it fails to import with the error:

Batch import failed: invalid input syntax for type timestamp with time zone: “”

I tried 5 times with the same error. For troubleshooting, I used the same QRZ ADI file to upload to LOTW and it imported there fine, so I don’t understand what my issue is.

Any help would be greatly appreciated!

1 Like

Hey, @KD3ABC are you exporting the ADI file from QRZ then importing it into WRL, or are you importing straight from QRZ?

Exporting to a file, then to WRL. I save the ADI files on my laptop as a record of what I uploaded to LOTW. It’s the exact same file I uploaded to LOTW 2 minutes after I tried WRL and failed and got that error message repeatedly. No issues uploading to LOTW.

1 Like

Got it. Can you send me a copy of your ADI file? You can DM me with it if you’re not comfortable sending it in a public thread.

1 Like

I’m not sure how to send the file via the forums or DM’s. Sorry. I can copy and paste the text, but I don’t think your looking for a thousand line forum post, :smiley: lol.

I could load it to my one drive and link it? Or is there a better way?

1 Like

No worries! Yep, a OneDrive link would be great!

1 Like

Do you pay for QRZ? If not it will not let you transfer the logbook.

1 Like

Let me know if the link doesn’t work. Just for giggles, I tried it again tonight with the same error code.

ADI

OH, and thank you so much for helping me with this!

1 Like

Yes, these are the same ADI files I download from QRZ to update my LOTW all the time.

1 Like