Hi all!
After changing ADIF-version in database of this site we've got a lot of "red marks" in our Output Boxes in the field "Mode" for many old records. Those records had right mode earlier, for example, "PSK63". But after changing ADIF-version the database now cannot understand, what "PSK63" now means :) Now the database want this mode to be "PSK | PSK63".
OK, we have two ways. First - manually edit every "now red" old good record in every old month of every old year, manually change "PSK63" to "PSK | PSK63", "PSK125" to "PSK | PSK125", "QPSK63" to ..... and so on... and then save every record...
And everyone user have to do it !
Very attractive business, right ? :)
And there is another way. Just run script on the database - and it will do the same automatically.

So there is a question - what is the problem with automatic changing of the QSO modes in all records to new standard?

If someone needs to help him making this script - I (as a programmer myself) would try to help, no problems. To my mind it will be something like:
UPDATE EQSLDB SET MODE='PSK', SUBMODE='PSK63' WHERE MODE='PSK63' - if MODE and SUBMODE have a string format
If database doesn't allow updating all at once - we can do it part by part, for example, year by year:
UPDATE EQSLDB SET MODE='PSK', SUBMODE='PSK63' WHERE MODE='PSK63' AND QSLDATE BETWEEN '20100101' AND '20101231' ...

So please, save our time! Script will make it much quicker and better !

---

RD3AJB Mikhail Nosov

Forwarded to N5UP

---

F6DKQ Guy FALCOZ

Thanks ! :)

---

RD3AJB Mikhail Nosov