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:


Pakistan native tries to demystify his native country with software start-up
Washington Post
The business he created is called 10Pearls, a profitable custom software company based in Herndon, Va., and Pakistan. The company has more than 150 software experts supervised by Aftab's brother in a 33,000-square-foot office in Karachi. Only about 15 ...


How HubSpot is Carving out a New Niche in CRM
BostInno
Its all-encompassing dashboard and dynamic timeline view aim to let sales teams to easily view contacts, deals and tasks as well as identify opportunities and leads at a glance. The software also pulls in all relevant information from Web activity ...


Slate Magazine

Should Software-Makers Be Held Liable for the Sony Hack?
Slate Magazine
In an era when software is at the heart of so much of what we do, this seems a bit absurd. What if General Motors and every other auto manufacturer made you agree to language like that when you bought a car? Do you think the highways would be safer?


China's software, IT sector growth slows
Xinhua
BEIJING, Dec. 21 (Xinhua) -- Both revenue and profit of China's software and information technology sector slowed in the first 11 months of this year, new data showed Sunday. The sector generated around 3.3 trillion yuan (539 billion U.S. dollars) in ...

and more »

Moneris and Syrasoft Introduce Enhanced Integrated Payment Solutions for Self ...
Business Wire (press release)
SCHAUMBURG, Ill.--(BUSINESS WIRE)--Moneris Solutions, Inc. (“Moneris”), a wholly-owned subsidiary of Moneris Solutions Corporation and Syrasoft Self Storage Software (“Syrasoft”), announced a partnership to provide two new integrated payment ...

and more »

Entrepreneur

Don't Get Stuck in the Software Jam
Entrepreneur
Anyone who tries to select accounting software, email marketing tools, and scheduling automation all at once is bound to make a bad choice. You don't need every bit of software out there, so your first job is to prioritize tools that will really make a ...

and more »

Los Angeles Times

Software upgrades re-create old-school toys as smart playthings
Los Angeles Times
Balls. Dolls. Race cars. So dull. How can good old-fashioned toys like these compete for children's attention when the kids seem umbilically connected to their iPads? How about software-upgradable balls, dolls and race cars? Established toy makers and ...


CIO

Three Ways Enterprise Software Is Changing
CIO
Once upon a time, life in the enterprise IT shop was fairly simple, at least conceptually speaking. IT issued computers and laptops to employees, and maintained enterprise software, databases and servers that supported the company, which were mostly ...
Announcing @IsomorphicHQ to Exhibit at @DevOpsSummit New York [#DevOps]SYS-CON Media (press release)

all 19 news articles »

New York Times

New Software Helps Connect the Money Dots in Politics
New York Times
Consider this a last-minute holiday present for the campaign finance enthusiast on your list. Today The Upshot is releasing a piece of software that helps define the relationships between federal political action committee donors and their recipients.


ZDNet

​Free software GNU/Linux laptop in development
ZDNet
Linux laptops are available from major computer OEMs such as Dell and Lenovo and specialized Linux vendors such as System76 and ZaReason, but the Free Software Foundation (FSF), which would prefer it if I referred to Linux as GNU/Linux, doesn't ...
Purism discovered how to make open-source software laptops even more openPCWorld

all 7 news articles »
Google News

Falling in Love With More Than One Screensaver: The Fun Part

Having from five to ten and more favorite screensavers is... Read More

Software Piracy

SOFTWARE PIRACY We regularly hear reports... Read More

Destination: Desktop for Google

First we had the original Google search that evolved into... Read More

Microsoft Great Plains Integration with Legacy Systems ? Overview For Developer

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

Instant Messenger Clients

If you have been using the Internet for any amount... Read More

Putting Screensavers Under Control

No matter how much you enjoy your favorite screensavers, sometimes... Read More

FreeDOS

Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More

Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

Microsoft Retail Management System serves retail single store as well... Read More

Not All Project Management Software is Created Equal

The purpose of Project Management Software is to provide an... Read More

The End of Spyware?

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

How To Identify, Cure and Prevent Spyware/Adware Infections

Just when you thought you were Web savvy, one more... Read More

The Tools and Features of Adobe Photoshop

Adobe Photoshop is one of the world's leading graphics editing... Read More

Make 2005 the Year You Save Time!

Today's business world is fast-paced. No matter what it is... Read More

Brand Your Websites URL With a Favicon

Have you ever noticed that when you look at your... Read More

Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

Microsoft Business Solutions Great Plains serves multiple industries in the... Read More

Simple Solution for Php Includes - IFrames

I have recently created my first Php program. I wanted... Read More

5 Easy File Management Tips in Microsoft Word

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

The Hidden Power of Online Manual

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

What is Fleet Maintenance Management?

Fleet Maintenance Management is a critical position in any company... Read More

Microsoft Great Plains Customization and Development ? Overview for Programmer

When Great Plains Software was designing and developing Great Plains... Read More

Snort for Network IDS

What is Snort?Snort is an open source network intrusion detection... Read More

Oracle Development: JDeveloper 10G ? Java, J2EE, EJB, MVC, XML - Overview For Programmer

In 2004 Oracle, Inc. made its new step toward J2EE... Read More

Causes of ERP Failures

ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More

Unwanted Files

A LOT OF UNWANTED FILES.When you uninstall an item of... Read More

Separate Anti-Keylogging Protection: Who Needs it Most?

If there still are few unprotected computers left, I haven't... Read More