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:


CIO Today

Slideshow: VMworld 2014 highlights software-defined data center
Tech Page One
The platform is a software-defined infrastructure building block that will enable networking, storage and management for end users, remote offices and small virtual private clouds, said Duncan Epping, chief technologist at VMware, in a blog post.
VMware: Before us, software-defined networking couldn't be doneFierceEnterpriseCommunications
HP, VMware team on software-defined networking solutionITWorld Canada
Dell and VMware Collaborate to Deliver VMware NSX Solutions for the Software ...Wall Street Journal
Cloud Pro
all 45 news articles »

Wall Street Journal

VMware Moves to Defuse Software Threats, Plans Hardware
Wall Street Journal
The company used its annual conference in San Francisco to announce plans to distribute a version of OpenStack—a tool for managing data centers—and software offering features of a technology called containers that some companies use to develop and ...
VMworld 2014 Day 2 Keynote: Software-Defined Datacenter RealizedVirtualization Review
HP and VMware Collaborate to Simplify Software-Defined Data Center and ...CNNMoney

all 281 news articles »

New York Times (blog)

Google Buys Zync, Maker of Visual Effects Software
New York Times (blog)
The Internet giant announced Tuesday that it bought Boston-based Zync Inc., the maker of Zync Render, a “cloud-based rendering software.” That's software that helps movie studios take simple, computer-generated pictures of things like a giant robot ...


Software will eat the $1.2 trillion apparel industry
Fortune
That's why Apple has been shopping for executive talent at Burberry's, TAG Heuer and Yves St. Laurent, says Horace Dediu. Expanding on Mark Andreessen's observation that “software is eating the world,” Asymco's Horace Dediu took a close look Thursday ...


ZDNet

The mix of poverty and piracy that turned Romania into Europe's software ...
ZDNet
Software piracy and the large numbers of developers are "absolutely" connected, says Mihai Moldovanu, lead developer for the first Romanian Linux distribution TFM Linux, launched in March 2001. Piracy, along with Romania's high-speed broadband ...


Report: This Is Why LG Software Sucks
Gizmodo
If you've ever despaired with a piece of ropey LG software, you're not alone. But it's not just pure chance that's rendered it so bad—it's practically corporate policy. In a feature about how LG screwed up its webOS acquisition, GigaOM unearthed a ...

and more »

'The Shift': BYO Brings a Big Challenge to the Software Community
Wired
There was a time not too long ago when web sites and web applications prescribed directions on how each should be sourced to be properly viewed and utilized. For example, on many sites there was a banner that would proclaim that this application or ...


Android Police

AT&T Galaxy S5 Gets Minor Enhancements Via OTA Software Update ...
Android Police
Not all updates are created equal. Some are the kind that keep us up at night, leaving us banging on the virtual update button in hopes that it will appear. Others, well, if they had slipped in under the radar, we wouldn't have noticed a difference. AT ...


BetaBoston

HubSpot's Mike Volpe joins board of software firm Repsly
BetaBoston
It was announced this morning, that one of HubSpot's executive team, chief marketing officer Mike Volpe, will be joining his first board of directors. Volpe, who was an early investor in HubSpot as well, will be joining the board for mobile field ...

and more »

Dell Goes Full Steam Ahead on Software-Defined Storage
Datamation
Software-defined storage (SDS) is one of the hot button topics in storage today and Dell is an active player in that space. That should come as no surprise if one understands the nature of how the company is rapidly evolving. Dell is often narrowly ...

Google News

Microsoft Great Plains: Manufacturing or Bill of Materials - Overview for IT Specialist

Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More

The Hidden Power of Online Manual

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

Navision Attain Database access via C/ODBC in ASP.NET Application

Navision Software was purchased by Microsoft and now it is... Read More

Microsoft Navision and Crystal Reports - An Overview

Microsoft Business Solutions ? Navision is an integrated solution for... Read More

Mapping Software: Putting Data Visualization on the Map

Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More

Algebra Help Software

Need help making sense of algebra? Have algebra lectures in... Read More

Microsoft Great Plains Implementation: Collection Management ? Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

EDI: Electronic Document Interchange for Microsoft Great Plains ? Overview for Software Developer/Pr

Microsoft Great Plains - Microsoft Business Solutions accounting and ERP... Read More

Basic Steps To Optimize Your Internet Security

After seeing many people complain about their weak Internet security... Read More

Great Plains Sales Order Processing and Invoicing Modules ? Tips For Consultants

We'll give you non formal view, based on our consulting... Read More

Microsoft Great Plains: Customization Upgrade & Recovery ? Visual Studio VB 6.0

Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has... Read More

Run Your Own Search Engine

Our hosted solution allow you to run your own search... Read More

Review of TikiWiki Content Management System

TikiWiki is open source software - it is written in... Read More

How to Choose the Right Accounting Software for Your Business

With any good luck and a good amount of hard... Read More

Demand More From Your Lead Tracking Software

An integral part of any quality CRM system is lead... Read More

Cisco Certification: Introduction To ISDN, Part IV

In part III of this ISDN primer, we learned that... Read More

Partitioning, Formatting and Reinstalling in Windows 98

Formatting and reinstalling windows 98 is very easy if you... Read More

The End of Spyware?

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

Navision Sales Module & Reporting: Jet Reports, C/ODBC, XBRL, Business Analytics ? highlights

Microsoft bought Navision, Denmark based software development company, along with... Read More

Microsoft CRM Implementation ? Fundamental CRM Principles Revision

Microsoft CRM is relatively new player on the now becoming... Read More

IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java

Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More

Making The Decision To Automate Your Software Testing

Not every software testing project can or should be automated.... Read More

Two Reasons to Use Timesheet Software

This short paper will expand on two key reasons to... Read More

Linux Secrets

The first thing that you will notice about Linux Red... Read More

Story Development Software: Good or Evil?

In the early days of the personal computer, we're talking... Read More