Search ticket body for Phone number and map that to Customer

Moderator: crythias

Locked
logitools
Znuny newbie
Posts: 1
Joined: 16 Jul 2013, 12:00
Znuny Version: 3.2.9
Real Name: Ivo Pereira
Company: Logitools, Lda

Search ticket body for Phone number and map that to Customer

Post by logitools »

Hello everyone,

We have recently upgraded our old OTRS 2.x sofware, running on IIS 7.5 + SQL Server 2k8, to a CentOS 6.4 + MySQL + Apache solution.
All is working very well and now we need to start customizing OTRS.

We also have a Linux Elastix PBX that reports, via email, all missed client calls to our OTRS-fetched support mail account.
All works well but the PBX sends an email always from the same sender (pbx@somedomain.com), the email is received by OTRS and sent to a Queue, and the ticket body contains this text:

DATA: 2013-07-16 10:08:50
FILA: TECNICO NIVEL 3
NUMERO: 999999999


(the number is false for demonstration purposes and the text is in Portuguese)

I need to search for emails sent from this address (pbx@somedomain.com) and search the email's body for a 9 digit number. Then, since this number is recorded in my Client's Phone number field, I need to create this ticket to the corresponding client.

I thought of using the PostMaster::PreFilterModule###2-Match in System - Postmaster configuration but I can't map the phone to my Customer's phone.
Any ideas would be so very appreciated!

Thanks,
Ivo Pereira
Locked