LOTW error

Need help? - Post here and we will find a solution for you.
Locked
w9mdb
Old Man
Posts: 434
Joined: 13 Jul 2014, 12:05

LOTW error

Post by w9mdb »

LOTW started putting comments in their download files

So when you look at statistics and awards, for example you see this

IL // ILLINOIS *** NOT FOUND ***

So far it's only for CNTY and STATE
<CNTY:15>FL,HILLSBOROUGH // Hillsborough
<STATE:2>TX // Texas

So it appears the ADIF parser is not using the field length to truncate the fields

de Mike W9MDB
w9mdb
Old Man
Posts: 434
Joined: 13 Jul 2014, 12:05

Re: LOTW error

Post by w9mdb »

If you download the sqlite3 command line utility you can fix this until LOTW or Log4OM fixes this.
Just run 'sqlite3 database.sqlite' with whatever your database name is and do this:
update log set state=SUBSTR(state,1,2);

de Mike W9MDB
Locked