O-Checklist YAML Parser

File='LO26op3.yaml'
Event='Lipica open 2026 Stage 3'
Creator='O Checklist v5.0', Created='2026-03-09T13:26:17+01:00'
Competitor identification mode: Id / Stage: 3 / Reset file-selection and start over

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Done. (81 items)

Warnings:

Comment 'Prepozna naključno številko čipa': Id=' 208', StartStatus='Late start', Name='Réka Kassay', Org='Watch Out Cluj', ClassName='OPEN C', StartTime='09:59:00'.

Comment 'Startal 9:34': Id=' 829', StartStatus='Late start', Name='Andras Simon', Org='Watch Out Cluj', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '09:59:15': Id=' 486', Name='Gabi Hoch', Org='Der Berger-Clan', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '10:01:02': Id=' 745', Name='Sebastian Geier', Org='Der Berger-Clan', ClassName='OPEN B', StartTime='09:59:00'.

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

LateStart '10:04:16': Id='1169', Name='Mario Paier', Org='WAT.OL', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '10:04:24': Id='1170', Name='Doris Gaar-Paier', Org='WAT.OL', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '10:06:22': Id=' 997', Name='Helge Inge Giil', Org='Aller Travel Orientering', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '10:10:33': Id=' 460', Name='Gianfranco Siega', Org='Friuli MTB & Orienteering ASD', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '10:11:02': Id=' 829', Name='Andras Simon', Org='Watch Out Cluj', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '10:15:27': Id=' 732', Name='Edit Laczka', Org='KiFutKI KTE', ClassName='OPEN C', StartTime='09:59:00'.

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

LateStart '10:16:32': Id=' 999', Name='Tina Bjørnstad', Org='Aller Travel Orientering', ClassName='Beginners', StartTime='09:59:00'.

LateStart '10:18:35': Id='1383', Name='Gregor Pavlič', Org='OK Azimut', ClassName='OPEN A', StartTime='09:59:00'.

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

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

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

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

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

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

LateStart '10:29:35': Id=' 729', Name='Péter Szűcs', Org='KiFutKI KTE', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '10:29:39': Id=' 731', Name='Kata Laurinyecz', Org='KiFutKI KTE', ClassName='OPEN C', StartTime='09:59:00'.

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

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

LateStart '10:36:35': Id=' 680', Name='Anett Dobroka', Org='MOM Budapest', ClassName='Beginners', StartTime='09:59:00'.

LateStart '10:36:39': Id=' 432', Name='Jana Velátová', Org='Orientační sporty Písek', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '10:41:43': Id=' 855', Name='Francesco Cibati', Org='Punto K Orienteering ASD', ClassName='OPEN A', StartTime='09:59:00'.

LateStart '10:46:25': Id=' 682', Name='Maddalena Zupin', Org='Punto K Orienteering ASD', ClassName='OPEN A', StartTime='09:59:00'.

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

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

LateStart '10:59:15': Id='1114', Name='Hana Buráňová', Org='BzB', ClassName='OPEN C', StartTime='09:59:00'.

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

LateStart '11:03:29': Id=' 748', Name='Gislind Berger', Org='Der Berger-Clan', ClassName='OPEN B', StartTime='09:59:00'.

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

LateStart '11:08:30': Id=' 284', Name='Fruzsina Biro', Org='Bimahev', ClassName='OPEN C', StartTime='09:59:00'.

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

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

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

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

LateStart '11:14:13': Id=' 758', Name='Karolina Stachoňová', Org='Expres Czech Team', ClassName='W10 Shadowed', StartTime='09:59:00'.

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

LateStart '11:17:27': Id=' 240', Name='Magdalena Vodová', Org='', ClassName='OPEN C', StartTime='09:59:00'.

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

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

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

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

LateStart '11:25:34': Id=' 251', Name='Michaela Cionoiu', Org='TV Coburg-Neuses', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '11:32:57': Id='1488', Name='Rasa Ivanauskaite', Org='Azuolas', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '11:43:52': Id=' 310', Name='Adrián Tóth', Org='Tipo Orienteering Club', ClassName='OPEN A', StartTime='09:59:00'.

LateStart '11:49:28': Id='1234', Name='Johanna Cart', Org='OLC Wienerwald', ClassName='OPEN C', StartTime='09:59:00'.

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

LateStart '11:57:30': Id=' 307', Name='Martin Tóth', Org='Tipo Orienteering Club', ClassName='OPEN B', StartTime='09:59:00'.

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

LateStart '12:03:01': Id=' 457', Name='Daniel Tomasin', Org='Friuli MTB & Orienteering ASD', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '12:04:11': Id=' 103', Name='Matyáš Ludvík', Org='TJ Stadion Novy Bor', ClassName='OPEN A', StartTime='09:59:00'.

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

LateStart '12:11:00': Id=' 102', Name='Anna Auermüllerová', Org='TJ Stadion Novy Bor', ClassName='OPEN A', StartTime='09:59:00'.

LateStart '12:26:10': Id=' 288', Name='Viktorie Trtlikova', Org='Expres Czech Team', ClassName='Beginners', StartTime='09:59:00'.

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

LateStart '12:29:18': Id='1409', Name='Sandi Kmetič', Org='DROT', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '12:39:17': Id='1233', Name='Simon Cart', Org='OLC Wienerwald', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '12:43:58': Id=' 306', Name='Katalin Kiss', Org='Tipo Orienteering Club', ClassName='Beginners', StartTime='09:59:00'.

LateStart '12:48:30': Id='1237', Name='Veronika Cart', Org='OLC Wienerwald', ClassName='OPEN B', StartTime='09:59:00'.

LateStart '12:56:45': Id=' 289', Name='Marketa Trtlikova', Org='Expres Czech Team', ClassName='Beginners', StartTime='09:59:00'.

New CardNumber '1311971': Id='1409', StartStatus='Late start', Name='Sandi Kmetič', Org='DROT', OldCard='7171717'.

OK (0):

Late (62):

DNS (19):

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 FinishType3 = 4 WHERE (FinishType3 = 0)
AND (Id IN (72, 141, 168, 257, 309, 393, 394, 539, 1634, 1637, 1638, 1642, 1643, 1644, 1646, 1647, 1649, 1650, 1679));

-- 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 (102, 103, 197, 208, 240, 251, 252, 284, 288, 289, 306, 307, 310, 407, 432, 457, 460, 486, 555, 568, 628, 631, 680,
    682, 729, 731, 732, 745, 748, 751, 758, 821, 829, 854, 855, 939, 945, 997, 999, 1114, 1169, 1170, 1233, 1234, 1237, 1286, 1371,
    1382, 1383, 1384, 1409, 1461, 1486, 1488, 1518, 1519, 1531, 1562, 1563, 1568, 1615, 1616));

-- ChipChange: Set NewChip, but only if OldChip and Id match and FinishType is 0=NotSet
UPDATE OEvCompetitor SET ChipNumber3=1311971 WHERE (Id=1409) AND (FinishType3=0) AND (ChipNumber3=7171717);

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