Re: Email Integration. - Bryan Alsdorf - com.mysql.lists.eventum-users

9 messages in com.mysql.lists.eventum-usersRe: Email Integration.

From	Sent On	Attachments
Tim Uckun	21 Feb 2006 15:10
Tim Uckun	22 Feb 2006 14:34
Ryan Lovelett	22 Feb 2006 14:52
Tim Uckun	22 Feb 2006 14:54
Bryan Alsdorf	23 Feb 2006 22:08
Tim Uckun	23 Feb 2006 23:26
Ryan Lovelett	24 Feb 2006 08:25
Steve Stefanovich	28 Mar 2006 06:19
Bryan Alsdorf	28 Mar 2006 07:54

Subject:	Re: Email Integration.
From:	Bryan Alsdorf (bry...@mysql.com)
Date:	03/28/2006 07:54:16 AM
List:	com.mysql.lists.eventum-users

FYI,

I have gone ahead and included this snip for the next release of Eventum, which I am starting to work on today.

Best Regards, /bryan

Steve Stefanovich wrote:

I've got it working (subject based routing and auto-creation of the issues) with Bryan's code.

Be careful to put the "else" snippet at the right place.

This is what you should have:

// look for [#XXXX] in the subject line if (preg_match("/\[#(\d+)\]( Note| BLOCKED)*/", $subject, $matches)) { $should_create_issue = false; $issue_id = $matches[1]; if (!Issue::exists($issue_id, false)) { $issue_id = ''; } elseif (!empty($matches[2])) { $type = 'note'; } } else { $should_create_issue = true; }

-----Original Message----- From: Ryan Lovelett [mailto:RLov...@simplifiedsoftware.org] Sent: Saturday, 25 February 2006 3:25 AM To: Bryan Alsdorf Cc: Tim Uckun; even...@lists.mysql.com Subject: RE: Email Integration.

Ok well Bryan I applied that code to the class.support.php file. And the files are still sitting int the Associated Emails section marked pending.

But here is the question: do I perhaps have it setup wrong?

I have two email inboxes. One is Info...@mydomain.com and that one grabs the emails and makes my issues automatically.

The next one is mess...@mydomain.com this one is where emails are sent from, and returned to. That should automatically seperate and associate the emails with the correct issue.

The first of the two email accounts ('information') is pulling down emails and creating an issue automatically. Works great. And the second email account ('message') is pulling down fine too. It just isn't creating the issues. Have I got this setup correctly. Or is this all wrong?

________________________________

From: Bryan Alsdorf [mailto:bry...@mysql.com] Sent: Fri 2/24/2006 1:08 AM To: Ryan Lovelett Cc: Tim Uckun; even...@lists.mysql.com Subject: Re: Email Integration.

Hi Ryan,

Ryan Lovelett wrote:

Tim you cannot have the subject based routing turned on to get it to make a ticket. Then you have to click on the list of Auto-Creation of issues and get it to be associated with an issue. That is how I got mine to auto create the tickets.

My problem is that I cannot have both at the same time. That is what I'm still trying to figure out.

I sent this to another user but forgot to CC the list.

I don't have time to test this, but I have a suggestion. If it works, let me know and I will incorporate it into our next release.

Edit include/class.support.php, the createIssueFromEmail method.

After this code: // look for [#XXXX] in the subject line if (preg_match("/\[#(\d+)\]( Note| BLOCKED)*/", $subject, $matches)) { $should_create_issue = false; $issue_id = $matches[1]; if (!Issue::exists($issue_id, false)) { $issue_id = ''; } elseif (!empty($matches[2])) { $type = 'note'; } }

Add: else { $should_create_issue = true; }

That code should enable both subject based routing and auto creation of issues.

Let me know how it works for you.

/bryan

-----Original Message----- From: Tim Uckun [mailto:timu...@gmail.com] Sent: Wednesday, February 22, 2006 5:35 PM To: even...@lists.mysql.com Subject: Email Integration.

So far I have been able to get eventum to pick up the emails using subject based routing. I would however prefer to have these emails turned into tickets. If I click on "use this email for routing" It does nothing. It checks the email box, marks the message as read does not delete it from the inbox, does not create a new ticket.

Does this mean I can't use subject based routing and auto creation of tickets?

Are you MySQL certified? www.mysql.com/certification