O-Checklist YAML Parser

File='LO26open5.yaml'
Event='Lipica open 2026 Stage 5'
Creator='O Checklist v5.1 beta 5', Created='2026-03-11T12:38:29+01:00'
Competitor identification mode: Id / Stage: 5 / Reset file-selection and start over

. . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Done. (58 items)

Warnings:

Comment 'Pred 00': Id=' 208', StartStatus='Late start', Name='Réka Kassay', Org='Watch Out Cluj', ClassName='OPEN C', StartTime='09:59:00'.

Comment 'Pred 00': Id='1722', StartStatus='Late start', Name='Aleš Zobavnik', Org='CISM SLO', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '09:54:05': Id=' 208', Name='Réka Kassay', Org='Watch Out Cluj', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '09:55:17': Id='1722', Name='Aleš Zobavnik', Org='CISM SLO', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '09:57:15': Id=' 568', Name='Monika Váňová', Org='Orientační sporty Písek', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '09:58:07': Id='1518', Name='Marco Garbani', Org='O-92 Piano di Magadino', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '09:58:25': Id='1519', Name='Belinda Bustini', Org='O-92 Piano di Magadino', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '10:00:00': Id='1382', Name='Zdenko Pavlič', Org='OK Azimut', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '10:08:04': Id='1486', Name='Catherine Berne', Org='Jura Alpes Orientation', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '10:09:47': Id=' 751', Name='Elena Lombardi', Org='Polisportiva Besanese', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '10:09:56': Id='1562', Name='Isabell Edelhäuser', Org='Startuhr Dresden', ClassName='Beginners', StartTime='09:59:00'.

LateStart '10:11:21': Id='1563', Name='Frank Edelhäuser', Org='Startuhr Dresden', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '10:12:35': Id=' 628', Name='Máté Mauer', Org='Gerecse Tájfutó Club', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '10:16:41': Id=' 935', Name='Mauro Spano', Org='Punto K Orienteering ASD', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '10:17:14': Id=' 631', Name='Gergő Major', Org='Gerecse Tájfutó Club', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '10:23:29': Id='1531', Name='Petra Kanakova', Org='OK Jihlava', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '10:25:48': Id='1461', Name='Martin Teichmann', Org='Sportunion Schöckl Graz', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '10:26:55': Id='1371', Name='Dima Gochkova', Org='NSA-SIVEN', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '10:29:33': Id='1462', Name='Christine Teichmann', Org='Sportunion Schöckl Graz', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '10:35:48': Id='1409', Name='Sandi Kmetič', Org='DROT', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '10:49:58': Id=' 240', Name='Magdalena Vodová', Org='', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '10:50:19': Id=' 407', Name='László Faggyas', Org='Veszpremi Honved Sportegyesulet', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '10:51:01': Id=' 939', Name='Enrico Pascatti', Org='Punto K Orienteering ASD', ClassName='OPEN A', StartTime='09:59:00'.

LateStart '10:57:41': Id=' 945', Name='Alessia Albano', Org='Punto K Orienteering ASD', ClassName='OPEN A', StartTime='09:59:00'.

LateStart '10:58:25': Id='1634', Name='Eemeli Hemminki', Org='Rasti-Kurikka', ClassName='OPEN A', StartTime='09:59:00'.

LateStart '10:59:13': Id='1384', Name='Remo Madella', Org='REM MAPS', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '10:59:34': Id='1643', Name='Konsta Räihä', Org='Navi', ClassName='OPEN A', StartTime='09:59:00'.

LateStart '10:59:50': Id=' 821', Name='Marko Prica', Org='SK MAGIC MAP', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '11:02:05': Id='1650', Name='Veeti Viippola', Org='Jämsän Retki-Veikot', ClassName='OPEN A', StartTime='09:59:00'.

LateStart '11:03:06': Id='1646', Name='Heikki Seväkivi', Org='SK Pohjantähti', ClassName='OPEN A', StartTime='09:59:00'.

LateStart '11:03:27': Id='1647', Name='Lauri Sorsa', Org='Kalevan Rasti', ClassName='OPEN A', StartTime='09:59:00'.

LateStart '11:03:50': Id='1638', Name='Vili Kantelinen', Org='Rasti-Kurikka', ClassName='OPEN A', StartTime='09:59:00'.

LateStart '11:04:08': Id='1644', Name='Joakim Savinainen', Org='Rasti-Kurikka', ClassName='OPEN A', StartTime='09:59:00'.

LateStart '11:04:11': Id='1637', Name='Niklas Hirvilahti', Org='Vehkalahden Veikot', ClassName='OPEN A', StartTime='09:59:00'.

LateStart '11:14:08': Id='1286', Name='Kamil Klíma', Org='Czech deaf team', ClassName='OPEN A', StartTime='09:59:00'.

LateStart '11:27:01': Id=' 999', Name='Tina Bjørnstad', Org='Aller Travel Orientering', ClassName='Beginners', StartTime='09:59:00'.

LateStart '11:27:27': Id=' 555', Name='Yana Bogya', Org='C.S. TranSilva Cluj', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '11:31:05': Id=' 252', Name='Gheorghe Cionoiu', Org='TV Coburg-Neuses', ClassName='OPEN A', StartTime='09:59:00'.

LateStart '11:32:09': Id=' 854', Name='Erik Zannier', Org='Punto K Orienteering ASD', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '11:35:03': Id=' 197', Name='Gašper Mihelič', Org='OŠ Stari Trg ob Kolpi', ClassName='Beginners', StartTime='09:59:00'.

LateStart '11:42:56': Id=' 93', Name='Anna Rita Bertolazzo', Org='Punto K Orienteering ASD', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '11:48:11': Id='1568', Name='Cyril Kolaja', Org='Slavia Liberec Orienteering', ClassName='M10 Shadowed', StartTime='09:59:00'.

LateStart '12:17:32': Id='1649', Name='Aaro Varvikko', Org='Espoon Akilles', ClassName='OPEN A', StartTime='09:59:00'.

LateStart '12:23:31': Id='1615', Name='Ivo Kete', Org='Planinsko Društvo Ajdovščina', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '12:24:03': Id=' 142', Name='Maria Micossi', Org='ASD TEAM SKY FRIUL', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '12:28:29': Id='1616', Name='Stanko Čufer', Org='Planinsko Društvo Ajdovščina', ClassName='OPEN B', StartTime='09:59:00'.

New CardNumber '2027940': Id=' 945', StartStatus='Late start', Name='Alessia Albano', Org='Punto K Orienteering ASD', OldCard='2106956'.

New CardNumber '8410087': Id=' 628', StartStatus='Late start', Name='Máté Mauer', Org='Gerecse Tájfutó Club', OldCard='2111507'.

OK (0):

Late (44):

DNS (14):

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 FinishType5 = 4 WHERE (FinishType5 = 0)
AND (Id IN (72, 141, 168, 251, 257, 284, 460, 682, 997, 1318, 1383, 1488, 1642, 1679));

-- LateStart: Reset FinishType to 0=NotSet, but only for people previously marked as 4=DNS
UPDATE OEvCompetitor SET FinishType5 = 0 WHERE (FinishType5 = 4)
AND (Id IN (93, 142, 197, 208, 240, 252, 407, 555, 568, 628, 631, 751, 821, 854, 935, 939, 945, 999, 1286, 1371, 1382, 1384,
    1409, 1461, 1462, 1486, 1518, 1519, 1531, 1562, 1563, 1568, 1615, 1616, 1634, 1637, 1638, 1643, 1644, 1646, 1647, 1649, 1650,
    1722));

-- ChipChange: Set NewChip, but only if OldChip and Id match and FinishType is 0=NotSet
UPDATE OEvCompetitor SET ChipNumber5=2027940 WHERE (Id= 945) AND (FinishType5=0) AND (ChipNumber5=2106956);
UPDATE OEvCompetitor SET ChipNumber5=8410087 WHERE (Id= 628) AND (FinishType5=0) AND (ChipNumber5=2111507);

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