Is it possible to update OTRS tickets via email?

Moderator: crythias

Locked
Waltero
Znuny newbie
Posts: 18
Joined: 16 Dec 2010, 18:14
Znuny Version: 2.4

Is it possible to update OTRS tickets via email?

Post by Waltero »

Hi All,

I work for a travel software company. We use OTRS for all support tickets but Bugzilla / Jira for the development teams. This means that any tickets that need to be passed to our development teams for investigation have to be rekeyed into Bugzilla and the bugzilla reference entered into the OTRS Ticket. I'd like to add a degree of automation to this by having OTRS Mail raise the bugzilla ref. I can do this using the Bugzilla email_integration, but i haven't found a way of updating OTRS tickets via email.

Can anyone help?

thanks in advance for your time.

I'm currently using Version 2.4.9 but we'll be upgrading to 3.x once the ITSM pack has been signed off.
Production OTRS: 2.4.7 + ITSM pack
Test OTRS: 3.0.9
MySQL DB
Linux
Wolfgangf
Znuny ninja
Posts: 1029
Joined: 13 Apr 2009, 12:26
Znuny Version: 6.0.13
Real Name: Wolfgang Fürtbauer
Company: PBS Logitek GmbH
Location: Pinsdorf

Re: Is it possible to update OTRS tickets via email?

Post by Wolfgangf »

what do you mean by update?

Adding follow-up to tickets via mail is a standard feature of OTRS
Just make sure you have a reference to the ticket (Ticketnumber as given from OTRS) in your subject, body, ... and configure OTRS to look for such references in theses fields. Searching subject is standard, others have to be configured in Sysconfig -> Postmaster
Produktiv:
OTRS 6.0.13/ ITSM 6.0.13
OS: SUSE Linux (SLES 12, Leap), MySql 5.5.x, 5.6.x
Windows 2012 AD Integration (agents and customers), Nagios integration (incidents, CMDB), Survey, TimeAccounting
ferrosti
Znuny superhero
Posts: 723
Joined: 10 Oct 2007, 14:30
Znuny Version: 3.0
Location: Hamburg, Germany

Re: Is it possible to update OTRS tickets via email?

Post by ferrosti »

I am not familiar with bugzilla, but in case you can configure it to send mails to OTRS (e.g. reply to a mail) automatically, it will update the opened ticket.
Just make sure that in case you open a bugreport throughout OTRS to bugzilla, that bz keeps the ticket number in its subject or its body. Last case will need OTRS to be configured to search the mailbody for tn, too.
openSuSE on ESX
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems
Waltero
Znuny newbie
Posts: 18
Joined: 16 Dec 2010, 18:14
Znuny Version: 2.4

Re: Is it possible to update OTRS tickets via email?

Post by Waltero »

Hi, thanks for taking the time to reply, i think i'm missing something here!

I've got a test box running OTRS 3.0.5 on it. I've created an email address otrsupdate@xxxx.com and configured the postmaster to retrieve mail from it.

I've created a Phone Ticket and what i'd like to do now is be able to update it via email, to do this i've emailed otrsupdate@xxxx.com with the ticket number in the subject line and an update as the message body. Nothing seems to have happened!

Any ideas? Thanks again for your help.
Production OTRS: 2.4.7 + ITSM pack
Test OTRS: 3.0.9
MySQL DB
Linux
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Is it possible to update OTRS tickets via email?

Post by crythias »

If nothing happened, the email did not get to OTRS (either not sent or not received or not retrieved)
If nothing noticeable happened (check the OTRS logs) it didn't update the ticket you want, but may have created a new ticket.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
ferrosti
Znuny superhero
Posts: 723
Joined: 10 Oct 2007, 14:30
Znuny Version: 3.0
Location: Hamburg, Germany

Re: Is it possible to update OTRS tickets via email?

Post by ferrosti »

I think I have had the same error here, when I did not have the complete TicketHook, Divider, etc. completely in its subject.
Can you try that please, to have the TN 'area' in its subject look just the way like it looks when sending mails from OTRS?!
openSuSE on ESX
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems
Waltero
Znuny newbie
Posts: 18
Joined: 16 Dec 2010, 18:14
Znuny Version: 2.4

Re: Is it possible to update OTRS tickets via email?

Post by Waltero »

ok thanks guys. looks like we had a problem with our OTRS install which is now fixed. So OTRS is receiving mails and raising tickets automatically by email but I still can't get it to update an existing ticket via email. I've put the entire ticket reference in the subject for example "2011012010000055" I've tried the ticket reference plus the title "#2011012010000055 — Test Ticket"

What am i missing? I'm sure its something simple that i've not setup somewhere. I can't see details in the Admin guide either.

thanks again for your patience & help!
Production OTRS: 2.4.7 + ITSM pack
Test OTRS: 3.0.9
MySQL DB
Linux
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Is it possible to update OTRS tickets via email?

Post by crythias »

it's possible you're missing the word "Ticket" (as in, Ticket#xxxxxxxxxx) the same way it appears in an email.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Is it possible to update OTRS tickets via email?

Post by jojo »

You have to use: TicketHook + TicketHookDivider + Ticketnumber

which looks normally like this:

Ticket#2011012042008587

TicketHook: Ticket#
TicketHookDivider:
Ticketnumber: 2011012042008587
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Waltero
Znuny newbie
Posts: 18
Joined: 16 Dec 2010, 18:14
Znuny Version: 2.4

Re: Is it possible to update OTRS tickets via email?

Post by Waltero »

crythias wrote:it's possible you're missing the word "Ticket" (as in, Ticket#xxxxxxxxxx) the same way it appears in an email.
Thats done it! Its working!!!! Thanks so much! :D
Production OTRS: 2.4.7 + ITSM pack
Test OTRS: 3.0.9
MySQL DB
Linux
ferrosti
Znuny superhero
Posts: 723
Joined: 10 Oct 2007, 14:30
Znuny Version: 3.0
Location: Hamburg, Germany

Re: Is it possible to update OTRS tickets via email?

Post by ferrosti »

Please have a look at your sysconfig frontend:
Core::Ticket

AFAIK you´ll need Ticket::Hook, Ticket::HookDivider followed by your TicketNumber. Make sure that you take possible spaces from your Ticket::HookDivider (e.g. ': ') to your other systems configuration.
It might also be possible, that OTRS requires a 'RE' or something similar at the beginning of the subject to recognize that it is no new ticket.
openSuSE on ESX
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems
Locked