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:


Wall Street Journal

Tesla Motors Releases New Software Suite for Model S
Wall Street Journal
Tesla Motors Releases New Software Suite for Model S. Midcycle Upgrade, Nearly Unique Among Car Makers, to Help Drivers Better Navigate Traffic, Nickname Car. Email; Print; Comments. Facebook. Share. 0. Twitter. Google+. LinkedIn. smaller; Larger. By.
Tesla software update zaps new features into carsUSA TODAY
Other automakers to challenge Tesla in over-the-air software upgradesReuters
Tesla sends traffic help via software upgradeAutomotive News
StreetInsider.com (subscription)
all 76 news articles »

Reuters

SAP buys expenses software maker Concur for $7.3 billion
Reuters
FRANKFURT (Reuters) - Germany's SAP (SAPG.DE) has agreed to buy U.S. expenses software maker Concur (CNQR.O) for $7.3 billion in cash, strengthening its position in cloud computing but sending its shares down almost 3 percent on concern over the ...
SAP buys software group Concur for $8.3bnFinancial Times
Software giant SAP buys expenses rival Concur for $7.3bnIrish Independent
SAP to buy expense management software maker Concur for $7.3 billionTimes of India
Daily Times
all 314 news articles »

With Open-Source Software, You Don't Have to Start From Scratch
Entrepreneur (blog)
Gauging open-source software. With 86.3 percent of companies in non-technical segments adopting open-source software, it's pretty clear that it can be leveraged to benefit your business. However, as with any new technology, you should always understand ...


Software developers can test their programs for weaknesses at the SoftWare ...
Network World
Software touches every aspect of our lives today. Not only does it run our office computers and smartphones, it also controls transportation systems, utility grids, weapons guidance systems, medical devices, our personal vehicles, embedded systems of ...
Homeland Security-Funded Software Assurance Marketplace (SWAMP ...Broadway World

all 6 news articles »

Bidness ETC

Tibco Profit Falls Sharply On Lower Software Revenue
Wall Street Journal
The Palo Alto, Calif., data management and analytics-software maker benefited in recent years from the growing popularity of cloud-computing services, but its bottom line has been hurt in recent quarters by weak margins. Earlier this month, Tibco bowed ...
Tibco Software, Inc. Stock Falls On Disappointing ResultsMotley Fool
Why Tibco Software Inc. Stock Closed In The Red TodayBidness ETC
Wedbush Feels 'Acquisition Premium Looks Iffy' For Tibco Software Inc.Benzinga
MarketWatch -TheStreet.com
all 54 news articles »

Weather software developed by NASA helps save American fuel
Fort Worth Star Telegram (blog)
A new weather software program is helping American Airlines reroute flights around severe weather while still getting passengers to their destinations in a timely fashion. The program, called Dynamic Weather Routes and created by NASA, has been tested ...


New York Times

Review and Video: With Big New iPhones, It's What's Inside That Counts
New York Times
The best part of the new phones is actually the new software inside, which is available for some older models, too, starting on Wednesday. The software, iOS 8, combines some of the advanced features of Android with Apple's ease of use and reliability.
iPhone 6 Review Roundup: Size Attracts, Software SatisfiesLatin Post

all 923 news articles »

WFMY News 2

Guilford County DA Won't Prosecute New Sweepstakes Software
WFMY News 2
Howard Neumann, Assistant District Attorney, Guilford County, told WFMY News 2's Morgan Hightower that his office has decided to not prosecute sweepstakes cases where pre-reveal software is used. Neumann called the chief investigators for the Guilford ...


eChannelLine

Dell pleased with performance in first year of software integration into ...
eChannelLine
A year ago, Dell updated its PartnerDirect channel program to add the first four software competencies to its existing five hardware-focused competencies, reflecting the growth of Dell Software following the accumulation of software companies through ...

and more »

Terrance Paul, Developer of Teaching Software, Dies at 67
New York Times
Mr. Paul, a lawyer-businessman, and Mrs. Paul, a homemaker with a degree in elementary education, though she never taught school, began their software business, Advantage Learning Systems, in 1986 from the basement of their home in Port Edwards, ...

and more »
Google News

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

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

Two Reasons to Use Timesheet Software

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

Configure Windows Indexing Service for Performance

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

Software Process Improvement -A Successful Journey

Background: For many organizations like ours, the interim target of... Read More

Microsoft RMS Customization ? PO Items Receiving in Great Plains

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

Builders Beware

Which Type of Shop Can Rely On A Home Built... Read More

Running a Program on a Remote Server Using SSH

How do you run a program on a remote server... Read More

CROOK: A Methodology for the Refinement of Forward-Error Correction

Table of Contents1) Introduction 2) Related Work 3) Framework 4)... 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

What is Spyware? Are You Being Watched?

Find out why Spyware Removal from computers is important and... Read More

Monitoring Software Can be Used for Spying as Well

We all already got used to computer monitoring both at... Read More

Programming Language Migration Path

While I was preparing some personal background information for a... Read More

Microsoft Great Plains IV: Inventory Management

Great Plains Inventory Management (IV) module gives your business a... 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

About Microsoft Sysprep (System Preparation) Utility (Windows 2000)

The Microsoft system preparation utility for Windows 2000 is a... Read More

XML Parser and Their Types

XML parser is a software module to read documents and... Read More

Corporate ERP Selection: Microsoft Great Plains

In our opinion, traditional approach when you select ERP/MRP system... Read More

25 Things Mapping Software Can Do For You

1. With mapping software you can create a report that... Read More

Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More

Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

It?s Back!! WordPerfect?s Amazing Comeback

Have you noticed WordPerfect is gearing up for a comeback... Read More

Microsoft Great Plains Customization: Project Organization ? International Business Example

Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More

Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware

Spyware and malware are large problems for Internet users today... Read More

PHP On-The-Fly!

IntroductionPHP can be used for a lot of different things,... Read More

Groupware: What Works the Way Businesses Do?

GroupwareThe internet is full of 1.5 million to 7 million... Read More

Story Development Software: Good or Evil?

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