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:


ASG Software Solutions Seeks Buyer
Wall Street Journal
Software firm ASG Software Solutions, which has had trouble repaying its debt, is looking for a buyer, according to people familiar with the matter. The privately held software company, once known as Allen Systems Group, has hired an investment bank to ...


Rigged industrial software site points to watering hole attack
Computerworld
Attackers have rigged the website of an industrial software firm with a sophisticated reconnaissance tool, possibly in preparation for attacks against companies from several industries. The incident was detected last week by researchers from security ...

and more »

5 tips on migrating to open-source software
TechRepublic
Regardless of what Free Open Source Software (FOSS) you need to use, you might not always find it the most natural evolution -- especially when you've spent the whole of your career using proprietary software. The thing is, a lot of open-source ...


Daily Mail

Bryan Hamade denies he's the hacker who leaked celebrity nude photos
Daily Mail
An American software engineer has denied stealing nude photos from celebrities' iCloud accounts after being identified as the hacker online. Bryan Hamade, 26, was named as the source of the leak after he tried to sell intimate pictures of actress ...
Jennifer Lawrence leaked nude photos: Apple iCloud password hack could be ...Mirror.co.uk
Celebrity Nude-Photo Hack May Be Breach of Apple's ICloudBloomberg

all 966 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 ...
HP and VMware Collaborate to Simplify Software-Defined Data Center and ...MarketWatch
VMworld 2014: In Pursuit of Software Defined EverythingEnterpriseNetworkingPlanet
VMware EVO speeds up software-defined datacentre deliveryZDNet
Seeking Alpha (registration)
all 281 news articles »

Police seeking software for monitoring social media
Journal Times
According to the description, the software allows users to place a “listening lens over any location in the world,” allowing them to “listen, collect, and analyze the open social media activity emanating from that location – Tweets. Facebook posts ...


China gives Microsoft deadline to explain software problems
Business Spectator
Chinese officials gave Microsoft Corp a deadline to explain what they called compatibility and bundling issues with its software, putting pressure on the software maker as it faces an antitrust probe into its business practices in China. In a statement ...


Economic Times

China gives Microsoft 20 days to explain software compatibility in antitrust probe
Tech Times
These verification codes are used by companies as an anti-piracy mechanism, and are only provided with legitimate copies of the software. Microsoft is one of over 30 U.S. technology firms under investigation by officials in China as the Chinese ...
China gives Microsoft 20 days to answer anti-trust probeNetwork World
China gives Microsoft 20 days to provide explanation in anti-trust probeOrlando Sentinel

all 86 news articles »

TrustedReviews

Vita gets a personal touch with themes in new software update
Joystiq
A new software update for the system will add customizable themes to the handheld, allowing for customization of wallpaper, icons and sounds on the system's dashboard. The announcement only featured themes of popular Japanese video game franchises, ...
PS4 themes coming in next software updateTrustedReviews
Sony eager to woo Japanese with Dragon Quest, other software for PlayStation ...Times Colonist

all 150 news articles »

Forbes

The Software Behind IBM's Watson Will Be Probing The Mysteries Of Physics
Forbes
Last week, the Deutsches Elektronen-Synchrotron – one of the largest research centers in Germany – announced that it has entered into a collaboration with IBM to enhance its computers' abilities to crunch the massive amounts of data being generated ...

Google News

Imagine if Everyone Working In Your Office Was In Synch?

Microsoft-Outlook is a pretty amazing program. So much more than... Read More

Artificial Intelligence And Intuition

The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More

Microsoft Great Plains Implementation: Collection Management ? Overview For Consultant

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

The Top 5 Wrong Reasons For Not Hiring Testers

Considering whether or not your software company should hire a... Read More

Microsoft Great Plains BR: Bank Reconciliation

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

How To Develop Software For Your Business

Software development is a risky business.Many software developers are barely... Read More

SQL scripts for Project Accounting: Microsoft Great Plains series ? overview for developer

Microsoft Business Solutions Great Plains has Project Accounting module where... Read More

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

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

Free Software for Newbies and Web Developers

Here is some free software tools to help you build... Read More

Perfectly New Database Query Tool - Foxy SQL Pro Released

Are you a database professional? Do you work with a... Read More

Corel WordPerfect 7 Macro Programming Example

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

Is Your Family Protected?

When you think... Read More

Microsoft Great Plains Inventory Control ? Overview For Consultant

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

Run Your Own Search Engine

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

Benefits of Shareware

Shareware has been fighting the stigma of being misunderstood for... Read More

Basic Steps To Optimize Your Internet Security

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

Lotus Notes Domino and Web: Application Development ? Tips for Programmers

Beginning with Domino version R4 it has integration with the... Read More

Document Templates Give You The Perfect Framework For Your Documents

When it comes to running an office, the SOHO entrepreneur... Read More

Passwords Used In Microsoft Word Documents

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

Professional Software Icons For Your Standalone Application

User interfaces and accessibility are some of the most important... Read More

Microsoft Great Plains customization ? Freight Forwarding/Transportation industry example

Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More

Microsoft Great Plains Upgrade ? Things to Consider and FAQ

If you have Microsoft Great Plains and support it for... Read More

Microsoft Great Plains: Getting New Users Licenses ? Annual Service Plan FAQ

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

Five Reasons for Using an O/R Mapping Tool

So, why should you use any O/R mapping tool? I... Read More

Microsoft Business Solutions Products Selection: ERP, CRM, Retail Management

Let's first look at your ERP system selection (without Retail... Read More