Graphics

 View Only
  • 1.  datalinq and updating datalinq keys

    Posted 08-07-2019 22:16

    I have 3 datalinq keys: MATCH, TEAM1, and TEAM2

    Using an Excel workbook as a datasource, MATCH selects the desired match up on one sheet, where two Text objects are set to team1 and team2 (text from the spreadsheet); those objects have an onSetText that sets the TEAM1 and TEAM2 (datalinq keys) to team1 and team2 (read from the spreadsheet), which then should subsequently load a pile of data for each team from each of their respective pages.

    My issue isn't that it doesn't work, it's that it seems to take a long time (MATCH is being set from an external program using the API, so it's not a take item, it's the actual template scene online). It seems to take quite some time to populate each team's data after that.  If I have set my text objects visible, I can see that the match updates immediately, but it almost seems random how quickly the other fields then propagate from there.

    I know I can update datalinqs to force things along, but am not sure of the effective location in code/event scripts to do that.

     



  • 2.  RE: datalinq and updating datalinq keys

    Posted 08-08-2019 02:01

    Ok, so here's an example of trying to keep everything in sync; I have a first name text field, and a last name text field, and I set a texture based on both (last_first.png); I put the OnSetText event on the last name, but sometimes it works, and sometimes, when it runs, it runs before the first name as been updated, so it has the old first name, and the new last name.


    #XPression


  • 3.  RE: datalinq and updating datalinq keys

    Posted 08-08-2019 17:04

    Honestly if you're just trying to pull a file path based off a player's name, I would just set that up in your excel sheet so you don't have to worry about any scripting on the XPression side. You're just datalinqing to the image path.


    #XPression


  • 4.  RE: datalinq and updating datalinq keys

    Posted 08-08-2019 17:24

    Because then I have to do that for like 600 players, and there's a rule for when there's no first name given that is easy in VB Scripting, but a pain in Excel formula.  But whatever.

    I just put the OnSetText script on both; the first one just fails, the second one works, it doesn't matter which order they come in.

    It would be nice to have a "OnAllDataLinqsDone" event, or something.

     


    #XPression