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:


2014 IRS Form 1099-MISC Software by W2Mate.com Now Available for ...
WKRG-TV
Real Business Solutions has announced that the desktop client of its 2014 1099 Miscellaneous Income Software is now available for download at http://W2-Mate.com/ . The year-end processing software gives 1099 filers and tax professionals all the tools ...

and more »

Tri-City police get software to monitor social media sites
Mid Columbia Tri City Herald
Tri-City law enforcement agencies will soon have software that will allow them to track personal accounts on a number of social media websites. Benton County Commissioners this week approved $20,000 to buy the SnapTrends software to help investigators ...

and more »

blogs.hbr.org (blog)

Building a Software Start-Up Inside GE
blogs.hbr.org (blog)
It made a massive investment (more than $1 billion) to build a software “Center of Excellence” in San Ramon, California to manage the data explosion created by the increasing intelligence of its industrial machines. CEO Jeff Immelt declared in 2011 ...


VentureBeat

Drones need software, too
VentureBeat
Enterprise software historically catered only to people at their desks. But today's mobile apps can make a field worker's day far more productive, freeing up hours that would otherwise be spent physically filling out forms and pushing paperwork. By ...


Tech Times

Apple Software Updates: What to Know About iOS 8.1.3, OS X Yosemite 10.10.2 ...
Tech Times
The changelog for the update includes a reduction in the required amount of storage when performing a software update, a fix on the issue that deals with entering a user's Apple ID password for Messages and Face Time, a fix on what could have caused ...
Apple Releases iTunes 12.1 With New Yosemite Notification Center WidgetMac Rumors

all 46 news articles »

Geek

Tesla bumps up Model S P85D acceleration – with software update
The Register
He also said that the astonishing P85 would see some lesser improvements as a result of the software tweak and posted an impressive video of someone driving a P85D in the snow, claiming that the Dual motor launch was driven by better traction rather ...
Tesla P85D software update reduces the car's already insane 0-60 timeGeek
Tesla just made its new car even faster — through a software updateBusiness Insider
​Tesla Making Insanely Fast P85D Even More Insane With Software UpdateJalopnik
Computerworld -Daily Mail -Daily Caller
all 134 news articles »

Marshfield News-Herald

Marshfield police use software to analyze crime
Marshfield News-Herald
“Service and protection in our community will be improved,” said Police Chief Rick Gramza about the planned purchase of new software to analyze dispatch and records data. Data about crimes can be analyzed to pinpoint “hotspots” by time of day, category ...


Stuff.co.nz

Asia beckons for software innovator Finzsoft
Stuff.co.nz
Goh is the founder and executive chairman of Silverlake Axis, a big Malaysian company listed in Singapore aiming to take over NZX-listed software minnow Finzsoft. In an interview with Prospect Group in 2013, he explained that his software was built on ...

and more »

The Northwest Florida Daily News

District purchases software to track bus routes, riders
The Northwest Florida Daily News
FORT WALTON BEACH — It's about to get a little easier to track who rides which school bus in Okaloosa County and where every bus stop is located. The Okaloosa County School Board approved the purchase of bus routing software earlier this week at the ...

and more »

Four Software Stocks to Buy Ahead of Q4 Reports
Barron's
In our opinion, the recent exchange-rate fluctuations do not reflect changes in sector fundamentals, and we think most Software-as-a-Service (SaaS) and applications software companies can still execute in line with consensus estimates this year because ...

and more »
Google News

Microsoft Great Plains: Large Scale Implementation

Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More

Great Plains Bill of Materials Setup & Customization for Process Manufacturing ? Overview

Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More

Cisco CCNA Certification: Becoming A Truly Valuable CCNA.

I've been active in the Cisco Certification track for four... Read More

Free Program Removes Spyware not Detected by Premium Security Scan

What is Spyware?Spyware monitors your surfing habits and sends the... Read More

Interactive Mapping Brings Information to Life

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

Microsoft CRM Custom Design & Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports

Microsoft CRM is new player on the CRM software... Read More

Microsoft Great Plains Chemicals & Paint Industry Implementation & Customization Notes

Microsoft Great Plains fits to majority of industries, in the... Read More

Tripwire for Linux File Integrity

What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More

Corel WordPerfect 7 Macro Programming Example

Case study: A secretary using Corel WordPerfect 7 is often... Read More

How to Make Attractive and Effective PowerPoint Presentations

Microsoft PowerPoint has dramatically changed the way in which academic... Read More

An Easy Way to Deal with Email Viruses and Worms

If you feel intimidated when someone tries to teach you... Read More

Microsoft Great Plains IV: Inventory Management

Great Plains Inventory Management (IV) module gives your business a... Read More

Microsoft RMS Customization ? PO Items Receiving in Great Plains

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

What is Software Piracy?

There are several kinds of software piracy. The bottom line... Read More

Microsoft Great Plains Remote Support - Overview

Microsoft Great Plains is now standard mid-market ERP application, serving... Read More

Microsoft Great Plains 8.0 Brazilian Version ? Overview For International Consultant

Microsoft Great Plains has substantial mid-market share in the USA... Read More

A Simple Guide To Wikis

A wiki is an editable text-based website. But you don't... Read More

The Truth: Netzero 3G

We've all seen the ads on TV for Netzero 3G.... Read More

Microsoft Great Plains Installation ? Overview for IT Director/Controller

Microsoft Great Plains is main mid-market application from Microsoft Business... Read More

The Opera Alternative

Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More

How To Make Good Use of Spreadsheets

Most computer users use spreadsheets software such as Microsoft Excel... Read More

Introduction To ISDN, Part III: PAP

Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More

C++ Function Templates

C++ Function templates are those functions which can handle different... Read More

Reduce TCO: The Java Database Way

TCO (Total Cost Ownership) is the buzzword in... Read More

Bridging the Gap between Paper and Data

The cornerstone of successful automated office systems is the ability... Read More