Graphics

 View Only
  • 1.  Updating data in live output using xpression dropdown lists and excel spreadsheet databases

    Posted 16 hours ago

    Hi,

    Is it possible to make the data selected from Xpression dropdown lists (list boxes, combo boxes, radio buttons, checkboxes) refresh when the live output changes? Currently, the data only refreshes in the preview window; the live output remains unchanged during the broadcast.

    (Sequencer View)

    The database is created in an Excel spreadsheet and managed by the selected DataLinq option.

    Thanks in advance for any suggestions.



    ------------------------------
    Tom Jan
    editor
    ------------------------------


  • 2.  RE: Updating data in live output using xpression dropdown lists and excel spreadsheet databases

    Posted 16 hours ago

    I would use a widget for that instead if you want it all contained inside XPression. 



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



  • 3.  RE: Updating data in live output using xpression dropdown lists and excel spreadsheet databases

    Posted 10 hours ago
    Thank you, but I don't quite understand what widget you're referring to.
     
    I don't think this solution will suit my needs.
     
    Am I to understand that dropdown lists cannot be used in live data updates?
     
    I'm sending a short video that illustrates the scenario I'm talking about.


    ------------------------------
    Tom Jan
    editor
    ------------------------------



  • 4.  RE: Updating data in live output using xpression dropdown lists and excel spreadsheet databases

    Posted 9 hours ago

    Hey Tom,

    I can't watch the video right now as I'm traveling with poor data but I understand what you mean. The input controls are not designed to be used while the scene is online.

    You can used widget drop-down list like this. 

    https://www.rossvideo.com/resources/ross-university/using-the-xpression-clock-and-timers-widget/

    Or you can use external data such as dashboard. 

    If you change the data in the template data entry in the sequence and take the item again it will force an update but it won't animate.

    The normal workflow method is to duplicate the item in the seqence list and then have transiton or transition logic of some kind.



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



  • 5.  RE: Updating data in live output using xpression dropdown lists and excel spreadsheet databases

    Posted 9 hours ago

    I also remembered another option called Data Pages.

    XPression Data Pages and Take IDs Appear in Previews Together - Ross Video https://share.google/44tE2lIz16OIUX26a



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



  • 6.  RE: Updating data in live output using xpression dropdown lists and excel spreadsheet databases

    Posted 6 hours ago
    Thank you Simon.
    I needed confirmation that this method of live updating using data from dropdown lists wouldn't work.
    It's a shame, because it would be an extremely efficient solution in the scenarios I envisioned.
    If you had a moment to watch my demo video, you might agree.
    I'll probably have to choose the datalinq server method of updating data in an Excel spreadsheet. I wanted to avoid this to stay solely within the Xpression app interface and save time, which is already scarce in certain situations.
    Could you please provide links to dashboard tutorials on selecting players from lists by jersey number without having to manually enter a player's data? I've only found basic tutorials myself.
    For me, even fractions of a second count when it comes to reaction time during broadcasts.
    I only use the dashboard application to track full match statistics (ball possession, shots, offsides, number of passes, cards, etc.).
    Generally, the solutions I've implemented work reliably without the dashboard for match events, but I'd be happy to improve it if it warrants better performance during live play.
     
    I'm sending you a short video demo:
    I'd like to revisit the questions from this thread:
     
    I'm attaching a short video where I'd like to implement the solution you mentioned:
    Thanks in advance for any suggestions.


    ------------------------------
    Tom Jan
    editor
    ------------------------------



  • 7.  RE: Updating data in live output using xpression dropdown lists and excel spreadsheet databases

    Posted 8 hours ago

    Tom, I took a look at your video.

    That is correct: Dropdown lists (and all User Input Controls) can't be used with live data updates. If you look in your original screenshot, they fall under the "Static Text" data source, meaning the text is going to be static once the graphic goes live. Depending on the graphic, it might update if you take the graphic again, though you might also see it reanimate. For data that changes live while online, you'd need to either use a Widget, a Data Page, or use a Datalinq source. (For football sub graphics like in your example, I could see a Dashboard that's a datalinq source being very user friendly and allowing live changes)



    ------------------------------
    Zachary Fradette
    United States
    ------------------------------



  • 8.  RE: Updating data in live output using xpression dropdown lists and excel spreadsheet databases

    Posted 6 hours ago

    Thank you Zach
    I wanted to make sure the dropdown list method wouldn't work in this scenario. The only option left is to update the data directly in the Excel spreadsheet and DataLinq Server.



    ------------------------------
    Tom Jan
    editor
    ------------------------------