Microsoft CRM Integration & Customization: SharePoint Document Gateway

MS CRM is very close to document workflow automation, including Microsoft Office documents: Words, Excel, etc. The document workflow was perfectly automated about 10 years ago in Lotus Notes Domino. In this small article we describe the solution based on MS CRM integration with MS SharePoint.

Microsoft CRM is new player on CRM applications market and it is gaining its market share. Having different paradigm in its design (it stakes on Microsoft OS and technologies and completely disregards alternative platform, such as UNIX, Linux, Oracle, etc. based). Microsoft CRM market is very diversified: from small (5 users) to large (several hundred MS CRM User licenses) and it serves variety of industries: Transportation, Logistics, Lawyers, Pension Funds, High-Tech, and many others. Deploying technologies, like Windows Active Directory, Microsoft Exchange 2003/2000, SQL Server, Crystal Reports Enterprise, Biztalk, Microsoft Outlook, Internet Explorer, Microsoft Great Plains and Navision in close future - makes CRM a beloved system for Microsoft oriented IT departments.

Let's go right to the topic.

Major issue with storing documents in MS CRM in the form of attachments to Activity is inability to work on these attached files in cooperation with other colleagues, who do not have to use CRM. When several service people serve requests from the same client this is required. Currently you can use alternative way when you store office documents in the folders of your file system and when modifying document, you save it and reattach to CRM. This is inconvenient, because first it requires all your editing users to have CRM licenses, which delays CRM implementation.

We seem increasing popularity of document storage systems, like Microsoft SharePoint, Oracle Files, etc. Such systems, being implemented gives you time savings, related to documents revisions and versioning, approval cycles and workflows, web access through web-portals systems and the like.

The target of our product is Microsoft SharePoint integration with MS CRM for document storage. Let's take a look at the high level technical realization details:

?Main modification from the MS CRM side is standard system behavior change when you open attachment in Activity. Standard unmodified CRM suggests you to store documents in the file system. Modified version sores document in SharePoint Document Library (the required library is subject for setup by MS CRM system administrator) or keep it in MS CRM as is (for documents of minor importance). From the moment of saving the document in SharePoint Document Library it is not stored in MS CRM ? CRM will now store only the link/reference to the document. Also you are given the ability to open and modify the document at the place of opening, which speeds up MS CRM user performance substantially.

?Table, storing the links to the documents sits in separate database and doesn't deal with MS CRM tables (you know that you are banned to do structure changes in MS CRM db)

?Document saving into MS SharePoint process occurs in MS CRM and with its assistance ? SharePoint bridge, which does addition and update for the existing document into destination Document Library with MS SharePoint Web Services calls

?Upon the addition into Document Library, MS CRM ? SharePoint bridge registers the document in the special table for the future data extraction or notification mechanism registration

?Then, interested users can work with the documents just using MS Office 2003 or other programs/editing tools, assuming these tools have access to MS SharePoint

?Feedback is provided by MS SharePoint Event Handler component. This is special handler, inspecting document change status, transferred from MS CRM to document storage (SharePoint), and report Activity owner on the changes with home page notifications (User home page in MS CRM). User in turn can review the history of the document editing - who, when and where is the change

?Opening Activity, where document is "attached", and in fact placed into MS SharePoint Document Library, and pressing opening button, MS CRM user gets live version of the data

?This approach allows you seamless work with MS CRM document in the whole informational space of your company

?Additional enhancements to this product might be document library management directly from MS CRM (web interface - meaning remotely), administrative interface for MS Sharepoint documents revision, ability to create reports on the document storage status, rights/access management (Author, Reader, Contributor etc) from MS CRM, portal pages integration into MS CRM to name a few.

Happy programming, implementation, customization and modification! If you want us to do the job ? call use 1-630-961-5918, 1-866-528-0577! help@albaspectrum.com

Boris Makushkin is Lead Software Developer in Alba Spectrum Technologies ? USA nationwide Oracle, Navision, Microsoft CRM, Microsoft Great Plains customization company, serving Chicago, California, Arizona, Colorado, Texas, Georgia, Florida, New York, Canada, Australia, UK, Russia, Europe and internationally ( http://www.albaspectrum.com ), he is Oracle, Unix, Microsoft CRM SDK, Navision, C#, VB.Net, SQL developer.

In The News:


Wall Street Journal (blog)

AppDynamics Raises $120M, Valued at $1 Billion for Corporate Software
Wall Street Journal (blog)
For instance, AppDynamics' software now can help businesses figure out whether their applications are affecting the experience of users on their website, and if so whether the problems are costing that business revenue and how they can be fixed. A ...

and more »

Forbes

Inside The Software That Shapes Your Music: Announcing A New Series
Forbes
Earlier this summer, friend and colleague Zack O'Malley Greenburg published a fascinating book entitled Michael Jackson Inc. Its titular subject covered not only the music of the Gloved One, but took a concentrated look at the fiscal acumen of a titan ...


Fstoppers Reviews the FoCal Autofocus Calibration Software
Fstoppers
Once you've opened the FoCal app and connected the camera the software will help get your camera in the right position, detecting pitch, roll, and elevation deviations that might impact the test results. After you've gotten everything lined up you'll ...


The National Law Journal (registration)

Feds Join Lawsuit Alleging Symantec Overcharged Agencies for Software
Nextgov
The suit alleges Symantec failed to disclose to government customers deep discounts it offered its favored commercial clients during the negotiation and performance of a 2007 multiple-award schedule software contract. That in turn caused agencies to ...
Software Maker Symantec Faces False Claims SuitThe National Law Journal (registration)
Feds hit software firm for false claimsThe Hill

all 12 news articles »

How to Govern Cheese: Or, Controlling Your Software Assets Through a ...
CIO
In many cases, these are a diverse set of endpoints including mobile devices used by individuals who hardly think twice at installing some new piece of software. In those instances, how is a manager even supposed to know where the devices are? Even ...


Senior-living software companies merge
Sun-Sentinel
The combined companies will result in one of the largest software companies in South Florida and one of the largest health care IT companies focused on seniors. Together, the companies employ more than 200 professionals and provide software solutions ...


Manufacturing analytics software firm raises $1.4M
Portland Business Journal (blog)
Northwest Analytics has been around for 30 years, but this week the software maker disclosed it's first round of outside funding. The Portland-based company raised $1.4 million from 18 investors, according to documents filed with the U. S. Securities ...

and more »

Hospitals upgrade software to improve ambulance service
Springfield News-Leader
Michelle Leroux, a spokeswoman for CoxHealth, said the health system is updating its software to let dispatchers visually compare what ambulances are available. "We have had software that allows the dispatchers to see available ambulances for a number ...

and more »

iTunes Software and Services fastest growing Apple business segment this year
Apple Insider
iTunes Software and Services fastest growing Apple business segment this year. By AppleInsider Staff. During Apple's quarterly conference call for the third fiscal quarter of 2014, CEO Tim Cook said iTunes software and services was the fastest growing ...

and more »

Healthdirect Australia looks through the 'software lens'
ZDNet
Haefele said the approach the organisation took from the get-go on making decisions was to look at everything through a "software lens" based on the knowledge that software applications was going to play a crucial role for the business going forward.

Google News

Software Review: Xsitepro Total Site Management Software

It's not very often I get excited about a software... Read More

Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing

Microsoft Great Plains is now targeting large and midsize businesses... Read More

Secure File Transfer Using SSH Plus Additional Audit & Automation - FSA Reporting

In order to meet regulatory and corporate compliance requirements reporting... Read More

Microsoft Great Plains - Typical Problems And Fixes ? Overview For IT Administrators

How to delete the user? This is the first problem... Read More

Microsoft Great Plains BR: Bank Reconciliation

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Resume Software ? Advantages Revealed

The various resume software offered, particularly on the internet, can... Read More

Why Stick With Email Clients Like Outlook?

Trying to figure out a stream in banning one email... Read More

Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More

Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

Corporate Accounting System: Microsoft Great Plains ? Overview

Corporate ERP/MRP selection might be tough one, especially considering very... Read More

Lotus Domino: Application Integration ? A Programmer View

There are two approaches for application integration:? Programmer's approach ?... Read More

Upgrading Great Plains Dexterity Customization ? switching to new technologies: SQL, Crystal, eConne

1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More

Examining the Substance of Studio MX

To all web designers out there, this article is for... Read More

Microsoft Great Plains Project Accounting ? Overview For IT Director/Controller

Microsoft Business Solutions is now in process of creating so... Read More

Lotus Domino Implementation and Development: Infrastructure ? Present and Future

Domino server is a buffer between the operation system and... Read More

A Simple Computer Software Definition

What is Software?Software is a set of instruction written to... Read More

Interactive Mapping Brings Information to Life

What is Interactive Mapping?Interactive mapping is a visual display medium... Read More

The Software 2005 Conference - A Review

The Software 2005 conference is now a wrap. This conference,... Read More

Scrap Booking Online: Word Perfect or Corel Graphics Suite?

Scrapbooks are very popular these days. I think that almost... Read More

Microsoft Axapta, Navision or Great Plains: ERP Selection for Large Corporation

If you would like to pick something from Microsoft, or... Read More

The End of Spyware?

The US House of Representatives has recently passed the "Spy... Read More

Dashboard Widgets for Windows

For a windows user like me, just can watch with... Read More

Microsoft CRM Integration With Microsoft Office Documents ? Overview For System Integrator

Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More

Computer Phones ? Facts and Fallacies

The stakes are high when considering security, privacy, and savings,... Read More

Microsoft Great Plains implementation: Restaurants Supply Chain Management Example

Microsoft Great Plains serves majority of US based horizontal and... Read More

Microsoft CRM Integration with Microsoft Retail Management System (RMS) ? Overview

Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More