Copy TABLE email body data into ticket fields

English! place to talk about development, programming and coding
Post Reply
cris12345
Znuny advanced
Posts: 105
Joined: 24 Feb 2017, 16:45
Znuny Version: 5.0.16.01
Real Name: Cristina Corrales
Company: -

Copy TABLE email body data into ticket fields

Post by cris12345 »

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
Znuny wizard
Posts: 380
Joined: 20 Sep 2010, 16:54
Znuny Version: OTRS 6 CE
Real Name: Alexey Yusov
Company: Radiant System Group s.r.o
Location: Prague
Contact:

Re: Copy TABLE email body data into ticket fields

Post by alexus »

Hello,

Have you tried to use PostmasterFilters?
Alexey Yusov

Production: OTRS CE ITSM 6.0.28 on CentOS 7 + Apache 2.4 + MariaDB 10.4.13 + Radiant Customer Portal

Radiant System OTRS Intergrator
RS4OTRS marketplace
Stay tuned on our Facebook
((OTRS)) Community Edition - what next?
cris12345
Znuny advanced
Posts: 105
Joined: 24 Feb 2017, 16:45
Znuny Version: 5.0.16.01
Real Name: Cristina Corrales
Company: -

Re: Copy TABLE email body data into ticket fields

Post by cris12345 »

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
Znuny wizard
Posts: 380
Joined: 20 Sep 2010, 16:54
Znuny Version: OTRS 6 CE
Real Name: Alexey Yusov
Company: Radiant System Group s.r.o
Location: Prague
Contact:

Re: Copy TABLE email body data into ticket fields

Post by alexus »

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 CE ITSM 6.0.28 on CentOS 7 + Apache 2.4 + MariaDB 10.4.13 + Radiant Customer Portal

Radiant System OTRS Intergrator
RS4OTRS marketplace
Stay tuned on our Facebook
((OTRS)) Community Edition - what next?
cris12345
Znuny advanced
Posts: 105
Joined: 24 Feb 2017, 16:45
Znuny Version: 5.0.16.01
Real Name: Cristina Corrales
Company: -

Re: Copy TABLE email body data into ticket fields

Post by cris12345 »

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.
Post Reply