Outlook integration

One thing I always get into confusion over in these areas - does the user want OUTLOOK integration or EXCHANGE integration.

Consider that an Outlook integration historically is when a user opens Outlook (or other office apps) on their desktop and wants to do some things to pull data from ERP seamlessly?
In other folks minds, they want to interact with the server receiving emails and documents and feed that to the ERP system automatically, no client involved (just a usually suspicious Exchange admin).

These are two very different needs and technologies. Fast forward to today with Outlook on a tablet and phone, O365 and all and things can be even more challenging to cover all users scenarios.

Do yourself a favor and do a deep dive into the scenarios they envision.

#BeCarefulOnRequirements

4 Likes

This is a good topic and thank you to everyone who have responded. We have been using Dynamics CRM for years because of its Outlook integration. In the past, when cell data was slow and expensive, having offline data for traveling folks was key. We have written a 2 way sync (accounts/Customers and Contacts/Cust Contacts between the two systems which works very well. We have been patiently waiting for Epicor to improve their CRM offering to eliminate the need for the connection, but it’s just not there yet. Our version of Dynamics CRM is very outdated (although works for us) and we need to look hard at an updated solution. With so many customizations on both systems, it’s going to be a monster culture shock.

We use a module called information worker sold to us directly by Epicor.
It allows you to interact with Epicor data direct from outlook/word/excel.

works quite well for CRM, here is a screenshot to give you an idea

Hello,

How did you go about installing this Information worker?

It’s part of the Appserver set up. Add it there, then use the URL provided in the Appserver tab for IW to connect to from your PC. It will allow you to download the Outlook add-in. Then it’s just a matter of setting up the plugin for the connection and which objects you want to download.

We have a cheat sheet that may help you…
InformationWorker Install and Admin Notes [Safe to Dist].pdf (232.0 KB)

2 Likes

If I recall correctly, IW uses WCF. Do you have to keep the versions of IW in sync with your version of Epicor? Do you think that Microsoft and/or Epicor will replace the model with REST?

Just curious,

Mark W.

Good question. I believe it does need to be kept in synch otherwise the new fields/etc would not be reflected. Also, it processes task completion and a few other things so I’m pretty sure it’s version dependant. I’d love for them to go REST. Currently you have to be a VPN to use it… it needs to be SSL/REST based for field reps and such to use it. But then there is also Microsoft’s constant changes in Outlook that just make this all very difficult.

I also know for a fact that you can only have one IW appserver on a physical(or virtual) host. In other words, you cannot have your Prod and Test appservers on the same physical host and have IW set up both. You would need a completely separate host to have a TEST IW connection.

AND - worst of all for us - is that the individual sync for customer/contacts/etc can only have ONE filter criteria (as of 10.1.500.17). So you couldn’t filter the IW Synch for customers by company AND territory if you have some field service folks who should not see your entire customer base. We are really hoping that is fixed in the latest version since we put the DEV request in like two years ago…

I have NOT tested the new version yet since no one is actually using it after we found the above limitation.

1 Like

Does anyone know what happened with this product / company after the Epicor purchase? The link to the video for ConnectCX no longer works, and e-mails sent to them bounce.

Reach out to your CAM - they can find out - no matter waht they say, they CAN find out. Most are handled by CSG in the UK, btw…

Not all products from DotNetIT are available any more, but a lot are still available.

1 Like

You can try the following for access to the video…

https://epicweb.epicor.com/Support/EpicorERP/Downloads/Connect%20CX%20%20MS%20Outlook%20Call%20Logging/ConnectCX%20recording.aspx

1 Like

Very helpful - thanks! Still haven’t figured out how to find this stuff.
Also, still wondering if anyone has any information as to what has happened to this product since Epicor bought them…

1 Like

Thanks, Mike. Responses from our CAM have generally been nonexistent so far. Will keep chasing it.

Once you tell that it’s CSG in the UK, they can pass the buck to the right person… I might be able to dig up a name… I PM’d you a name…

1 Like

Here is the response I got, in case anyone else may find it useful:

Our extended solutions can now be found on EpicWeb here → Sign In

If you scroll down to Extended Solutions and then ConnectCX, you will find a recording you can download.

We do not currently have ConnectCX available for Epicor 10.2.300 or later but will make a version available if we receive a firm order. This work would need to be scheduled so please ensure you factor this into your plans.

Another thing to be aware of is that ConnectCX is only available for on-premise installations.

As we are SaaS, this solution won’t work for us, so we are investigating Information Worker. Not quite the same functionality, but hoping it will get us the basics we need.

I don’t think that the current Information Worker (a traditional Outlook Addon) is going to be getting much love as we move forward. The world is going to the browser (embedded in an application or standalone) and the older Information Worker architecture won’t work there. Just food for thought.

5 Likes

that’s a shame b/c it was SOOOOO much better than InfoWorker. And @Mark_Wonsil is correct, the IW processing only works with a full Outlook client installed, so it doesn’t look like ti has a bright future.

What we need is Epicor to write the REST/API Exchange Connector extension for the Appserver where we can configure Employees or Workforce records to synch with an Exchange Server and selectively move territory-filtered contacts, customers, tasks, appointments, etc. back and forth… My folks would pay BIG money for this as my mobile sales force doesn’t even have Outlook other than on their phone.

I’m tagging @Rich and @Bart_Elia and @josecgomez - to see if anyone wants to take on this challenge :slight_smile: (or to tell me if I’m ‘getting warm’ )

1 Like

Ahem…

Poorly named request but that’s exactly what I’m proposing here. However, I’m not limiting it to email. For a group that works with manufacturing people, we IT people sure like push systems! :rofl:

I’m suggesting more of an Actor Pattern where our customizations/BPMs/Functions just send the information to a queue. The notification system would then do what was needed: email, text, message, fax, Teams/Slack or whatever you dream up. The user would be in charge of how and when they would like to be notified.

The reason I said “outside of Epicor” and by that I mean E10, is then the product would work for Prophet 21, and the other Epicor products fulfilling the “Chicklet” vision we’ve seen at Insights.

2 Likes

Good one - universal is always better!!! Sorry I forgot about that request!

1 Like

As a bonus, you’ll be able to see what items were unsuccessful, how many times something was sent, etc.

They have the new notification engine in +500… (not sure if that will do everything though) but it can do hook type things (CDC)

2 Likes