Facility Control

 View Only
  • 1.  Can dashboard tell XPN which row in the DataLinq connection to use ?

    Posted 08-10-2019 19:08

    I would like to click on a row in a Dashboard table and have XPression use that DataLinq row when populating a graphic.

     

    I guess I would like to send (TakeID, Object, DataLinq, Column, Row) to XPression. Is this feasible currently?

     

    Thanks

     

    Whit

     

    I need to know if this possible, before I spend time learnig how to populate a dropdown table with JSON data.



  • 2.  RE: Can dashboard tell XPN which row in the DataLinq connection to use ?

    Posted 08-10-2019 20:45

    Hi again Whit! Quick question, what XPression version do you have?


    #DashBoard


  • 3.  RE: Can dashboard tell XPN which row in the DataLinq connection to use ?

    Posted 08-11-2019 12:46

    Hi Aleksander

     

    I believe it is V 7 in the truck.

     

    Down to only 4 weeks before our season begins. I have two sections of my panel working

    • Takes in & out
    • Scorebog on Dashboard being populated from a JSON online file

    Actually have two versions created,

    1. one for using Sportzcast
    2. the second one for the JSON API 

     

    Still To Do:

    Set up dataling for th Events ( goals & penalties) API (JSON)

    Emulate this in Dashboard to have DB tell XPN which row to use. It was easy to do in vMix but .......

    Are you all set for the upcoming season? Which league are your games in ?

     

    Whit


    #DashBoard


  • 4.  RE: Can dashboard tell XPN which row in the DataLinq connection to use ?

    Posted 08-11-2019 17:03

    Hmmm, I think you're a bit stuck then... I know from experience you could do a sort of GET * FROM 'player' WHERE 'jersey' IS %relid%, and I know that in the new version you can do a similar thing to %relid% but you can get the value of a text object instead.

    Meaning you could have most of the stats in an Excel sheet, and call upon just the number to get the values for a specific player.

    But again, only saw that when it came to version 9.


    #DashBoard


  • 5.  RE: Can dashboard tell XPN which row in the DataLinq connection to use ?

    Posted 08-12-2019 15:00

    You can't directly change the datalinq source when you click on a row in a table.   But what you can do is have parameters outside the table that are datalinq'ed.    When you click on a row, you update those parameters with the row data.

    For example, you could have a "name" parameter that is datalinq'ed to XP.   When you click on a row in a table, you do param.setValue("name", 0, <value of the row>);    

    If you need more help, let me know and I can whip up an example.

     


    #DashBoard


  • 6.  RE: Can dashboard tell XPN which row in the DataLinq connection to use ?

    Posted 08-15-2019 12:33

    Would love to see an example, please.

     

    I have progressed to the point , in Dashboard, where I have:

    1. parsed the onlineJSON file
    2. assigned the elements to variables
    3. populated a table with the elements

    I am thinking this table should show up as  dataLinq source in XPression. All the other objects in this panel do show up in XPN datasources but not this table.

     

    DO I need to do something special to have it appear in DataLinq. If I can see it in the XPN DataLinq then I am away to the races.

     

    Thanks to everyone for their help on this project. Checked our " CCHL Game of the Week" broadcast schedule and our first home broadcast will be October 4.


    #DashBoard


  • 7.  RE: Can dashboard tell XPN which row in the DataLinq connection to use ?

    Posted 08-17-2019 23:40

    Hey Whit!

    Good to hear you're making progress!
    You might've solved this one now, but just wondering. How did you set up your table? Parameters? Structs? Cant remember the last option, but there is one...


    #DashBoard


  • 8.  RE: Can dashboard tell XPN which row in the DataLinq connection to use ?

    Posted 08-21-2019 12:29

    Table was parameters definitely not structs. I simply grabbed a table example from this "community" and re-purposed it.

     

    I still need a technique for

    1. seeing my jSON data in aDashboard table (which I have done)
    2. selecting a row

    I can then tell XPN which data to use to populate the graphic. Similiar to what Ben has suggested above.

     

    Thanks

     

    Whit


    #DashBoard


  • 9.  RE: Can dashboard tell XPN which row in the DataLinq connection to use ?

    Posted 08-21-2019 13:54

    Upon further examination, the data sources ( a section I copied into my panel) are not showing up in XPN DataLinq. When I use it as a standalone panel, works fine; but when copied and pasted into my main panel, it does not show in DataLinq.

     

    Any thoughts as to what I have missed?

     

    Thanks

     

    Whit


    #DashBoard