Automatic generation of league matches for a season

twoccer , January 27 2022, 05:53
T
twoccer 16
January 27 2022, 05:53 #209
Hi There,
I subscribed to the football manager modules and setting up my teams, leagues and seasons.
I'm just wondering, is it possible auto-generate all league matches of a season when the teams are added, or do I have to add every match manually?
marco 400
January 27 2022, 15:50 #210
Hi twoccer
First of all thank you for your purchase of the FootballManager pro modules. Even if those modules will make your life (with footballmanager offcourse) easier there is currently no such function for "game scheduling" included. I had other customers asking for the same features in the past - the reason why its (not yet) available its simple: its "just" a question of time... To develop such a functionality (on my own) is very time consuming at least you have to check a lot of things to create usefull auto schedules. And to be honest there are a lot of very good applications on the market that creates schedules. But its something i have on the list for the future for FootballManager after a stable Joomla 4 Version. Also there is a plan to add a "guided" option to add teams / games to the component.
In the meantime this might be helpfull for you, because this is what I've done so far (and other users too):

Using import export feature

Like every data-driven application the sections in FootballManager are linked between each others – so import / export are RAW. Let’s say you have created Team A and Team B in the application, when you use the export you can see that team A and B has its own ID So Team A has an ID of “1” and Team B an ID of “2” and so on… the same goes for players, locations, sponsors, etc.

When you now create a game and select Team A vs. Team B on Location X and do an export of this you will get an excel with the following information:

Home Away Location kickoff Sponsor

1 2 1 2021-06-06 14:00 99

The game table only contains the raw values of these data. So best practice  (and what I’ve done so far) would be:

First create a demo team in FootballManager and export this, you will get an excel sheet with two rows (header and demo team info) checkout the excel and fill in all your teams into this excel  row by row, do not set an ID (leave the id column blank - its autofilled).

In general you can ignore columns for id,created,modified,hits,access,ordering, and probably others too… most of them will be auto generated when you do something in FM with this teams. The only thing you should not forget is to always set an unique alias – this is important for the joomla system.

Then Import this excel into FM via footballmanager > teams > import (top menu)

Now you have your teams and you can do another export to have an excel sheet including the ID’s (so yes export the whole list of teams now to have a cheatsheet for the task below)

<<< From here on it could be important for you >>>

Now do the same with events – create a demo event and export this to have a blueprint of the needed data. Fill in all the required data directly in excel &nbsp;row by row – game by game. So when Team B plays vs. Team A you will enter the ID’s for this teams.

Alternatively you could copy / paste your schedule into this sheet and move the columns to the right place - then bulk search and replace Team Names with ID’s (or when you know how to do it let Excel do this for you with mapping – Do you remember, you have the Id’s in the exportet (cheat)sheet from above. The only thing you have to worry about is the “date formatting” of excel. Dates has always to be database like yyyy-mm-dd hh:mm:ss. I know it sounds like a lot of work and yes with 600 teams or more for example its a lot of work, but keep in mind: next year you only have to worry about the schedule table itself, all the teams are already in the database. And when you ha some Excel Know how its easy to do such bulk changes for data.

Hope this helps a bit
kind regards
Marco
---------

Rate us on JED: https://extensions.joomla.org/profile/profile/details/379934

---------
T
twoccer 16
January 28 2022, 07:57 #211
Hi Marco,

Thanks for your reply.

I’m working with 3 leagues of 20 teams so that is 380 games per league per season to set up. It's a lot of work and easy to make mistakes.

I did figure out that using the excel sheet saves some time. I actually installed the dj-league extension, added the teams there, automatically generated the whole season, which gave me the same team id’s. I then copied these to the excel sheet and uploaded it.

It’s a bit confusing to manually finish the setup, but save a lot of time.

marco 400
January 28 2022, 11:37 #213
Hi
yeah i'm aware of that - I receive all Schedules already in Excel so for me it was no big deal in the past - but i see that you might be the person who creates the schedule and then it would be nice to have such an option.
I will have a look into that
kind regards
---------

Rate us on JED: https://extensions.joomla.org/profile/profile/details/379934

---------
D
Domenick027 2
April 19 2022, 20:38 #295
I think we have the same request, I am running 2 leagues of 37 teams, Can i have your contact such as whatsapp, twitter, telegram, email or something you're using. So we can share experience.
D
Domenick027 2
April 19 2022, 20:41 #296
I currently have more than 800 players. I hope they can log in to the website and manage their players - join the team, transfer, etc. if they are the captain, they can report the score through the front end. Can these functions be realized? I sent you a message through Facebook and look forward to your reply. Cheers bro
marco 400
April 20 2022, 09:47 #298
Hi Domenick027
First of all i will close this Thread - because otherwise twoccer will receive notifications - I will answer your questions in this thread here: https://nx-designs.ch/support/supportforum/posts/t78/user-based-frontend-game-management
---------

Rate us on JED: https://extensions.joomla.org/profile/profile/details/379934

---------