Re: Integrating Remedy with Outlook

[Rodney Harris]

** Hi Dan,   Had a quick look at your program and I like it. I wouldn’t mind taking a look at the multiple data sources version as this will allow us to run Outlook on the server and keep a whole group of users in sync without any config on their end. We were intending to start with calendar sync anyway so the lack of contacts is something we can add later.  A config file for the multi data source version might be the way to go too as I wouldn’t want to be typing heaps of stuff in each time Outlook started.   Yes – I like the fact that it is free. Perhaps I can contribute to the project in return.   Good stuff!!   Rod   CMS Asset Solutions Level 10, 23-25 O’Connell Street Sydney Australia       From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dan Hardy Sent: Thursday, 7 September 2006 4:06 PM To: arslist@ARSLIST.ORG Subject: Re: Integrating Remedy with Outlook     You might look at:   http://www.sourceforge.net/projects/roi   It doesn't do anything with contacts...but it synchronizes tasks and/or calendar.  And it's free.  And open source.  And free.  And you could easily tweak it do contacts as well (provided you know a little C++/STL/ATL and are able to muck about with Outlooks' API).   I have an update coded locally that allows you to synchronize multiple data sources (any number of source for tasks and/or calendar).  It currently lacks a fancy UI for configuration of multiple sources, but takes a straightforward XML config file.  If there is interest....I'll get around to checking it in and putting a new build up for download.   Did I mention it's free?   Dan   From: Action Request System discussion list(ARSList) on behalf of Rodney Harris Sent: Wed 9/6/2006 7:24 PM To: arslist@ARSLIST.ORG Subject: Integrating Remedy with Outlook ** Hi All,   I’m looking at using a product called Genius Connect (or similar) to link our custom Remedy V7 CRM system to Outlook. The functionality we require is the ability for our sales force to use Outlook as their contact list, calendar and task list while retaining compatibility with our CRM. Has anyone done anything like this?   This is how I’m planning to do it.   1. When the user has an internet connection, Outlook synchronises with the Exchange server via HTTP or straight IP. The users use the offline cache feature of Outlook to retain access to their data when not connected. 2. A server runs Outlook with Genius connect installed and connects to each mailbox that we want synchronised. Periodically Genius Connect synchronises the Outlook mailboxes with an SQL database on the same server as our Remedy database via ODBC. 3. The Remedy server runs escalations that read and write to the intermediate SQL server tables. The intermediate tables allow for date conversions and allow Remedy to retain full control of its database. Remedy can read from the SQL tables via View Forms and write to them via direct SQL.   Is there a better way than this to do what we want? Has anyone done anything similar and would they share their experiences with me?   Thanks,   Rod Harris CMS Asset Solutions Level 10, 23-25 O’Connell Street Sydney Australia __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___