Fixtures xml

[IjonTihy]

Hallo.

Welches XML-Dateiformat wird für die Vorbereitung von Liga-Spieltagen verwendet? Wie erstellt man eine solche Datei?

Bestehende Spielpläne werden zwar exportiert, aber Änderungen an der Datei führen zu der Fehlermeldung: Die Datenbank enthält keine Spielpläne.

Beim Versuch, die exportierte Datei im Webbrowser zu öffnen, wird eine Fehlermeldung zur Kodierung angezeigt („error on line 2 at column 124: Encoding error).

[vmLOGIC]

Wovon genau sprichst du?

[IjonTihy]

Datei -> Ansetzungsschluessel ->  Ansetzungsschluessel importieren = the program needs an xml file.

What should the structure of this file be?

I used the "Markierten Ansetzungsschluessel exportieren" option to export one of the existing fixture schemas (I have databases downloaded from https://www.dfs-datenbanken.info/cont/index.php). I received an XML file, but after I edit it (simple change the teams in pairs; in Notepad++) when I try to import it back into the program, it claims that the file doesn't contain the correct data (Die Datei enthält keinen gültigen Anstellungsschlüssel). Is it a matter of checksum?


PS. It would be easiest if the program accepted simple Excel files with pairs of matches in subsequent lines...
PPS. I would use screenshots but this forum doesn't allow posting images other than those from external urls

[vmLOGIC]

Ein Ansetzungsschlüssel wird auf Basis des Spielplans einer bereits erfassten Saison erstellt. Import/Export ist lediglich dazu vorgesehen, einen Ansetzungsschlüssel von einer Datenbank in eine andere zu transportieren. Die XML-Datei dient lediglich dem Transport und nicht dazu gedacht, darin Änderungen vorzunehmen.

[IjonTihy]

I understand.

So how can I create a fixtures that I can use multiple times in different leagues? The author of the database I downloaded created such a fixture...

[vmLOGIC]

Hier - ganz oben - findest du den Link zur Doku. Suche dort nach "Ansetzungsschlüssel".

[IjonTihy]

There's no answer to my question there. (Or maybe I don't see it, which is possible with automatic translation.)

I don't want to know how to convert manually created all-season fixtures into a schema (for reuse in another season). I'll only do this if it turns out there's no easier way.
I'm interested in preparing a schema outside of the program and importing it into the program - so that I can simply assign numbers to the teams in the first round to complete the entire season.

I don't know if I'm explaining this clearly (the fact that English isn't our first language probably doesn't help):

From what I read in the doc, I have to manually create matches, matchday by matchday. 34 matchdays. And then I can export them as a template.

But what I want is to take the complete fixtures from my files or website, put them into Excel, convert the club names to numbers, and get a ready-made template. Manually convert it to xml, import it into the program, and then I only need to manually set the first round. Just like with the ready-made DFB templates.

This is especially useful when a given fixture scheme was used only in one season - then the export option makes no sense because I won't use the scheme again anyway.

[vmLOGIC]

From what I read in the doc, I have to manually create matches, matchday by matchday. 34 matchdays. And then I can export them as a template.

Exactly. There’s nothing else.

[bignike]

IjonTihy

You don’t have to manually enter all 34 matchdays for every single season.
There’s a way to copy the second half of the season ("Rückrunde") and simply swap the home/away teams. Most likely, the matchday pattern (match schedule key or "Spielschlüssel") remains the same each year.
So you only need to enter the first 17 matchdays, then copy them and swap the home advantage. Of course, you may still need to adjust the exact match dates afterwards.
In my case, for example, the first matchday of the copied second half was always the last matchday of the season — meaning that the opening fixtures were the same as the final round. Because of that, I had to manually move the first Rückrunde matchday to the end. But after that, everything lined up correctly.
Then you can save this full 34-matchday schedule as your "Spielschlüssel" (schedule key).
In the next season, you simply generate the schedule using this saved key. It works like a puzzle: for example, which team is the only one to have a home game in both matchdays 2 and 3? Click on the team on the right side and assign the correct number, etc.
Of course, promoted or relegated teams won’t be in your existing team list, so you can temporarily use a “placeholder” team that has left the league. Later, just use the “replace team” function to swap it with the correct one.

--
Nie musisz ręcznie wprowadzać wszystkich 34 kolejek na każdy sezon.
Istnieje sposób, aby skopiować drugą połowę sezonu („Rückrunde”) i po prostu zamienić drużyny gospodarzy z gośćmi. Najprawdopodobniej wzór kolejek (klucz terminarza, czyli „Spielschlüssel”) pozostaje taki sam co roku.
Wystarczy więc wprowadzić pierwsze 17 kolejek, następnie je skopiować i zamienić gospodarzy z gośćmi. Oczywiście później może być konieczne ręczne dostosowanie dokładnych dat meczów.
W moim przypadku, na przykład, pierwsza kolejka skopiowanej rundy rewanżowej była zawsze ostatnią kolejką sezonu — co oznaczało, że mecze otwierające sezon były identyczne z tymi z ostatniej rundy. Z tego powodu musiałem ręcznie przenieść pierwszą kolejkę Rückrunde na koniec. Po tym wszystko się już zgadzało.
Następnie możesz zapisać ten pełny terminarz 34 kolejek jako swój „Spielschlüssel” (klucz terminarza).
W kolejnym sezonie po prostu generujesz terminarz, używając tego zapisanego klucza. Działa to jak układanka: na przykład, która drużyna jako jedyna gra u siebie zarówno w 2., jak i 3. kolejce? Klikasz na drużynę po prawej stronie i przypisujesz odpowiedni numer, itd.
Oczywiście drużyny awansujące lub spadające nie będą na Twojej aktualnej liście drużyn, więc możesz tymczasowo użyć „drużyny-zamiennika”, która opuściła ligę. Później po prostu skorzystaj z funkcji „zamień drużynę”, aby podmienić ją na właściwą.

[IjonTihy]

From what I read in the doc, I have to manually create matches, matchday by matchday. 34 matchdays. And then I can export them as a template.

Exactly. There’s nothing else.

Understood. Too bad, but ok.

[IjonTihy]

IjonTihy

You don’t have to manually enter all 34 matchdays for every single season.
There’s a way to copy the second half of the season ("Rückrunde") and simply swap the home/away teams. Most likely, the matchday pattern (match schedule key or "Spielschlüssel") remains the same each year.
So you only need to enter the first 17 matchdays, then copy them and swap the home advantage. Of course, you may still need to adjust the exact match dates afterwards.
In my case, for example, the first matchday of the copied second half was always the last matchday of the season — meaning that the opening fixtures were the same as the final round. Because of that, I had to manually move the first Rückrunde matchday to the end. But after that, everything lined up correctly.
Then you can save this full 34-matchday schedule as your "Spielschlüssel" (schedule key).
In the next season, you simply generate the schedule using this saved key. It works like a puzzle: for example, which team is the only one to have a home game in both matchdays 2 and 3? Click on the team on the right side and assign the correct number, etc.
Of course, promoted or relegated teams won’t be in your existing team list, so you can temporarily use a “placeholder” team that has left the league. Later, just use the “replace team” function to swap it with the correct one.

Yes, I know. The only problem is that the method for copying half a season described in the manual doesn't work. I mean, if I check 17 matchdays, select the start date for the beginning of the round and then check box "reverse home teams", the program hangs. Well it's possible that it works but very slowly, but after over half an hour I'm tired of waiting because it's faster to do it manually. As a result, I'm only copying 17 matchdays with the new starting date, but without reversing the home team - and that takes the program only a few seconds. Then I manually reverse the home team for each matchday separatedly.

[bignike]

Did you select all matchdays? Then click "Copy" and make sure that your time period allows the dates to be entered.
Then, when copying, enter the date of the first matchday of the second half of the season at the top, set the time to 00:00 and the days to 1.
Then select "Swap home rights" and most importantly, choose "Insert after the last matchday" (click the option below the two icons), and then click OK.
If a message appears saying the match date is outside the time period, confirm with "Yes" when asked if you want to copy the selected matchdays anyway.
For me, copying 17 matchdays for the second half of the season takes just about 10 seconds, no more.


Zaznaczyłeś wszystkie kolejki? Następnie kliknij „Kopiuj” i upewnij się, że wybrany przedział czasowy pozwala na wprowadzenie nowych dat.
Podczas kopiowania wpisz datę pierwszej kolejki rundy rewanżowej na górze, ustaw godzinę na 00:00 i liczbę dni na 1.
Następnie zaznacz opcję „Zamień gospodarzy” i — co najważniejsze — wybierz „Wstaw za ostatnią kolejką” (kliknij opcję pod dwoma ikonami), a potem kliknij OK.
Jeśli pojawi się informacja, że termin meczu wykracza poza dozwolony przedział czasu, potwierdź, klikając „Tak”, gdy zapyta, czy chcesz mimo to skopiować zaznaczone kolejki.
U mnie kopiowanie 17 kolejek rundy rewanżowej trwa około 10 sekund, nie więcej.

[IjonTihy]

Did you select all matchdays? Then click "Copy" and make sure that your time period allows the dates to be entered.
Then, when copying, enter the date of the first matchday of the second half of the season at the top, set the time to 00:00 and the days to 1.
Then select "Swap home rights" and most importantly, choose "Insert after the last matchday" (click the option below the two icons), and then click OK.
If a message appears saying the match date is outside the time period, confirm with "Yes" when asked if you want to copy the selected matchdays anyway.
For me, copying 17 matchdays for the second half of the season takes just about 10 seconds, no more.

Yes - that is what I'm doing. But the moment I press option "Swap home rights" the program starts... well, thinking, because you can see the processor activity in Task Manager. But the longest I waited was a little over half an hour and nothing changed.

Hmm, okay, not exactly like that - I'm setting the date of first matchday of the second half of the season, but I'm setting the time to 4:00 PM and the number of days to 7. If I do it as you say ( 00:00 and the number of days to 1), I'll have to manually change each round's date&time anyway. So I might as well manually change the home rights.