Graphics

I am currently working on a batting order graphic for a baseball videoboard project.

The batting order graphic basically consists of three columns: jersey number, name, and batting average.

The jersey number and batting average I am pulling straight from the statcrew XML. The name however I want to pull from an excel sheet. (The reasoning is that the names provided by statcrew can be all over the place. Sometimes they come as "Firstname Lastname", other times it's "Lastname, Firstname".)


To accomplish this I have a script on the scene director that runs every two seconds which reads the text field of the jersey numbers, sets the datalinqs for the names based off those jersey numbers, and then refreshes all the datalinqs.

That part works fine, however when the graphic is taken to air it takes a cycle of the scene director before the names are populated.

How can I make sure that the names populated when the graphic hits air? I've tried various combinations of trying to set and/or refresh the datalinqs in "OnOnline", "OnPrepare", and "OnBeforeOnline", but I haven't had any luck so far.

(Ironically, I was able to set the datalinqs and "refresh and wait" in "OnPreviewRender" which shows up correctly. I just can't get the same to happen when taking the graphic online.)

Hello plantassassin,

try to put your script in the OnSetText event of the text object that holds the jersey number that comes from xml datalinq.
It may work.

dim txtObj as xpTextObject

Scene.GetObjectByName("Text_Name",txtObj)

txtObj.Datalinq.Row = Cint(Text) ' Text contains the jersey number

where Text_Name is the text object bound to excel datalinq. Assuming the jersey number match the row number in your excel file.

Hope it helps.

#XPression

I've chosen to use a query in the datalinq table instead of selecting the row, but it does seem to work.

Thanks for the help.
#XPression