Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MS Dynamic CRM 2011 Ticket System (route email as case)

Posted on 2013-02-04
14
Medium Priority
?
2,004 Views
Last Modified: 2013-03-04
We are using MS Dynamics CRM 2011, and would like to use the  "cases" as our ticketing system. What I want to do is route all emails to support@domain.com to our CRM, so it automatically creates a case.

This seems possible (at least, thats what I read on the internet), but I can't find how to setup this email routing.

Can anyone tell me how I set that up?

E-Mail received for support@domain.com >> CRM Email router >> Create case
0
Comment
Question by:redworks
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 6
14 Comments
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 38850744
There are several steps to achieve your requirement:

1.

Create a mailbox for the support email address

2.

Create a queue in CRM and add the support email address to the queue. Configure the incoming email option for the queue to all e-mails.

3.

Install and configure the e-mail router
Installing and configuring the e-mail router is a topic in its own right but as a minimum you must configure an incoming profile which tells the e-mail router where to find incoming e-mails and a deployment which tells the e-mail router the location of your CRM web services. There are options for how to connect to Exchange to get incoming e-mails. You may need to read up about that. An option I recommend is to use a Forward mailbox.


4.

Create a workflow that creates a case when an e-mail is received. An alternative to this is to consider a third-party e-mail to case add-in for CRM such as that from c360. But see what you can acheive with workflow first.
0
 

Author Comment

by:redworks
ID: 38850765
Thanks for your reply. I was just trying that when you sent it :)

I created a mailbox, added a queue with the matching support@domain.com, fired up Email router, loaded data. Saw queue. Pressed test button, and it gives me:

Name: Support system
Incoming Status: Failure - Error: ErrorNonExistentMailbox


Server: https://exchange2013/EWS/Exchange.asmx
Outgoing Status: Succeeded

Any clue? (using Exchange 2013, with CRM2011 rollup 12 (which supports exchange 2013))

PS: needless to say, the mailbox support@ DOES exist... I can login using Webmail, and see "support@"...
0
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 38850789
Hmm, couple of thoughts. The e-mail addresses on the mailbox and the queue do not match (does the mailbox have more than one e-mail address?) or the credentials specified for the incoming profile are not sufficient to look at the mailbox.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 38850803
By the way, where did you see that the e-mail router supports Exchange 2013?  This article http://support.microsoft.com/kb/2669061 does not include Exchange 2013.
0
 

Author Comment

by:redworks
ID: 38850804
I created an access user "dynamiccrmemail", and gave that all permissions for incoming. I tested this with a CRM *user* account (not a queue), and that works. Furthermore, this user (dynamiccrmemail) is also the account holder of support@domain.com (I see this in webmail, when I login with that user).

So, credentials are ok, email address matches (I reconfigured again, copy/paste, just to be sure)
0
 

Author Comment

by:redworks
ID: 38850858
Hmm, weird... After getting come coffee, I clicked the test button again and it was succesful... Maybe it had to sync? No clue... But it works now.

However, I am having trouble creating the workflow.
Under the queue, I can not create the workflow (dont see ADD)

Under settings, I go to processes, and create a workflow. However, I don't see the option "receive email" anywhere.... How do I do this?
0
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 38850883
Go to Settings | Workflow.

Create a workflow (type process) for the email entity. In the workflow select Scope, organization and Start when record is created.
0
 

Author Comment

by:redworks
ID: 38850915
OK, doing that...

Go to settings, processes, create process, workflow
Processname: "Create Ticket"
Entity: E-Mail
Category: Workflow
New blank process

Then, I leave all defaults, select Scrope: Organization (why this option?)
I click "add step", Create Record.
Create Case
I click Properties

Problem is: I have to enter a title, and customer... It is possible a non-existing customer (i.e., does not exist as record) can E-Mail us...

Furthermore, I can not seem to be able to set the DESCRIPTION field...

How to do this?
So a case is generated, with the name+email adres of the FROM header of the email, and description of the E-Mail as case text?
0
 

Author Comment

by:redworks
ID: 38852641
See link below. Allthough this is for CRM4 and I am using CRM2011, it should be the same.
http://blogs.msdn.com/b/crm/archive/2008/02/19/e-mail-to-case-lead-using-crm-4-workflow.aspx

I follow the steps exactly, and in System Jobs I see the task as executed and completed, it does not create the actual case... What am I doing wrong??
If I create a case manually, it works fine...
0
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 38853029
It may help if you post a screenshot of your workflow. Does your workflow include a create case step and is the workflow running for emails as they are arrive in the queue?

Open an e-mail in the queue and then click Workflows in the left-hand navigation. This will show a list of system jobs, one record for each time the workflow ran for the e-mail. Double-click the system job. In the system job window you will see the steps for your workflow with ticks against each step that was executed.
0
 

Author Comment

by:redworks
ID: 38854156
See image below. All seems to go OK.
(I use service@, not support@)

Email router picks up mail, workflow processes it (see it in system jobs also), and all seems to go OK, except for creating the case...

Workflow process
0
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 38856910
Your screenshot looks like the outcome of a workflow running (i.e. a log). I see the first green tick but the absence of a tick against create case suggests that the if check failed and nothing else was processed.

Try changing the test to If E-mail: To equals and then click the lookup to your queue rather than using To Recipients.
0
 

Accepted Solution

by:
redworks earned 0 total points
ID: 38934141
I managed to resolve this using not "equals" but "contains" in TO. Then it works
0
 

Author Closing Comment

by:redworks
ID: 38949150
this was the answer
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Solr 4.0 it is possible to atomically (or partially) update individual fields in a document. This article will show the operations possible for atomic updating as well as setting up your Solr instance to be able to perform the actions. One major …
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses
Course of the Month8 days, 12 hours left to enroll

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question