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:


Statesman Journal

DMV software upgrade could cut local road funds
Statesman Journal
The Oregon Department of Transportation has approached the legislature with a proposal to spend $90 million over the next 10 years on a software upgrade of its Driver and Motor Vehicle Services Division. But the proposal has cities and counties worried ...


Lifehacker

Pixar's Powerful 3D Rendering Software RenderMan Is Now Free to Use
Lifehacker
It's important to note that RenderMan is not a 3D modeling application, so you'll need to make some 3D models or animations to render first. It can be used alongside Maya, as well as the lighting program KATANA (with compatibility for more software ...

and more »

Bleeding Cool News

The Cult Of Souls – Why Hardcore Attitudes Towards From Software's Titles Can ...
Bleeding Cool News
(Disclaimer: So far, I think Bloodborne is an incredible game. This is not a review (that will come in the next few days) or even frankly about From Software's games directly. It's especially not meant to annoy fans of the games. As stated several ...


Forbes

Teradata Integrated Marketing Cloud: A Bet On Evolution of Software
Forbes
If you are an entrepreneur seeking to create a new software product, these days by default you choose the Software as a Service model. This model offers lots of advantages and eventually will likely be the dominant model. But it should be pointed out ...


Science AAAS

Hoax-detecting software spots fake papers
Science AAAS
The goal, says Stribling, now a software engineer in Palo Alto, California, was “to expose the lack of peer review at low-quality conferences that essentially scam researchers with publication and conference fees.” The program—dubbed SCIgen —soon ...


Forbes

Business And Marketing Software Trends To Watch Out For In 2015
Forbes
Software and tech predictions have been the talk of IT town for a good bit of time, particularly when 2014 came to a close. Despite the fact that predictions are just that – predictions – and may either come to fruition or not, they point businesses in ...


Auto Stock Roundup: Tesla Updates Software, AutoZone Raises Buyback
Zacks.com
The software will alert the driver about the battery charge and thus reduce the risk of the vehicle running out of power. Moreover, Tesla is working on another software update that will enable hands-free driving on the highway in the near future (read ...


Data Center Knowledge

Software Defined Storage Startup Hedvig Raises $12.5M
Data Center Knowledge
After three years in stealth, software-defined storage company Hedvig wants to change the way enterprises approach and architect storage. The storage startup plans to spend the $12.5 million recently raised from investors that include Atlantic Bridge ...

and more »

Boston Globe (subscription)

Feeling fit? Firm unveils software to let your doctor know
Boston Globe (subscription)
Westborough-based eClinicalWorks, one of the largest companies selling electronic health records to medical practices, has launched a software feature to link dozens of popular consumer devices — including fitness trackers, scales, and blood sugar ...


Biz News: Lexmark acquiring Irvine software company for $1 billion
Daily Pilot
Printer manufacturer Lexmark will acquire Kofax, an Irvine-based customer information software company, for $1 billion, Lexmark announced Wednesday. Kofax, which was founded in 1985 and has more than 20,000 customers worldwide, had revenue of ...

Google News

SyncUp ? A File/Folder Synchronizer For Windows

SyncUp, a file synchronizer is designed to assist the home... Read More

5 Easy File Management Tips in Microsoft Word

How many steps does it take you to locate and... Read More

Freight Forwarding ERP: Microsoft Business Solutions Great Plains customization & setup ? overview

Microsoft Great Plains may be recommended for international freight forwarding... Read More

The Hidden Power of Online Manual

Writing software manuals is boring, isn't it? We often think:... Read More

Configure Windows Indexing Service for Performance

The Windows Indexing Service provides you with the ability to... Read More

C++ Tutorial 1, Introduction to C++

Introduction to C++Why Learn C++?C++ may at first seem like... Read More

Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

The Dirt on Screensavers

Remember back in the days where screensavers were the coolest... Read More

Start Developing Your Own Software

Learning how to program software seems like a daunting task... Read More

Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More

Think Of This

Think of this, first we had the HAM Radio, then... Read More

Passwords Used In Microsoft Word Documents

You would like to protect your documents, wouldn't you? Reasons... Read More

Microsoft Great Plains: Government & Non-Profit Organization ? Workflow Implementation

Usually workflow & messaging is realized in CRM and then... Read More

Microsoft Great Plains: If You are Orphan Client ? What to Do and FAQ

Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More

Managing Stress in the Computer Industry - Five Steps to a Stress-free Life

It would be easy to think, like most people apparently... Read More

Microsoft Great Plains: carpet, textile, fabric, felt distributor ? implementation overview

In this small article we will show you the possible... Read More

Assertion in Java

Assertion facility is added in J2SE 1.4. In order to... Read More

Most Dangerous Types of Spyware are on the Rise: How to Choose the Weapon

Bad News - the Threat is Bigger than it SeemedHow... Read More

How Do I Get Rid Of That Darn Spyware?

Ad-Aware and Spybot are probably the two most well known... Read More

Software Piracy - Global Increase

Pirated software is on the increase and now accounts for... Read More

Microsoft Great Plains Multicurrency ? Overview For Implementation Consultant

When you first think about multicurrency ? you probably have... Read More

Microsoft Great Plains Reporting ? Overview for Developer

Looks like Microsoft Great Plains becomes more and more... Read More

Great Plains DOS Support ? Notes for Consultant

Great Plains Accounting, accounting package for mid-size and small companies... Read More

MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains

If you look back to the history, you will see... Read More

Software Development in 2005 - Back to the Future

2005 ? Back to the Future.What does the future hold?... Read More