Execute a massive update on DB

Post Reply
User avatar
IW3HMH
Site Admin
Posts: 2280
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Execute a massive update on DB

Post by IW3HMH » 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:

Code: Select all

update log set distance = distance * <conversion factor>
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]
  • 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
Daniele Pistollato - IW3HMH

Post Reply