Graphics

 View Only
  • 1.  DataLinq with NCAA stats, starters and jersey numbers

    Posted 01-09-2024 11:37

    Hey! I am trying to figure out the best way to populate the names of players by jersey number and starters automatically. Currently, I am using this, which becomes an issue once there is a gap in player numbers. I believe this is a simple thing, but I am not 100% sure! I want to pull the starting 5 automatically using oncourt=Y and also pull names by using the uni box. Any ideas?



    ------------------------------
    Philip Doherty
    Elon University
    ------------------------------


  • 2.  RE: DataLinq with NCAA stats, starters and jersey numbers

    Ross Staff
    Posted 01-09-2024 11:48

    Have an object that looks up the on-field like this;



    ------------------------------
    Simon Redmile
    Senior Graphic Programmer & Designer
    Ross Video
    Bristol United Kingdom
    ------------------------------



  • 3.  RE: DataLinq with NCAA stats, starters and jersey numbers

    Posted 01-09-2024 11:56

    I am not sure mine is exactly formatted that way, I'll send how a typical player is formatted. Sorry, I'm relatively new to this!

     <player uni="1" code="1" name="Hill, Jami" checkname="HILL,JAMI" class="FR" gp="0" gs="0" pos="G" oncourt="N">
          <stats fgm="0" fga="0" fgm3="0" fga3="0" ftm="0" fta="0" tp="0" blk="0" stl="0" ast="0" min="0" oreb="0" dreb="0" treb="0" pf="0" tf="0" to="0" dq="0" fgpct="0" fg3pct="0" ftpct="0">
          </stats>
        </player>



    ------------------------------
    Philip Doherty
    Elon University
    ------------------------------



  • 4.  RE: DataLinq with NCAA stats, starters and jersey numbers

    Ross Staff
    Posted 01-09-2024 12:00

    I think that this will work;

    team<vh=H>\player<oncourt=Y>



    ------------------------------
    Simon Redmile
    Senior Graphic Programmer & Designer
    Ross Video
    Bristol United Kingdom
    ------------------------------



  • 5.  RE: DataLinq with NCAA stats, starters and jersey numbers

    Posted 01-09-2024 12:04

    This does work! Thank you very much.

    If I want to use this to pull the highest scorers and such, how would I do that?



    ------------------------------
    Philip Doherty
    Elon University
    ------------------------------



  • 6.  RE: DataLinq with NCAA stats, starters and jersey numbers

    Ross Staff
    Posted 01-09-2024 12:06

    Highest scores or what?



    ------------------------------
    Simon Redmile
    Senior Graphic Programmer & Designer
    Ross Video
    Bristol United Kingdom
    ------------------------------



  • 7.  RE: DataLinq with NCAA stats, starters and jersey numbers

    Posted 01-09-2024 12:08

    Yeah! Like the top 5 scorers for each team for example.



    ------------------------------
    Philip Doherty
    Elon University
    ------------------------------



  • 8.  RE: DataLinq with NCAA stats, starters and jersey numbers

    Ross Staff
    Posted 01-09-2024 12:10

    I think this video is what you're after but let me know if not.

    https://www.rossvideo.com/resources/ross-university/xpression-visual-logic-sort-selector-function-block/#:~:text=A%20Sort%20Selection%20function%20block,Function%20Blocks%20and%20Object%20Blocks. 



    ------------------------------
    Simon Redmile
    Senior Graphic Programmer & Designer
    Ross Video
    Bristol United Kingdom
    ------------------------------



  • 9.  RE: DataLinq with NCAA stats, starters and jersey numbers

    Posted 01-09-2024 12:46

    It is somewhat what I am after. The main issue is that I don't want to have a million different text objects for each player, instead, I would love if I could automatically pull it from datalinq. Like I would love to be able to point it to the "fgm" stat for each player, and then allow me to increment the outputs to just pull the name, number, and fgm for the top 5. I would like to minimize the amount of visual logic needed.



    ------------------------------
    Philip Doherty
    Elon University
    ------------------------------



  • 10.  RE: DataLinq with NCAA stats, starters and jersey numbers

    Ross Staff
    Posted 01-09-2024 14:13

    Unless the data itself has something to flag the top 5 of a stat in then at some point you have to bring all the fgm into XPression so it can compare them and then know which is the highest. XPression doesn't know that 96 is the highest unless it sees all the other numbers to compare it to.

    When using tables you can sort the results like this explained here; https://rossvideo.community/communities/community-home/digestviewer/viewthread?GroupId=199&MID=21267&CommunityKey=91812bfd-9393-4a3f-8a74-7f8035df130e

    Not sure if that can be done in XML, hopefully, someone might jump in here and advise. 



    ------------------------------
    Simon Redmile
    Senior Graphic Programmer & Designer
    Ross Video
    Bristol United Kingdom
    ------------------------------