O-Checklist YAML Parser

File='OO25op2.yaml'
Event='OO Cup 2025 Stage 3'
Creator='O Checklist v4.3.0', Created='2025-07-29T14:29:59+02:00'
Competitor identification mode: Id / Stage: 3 / Reset file-selection and start over

. . . . .
Done. (11 items)

Warnings:

Malformed YAML-file: incomplete RUNNER-element at index 10!

Malformed YAML-file: missing EndOfData-element at end-of-file!

LateStart '10:01:22': Id=' 728', Name='Valerie Wambersy', Org='', ClassName='OPEN C', StartTime='10:00:00'.

LateStart '10:03:32': Id=' 710', Name='Tomas Strejcek', Org='KOS Tesla Brno', ClassName='M10-SHADOWED', StartTime='10:00:00'.

LateStart '10:05:03': Id=' 687', Name='Birk Hvidberg Tofte', Org='Odense OK', ClassName='M10-SHADOWED', StartTime='10:00:00'.

LateStart '10:35:15': Id='1879', Name='Wolfgang Schüller', Org='Der Berger-Clan', ClassName='OPEN B', StartTime='10:00:00'.

LateStart '11:03:43': Id=' 199', Name='Reka Susanne Toth', Org='', ClassName='OPEN A', StartTime='10:00:00'.

LateStart '11:53:53': Id=' 108', Name='Mason Malone', Org='CNOC', ClassName='M10-SHADOWED', StartTime='10:00:00'.

LateStart '12:21:29': Id=' 165', Name='Leon Asenbauer', Org='Naturfreunde Wien - Orienteering-Team', ClassName='M10-SHADOWED', StartTime='10:00:00'.

LateStart '12:21:33': Id=' 166', Name='Luis Asenbauer', Org='Naturfreunde Wien - Orienteering-Team', ClassName='M10-SHADOWED', StartTime='10:00:00'.

LateStart '12:22:57': Id=' 77', Name='Dylan Kennedy', Org='Lagan Valley Orienteers', ClassName='M10-SHADOWED', StartTime='10:00:00'.

LateStart '12:30:00': Id=' 136', Name='Maximilian Meizer', Org='Naturfreunde Wien - Orienteering-Team', ClassName='M10-SHADOWED', StartTime='10:00:00'.

New CardNumber '2033615': Id='1879', StartStatus='Late start', Name='Wolfgang Schüller', Org='Der Berger-Clan', OldCard='2033592'.

New CardNumber '2106963': Id=' 199', StartStatus='Late start', Name='Reka Susanne Toth', Org='', OldCard=''.

New CardNumber '8658401': Id=' 728', StartStatus='Late start', Name='Valerie Wambersy', Org='', OldCard='2106973'.

OK (0):

Late (10):

DNS (0):

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).

-- LateStart: Reset FinishType to 0=NotSet, but only for people previously marked as 4=DNS
UPDATE OEvCompetitor SET FinishType3 = 0 WHERE (FinishType3 = 4)
AND (Id IN (77, 108, 136, 165, 166, 199, 687, 710, 728, 1879));

-- ChipChange: Set NewChip, but only if OldChip and Id match and FinishType is 0=NotSet
UPDATE OEvCompetitor SET ChipNumber3=2033615 WHERE (Id=1879) AND (FinishType3=0) AND (ChipNumber3=2033592);
UPDATE OEvCompetitor SET ChipNumber3=2106963 WHERE (Id= 199) AND (FinishType3=0) AND (ChipNumber3 IS NULL);
UPDATE OEvCompetitor SET ChipNumber3=8658401 WHERE (Id= 728) AND (FinishType3=0) AND (ChipNumber3=2106973);

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