Time Zone and Open Window
Introduction
Some customers use Bin Sentry to gather bin readings using IOT. They have certain requirements for bin readings to Aeros LIVE ending feeds.
Bin readings that are not within an open window should be toss out.
Bin readings within the open window but are pass midnight needs to be push back to the prior date
Farms can be located in various time zones and needs to be considered when date/time is involved.
Prerequisites
To recognize time zone and/or limit importing ending feeds to a specific window, we will need:
Required
Access to Aeros LIVE
Access to Aeros CONNECT
Recommended
Access to Bin Sentry UI
Configuring Time Zone and Open Window
Facility Management → Farm → Ending Feed
New settings had been added to the Farm.
Field Description
Time Zone: Specifies the time zone of the farm.
Start Cutoff: The start time
End Cutoff: The end time
Info
To define the open window to consider whether bin readings are valid, the time zone needs to be specified.
New Ending Date UTC
In CONNECT, the new column "Ending Date UTC" had been added to the staging table. This is needed since the previous "Ending Date" column doesn't include local info.
When the farm is properly configured, the commit process will use the date/time from Ending Feed UTC as follow..
Convert ending date to farm's time zone
Determine if the ending date is within the open window as defined
If the date is outside the open window, no ending feed is created in Aeros LIVE#
If the date is within the open window but is before midnight, the date is used as-is w/o further adjustment
If the date is within the open window but is after midnight, the date is adjusted to the prior date and the time is set to 11:59 PM.
It is possible to not adjust to prior date by setting the web.config flag IsEnableAdjustToPriorDate to false.