[rt-users] Append Data to CustomFields

Wed May 30 20:19:42 EDT 2012

Mike,

Yes, I believe this could be done with a scrip. I'd do all the calc work
with temp fields (defined in the perl code) and then put the results in the
CF.
Be careful to name your fields with a name that cannot be confused with an
RT delivered field. It's just not a clean way to go.
Also, make sure your condition for the update is when the exact field you
want to change has been updated and not just any update to the ticket.
This might mean creating an update scrip for each individual CF you want to
do this to. RT will execute all of them. Make they are set to TransBatch.

Kenn

On Wed, May 30, 2012 at 2:44 PM, Michael Coakley <mike.coakley at gmail.com>wrote:

> This is easily done with a scrip. You need a Ticket custom field to hold
> the totals and a Transaction custom field for the users to update during a
> reply or comment. The scrip will take the transaction custom field value
> and add it to the ticket custom field value to keep the running total.
>
> I've absolutely done this before but a long time ago. It works great and
> I've built billing systems off of these values which seems like you are
> trying to do.
>
> The only "gotcha" and it's a little one because once you start scrip
> development you'll know this; it is to use TransactionBatch mode on the
> scrip because that is the only way you will actually be able to see the
> Transaction custom field values.
>
> Hope that gets you started.
>
> Mike
>
> Sent from my iPhone
>
> On May 30, 2012, at 1:53 PM, TheHoboKing <demon_eyes_kyoms at hotmail.com>
> wrote:
>
> >
> > Hi Kenneth,
> >
> > Thank you for the reply and my apologies for the delay, I've been busy
> with
> > other projects.
> >
> > I mentioned the TimeWorked field because that's how I'd like my other
> 'time'
> > CFs to behave but here's what I'm trying to achieve in more details.
> >
> > I have two CFs: Emergency Hours | Schedule Hours
> > CFs type is 'Enter one value'
> >
> > On ticket updates (users will most likely only update tickets from the
> WebUI
> > via comment/reply action), I'd like those CFs to behave as followed:
> >
> > On update, the CFs should show no value. If my user(s) enter a value and
> > update the ticket, the value should be added to the previous value (users
> > will only be inputting integers).
> >
> > i.e.:
> > Emergency Hours current value = 10
> > Users Update the ticket and adds 15 in the Emergency Hours
> > Emergency Hours should now display 25
> >
> > Is there a way to achieve this via script or more in dept RT
> customization?
> >
> > -I've tried to create another TimeWorked field but TimeWorked seems to be
> > all over the place and I couldn't identify the proper sections to
> add/modify
> > in order to 'duplicate' TimeWorked.
> >
> > -I was also thinking if it may be possible to do it via scrip by;
> > OnComment or OnTransaction
> > Reading the value of 'Emergency Hours'
> > Storing the value in a temporary variable
> > Adding the new value to the old value. .i.e: Emergency Hours =
> > TemporaryEmergencyHoursTotal + EmergencyHours
> >
> > -I also thought I could simply create another CF called
> > 'EmergencyHoursTotal' and store the total there BUT then, on ticket
> display
> > only 'EmergencyHoursTotal' should be visible and 'Emergency Hours'
> should be
> > hidden, on ticket update only 'Emergency Hours' should be visible and
> > 'EmergencyHoursTotal' should be hidden.
> >
> > I read hiding/displaying specific CF can be achieved via the
> > MassageCustomFields callback but I don't find much information on how to
> > code my MassageCustomFields. This is the most informative code I've
> found in
> > regards to it.
> >
> >
> http://cpansearch.perl.org/src/RUZ/RT-Extension-CustomField-HideEmptyValues-0.01/html/Callbacks/CustomField-HideEmptyValues/Elements/ShowCustomFields/MassageCustomFields
> >
> > Sorry for my long long post, let me know if I should open a new tread in
> > regards to the MassageCustomFields info.
> >
> > Thank you again!
> >
> >
> >
> >
> > Kenneth Crocker-2 wrote:
> >>
> >> HoboKing,
> >>
> >> You could create a CF with SeeCF rights only to Users and then write a
> >> scrip so that when the TimeWorked field is updated, the scrip subtracts
> >> the
> >> old value from the new value and then adds that result to the CF.
> >> You could also add a condition to check the date and if it is month-end
> or
> >> something you could move the final "TomeWorked" value to a Month-end
> Time
> >> CF and then zero out the contiguos one.
> >> That way, you won't run into problems of some user entering a non-inter
> >> type value into the field. You might want to grant "ModifyCF" to the
> >> SuperUSer or some management group of users so they can override the
> value
> >> when necessary.
> >> It all depends on what you want to accomplish.
> >> TimeWorked is already designed to receive integers. So all you really
> need
> >> is a CF to act as a monthly or yearly, etc. accumulator, along with a
> >> routine to zero out at the end of that cycle.
> >> The best way is to write a cronjob to run through all tickets on
> whatever
> >> cycle you want to accumulate and have that routine do the
> >> accumulate/move/zero work. That way you get ALL tickets updated
> >> consistently, not just the ones that were updated in a given cycle.
> >>
> >> Hope this helps.
> >>
> >> Kenn
> >>
> >> On Mon, May 28, 2012 at 11:44 AM, TheHoboKing
> >> <demon_eyes_kyoms at hotmail.com>wrote:
> >>
> >>>
> >>> Hi,
> >>>
> >>> I'm still quite new at RT and was wondering if there's a way to have
> >>> appendable/updatable CustomFields like the TimeWorked field?
> >>>
> >>> Whenever I update a ticket, the TimeWorked field is blank, any value
> >>> (digits) I add will automatically be added to the old value, it'll
> make a
> >>> simple addition.
> >>>
> >>> How can I do the same with CustomFields? Either via the webUI, scrip or
> >>> back-end (Update.html ? ModifyAll.html?)
> >>>
> >>> I'm running RT 4.0.5
> >>>
> >>> Thank you!
> >>> --
> >>> View this message in context:
> >>>
> http://old.nabble.com/Append-Data-to-CustomFields-tp33920988p33920988.html
> >>> Sent from the Request Tracker - User mailing list archive at
> Nabble.com.
> >>>
> >>>
> >>
> >>
> > --
> > View this message in context:
> http://old.nabble.com/Append-Data-to-CustomFields-tp33920988p33933640.html
> > Sent from the Request Tracker - User mailing list archive at Nabble.com.
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120530/ae46f836/attachment.htm>