Hi,
In my current setup;OTRS recieves emails in below format and ticket is to be created.Though ticket creation is working;i need to capture values between tags to corresponding OTRS fields.
like "Nancy" to first name field in OTRS;
Need guidance in How to extract this values and put this in database fields
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<BusinessName>
Dear Ravi, this is an interesting one :-) I’ve never been with a customer yet who received XML within the email body in plain text, but I will properly add a blog post about this. However, you should use postMaster filter for this with regular expressions. As this can become very complex I recommend to use the famous online reg ex editor on http://gskinner.com/RegExr/ If you find your way, please come back to the list so I may receive useful content for the blog :-) On 28.09.2011, at 05:24, ravi shanker wrote:
In my current setup;OTRS recieves emails in below format and ticket is to be created.Though ticket creation is working;i need to capture values between tags to corresponding OTRS fields. like "Nancy" to first name field in OTRS;
Need guidance in How to extract this values and put this in database fields
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <BusinessName>
<FirstName>Nancy</FirstName> <LastName>B</LastName> <Phone>9885098850</Phone> <Email>nancy.b@test.com</Email> <CaseTitle>email submission</CaseTitle> <Priority>Normal</Priority> <Severity>Medium</Severity> <CaseType>Webform</CaseType> <PCC1>INVOICE STATUS</PCC1> <PCC2>NON-PO INVOICE</PCC2> <PCC3>please specify</PCC3> <PCC4>please specify</PCC4> <AttachmentLink/> <QueueName>Pharma</QueueName> <Description>please transfer to me</Description> </BusinessName>
-- Cheers, Nils http://webint.cryptonode.de / a Fractal project
participants (2)
-
Nils Leideck -
ravi shanker