Hi jamie77

if you change the timezone to any other but yours and then change it back it will load the dates until 2025

Joe
FHandw, ACSS, ACIS

If you give more information you will get better answers. If you only give bits and pieces then you will get the same back and maybe not fitting your problem.

Coming from the Nortel world, as my handle obviously states, I could never figure out why Avaya chose to handle DST changes in the manner in which they did. Nortel had this figured out 30 years ago with Norstar and Meridian 1. Advance the time by 1 hour at 02:00 on the first sunday of the 3rd month, and retard it by 1 hour at 02:00 on the first Sunday of the 11th month (I'm making these times up, but you get the idea). It this way the year is completely taken out of the equation. For those areas of Canada that don't follow DST changes at all the DST feature could simply be disabled with a DST Y/N toggle.

There is no reason why you need to have a specific entry for each year, because as we are now seeing, regardless of how many DST entries you add they will at some point expire.

Avaya should have been updating the timezoneinfo.xml file with each release of software, how hard would that be??? Or better yet, implement Nortel's way of DST changes. They bought the company and the tech, why aren't they using it???

Quote:

if you change the timezone to any other but yours and then change it back it will load the dates until 2025

I found a post of yours from a few years back, and tried this, but it doesn't work. The file has upto 2025 in it, but has too many entries fro the IPO to load in, so we onlt get upto 2023.

Either way, they will expire soon.

What does work, is adjust the .xml file with new dates, then using manager to go in to update. You don't even need to select another time zone, just re-select your own from the list and will pull the file in from your local PC. As long as someone doesn't do the same with an out of date file!! lolz

Quote:

Avaya should have been updating the timezoneinfo.xml file with each release of software

It's like you've read the email I sent them yesterday!!

Jamie Green

Avaya Registered Specialist Engineer

Editing that XML file is possible, but time consuming as you still have to copy that file to your PC, look up the DST date changes for the next few years, manually edit that file, then copy the file back to the SC card.
If Avaya would just do the right thing for once and completely re-write how they handle DST that would be a big help.

Never looked at this too closely but I thought it was updated to a few years (5?) after the release date

I have an autoit script that edits the csv config export

You can then run the script then import the configuration.csv dates updated for next 5 years.

Will upload it tomorrow

Autoit script to set dates in ip office should hopefully go up to 2033 please sanity check the dates :)
Use at own risk.

open config with manager.
export config to Configuration.csv
run script on Configuration.csv
import Configuration.csv
save config

#include <File.au3>
#include <Array.au3>

_NEWDATES("26|3|2023|1|0|29|10|2023|2|0|01:00~31|3|2024|1|0|27|10|2024|2|0|01:00~30|3|2025|1|0|26|10|2025|2|0|01:00~29|3|2026|1|0|25|10|2026|2|0|01:00~28|3|2027|1|0|31|10|2027|2|0|01:00~26|3|2028|1|0|29|10|2028|2|0|01:00~25|3|2029|1|0|28|10|2029|2|0|01:00~31|3|2030|1|0|27|10|2030|2|0|01:00~30|3|2031|1|0|26|10|2031|2|0|01:00~28|3|2032|1|0|31|10|2032|2|0|01:00~27|3|2033|1|0|30|10|2033|2|0|01:00")
MsgBox(1, "DONE", "DONE")


Func _NEWDATES($sNewdates)
	Local $iRet = 0

	Local $sFile = FileOpenDialog("SELECT the Configuration.csv FILE", "", "CSV (*.csv)")
	If @error Then
		MsgBox($MB_SYSTEMMODAL, "", "No file(s) were selected.")
		FileChangeDir(@ScriptDir)
		exit
	Else
		FileChangeDir(@ScriptDir)
	EndIf
	local $aFile=""
	local $sData=""
	_FileReadToArray($sFile, $aFile)

	For $a = 1 To $aFile[0]
		if StringRegExp($aFile[$a],"BootP_Info_End") then
			$sData &=$aFile[$a+1]& @CRLF
			$sData &=$aFile[$a+2]& @CRLF
			$sData &=$aFile[$a+3]& @CRLF
			$sData &=$aFile[$a+4]
		endif
	next
	FileSetAttrib($sFile, "-R")
	Local $hFile = FileOpen($sFile, 2)
	$sData = StringRegExpReplace($sData, '\|,[2-3][0-9]\|.*\|01:00,', '|,' & $sNewdates & ',', 1)
	$iRet = @extended
	FileWrite($hFile, $sData)
	FileClose($hFile)
	Return $iRet
EndFunc   ;==>_NEWDATES
 

Thanks Daken

that gets blown away if you ever touch the time zone settings again.

@Jamie77

how did you manage to adjust the xml file?

I took only 3 dates out for 2014, 2015 and 2016 and it complains that it is corrupt

I took the bold and underlined part for the years in question out and get nothing but error messages as soon as I open a config.

<TimeZone><Name>(GMT-05:00) Eastern Time (US &amp; Canada)</Name>
<Locale>frc</Locale> <UTCOffset>18000</UTCOffset>
<Entry><DSTOffset>01:00:00</DSTOffset>
<DSTPair>3/12/2017 2:00:00 AM - 11/5/2017 2:00:00 AM</DSTPair>
</Entry>
<Entry><DSTOffset>01:00:00</DSTOffset>
<DSTPair>3/11/2018 2:00:00 AM - 11/4/2018 2:00:00 AM</DSTPair>
</Entry>
<Entry><DSTOffset>01:00:00</DSTOffset>
<DSTPair>3/10/2019 2:00:00 AM - 11/3/2019 2:00:00 AM</DSTPair>
</Entry>
<Entry><DSTOffset>01:00:00</DSTOffset>
<DSTPair>3/8/2020 2:00:00 AM - 11/1/2020 2:00:00 AM</DSTPair>
</Entry>

Joe
FHandw, ACSS, ACIS

If you give more information you will get better answers. If you only give bits and pieces then you will get the same back and maybe not fitting your problem.

I found that I accidentally erased the
<DSTEntries>

in front of the bold entry but putting it back still brings me the error message

Joe
FHandw, ACSS, ACIS

If you give more information you will get better answers. If you only give bits and pieces then you will get the same back and maybe not fitting your problem.

If you have another version of Manager, just copy the timezoneinfo.xml over to replace the corrupted one.

timezoneinfo.xml doesn't live on the SD card (that I can find), it seems to only be in Manager. Could experiment with keeping the same number of entries for the time zone, but modifying them to delete the old ones and add new ones in the same format.

Or, on a per system basis, in Manager, delete the older entries and add new entries until you fill up the available entries.

TTT I have made a copy before and reset it every time I make adjustments.

I just actually did leave the number of entries the same like you suggested and just moved them around but IPO sorted it by date anyways.
So I changed all the dates and went up to 2033 in the hopes I am still alive by then (just made my motorcycle license) and it worked

Joe
FHandw, ACSS, ACIS

If you give more information you will get better answers. If you only give bits and pieces then you will get the same back and maybe not fitting your problem.

Here the file if someone wants to have the file for the -05:00 timezone

I might do more over the weekend depending if I feel like it.

Joe
FHandw, ACSS, ACIS

If you give more information you will get better answers. If you only give bits and pieces then you will get the same back and maybe not fitting your problem.

• https://files.engineering.com/getfile.aspx?folder=9d7c4ef3-6057-4232-a9f8-d

Actually copy and pasting the dates is easy so here the file for US and Canada because our dates are different than the rest of the world

Joe
FHandw, ACSS, ACIS

If you give more information you will get better answers. If you only give bits and pieces then you will get the same back and maybe not fitting your problem.

• https://files.engineering.com/getfile.aspx?folder=44a49a36-8b4b-40a4-88a1-a

Last update includes most European countries as well as Australia and New Zealand

The following time zones are not updated as they are all over the place and I just don't want to google all these dates for single entries in the list for stuff I will never use.

Azores
Beirut
Buenos Aires
Cape Verde
Greenland (I seem to remember they stay permanently on DST anyways now)
Jerusalem
Tehran

If you need to update them feel free to do it and then upload it here for others to enjoy

Joe
FHandw, ACSS, ACIS

If you give more information you will get better answers. If you only give bits and pieces then you will get the same back and maybe not fitting your problem.

• https://files.engineering.com/getfile.aspx?folder=d64d135b-29bd-4b90-855e-b

@Westi, I pulled down your edited TimeZoneInfo.xml file (thank you for all of the work put into editing it) and replaced the one I found located at System - Primary - WebMgmtEE - Test - XML. I rebooted the IPO and launched Manager, but nothing has changed in the DST Offset dropdown. Obviously I did something wrong or missed a step. If you could let me know what that was I'd appreciate it.

Hello Nortel4Ever

I use the one for North America only because I may have buggered up my other one.

Try using the first one I posted.

then when you open a config and click on the time zone dropdown it should start with 2022

Joe
FHandw, ACSS, ACIS

https://www.millsidetc.com/

@Westi, I pulled down your second one because it included dates for the -07:00 time zone which is what I need.

I think the first one has those as well.
It should have all US and Canadian locale in that.

Joe
FHandw, ACSS, ACIS

https://www.millsidetc.com/

@Westi, this still is not working for me, could you email me at norm.b@completephones.com so that we can discuss off line?

Oh, nevermind I got it figured out.

I am glad, I was on the road and just came back into the office so missed your post until now.

Joe
FHandw, ACSS, ACIS

https://www.millsidetc.com/

Just going to post this cleaned up version of Westi's global TimeZoneInfo.xml file, there were a few missing tags etc.

To apply to an IPO500:

• Upload this file to \SYSTEM\PRIMARY\WebMgmtEE\TEST\XML\ on the IPO500 SD Card (backup and replace the existing TimeZoneInfo.xml file already there)
• Reboot the IPO500
• Close and re-open Manager and log into the IPO500 after the reboot
• The updated time zone data should now display under System > Time Zone, if it doesn't, select another random time zone and then back to your one, it should then update.

To apply to your local Manager to work on offline configs:

• Close Manager if it is open
• Copy this file to C:\Program Files (x86)\Avaya\IP Office Admin Suite\Manager\ (backup and replace the existing TimeZoneInfo.xml file already there)
• Reopen Manager and open a config
• The updated time zone data should now display under System > Time Zone, if it doesn't, select another random time zone and then back to your one, it should update.

Thank you Westi for doing the hard work for us

Cheers,
BFG9K
Avaya IPO/ACCS Technician
Melbourne, Australia

• https://files.engineering.com/getfile.aspx?folder=ebe8247c-6ceb-4f6e-bada-c

You are the man

I did the initial work in a hurry and completely forgot to get back and fix it.
If you see pink it is from another star not a forest fire in the distance.

Joe
FHandw, ACSS, ACIS

...and again I have to wonder why Avaya couldn't have kept this updated with each software release. I guess because they were too busy fixing their screw-ups from every previous release...

I guess that Avaya has laid off the guy that was responsible for this years ago and they forgot to have a new person in charge of that.
The same with their certificates and the fact that they did not keep that up to date either.
Probably the same person, HAHAHA

Joe
FHandw, ACSS, ACIS

I've already given a star and would give another if I could. So not knocking, this is excellent work and thanks for sharing, but for a few locales a few warnings are needed:

• Brazil: Stopped DST in 2019.
• Eygpt: Started DST in 2023.
• Morocco: Switched to permanent DST (UTC+1) in 2018.
• Russia: Stopped DST in 2014.
• Turkey: Switched to permanent DST (UTC+3) in 2016

Today is busy but if time allows Monday I'll try to post a corrected version for those odd locales.

...and then there's those pesky Americans, who've half-passed a law to stop DST, but only half! Strange people.

Stuck in a never ending cycle of file copying.

Okay, that took long than expected (finding both the time to do it and doing it).

Changes:

• Made the file a bit more human readable (though sadly Manager doesn't like comments in the file).
• Removed 2022 - it's happened.
• Fixed the missing 2026 DSTOffset value for the nlb,frb,dan,fra,esp locales.
• Removed all the DST settings for unsupported locales (would anyone ever see them?).
• Removed the DST settings for Brazil and Mexico. They stopped DST in 2019 and 2022 respectively.
• Added DST for Egypt (they started this year).
• Moved Turkey and Morocco forward an hour. They have effectively switched to permanent DST since 2016 and 2018 respectively.

File link below:

• https://files.engineering.com/getfile.aspx?folder=11b2be0e-7696-4768-a958-7

Nice job sizbut, I already have replaced my North America only file with yours.
pink for you.

Joe
FHandw, ACSS, ACIS

https://www.millsidetc.com/

@sizbut,I'm wondering if there is a way you could monitize this DST file for yourself and sell it to Avaya for wider distribution.

I still have some contacts inside the ever shrinking development team, so to repay favours its heading that way anyway.

Stuck in a never ending cycle of file copying.