[DogParkList] Batch update DXCC name?

[Larry West]

Don,

Thanks for the reply. I wasn't worried about the awards, etc. But sometimes I will want to look at things in the log for just the U.S., and it was made difficult by having two dxcc_country names for DXCC #291!

And thanks, Hisashi for the recommendation on the FF plugin! I installed it (after several rounds of updating FF), made the change and all is hunky-dory now!

73, N2LJ


On Jan 18, 2014, at 10:36 , dagro <dagro at dogparksoftware.com> wrote:


> 

> On Jan 18, 2014, at 8:54 AM, Larry West <viggen at mac.com> wrote:

> 

>> When I first started using MLDX, back in 2004, the DXCC name for the USA was recorded in MLDX as "USA". Then, in 2005, it started being recorded as "United States". Maybe that was a change with the FCC, or QRZ, I don't know, but I've got about 100-150 log entries with "USA", and all the rest as "United States". 

> 

> The ADIF enumeration is “UNITED STATES”, the important thing for matching, confirmation and awards is the DXCC ID - 291

> 

>> Anyway, I'd like to have them all say "United States". I just found the function to update multiple log entries for QSL sent/received (ok, some years late to that party...), but I didn't see the possibility to update the DXCC country name there.

>> 

>> Being an MSSQL admin during the week, I know there is an easy SQL "Update" statement do do exactly that, but I'm not up to speed how to do that with SQLite. Is there a command line method?

> 

> There is a free utility “SQLite database browser"

> 

> http://sourceforge.net/projects/sqlitebrowser/

> 

> 73 de VE3VRW Don Agro

> 

> 

> _______________________________________________

> DogParkList mailing list

> DogParkList at dogparksoftware.com

> http://two.pairlist.net/mailman/listinfo/dogparklist


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://two.pairlist.net/pipermail/dogparklist/attachments/20140118/2b439c3f/attachment.html>