Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/a26f9f83/public_html/articles/includes/config.php on line 159
Microsoft CRM Integration & Customization: SharePoint Document Gateway > NetSparsh - Viral Content you Love & Share

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! [email protected]

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:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

Fortune

Donald Trump Signs Federal Ban on Kaspersky Lab Software
Fortune
President Donald Trump signed into law on Tuesday legislation that bans the use of Kaspersky Lab within the U.S. government, capping a months-long effort to purge the Moscow-based antivirus firm from federal agencies amid concerns it was vulnerable to ...
Trump signs bill banning Kaspersky Lab software from federal useTechCrunch
Trump Signs Ban on Kaspersky Software - GizmodoGizmodo
Text - H.R.2810 - 115th Congress (2017-2018): National Defense Authorization Act for Fiscal Year 2018 | Congress ...Congress.gov

all 9 news articles »

TechCrunch

Clubhouse nets $10m Series A from Battery Ventures to make ...
TechCrunch
People often describe work as a rat race, but for a lot of engineers, that isn't too far off. Take one Jira ticket off the queue, fix the bug or add the feature, mark the ticket as complete and move as quickly as possible to the next ticket ...
| Battery Ventures leads Series A round for Clubhouse SoftwarePE Hub (blog)

all 3 news articles »

Forbes

Generous 401(k) Matches Helped Scott Scherr Build The Ultimate Software Stock
Forbes
Over the past decade, few companies have performed as well as Ultimate Software, a payroll and human resources software seller, and done so with less fanfare. Yielding a 20% annualized return since 2007, Ultimate Software has become the ultimate mid ...


Phys.Org

Beta of Neurodata Without Borders software now available
Phys.Org
In an effort to maximize the return on investment in the creation of neurophysiology data sets and enhance experiment reproducibility, Bouchard notes that the first version of NWB:N made huge strides toward generating a unified data format for cellular ...

and more »

ZDNet

Juniper Networks' OpenContrail software defined network joins The Linux Foundation
ZDNet
It's also the home of many open-source networking projects such as the software-defined network (SDN) OpenDaylight, Open Platform for Network Function Virtualization (OPNFV), and Open Network Automation Program (ONAP). Now, networking power Juniper ...

and more »

PC Gamer

AMD's Radeon Software Adrenalin Edition drivers arrive with a focus on latency
PC Gamer
AMD has released its most comprehensive software release of the year. Dubbed Radeon Software Adrenalin Edition, the new driver package is more than an incremental update, it's AMD's annual overhaul that was first set in motion with Catalyst Omega at ...
AMD Releases Radeon Pro Software Adrenalin Edition 17.12.1: Adrenalin and ProRender UpdatesAnandTech
Meet Radeon Software Adrenalin Edition: AMD Link mobile app, Radeon Overlay, and morePCWorld
AMD Launches Much-Needed Software Revamp, Offers More Control Of Video CardsGameSpot
TechRadar -TrustedReviews -VentureBeat -AMD Support
all 48 news articles »

We Live Security (blog)

It's time to patch your Microsoft and Adobe software again against vulnerabilities
We Live Security (blog)
It's the second Tuesday of the month, and you know what that means… Yep, it's time for another bundle of essential security updates from Microsoft. For its final scheduled batch of updates for 2017, Microsoft has released fixes for over 30 security ...

and more »

Den of Geek US

Dark Souls Developer From Software Teases New Game
Den of Geek US
Given that the teaser in question doesn't contain any real shots of gameplay and that From Software hasn't released any further information regarding what this footage is about, we're left to speculate in regards to what it is that we're looking at. So ...

and more »

TechCrunch

Clubhouse nets $10m Series A from Battery Ventures to make software development fun again
TechCrunch
The company just got a boost to bring that hopeful vision to development teams across the world, securing a $10 million series A investment from Battery Ventures investor Neeraj Agrawal, who will also be joining the company's board. Clubhouse is all ...


Why CyberArk Software Stock Popped 11% in November
Motley Fool
What happened. Shares of CyberArk Software Ltd. (NASDAQ:CYBR) jumped 11.1% in November, according to data provided by S&P Global Market Intelligence, after the cybersecurity company's third-quarter earnings report surpassed analysts' estimates for both ...

and more »
Google News

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

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

Software: What Suits Me?

Almost all new and major brand of PCs come with... Read More

Destination: Desktop for Google

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

Lotus Domino Implementation and Development: Infrastructure ? Present and Future

Domino server is a buffer between the operation system and... 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

History of Java

The java programming language is becoming more and more popular... Read More

A Simple Computer Software Definition

What is Software?Software is a set of instruction written to... Read More

The Importance of Timely Timesheets

Whether you are a small consultancy firm, a medium sized... Read More

Why Stick With Email Clients Like Outlook?

Trying to figure out a stream in banning one email... Read More

What is Preventive Maintenance Software?

Preventive Maintenance (PM) is defined as scheduled work done on... Read More

OSI Layers Model

IntroductionDuring the early years of our modern computer era, very... Read More

Make or Break Factors - When Considering Estimating Software

Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More

Examining the Substance of Studio MX

To all web designers out there, this article is for... Read More

Understanding Document Management

The term "document management" and "paperless office" is the subject... Read More

Fundraising Software ? How Can That Help Me?

Fundraising software lets you connect with donors in a way... Read More

Lotus Domino/Notes - Microsoft Great Plains Tandem as ERP with Documents Workflow - Overview for IT

Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More

Rapid Application Development - Is it Really a Need of Today?

Rapid Application Development (RAD) is a software development methodology. In... Read More

Antivirus Software ? Get The Bugs Before They Get You!

You turn on your computer, and it doesn't look quite... Read More

Instant Messaging is a Sweet Way to Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

Online PowerPoint Presentation ? Convert PowerPoint to Flash

Although we don't know whether Microsoft ever envisioned such a... Read More

Outlook... Not Just for Email! Using Your Outlook Calendar

Microsoft Outlook is one of the most widely used software... Read More

What is a Document Manager without Version History?

Document Manager and Version HistoryIn previous articles I have discussed... Read More

Document Templates Give You The Perfect Framework For Your Documents

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

Microsoft Update - 5 Reasons to Update Service Pack 2

Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More

Introducing GRML

Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More