• Resolved bsebire

    (@bsebire)


    I understand I can import events, fixtures, etc and this works quite well for current events & fixtures. I have many years of player statistics which include no of games, goals etc separated by Season. As an example I have the no of games and goals recorded for Tom Smith separated by Season 2000, 2001 and so on. I do not have the event information for this historical data. Is there a way I can do a historical import so that I can get career totals for players over a number of seasons, without creating a separate event for each record ?

Viewing 15 replies - 1 through 15 (of 15 total)
  • @bsebire

    Do you want to assign statistics for each player to display on a game by game basis ?
    Or just their overall statistics – games played, goals, assists, etc,etc ?

    Roch

    (@rochesterj)

    Good questions, corrinarusso

    I myself would either add a dummy event with all your data and add events played as one of the fields there as well. Then simply ignore SportsPress’ field for events played and use your own custom field for the averages calculations.

    Thanks!

    Thread Starter bsebire

    (@bsebire)

    @corrinarusso

    For my historical stats I dont need to display them on a game by game basis, but I would like to separate them by Season. I’m only looking to capture games played and goals, although these are broken down teams – Seniors, reserves, under 19’s.

    The example below shows the data I have
    Season Player Senior Games Senior Goals reserve Games Reserve Goals
    2001 John Smith 13 22 5 9
    2002 John Smith 17 35 1 3

    It would take too long to try and recreate an event for each game played.

    Roch

    (@rochesterj)

    Hi!

    You could create one dummy event per season then.

    You can even use Excel and our CSV importer to help you with that:
    https://support.themeboy.com/article/304-csv-importers

    Thanks!

    Thread Starter bsebire

    (@bsebire)

    Yes I think that would work. I have tried the import but it doesnt seem to recognise players as playing multiple games or have kicked goals in different games when they are mentioned mulitple times. Do you have a file format I should use ? Or is the event sample the way I should go ? Can you post me an example file please ?

    Thread Starter bsebire

    (@bsebire)

    I think the issue I have is that for historical data I dont have it broken down by individual events (games). My data only has a total for each season eg.
    2016 John Smith 13 Senior Games, 5 Senior goals, 6 reserve games, 3 reserve Goals

    If you have a way to import this format I’d be interested please.

    Thread Starter bsebire

    (@bsebire)

    I am trying to solve it as a different version error

    In player statistics, for example;
      He played Team A of the 2019 season and Team B in 2020.
    2 goals in 2019 Season A Team
    1 goal in 2020 Season B Team
    The past season does not show, since his career was only the filter for the last season for club information.
    If I want to show 2019, I added the 2019 and 2020 season for the club, the player career has improved.
    This solution was played in the 1st Amateur Group B of the club 2019 season and the 1st Amateur Group A in the 2020 season, but both the 1st Amateur A and the 1st Amateur B group leagues in the 2019 and 2020 seasons as the league did not distinguish between the season. he adds to his tables.
    System design has to be done according to the season. Each season should be in the form of clubs, leagues, players and league tables.
    If archiving of the Sportpress leagues in the form of season start and end, it seems to remove this error.

    Roch

    (@rochesterj)

    Hi @bsebire

    So, my suggestion was to have a single event with all the player data. So, for example if a player had 13 goals and 20 games in season 2000 you’d add them all in a single game.

    The “games played” would be a custom metric the same way goals are. Thus, in your metrics you’d ignore the system events played stat and use your own custom stat.

    Let me know if it’s clearer now.

    Thanks!

    Thread Starter bsebire

    (@bsebire)

    Thanks Roch, I’ll give it a go

    Thread Starter bsebire

    (@bsebire)

    Ok, just to make sure I’m on the right path. I’ve created a player performance field called Games Test. I’m assuming I can import my historical games data into this field together with the goals from each previous season. I’ve then modified the Games Played player statistic field to use the formula gamestest + eventsplayed. This should give me a total of historical games played plus moving forward each new event they play in. Hope this makes sense.

    Roch

    (@rochesterj)

    Hi!

    That’s a great solution. This will work for historical data as well as new data.

    Maybe you’ll need just one adjustment, in case a player has gamestest they will have one more game than they should (as you will need the actual dummy event to store data).

    For example, let’s say you are importing data for John. He has 5 games to be imported (in a single game) and he played 3 more in your current season (regular SP events).

    So his variables are:
    gamestest = 5
    eventsplayed = 3 + 1 (3 games plus the dummy event)

    This will mess up your averages.

    There are two ways to fix it. The first one is simpler, but not something I’d go for (as it can cause some issues in case you forget it, or someone else sees it). It would be adding one less event in the gamestest than it should be. So instead of importing gamestest as 5, you’d import it as 4.

    The second and better way to do it is by using a formula.

    ( gamestest > 0 ) * -1 + gamestest + eventsplayed

    The first portion of this formula simply says:
    if gamestest is greater than one, add -1 to the result. Which is how to translate that adjustment into an equation.

    I hope this makes sense 🙂

    Let me know how it works for you.

    Thanks!

    Thread Starter bsebire

    (@bsebire)

    Thanks Roch, I will test in coming days. Hopefully we can get this right and then open up to many other Australian Rules Football clubs.

    I have a couple of other questions please. I notice on the individual player pages if I link each player to all previous seasons then I can manually add the historical games and goals. Is there a way to import into the player pages ? This would solve all my problems.

    I’m still a little confused as the best way to setup the system. The Club plays in B Grade of the Victorian Amateur Football Association. This is setup as League = VAFA B Grade. My Club is Parkdale Vultures and is setup as a team. The Club has 3 teams Seniors, Reserves & Under 19’s. I have set these up as Leagues also but with the Parent VAFA B Grade. For our records I need to distinguish by Club records (a total of all games and goals for all teams) and then Senior records (a total of all games and goals in the Senior & reserves teams only). Is this the best way to set these up please ?

    Roch

    (@rochesterj)

    Hi!

    Thanks for your reply.

    Please keep in mind that it’s much better if you open new topics for each of your questions.

    Unfortunately no, there isn’t a way to import stats into the player profiles, the best way is using the events indeed.

    Regarding your other question, please let’s discuss it on another topic. That may get too long for this one 🙂

    Thanks!

    Roch

    (@rochesterj)

    Hi!

    I’ll mark this one as resolved for now.

    If you need anything else, just let us know.

    Thanks!

Viewing 15 replies - 1 through 15 (of 15 total)

The topic ‘Player Statistics’ is closed to new replies.