If you are using text macros for datalinqs and materials you need to be sure to check
on the text object that is connected to data and being used as a text macro
------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
------------------------------
Original Message:
Sent: 11-04-2024 02:36
From: Ryan Dunn
Subject: Datalinq to Excel Row and Column
Thanks, Simon, that helped a ton! I was able to set the time on OnPrepare and that took care of my daypart issue. I was also running into an issue with the icons still not assigning using the SQL query, but realized I could do the Datalinq query directly on the material without having to use a dummy text object. Now everything is working flawlessly. I appreciate the help, and hopefully this helps other people in the forums!
------------------------------
Ryan Dunn
Senior Production Manager
KVVU FOX5
Original Message:
Sent: 10-29-2024 06:19
From: Simon Redmile
Subject: Datalinq to Excel Row and Column
Hey Ryan, I believe you are facing an order of operation issue.
Visual logic doesn't run until after OnOnline so it would be better if you got current time via a script in OnPrepare.
OnPrepare
- Collect Datalinqs / Load Video Clips / Load Textures etc..
OnBeforeOnline
- Evaluate transition logic (which may include running
OnTransLogicScripts
) OnOnline
- Visual Logic Runs
------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
Original Message:
Sent: 10-29-2024 01:28
From: Ryan Dunn
Subject: Datalinq to Excel Row and Column
Hey everyone, I'm trying something a little complicated here but not having much success -- Linking "current condition" data from the National Weather Service to icons. There's a lot of possible conditions, but not a lot of icons... My process is this:
- Visual Logic gets the current time, dumps it into a text object
- A script on OnPrepare compares the current time to sunrise / sunset data to determine if it's day or night, then dumps that result into a text object
- Text objects (called "CurrentConditions#" in the project) for each city read the current conditions provided by the NWS
- Text objects (called "ImageTranslator#" in the project) for each city are assigned to an Excel document that has rows for conditions and columns for day / night; this result is used in a Dynamic Material to call the correct icon for the 1) condition, and 2) time of day
I've learned a lot from this community and I've tried to follow the thread here about referencing an Excel row and column using a Table macro, but this method works with my Datalinq about 50 percent of the time. Sometimes the icons load the right condition but wrong daypart, sometimes they load the wrong condition but correct daypart, sometimes some icons are day and some are night. I have a feeling I'm missing something small to make the data consistent 100 percent of the time... Any help would be appreciated! Project attached, and Excel doc & Datalinq Server parameters are in the project folder structure. Thank you all so much!!
------------------------------
Ryan Dunn
Senior Production Manager
KVVU FOX5
------------------------------