Saturday, August 21, 2010

1st Round of Data Uploads Complete!!

I finished the basic data upload today for all 19 World Cups, uploading all the teams and every game and result, along with the group tables and playoff brackets. I'm going to work with this data for a little while, before I go back to loading in the players and individual goal scorers.

This was quite challenging for some of the earlier tournaments, as all tournaments before 1994 you only got 2 points for a win, World Cup's 1950 and 1938 had some withdrawn teams, 1954 had group playoff games if teams finished with the same number of points,and the hardest problem, 1938 playoff games did not go to penalties, they replayed the game a few days later. I managed to solve most of the issues without changing the database, but I will have to spend some time on the website to show these exceptions correctly. Playoff replays are going to be the worst, mostly because there is just not that much room on the playoff table...







No comments:

Post a Comment