Re: [rt-users] Extract Custom Fields -
Hi Tony!
Thank you!
Following your exemple, I got the same error!
But…. I set up my mail client for plain text and my body for:
CustomField.{EIN}:45-1234567
CustomField.{Address}: 785, Hi Street
CustomField.{Cell Phone}:781-999-8111
CustomField.{City}:Stoughton
CustomField.{First Name}:Marcelo
CustomField.{Last Name}:Calado
AndWorks Fine….:)
What I need to do to extract from mail and assign my tickets fields?
Thank you So Much!
From: Tony G Palomino [mailto:palom...@reed.edu]
Sent: Tuesday, December 22, 2015 5:01 PM
To: Marcelo Calado | TBS TAX Services
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Extract Custom Fields -
In our instance we extract information from email headers on ticket create.
Our template looks something like:
RTcustomfieldname1|X-header-name-1|.*
RTcustomfieldname2|X-header-name-2|.*
RTcustomfieldname3|X-header-name-3|.*
I can see what you're trying to do with your template, but unfortunately don't
have enough experience to know how to help further.
On Tue, Dec 22, 2015 at 1:16 PM, Marcelo Calado | TBS TAX Services
mailto:mcal...@tbstaxservices.com> > wrote:
Hi There!
I am having trouble with RT-Extension Extract Custom Field.
Anyone ever done this before and can help? A quick help will be appreciated as
we are missing critical requests
Thank you.
My template:
EIN|Body|EIN:\s*(\w+)
Address|Body|Address:\s*(\w+)
Cell Phone|Body|Cell Phone:\s*(\w+)
City|Body|City:\s*(\w+)
First Name|Body|First Name:\s*(\w+)
Last Name|Body|Last Name:\s*(\w+)
My body:
Ein:20-999-745
Address: 100, High Street
Cell Phone:3809
City:Stoughton
First Name:Marcelo
Last Name:Calado
Into my logs:
Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (Ein,20) added:
1324
Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (Ein,20) added:
1324
Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (Address,100)
added: 1325
Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (Address,100)
added: 1325
Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (Cell Phone,3809)
added: 1326
Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (Cell Phone,3809)
added: 1326
Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (City,Stoughton)
added: 1327
Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (City,Stoughton)
added: 1327
Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (First
Name,Marcelo) added: 1328
Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (First
Name,Marcelo) added: 1328
Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (Last Name,Calado)
added: 1329
Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (Last Name,Calado)
added: 1329
Dec 22 16:08:35 751081-tbsfryou RT: [27756] Ticket 347 created in queue
'TaxOnline' by mcalado
Dec 22 16:08:35 751081-tbsfryou RT: [27756] Failed command 'address: 100, High
Street'#012Error message: Command 'address' is unknown#012#012Failed command
'ein: 20-999-745'#012Error message: Command 'ein' is unknown
Dec 22 16:08:35 751081-tbsfryou RT: [27756] Extended mailgate error: Failed
command 'address: 100, High Street'#012Error message: Command 'address' is
unknown#012#012Failed command 'ein: 20-999-745'#012Error message: Command 'ein'
is unknown
--
tony.palom...@reed.edu <mailto:tony.palom...@reed.edu>
Director, Computer User Services
Reed College
503-788-6622
Re: [rt-users] Extract Custom Fields -
In our instance we extract information from email headers on ticket create. Our template looks something like: RTcustomfieldname1|X-header-name-1|.* RTcustomfieldname2|X-header-name-2|.* RTcustomfieldname3|X-header-name-3|.* I can see what you're trying to do with your template, but unfortunately don't have enough experience to know how to help further. On Tue, Dec 22, 2015 at 1:16 PM, Marcelo Calado | TBS TAX Services < mcal...@tbstaxservices.com> wrote: > > > Hi There! > > I am having trouble with RT-Extension Extract Custom Field. > > > > Anyone ever done this before and can help? A quick help will be > appreciated as we are missing critical requests > > > > > > Thank you. > > > > My template: > > > > EIN|Body|EIN:\s*(\w+) > > Address|Body|Address:\s*(\w+) > > Cell Phone|Body|Cell Phone:\s*(\w+) > > City|Body|City:\s*(\w+) > > First Name|Body|First Name:\s*(\w+) > > Last Name|Body|Last Name:\s*(\w+) > > > > My body: > > Ein:20-999-745 > Address: 100, High Street > Cell Phone:3809 > City:Stoughton > First Name:Marcelo > Last Name:Calado > > > > Into my logs: > > Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (Ein,20) > added: 1324 > > Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (Ein,20) > added: 1324 > > Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (Address,100) > added: 1325 > > Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (Address,100) > added: 1325 > > Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (Cell > Phone,3809) added: 1326 > > Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (Cell > Phone,3809) added: 1326 > > Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue > (City,Stoughton) added: 1327 > > Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue > (City,Stoughton) added: 1327 > > Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (First > Name,Marcelo) added: 1328 > > Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (First > Name,Marcelo) added: 1328 > > Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (Last > Name,Calado) added: 1329 > > Dec 22 16:08:35 751081-tbsfryou RT: [27756] CustomFieldValue (Last > Name,Calado) added: 1329 > > Dec 22 16:08:35 751081-tbsfryou RT: [27756] Ticket 347 created in queue > 'TaxOnline' by mcalado > > Dec 22 16:08:35 751081-tbsfryou RT: [27756] Failed command 'address: 100, > High Street'#012Error message: Command 'address' is unknown#012#012Failed > command 'ein: 20-999-745'#012Error message: Command 'ein' is unknown > > Dec 22 16:08:35 751081-tbsfryou RT: [27756] Extended mailgate error: > Failed command 'address: 100, High Street'#012Error message: Command > 'address' is unknown#012#012Failed command 'ein: 20-999-745'#012Error > message: Command 'ein' is unknown > > > > > > > -- tony.palom...@reed.edu Director, Computer User Services Reed College 503-788-6622
Re: [rt-users] Extract Custom Fields (CF) from E mail
I just finished working this out for myself. Have you looked at this http://wiki.bestpractical.com/view/ExtractCustomFieldValues that along with some searching of this list has proved most helpful to me. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of fusco Sent: Friday, December 11, 2009 10:49 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] Extract Custom Fields (CF) from E mail Hello everyone, I want to update a ticket witch owner is identified by a Custom field into the body of an E-mail sended to Request tracker so I want to know how to use the extension extract from custom fields can you give some tracks greetings, Georghy -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Extract custom fields from tickets using commandline - [Pork] Email found in subject
Dan,
Thanks for the reply. I've done a whole bunch of perl hacking to and around
RT, but given I can "cut-and-paste" the query field in the 'Advanced'
descriptor of a query (generated via the web interface) I was hoping there
might be a similar thing that could be done with the displayed fields. This
would save me doing yet more perl hacking.
I was able to get individual values back using '-f', for example '-f Status'
would show me the ticket id's that matched the query with their Statuses, but
'-f CF.{Field name}' with any combination of quotes, or CustomField instead of
CF, resulted in only errors.
So, so far, it seems that '-f' was intended to fill what I need, but can
someone confirm whether I can specify a custom field, instead of a default
field?
BenR
From: Daniel Koo [mailto:[EMAIL PROTECTED]
Sent: Wed 12/03/2008 6:12 PM
To: Ben Robson
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Extract custom fields from tickets using commandline -
[Pork] Email found in subject
Hi Ben,
For something more involved than what the rt tool can give you I'd write
a script in Perl using the RT library. (Which is what 'rt' is, but it's
more generic)
cheers
Dan
On Wed, 2008-03-12 at 17:02 +1100, Ben Robson wrote:
> Greetings
>
>
>
> I was wondering if anyone had any advice on how to best, from the
> command line, conduct a search for tickets that match a custom field
> value ('CF.{Invoiced Date}' > '2008-04-03') show values in a custom
> field in matching tickets ('CF.{Purchase Order Number}').
>
>
>
> The intention is to use a cron task to find all tickets, who's
> invoiced date was last month and get the purchase order numbers
> associated with those tickets.
>
>
>
> I can get ./rt to show me the tickets using: ./rt ls "Queue = 'PSS
> Projects' AND 'CF.{Invoicable Date}' > '2008-03-31'" and adding a -l
> will give me the pro-forma fields, but not the associated custom
> fields.
>
>
>
> Any hints?
>
>
>
> BenR
>
>
>
>
>The information contained in this communication is intended solely
> for the use of the individual or entity to whom it is addressed and
> others authorised to receive it. It may contain confidential or
> legally privileged information. If you are not the intended recipient
> you are hereby notified that any disclosure, copying, distribution or
> taking any action in reliance on the contents of this information is
> strictly prohibited and may be unlawful. If you have received this
> communication in error, please notify us immediately by responding to
> this email and then delete it, and any associated attachments, from
> your system. Thank you.
>
>
>
>
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> <http://wiki.bestpractical.com/>
> Commercial support: [EMAIL PROTECTED]
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
> <http://rtbook.bestpractical.com/>
--
Daniel Koo
Developer
Bulletproof Networks
www.bulletproof.net
tel: 1300 663 903
fax: 02 9662 4744
"Hosting that just works."
This e-mail and any attachments are confidential and may be legally
privileged. Only the intended recipient may access or use it and no
confidentiality or privilege is waived or lost by mistaken
transmission. If you are not the intended recipient you must not
copy or disclose this email's contents to any person and you must
delete it and notify us immediately. Bulletproof Networks uses
virus scanning software but excludes all liability for viruses or
similar in any attachment as well as for any error or
incompleteness in the contents of this e-mail.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
