Page 1 of 1

LOTW error

Posted: 14 Dec 2017, 14:36
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

Re: LOTW error

Posted: 14 Dec 2017, 16:35
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