O-Checklist YAML Parser

File='skof2.yaml'
Event='Orientacija GZ Škofljica Stage 1'
Creator='O Checklist v4.2.1', Created='2025-05-31T12:03:51+02:00'
Competitor identification mode: Id / Stage: 1 / Reset file-selection and start over

. . . . . . . . . . . . . . . . . . . .
Done. (39 items)

Warnings:

Comment ']': Id=' 144', StartStatus='Started OK', Name='SOFIA , ELA , VITA ŠKOFLJICA 2', Org='ŠKOFLJICA ', ClassName='PIONIRKE', StartTime='12:29:00'.

LateStart '11:44:50': Id=' 50', Name='FILIP, JAKOB, NEJC DOLNJE RETJE 2', Org='VELIKE LAŠČE', ClassName='MLADINCI', StartTime='09:51:00'.

New CardNumber ' 235875': Id=' 126', StartStatus='Started OK', Name='SARA , LUCIJA , TJAŠA GOLO', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2037285': Id=' 113', StartStatus='Started OK', Name='BOR SVARUN, KAJA , LARA IG', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2099761': Id=' 102', StartStatus='Started OK', Name='NEŽA , NEŽA , KAJA IŠKA VAS 1', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2099763': Id=' 108', StartStatus='Started OK', Name='GAŠPER , LUKA , ŽIGA IŠKA VAS', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2099764': Id=' 145', StartStatus='Started OK', Name='NEJC , ERAZEM , REBEKA ŠKRILJE', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2099767': Id=' 123', StartStatus='Started OK', Name='AJDA , TARA , JAKOB GOLO 1', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2099775': Id=' 127', StartStatus='Started OK', Name='NEJA , EVA , IZA KOT - STAJE', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2099776': Id=' 139', StartStatus='Started OK', Name='TILEN , TIM , JAN ŠKRILJE 1', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2099779': Id=' 144', StartStatus='Started OK', Name='SOFIA , ELA , VITA ŠKOFLJICA 2', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2099780': Id=' 119', StartStatus='Started OK', Name='EMA , SARA , NEJA IG', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2099782': Id=' 148', StartStatus='Started OK', Name='JAKOB , MATEJ , TRISTAN ŠKRILJE 2', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2099783': Id=' 143', StartStatus='Started OK', Name='NEŽA , PETJA , NINA ŠKRILJE 1', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2099784': Id=' 50', StartStatus='Late start', Name='FILIP, JAKOB, NEJC DOLNJE RETJE 2', Org='VELIKE LAŠČE', OldCard=''.

New CardNumber '2099789': Id=' 112', StartStatus='Started OK', Name='LOVRO , MATEJ , TIM IŠKA VAS 1', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2106964': Id=' 134', StartStatus='Started OK', Name='ŽIGA , MATIC , TJAŠA ŠKRILJE 2', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2106968': Id=' 140', StartStatus='Started OK', Name='OSKAR , ŽAN , JAN GOLO', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2106969': Id=' 141', StartStatus='Started OK', Name='LIA , MIHA , DEAN ŠKRILJE 3', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2106970': Id=' 132', StartStatus='Started OK', Name='ŽIGA , DAVID , NEJC GOLO', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2106972': Id=' 125', StartStatus='Started OK', Name='MANCA , LARISA , ESTEL ŠKRILJE 1', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2106981': Id=' 116', StartStatus='Started OK', Name='ŽAN , ŽAN , ŽAN IŠKA VAS 2', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2106992': Id=' 135', StartStatus='Started OK', Name='JAN , TIM , TOM MATENA 1', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2106995': Id=' 138', StartStatus='Started OK', Name='ANJA , LEA , LARA ŠKRILJE 5', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2107904': Id=' 122', StartStatus='Started OK', Name='INJA , GABRIJELA , LEA MATENA', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2107905': Id=' 121', StartStatus='Started OK', Name='ŠPELA , MAŠA , JULIJA ŠKRILJE', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2107906': Id=' 124', StartStatus='Started OK', Name='MONIKA , ALJA , MINJA IG 1', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2107907': Id=' 129', StartStatus='Started OK', Name='ALJAŽ , ANTON , IZAK ŠKRILJE', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2107908': Id=' 111', StartStatus='Started OK', Name='TINKARA , DAŠA , ADAM KOT - STAJE 1', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2107910': Id=' 136', StartStatus='Started OK', Name='SVIT , IZAK , ANDREJ KOT - STAJE 2', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2107914': Id=' 142', StartStatus='Started OK', Name='RUBI , KARLA , ANJA GOLO', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2107915': Id=' 128', StartStatus='Started OK', Name='SAMO , MAJ , DOMEN ŠKRILJE 1', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2107916': Id=' 133', StartStatus='Started OK', Name='TAMARA , ANJA , MIA IŠKA VAS', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2107917': Id=' 109', StartStatus='Started OK', Name='ENCIJAN , MATIC , JAKOB KOT - STAJE', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2107920': Id=' 147', StartStatus='Started OK', Name='BRINA , PINA , LARA ŠKRILJE', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2107925': Id=' 110', StartStatus='Started OK', Name='REBEKA , ZALA , TJAŠA MATENA', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2114432': Id=' 101', StartStatus='Started OK', Name='ŠPELA , ANJA , ANA IG', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2214890': Id=' 131', StartStatus='Started OK', Name='GAŠPER , ALEN , TADEJ GOLO', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2214895': Id=' 146', StartStatus='Started OK', Name='EMA , LANI , NAJA ORLE', Org='ŠKOFLJICA ', OldCard=''.

New CardNumber '2214901': Id=' 105', StartStatus='Started OK', Name='JAN , URŠA , ANŽE MATENA', Org='IG PRI LJUBLJANI', OldCard=''.

New CardNumber '2214916': Id=' 104', StartStatus='Started OK', Name='MAJ , GAL , TIM MATENA', Org='IG PRI LJUBLJANI', OldCard=''.

OK (38):

Late (1):

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 FinishType1 = 0 WHERE (FinishType1 = 4)
AND (Id IN (50));

-- ChipChange: Set NewChip, but only if OldChip and Id match and FinishType is 0=NotSet
UPDATE OEvCompetitor SET ChipNumber1= 235875 WHERE (Id= 126) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2037285 WHERE (Id= 113) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099761 WHERE (Id= 102) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099763 WHERE (Id= 108) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099764 WHERE (Id= 145) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099767 WHERE (Id= 123) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099775 WHERE (Id= 127) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099776 WHERE (Id= 139) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099779 WHERE (Id= 144) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099780 WHERE (Id= 119) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099782 WHERE (Id= 148) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099783 WHERE (Id= 143) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099784 WHERE (Id=  50) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2099789 WHERE (Id= 112) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106964 WHERE (Id= 134) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106968 WHERE (Id= 140) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106969 WHERE (Id= 141) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106970 WHERE (Id= 132) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106972 WHERE (Id= 125) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106981 WHERE (Id= 116) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106992 WHERE (Id= 135) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2106995 WHERE (Id= 138) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107904 WHERE (Id= 122) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107905 WHERE (Id= 121) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107906 WHERE (Id= 124) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107907 WHERE (Id= 129) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107908 WHERE (Id= 111) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107910 WHERE (Id= 136) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107914 WHERE (Id= 142) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107915 WHERE (Id= 128) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107916 WHERE (Id= 133) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107917 WHERE (Id= 109) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107920 WHERE (Id= 147) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2107925 WHERE (Id= 110) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2114432 WHERE (Id= 101) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214890 WHERE (Id= 131) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214895 WHERE (Id= 146) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214901 WHERE (Id= 105) AND (FinishType1=0) AND (ChipNumber1 IS NULL);
UPDATE OEvCompetitor SET ChipNumber1=2214916 WHERE (Id= 104) AND (FinishType1=0) AND (ChipNumber1 IS NULL);

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