O-Checklist YAML Parser

File='LO26op1.yaml'
Event='Lipica open 2026 Stage 2'
Creator='O Checklist v4.3.0', Created='2026-03-08T10:09:02+01:00'
Competitor identification mode: Id / Stage: 2 / Reset file-selection and start over

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Done. (169 items)

Warnings:

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

LateStart '09:59:12': Id='1180', Name='Michaela Egarter', Org='OC Fürstenfeld', ClassName='Beginners', StartTime='09:59:00'.

LateStart '09:59:18': Id='1673', Name='Christa Paar-Zapf', Org='OC Fürstenfeld', ClassName='OPEN C', StartTime='09:59:00'.

LateStart '09:59:24': Id='1671', Name='Manfred Zapf', Org='OC Fürstenfeld', ClassName='OPEN C', StartTime='09:59:00'.

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

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

LateStart '10:04:09': Id='1689', Name='Matthias Friessnig', Org='OC Fürstenfeld', ClassName='OPEN A', StartTime='09:59:00'.

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

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

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

OK (0):

Late (10):

DNS (159):

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 (69, 72, 80, 87, 88, 93, 95, 136, 141, 146, 147, 148, 150, 157, 158, 159, 162, 163, 164, 165, 166, 168, 173, 208,
    235, 240, 251, 252, 257, 270, 279, 284, 287, 288, 289, 291, 307, 309, 330, 331, 332, 351, 369, 373, 384, 393, 394, 407, 432,
    437, 438, 457, 487, 522, 531, 532, 533, 539, 555, 568, 595, 596, 597, 599, 601, 603, 628, 631, 636, 673, 680, 681, 682, 683,
    684, 729, 730, 731, 732, 733, 745, 751, 758, 815, 821, 829, 854, 855, 935, 939, 945, 946, 950, 997, 999, 1039, 1041, 1054, 1114,
    1141, 1146, 1147, 1149, 1150, 1151, 1152, 1153, 1154, 1155, 1156, 1157, 1169, 1170, 1203, 1204, 1214, 1233, 1234, 1237, 1255,
    1270, 1286, 1287, 1295, 1318, 1349, 1371, 1375, 1384, 1405, 1409, 1461, 1486, 1488, 1510, 1518, 1519, 1531, 1562, 1563, 1568,
    1615, 1616, 1617, 1660, 1665, 1666, 1667, 1668, 1674, 1679, 1683, 1685, 1686, 1687, 1690, 1693, 1694, 1695));

-- LateStart: Reset FinishType to 0=NotSet, but only for people previously marked as 4=DNS
UPDATE OEvCompetitor SET FinishType2 = 0 WHERE (FinishType2 = 4)
AND (Id IN (197, 460, 486, 748, 1180, 1382, 1383, 1671, 1673, 1689));

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