Copy TABLE email body data into ticket fields

English! place to talk about OTRS development, programming and coding

Moderator: tto

cris12345
OTRS expert
Posts: 88
Joined: 24 Feb 2017, 16:45
OTRS Version?: 5.0.16.01
Real Name: Cristina Corrales
Company: -

Copy TABLE email body data into ticket fields

Postby cris12345 » 21 Jun 2017, 00:03

Hello,

Is there a way to create a ticket based on a table in the email body?
where the body table ihas only two columns: "Columns Name List"| "Values"

For example:

Type | type1
RequestorName | Cristina
Location | CR
...etc

So I want that OTRS ticket type automatically be completed with type1 and my dynamic field Location filled as CR
And avoid the needed of do it manually.

alexus
OTRS superhero
Posts: 252
Joined: 20 Sep 2010, 16:54
OTRS Version?: ITSM 4.0.11
Real Name: Alexey Yusov
Company: Radiant System
Location: Prague
Contact:

Re: Copy TABLE email body data into ticket fields

Postby alexus » 23 Jun 2017, 19:08

Hello,

Have you tried to use PostmasterFilters?
Alexey Yusov

Production: OTRS ITSM 5.0.14 on CentOS 7 x64 Linux with MySQL 5.7
Tested: OTRS ITSM 5.0.14
Radiant System OTRS Intergrator
Stay tuned on our Facebook
Get OTRS Professional Services - Consulting, Implementation, Training, Development, Support!

cris12345
OTRS expert
Posts: 88
Joined: 24 Feb 2017, 16:45
OTRS Version?: 5.0.16.01
Real Name: Cristina Corrales
Company: -

Re: Copy TABLE email body data into ticket fields

Postby cris12345 » 23 Jun 2017, 21:34

Yes I used it.
But is not what I need because I can find data from body searching and specific word.
Or maybe has a functionality that I don't know
Because sometimes the field can be null or is a name so I have to read it because I don't know the options it can contains.

alexus
OTRS superhero
Posts: 252
Joined: 20 Sep 2010, 16:54
OTRS Version?: ITSM 4.0.11
Real Name: Alexey Yusov
Company: Radiant System
Location: Prague
Contact:

Re: Copy TABLE email body data into ticket fields

Postby alexus » 23 Jun 2017, 21:39

If body structure is not predefined it's very complicated to get structured data from email. Can you provide more examples?
Alexey Yusov

Production: OTRS ITSM 5.0.14 on CentOS 7 x64 Linux with MySQL 5.7
Tested: OTRS ITSM 5.0.14
Radiant System OTRS Intergrator
Stay tuned on our Facebook
Get OTRS Professional Services - Consulting, Implementation, Training, Development, Support!

cris12345
OTRS expert
Posts: 88
Joined: 24 Feb 2017, 16:45
OTRS Version?: 5.0.16.01
Real Name: Cristina Corrales
Company: -

Re: Copy TABLE email body data into ticket fields

Postby cris12345 » 05 Jul 2017, 16:18

Sure, I attached two images. One is how the email body looks and the other is how the table structure is without borders.
Basically is a title, then appears the table (2 columns) and the rows count can change and later other title.

Thanks
You do not have the required permissions to view the files attached to this post.


Return to “OTRS Developers”

Who is online

Users browsing this forum: No registered users and 2 guests

cron