O-Checklist YAML Parser

File='OO26S2O1.yaml'
Event='OOcup 2026 Stage 2'
Creator='O Checklist v5.4', Created='2026-07-27T14:34:32+01:00'
Competitor identification mode: Id / Stage: 2 / Reset file-selection and start over

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Done. (138 items)

Warnings:

New CardNumber ' 845179': Id=' 222', StartStatus='DNS', Name='Mairead Murphy', Org='Setanta Orienteers', OldCard='8217785'.

New CardNumber ' 971103': Id='1215', StartStatus='Started OK', Name='Catherine Mcneal-lewis', Org='New England OC', OldCard='4655121'.

New CardNumber '1982719': Id=' 124', StartStatus='Started OK', Name='Brady Brown', Org='Grizzly Orienteering', OldCard=''.

New CardNumber '2010044': Id=' 447', StartStatus='Started OK', Name='Montserrat (CAT) Teixidó i Ferré', Org='Club Orientació Catalunya', OldCard=''.

New CardNumber '8217785': Id=' 223', StartStatus='Started OK', Name='Brendan Delaney', Org='Setanta Orienteers', OldCard='8451795'.

New CardNumber '8507561': Id=' 122', StartStatus='Started OK', Name='Maribeth Rothwell', Org='Grizzly Orienteering', OldCard=''.

OK (137):

Late (0):

DNS (1):

LateStart, DNS and ChipChange SQL-query:

-- Execute this query (F4) and then don't forget to
-- commit the changes to the database after executing (F5).

-- DNS: Set FinishType to 4=DNS, but only for people without another post-readout FinishType
UPDATE OEvCompetitor SET FinishType2 = 4 WHERE (FinishType2 = 0)
AND (Id IN (222));

-- ChipChange: Set NewChip, but only if OldChip and Id match and FinishType is 0=NotSet
UPDATE OEvCompetitor SET ChipNumber2= 845179 WHERE (Id= 222) AND (FinishType2=0) AND (ChipNumber2=8217785);
UPDATE OEvCompetitor SET ChipNumber2= 971103 WHERE (Id=1215) AND (FinishType2=0) AND (ChipNumber2=4655121);
UPDATE OEvCompetitor SET ChipNumber2=1982719 WHERE (Id= 124) AND (FinishType2=0) AND (ChipNumber2 IS NULL);
UPDATE OEvCompetitor SET ChipNumber2=2010044 WHERE (Id= 447) AND (FinishType2=0) AND (ChipNumber2 IS NULL);
UPDATE OEvCompetitor SET ChipNumber2=8217785 WHERE (Id= 223) AND (FinishType2=0) AND (ChipNumber2=8451795);
UPDATE OEvCompetitor SET ChipNumber2=8507561 WHERE (Id= 122) AND (FinishType2=0) AND (ChipNumber2 IS NULL);

-- ChipCopy: If chip for any next stage is unknown or different from today, set it from today
UPDATE OEvCompetitor SET ChipNumber3 = ChipNumber2 WHERE (FinishType3 = 0)
    AND (ChipNumber2 IS NOT NULL) AND (COALESCE(ChipNumber3, 0) <> ChipNumber2);
UPDATE OEvCompetitor SET ChipNumber4 = ChipNumber2 WHERE (FinishType4 = 0)
    AND (ChipNumber2 IS NOT NULL) AND (COALESCE(ChipNumber4, 0) <> ChipNumber2);