Execute a massive update on DB
Posted: 02 Jul 2013, 11:06
if you're able to work with SQL log4om provides a direct SQL input command to update your database directly.
The log table is called "log"
As example:
The command is in the "QSO ARCHIVE" -> "FIELD UPDATE" in the box "Execute custom update query".
It works on the WHOLE database without regard of previous filters.
Here the list of fields [release 1.14.0]
The log table is called "log"
As example:
Code: Select all
update log set distance = distance * <conversion factor>
It works on the WHOLE database without regard of previous filters.
Here the list of fields [release 1.14.0]
- qsoId
address
age
AIndex
AntAz
AntEl
AntPath
ArrlSect
ArrlCheck
TheClass
CreditSubmitted
CreditGranted
TenTen
MyAntenna
Band
bandRx
call
comment
cont
cnty
contactedOp
contestId
country
Cqz
Distance
dxcc
eqCall
email
eqslQslrdate
eqslQslsdate
eqslQslRcvd
eqslQslSent
ForceInit
Freq
FreqRx
Gridsquare
iota
iotaIslandId
Ituz
KIndex
lat
lon
MaxBursts
msShower
myLat
myLon
lotwQslrdate
lotwQslsdate
lotwQslRcvd
lotwQslSent
mode
myCity
myCnty
myCountry
MyCqZone
myGridsquare
myIota
myIotaIslandId
MyItuZone
myName
myPostalCode
myRig
mySig
mySigInfo
myState
myStreet
Name
notes
NrBursts
NrPings
pfx
theOperator
ownerCallsign
precedence
propMode
publicKey
programid
programversion
qslmsg
qslrdate
qslsdate
qslRcvd
qslRcvdVia
qslSent
qslSentVia
qslVia
qsoComplete
qsoDate
qsoDateOff
qsoRandom
qth
rig
Sfi
rstRcvd
rstSent
RxPwr
satMode
satName
sig
sigInfo
srx
srxString
state
stationCallsign
stx
stxString
swl
timeOff
timeOn
TxPwr
validatedCallsign
manualDateTime
mobile
qrp
portable
callsignUrl
homepageUrl
contest
submissionstatus