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
------------------------------