[DogParkList] Batch update DXCC name?

[dagro]

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


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