Remedy DST Time addition problems
When the DST match doesn’t appear to add up:
Here’s the original ARS List post I put out:
Fortunately this issue SHOULD be very straight forward.
Unfortunately – it isn’t.
There’s a button that calculates a person’s period of eligibility to make changes to their HR benefits, etc. You enter their employment anniversary date and hit the button and this performs a calculation:
$My Date$ – 864000 (i.e., minus 10 days).
Here’s the interesting thing – when the date entered is Daylight savings time – 3/15 this spring – the calculated value for the date time field returns 3/4/2010 11:00:00 PM. Normally all of the times in this date/time field are left at 12:00:00 AM and are unused.
Technically speaking the calculation is EXACTLY correct. 3/4/2010 11:00:00 PM is exactly 10 days before 3/15/2010 12:00:00 AM – because 3/15 has an “extra” hour added that is a figment of our collective imagination. Technically DST doesn’t happen until 2:00 AM though but that’s a matter for another time.
I was thinking about changing the times on these to default to 3:00:00 AM instead of 12:00:00 AM – but I’m open to suggestions.
As it turns out the solution was really simple – the original math for the “Set Fields” calculation did this:
$My Date$ – 864000
I just switched it to use the Remedy DATEADD function and added negative 10 days – this only evaluates the “date” portion of the value and ignores DST:
DATEADD(“day”,-10,$My Date$)
Thanks to C.B. on the arlist for the suggestion.
BMC Remedy ACD Integration via the C API – opening a Display Only form
How to set open a display only field and set fields using the C API
I had posted a question on the ARSList about how to properly format the C API call for “OpenForm” – we were getting errors using it.
Mark Worley – a fellow poster – was kind enough to send me this example which worked and allowed us to fix the problem
Dim arSession as ARUSER.COMAppObj
Dim arForm as ARUSER.ICOMFormWnd
Dim arField as ARUSER.ICOMField
Dim sessionNumber as Long
Set arSession = New ARUSER.COMAppObj
sessionNumber = arSession.Login(“ARUserID”, “ARUserPassword”,False)
arSession.OpenForm sessionNumber, “ARServer”, “Form Name”, ARSubmit , 1
Set arForm = arSession.GetActiveForm
Set arField = arForm.GetFieldById(999999999)
arField.Value = “Value”
arForm.Submit
Flash Board Server 7.1 patch 005 install failure and solution
Apparently the BMC Remedy Flash Board 7.1 patch 005 doesn’t like being installed as non-root on Solaris 5.10. We kept getting this error when it asked for the directory to install the product:
Directory to install BMC Remedy Flashboards? [/usr/ar/flashboards]
/xxx/yyy/a00/ar/flashboards FBServer
fb_install: syntax error at line 1: `)’ unexpected
It turns out awk was returning the wrong value – a “)” was being appended.
If you run into this just edit the shell script so the installer skips the section that checks for disk space. If you need help with that you can always contact me.
Remedy Development Best Practices
In response to:
** Hi folks. Just wondering what practices some developers are using for custom code and enhancing ootb workflow. IE, field ID’s in a non reserved range, New workflow easily identified perhpaps by the company name etc. My real big dillemma is modifying existing workflow. Does anyone have some best practices for modifying existing workflow so that in the event of an upgrade pitfalls can be avoided or at least anticipated?
William Rentfrow
Principal Consultant, StrataCom Inc.
715-410-8056 C
715-592-5185 O