[rt-users] RT 4.0.4 - Running Extract Custom Fields script on existing tickets in queue?

[Kevin Falcone]

On Wed, Jan 18, 2012 at 03:35:29PM -0800, Chris Rios wrote:
> 
> One more question.. I have my syntax as follows.. most of the tickets in
> this queue are in a stalled status, but I want to update all of them, but it
> doesn't seem to be doing that:
> 
>  ./rt-crontool --transaction first --action
> RT::Action::ExtractCustomFieldValues --template CustomFieldExtract --search
> RT::Search::ActiveTicketsInQueue --search-arg "Status='stalled' and
> Queue='Copyright_Notices'

ActiveTicketInQueue takes a --search-arg of the queue name, not a
status.  You're attempting to hand it syntax for the FromSQL Search
type.

-kevin

> The Search::ActiveTicketsInQueue only seems to pick up open tickets, and not
> ones in a "new" or "stalled" status. Any thoughts?
> 
> 
> 
> Kevin Falcone-2 wrote:
> > 
> > On Wed, Jan 18, 2012 at 11:04:22AM -0500, Chris Rios wrote:
> >>    I finally got my ExtractCF working last night on incoming tickets to a
> >> queue, what I would
> >>    like to do is find a way to manually run that script against the
> >> existing tickets in the queue
> >>    (There's about 2500). Is this possible at all? Please advise. Thank
> >> you!
> > 
> > You can use rt-crontool --transaction first --action
> > ExtractCustomFieldValues --template yourtemplate --search (find the
> > tickets you want to touch) to execute an existing action/template
> > across existing tickets.
> > 
> > You'll of course want to test on a development instance first
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120118/47dc4db3/attachment.sig>