Wednesday, January 30, 2008

CRM - Everyone You Meet is Fighting a Hard Battle

Relationships... Money... Health..The Past...Failure..Mental and Spiritual Battles..Time Constraints...Professional pressures..

At any given moment you, your clients, and employees are dealing with one or the other of these challenges in life. No one has escaped from this life untouched by problems, both big and small. No matter how people may appear on the outside, they battle with some problem that is unmanageable on the inside. The clearer this is to us the easier it is to be extrodinarily kind to others.

But if we are also suffering how is it possible to do this? It is not easy, it is a learned skill. It needs to be taught to all your employees. It must be practiced and practiced until it becomes habit. This habit needs to be policy and employees need to be encouraged daily until the habit is developed.

Customer Relationships are built on this knowledge. Why people act a certain way is always based on their level of life challenges at a given moment. This includes both employees and customers.

We cannot solve all their problems nor should we, but the fact that a person might be struggling in their personal or professional life needs to in the back of our mind whenever we deal with people.

There is nothing as memorable as a person's kindness when we are in a difficult situation.

Help your clients to solve their immediate problems (pertaining to your business!)and they will be satisfied. Give them reason to smile and they will be impressed. Do it every time they contact you and they will never leave you. Client loyalty is a reflection of the level of care they preceive they are getting from a business. This does not mean we sacrifice our profits and productivity. It means that we increase our profits and productivity. Happy employees work better and exhibit higher levels of company loyalty when dealing with customers and happy customers will return and tell their friends.

No matter what you sell or manufacture; from fertilizer to real estate, from preschools to restaurants, you are first in the business of providing solutions for people. These solutions need to include how the person feels when they walk out the door, and you must always keep that in mind.

Owner Lasting Impressions 2 - Custom Business gift baskets, greeting cards, Customer Service Tips
www.lastingimpressions2.com

 

Labels: , , , ,

Monday, January 28, 2008

Microsoft CRM Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports overview for programmer

 Microsoft CRM is new player on the CRM software market. The whole conception behind CRM seems to be different. In case of traditional CRM software (Siebel, Oracle) - the application was designed with platform independence in mind. Microsoft CRM is dedicated to Microsoft technology and so deploys all the Microsoft tools: Windows Active Directory, Microsoft Exchange 2003/2000, SQL Server, Crystal Reports Enterprise, Biztalk server, Microsoft Outlook, Internet Explorer, Microsoft Great Plains as backend, etc.
If you are software developer, database administrator or web designer who is asked: how do we customize Microsoft CRM we are giving you directions in this article.
1.Microsoft CRM SDK this is software development kit with C# and partly VB.net code samples it is supported by Microsoft Business Solutions technical support. It is based on web service calls, if you are C# .NET developer you are excellently positioned to do this type of customizations. This is the preferred modification scenario and this should be easily upgradeable customization. VB.Net examples will be available soon.
2.Legacy SQL Data integration. This is also easy and safe. If you have SQL database, sitting on the same or linked SQL Server you can create ASPX .Net application and simply integrate it into CRM. You can place it on the navigation bar or menu in isv.config please refer to MS CRM SDK
3.Legacy ASP integration this is somewhat more sophisticated. You have to deploy HTTP handler to be a middle party between CRM which is .Net based and ASP which is legacy IIS. The trick is you have to have INI file with security settings to penetrate into MS CRM with proper credentials, calling web service.
4.Microsoft Exchange Programming. Microsoft CRM has Exchange connector which moves CRM incoming email to MS if it has GUID in its subject. You can alter this logic (for instance - move email to CRM if it doesnt have GUID but it is from the sender who is contact or account in MS CRM). Refer to MS Exchange SDK onsyncsave event handling. Then simply apply some MS CRM SDK programming - you need some COM+ objects creation and VB programming experience.
5.Direct SQL touch in #4 above I described you the scenario with MS Exchange handlers this would be ideal world if MS CRM SDK does the job. But in real world this is not always true you have to do direct flags correction in CRM database (like making Activity closed, moving email attachments/octet streams, etc). This is not supported by MBS technical support but you can rescue to this technique if you have to get job done.
6.MS CRM Customization tool this is rather end-user tool and we dont describe it here read the manual. Weve described above the options to use when this tool doesnt do the job
7.Crystal Reports - feel free to create Crystal report - tables and views structure is self explanatory. Try to avoid the temptation to create your own SQL view or stored procedure in MS CRM database, instead - create custom database and place your view and stored proc in it.

Happy customizing, modifying and developing! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com
If you are software developer, database administrator or web designer who is asked: how do we customize Microsoft CRM we are giving you directions in this article.
1.Microsoft CRM SDK this is software development kit with C# and partly VB.net code samples it is supported by Microsoft Business Solutions technical support. It is based on web service calls, if you are C# .NET developer you are excellently positioned to do this type of customizations. This is the preferred modification scenario and this should be easily upgradeable customization. VB.Net examples will be available soon.
2.Legacy SQL Data integration. This is also easy and safe. If you have SQL database, sitting on the same or linked SQL Server you can create ASPX .Net application and simply integrate it into CRM. You can place it on the navigation bar or menu in isv.config please refer to MS CRM SDK
3.Legacy ASP integration this is somewhat more sophisticated. You have to deploy HTTP handler to be a middle party between CRM which is .Net based and ASP which is legacy IIS. The trick is you have to have INI file with security settings to penetrate into MS CRM with proper credentials, calling web service.
4.Microsoft Exchange Programming. Microsoft CRM has Exchange connector which moves CRM incoming email to MS if it has GUID in its subject. You can alter this logic (for instance - move email to CRM if it doesnt have GUID but it is from the sender who is contact or account in MS CRM). Refer to MS Exchange SDK onsyncsave event handling. Then simply apply some MS CRM SDK programming - you need some COM+ objects creation and VB programming experience.
5.Direct SQL touch in #4 above I described you the scenario with MS Exchange handlers this would be ideal world if MS CRM SDK does the job. But in real world this is not always true you have to do direct flags correction in CRM database (like making Activity closed, moving email attachments/octet streams, etc). This is not supported by MBS technical support but you can rescue to this technique if you have to get job done.
6.MS CRM Customization tool this is rather end-user tool and we dont describe it here read the manual. Weve described above the options to use when this tool doesnt do the job
7.Crystal Reports - feel free to create Crystal report - tables and views structure is self explanatory. Try to avoid the temptation to create your own SQL view or stored procedure in MS CRM database, instead - create custom database and place your view and stored proc in it.

Happy customizing, modifying and developing! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com


Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Los Angeles, San Diego, San Francisco, Denver, Houston, Dallas, New York, Boston, Atlanta, Miami, Canada, UK, Australia and having locations in multiple states and internationally ( www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

 

Labels: , , , ,

Microsoft Business Solutions Great Plains, Navision, Solomon, CRM & RMS: serving international clien

Microsoft Business Solutions products: Microsoft Great Plains, Navision, Solomon, Microsoft CRM, Microsoft RMS are now serving not only to small and mid-size, but also large clients, plus they maybe reasonably priced solution for the branch of multi-national corporation.

Microsoft Business Solutions products: Microsoft Great Plains, Navision, Solomon, Microsoft CRM, Microsoft RMS are now serving not only to small and mid-size, but also large clients, plus they maybe reasonably priced solution for the branch of multi-national corporation.  This raises question of supporting Microsoft Business Solutions product installation remotely and internationally.  We do not question local Microsoft partners service quality, the question maybe different local partners may not be authorized to sell and service specific MBS product, the example in France MBS promotes Navision, but there are multiple cases when branch of the US-based company in France needs users training and support for Microsoft Great Plains system.

In this small article we are trying to give you the best system selection idea, depending on your country and business type.

Microsoft has two major mid-market ERP packages: Microsoft Great Plains and Navision (Solomon is the one to consider for Project oriented company this would deserve dedicated publication).

  • Microsoft Great Plains this application serves the markets, formerly targeted and gained by Great Plains Software (Great Plains Dynamics/eEnterprise or Great Plains Accounting), later on GPS was purchased by Microsoft.  These markets are: USA, Canada, Spanish Speaking South and Central America (except Brazil), South Africa, Middle East, Australia, New Zealand and Oceania.  If you are in these regions you should probably consider Microsoft Great Plains
  • Navision we believe that Microsoft bought Navision Software Denmark based software development company few years ago in order to get European market share.  However Navision Software itself had long history of penetration to US market.  This is why we see Navision clients in both Europe and US. Now Microsoft seems to appreciate Navision accommodation to former European tax and language specifics and it promotes Navision on emerging markets: Russia, East Europe, Africa, Asia.  In Brazil situation is more complex Microsoft have not decided yet and you can have either Navision or Great Plains (our subdivision Enterlogix.com.br is exclusive Great Plains reseller in Brazil).  It is very delicate question for MBS - but what you can see - Great Plains version 8.0 has fewer number of languages support and at the same time Navision has more with new releases.
  • Microsoft CRM Microsoft promotes its CRM worldwide and it is web based so it naturally automates your worldwide operations or serves you in your local country.  Microsoft CRM has C# and VB.Net based SDK, BizTalk server based integration to Great Plains and Microsoft SQL Server database.  Plus it deploys all the spectrum of Microsoft technologies: MS Exchange, Message Queuing, Active Directory.
  • Solomon - this ERP application was formerly bought by Great Plains Software (before GPS was bought it its turn by Microsoft) - Solomon is very good fit for project-driven organization. 
  • Microsoft RMS you should probably stay with Navision Retail module if you are in the region where MBS promotes Navision.  In all other places consider Microsoft Retail Management System: RMS Store Operations and POS.  If you have multiple stores you may manage and control them via Microsoft RMS Headquarters.  RMS has several integration options to Microsoft Great Plains.
  • Remote Support Technology it gives you cheaper consulting rates, because consultant doesnt have to travel to you and can serve several remote clients per day.  Microsoft VPN and Remote desktop solution is usually free for the client and in the case of sophisticated firewall Web Session could be another way to serve.  We do voice training, based on Internet telephony solutions, such as Skype enable you free voice over the internet.
  • Customization it is always better to avoid it however if you really need it, you should consider MBS customization partner who specializes in custom development and has experienced programmer.  In such a case we do not recommend to stick to local programmers in our experience local markets may not provide enough clientele for local developers to specialize in your product customization.  Also we do not recommend choosing generic offshore software developer.  MBS products require dedication in their customizations and integrations.

You can always have us help you internationally, give us a call: 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Great Plains, Microsoft CRM, Microsoft RMS customization company, serving clients in Chicago, Arizona, Colorado, California, Texas, New York, Georgia, Florida, Minnesota( http://www.albaspectrum.com )

Labels: , , , , , ,

Microsoft CRM in Latin America: implementation, customization, support overview for consultant

Microsoft Business Solutions CRM is present several years on the US software market plus it makes advances in Europe.  We expect substantial number growth of Microsoft CRM implementations across South and Central AmericaMicrosoft Business Solutions CRM is present several years on the US software market plus it makes advances in Europe.  We expect substantial number growth of Microsoft CRM implementations across South and Central America

 

  • Sales.  Microsoft CRM in opposite to former CRM leaders, such as Siebel, Onyx, Saleslogix doesnt need hard pushing sales efforts.  It also should probably not be sold to the company top management, but rather to IT department enthusiasts, who are in charge for specific legacy business system support and data fixing.  Microsoft CRM is very simple from business logic and intuitively understood by IT group.  It is rather very simplified version of full-featured CRM, such as again Siebel.
  • Installation.  Microsoft CRM should be either hosted or installed by in-house IT group.  And this is due to the fact, that MS CRM utilizes all the resent Microsoft technologies: MS Exchange Server 2003/2000, Active Directory, MS SQL Server, Crystal Reports Enterprise, MS Outlook client, Microsoft IIS, .Net components, etc.  This makes installation sensitive to existing setup of the above components
  • Implementation.  The crucial in the implementation is Workflow design, which should be probably done by consultant with IT in-house specialist.  This process doesnt require a lot of business consulting knowledge and in our experience company middle management actually makes suggestions in the time of initial presentation.  In the case of MS CRM Sales module the workflow should organize leads processing up to the point of closing the deal and following invoicing.  When workflow is realized sales team works as excellent orchestra.
  • Customization.  Usually MS CRM ties together existing legacy business systems and replaces large portion of them.  Typical case if you are freight forwarding client and have cargo tracking system you should more likely have lookup from the MS CRM account screen to the customer current shipments statuses.  This is usually made as small web application, created in Visual Studio.Net with MS CRM SDK and SQL queries to legacy database.
  • Support.  Because MS CRM is web application it can be used by remote users and automate operations across the whole South America and even Worldwide.  The same should be said about MS CRM support your Microsoft Business Solutions CRM Partner can support your installation remotely from say office in San Pablo as if it is located across the street.

Good luck implementing, customizing and reports designing and if you have issues or concerns we are here to help!  If you want us to do the job - give us a call in San Pablo: 55-11-3826-3449, 55-113825-2586! help@albaspectrum.com


Author is MS CRM Specialist in Microsoft Business Solutions Partner Alba Spectrum Technologies ( http://www.albaspectrum.com ) Navision, Great Plains, Microsoft CRM customization company, serving client in Mexico-city, Buenos Aires, Montevideo, Bogota, Caracas, Panama, San Jose, Lima, Quito, Madrid, Barcelona

Labels: , , , , ,

Microsoft CRM in Brazil: implementation, customization, support overview for consultan

We expect substantial number growth of Microsoft CRM implementations across Brazil and the need for Microsoft CRM implementation, support, tuning, reporting, training services, especially in such business metros as So Paulo, Rio de Janeiro, Salvador, Porto Alegre, Curitiba, Belo Horizonte, Recife, Manaus. 

Microsoft Business Solutions CRM is present several years on the US software market plus it makes advances in Europe.  We expect substantial number growth of Microsoft CRM implementations across Brazil and the need for Microsoft CRM implementation, support, tuning, reporting, training services, especially in such business metros as So Paulo, Rio de Janeiro, Salvador, Porto Alegre, Curitiba, Belo Horizonte, Recife, Manaus.  In this small article we try to project US market lessons on Brazilian business climate.

  • Sales.  Microsoft CRM in opposite to former CRM leaders, such as Siebel, Onyx, Saleslogix doesnt need hard pushing sales efforts.  It also should probably not be sold to the company top management, but rather to IT department enthusiasts, who are in charge for specific legacy business system support and data fixing.  Microsoft CRM is very simple from business logic and intuitively understood by IT group.  It is rather very simplified version of full-featured CRM, such as again Siebel.
  • Installation.  Microsoft CRM should be either hosted or installed by in-house IT group.  And this is due to the fact, that MS CRM utilizes all the resent Microsoft technologies: MS Exchange Server 2003/2000, Active Directory, MS SQL Server, Crystal Reports Enterprise, MS Outlook client, Microsoft IIS, .Net components, etc.  This makes installation sensitive to existing setup of the above components
  • Implementation.  The crucial in the implementation is Workflow design, which should be probably done by consultant with IT in-house specialist.  This process doesnt require a lot of business consulting knowledge and in our experience company middle management actually makes suggestions in the time of initial presentation.  In the case of MS CRM Sales module the workflow should organize leads processing up to the point of closing the deal and following invoicing.  When workflow is realized sales team works as excellent orchestra.
  • Customization.  Usually MS CRM ties together existing legacy business systems and replaces large portion of them.  Typical case if you are freight forwarding client and have cargo tracking system you should more likely have lookup from the MS CRM account screen to the customer current shipments statuses.  This is usually made as small web application, created in Visual Studio.Net with MS CRM SDK and SQL queries to legacy database.
  • Support.  Because MS CRM is web application it can be used by remote users and automate operations across the whole Brazil and even Worldwide.  The same should be said about MS CRM support your Microsoft Business Solutions CRM Partner can support your installation remotely from say office in So Paulo as if it is located across the street.

Good luck implementing, customizing and reports designing and if you have issues or concerns we are here to help!  If you want us to do the job - give us a call in So Paulo: 55-11-3826-3449, 55-113825-2586! help@albaspectrum.com

Author is MS CRM Specialist in Microsoft Business Solutions Partner Alba Spectrum Technologies ( http://www.albaspectrum.com ) Navision, Great Plains, Microsoft CRM customization company, serving client in Brazil, USA, Lisbon, Porto, Madrid, Barcelona, Toledo, Malaga, Seville, Buenos Aires, Mexico and having locations in multiple states and internationally

 

Labels: , , , , , ,

Microsoft CRM Integration with Microsoft Retail Management System (RMS) overview

Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS are both Microsoft SQL Server based applications, however historically Microsoft was purchasing industry leading software applications, such as QuickSell which is now Microsoft RMS.  So, RMS design fundamentals were minted a long time before Microsoft CRM.  But, still integration between the two is straightforward and what you need is consultant, who is familiar with both systems structures and customization scenarios

Microsoft CRM is currently integrated with Microsoft Great Plains and will be integrated with Microsoft Navision in the close future, RMS integration is not planned to our knowledge, so you should seek third party solutions or create your own integration.  We see the need for such the integration when you sell on account in RMS and have customer support call center automated with Microsoft CRM.  Let us give you highlights:

  • Microsoft CRM custom lookup.  More likely you will nee lookup to your RMS headquarters or store records for the customer transactions from Account screen.  Microsoft CRM allows you to have custom navigation bar on Account screen by clicking on this bar you could call your custom web .Net application, which will call Microsoft RMS database and return you the grid of customer transactions
  • RMS architecture excurse.  Microsoft RMS has Headquarters and Store databases.  The exchange between the two types of databases uses worksheet mechanism.  Most of the transaction types are initiated on the store level and transferred to the Headquarters database (with some global data exception, global customers for example are handled on HQ level and then propagated down to the stores). 
  • Data Inquiry and Update.  The MS RMS architecture suggests you to query primarily Headquarters database and do not change data in HQ database.  If you need to change data on the store level from Microsoft CRM custom screen you should consider placing web service on the SQL Server hardware in the store to deal with the store-initiated transaction
  • Microsoft CRM programming.  Microsoft CRM has MS CRM SDK (Software Development Kit).  This is open source tool, you can download it from Microsoft site and it is description of Microsoft CRM classes and methods with sample codes in C# and VB.Net.  Microsoft technical support encourages you to use Microsoft CRM SDK objects and discourages you from direct SQL server programming.  If you need to query MS CRM database you should create your custom database and place your objects: SQL views and stored procedures there.  Do not place custom object into MS CRM databases
Do your homework in integration and if you have issues or concerns we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com


Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Great Plains, Microsoft CRM customization company, serving clients  in Chicago, California, Texas, Florida, New York, Georgia, Arizona, Minnesota, UK, Australia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: andrewk@albaspectrum.com

Labels: ,

Thursday, January 24, 2008

Microsoft CRM and Great Plains implementation: freight forwarding business automation example

In this small article well show you business automation example, where Microsoft CRM and Great Plains are integrated and customized to fit Freight Forwarding business processes

Microsoft Business Solutions offers several ERP applications: Great Plains, Navision, Solomon and its own CRM solution Microsoft CRM.  Targeting to automate all business operations, Microsoft CRM is now integrated with Microsoft Great Plains and in the close future it should have integration with Microsoft Navision.  In this small article well show you business automation example, where Microsoft CRM and Great Plains are integrated and customized to fit Freight Forwarding business processes.

  • CRM.  Central Customer and Vendor records place.  Assuming you have agents across the USA and internationally CRM, being web-interface application and so, could be used across the globe with good internet connection.  The nice features of this product are central emailing you send email from MS CRM and receive responses from your clients back in CRM, where they are permanently stored and documented.  You can issue Quote and Sales Order directly in CRM if needed or could have them issues in Microsoft Great Plains with propagation to Microsoft CRM (deploying MS CRM-Great Plains integration tool BizTalk based connector).
  • Accounting/ERP.  Microsoft Great Plains could play this role, being integrated with Microsoft CRM and with industry-specific business system.  In the case of Freight Forwarding/Transportation this business system could calculate fees and charged, associated with MBL/HBL and posted against agent accounts.  You could deploy SQL triggers for instant integration or stored procs for scheduled batches.
  • Great Plains Customizations.  Freight Forwarding specifics require Shipment tracking with SOP and POP invoices posted and tracked against the shipment and probably regular/monthly Agent Settlement report, where you match customer and vendor invoices, associated with the agent shipments and create AR or AP document, depending on positive or negative balance.  This is Great Plains Dexterity customization or web-development (if you need your agents lookup features from remote locations)
  • Microsoft CRM Customization.  Assuming that you have Shipment Tracking system, which might be SQL or Oracle based you need shipment lookups for your order takers and customer support personnel from Microsoft CRM screens.  Being designed for easy web customization Microsoft CRM allows you to incorporate .Net web application into its screens, such as Account, Contact, Lead, Opportunity, etc.  You use Web Forms and Microsoft CRM SDK to penetrate into MS CRM security realm and then ADO.Net to call third party MS SQL Server or Oracle data
  • Implementation Advices.  Microsoft CRM should be probably tried as in-house pilot implementation with 5 users license and then you can purchase additional license as you have your users trained.  If you need MS CRM SDK C# or VB.Net programming you could subcontract.  Great Plains requires consultant help to be implemented and integrated, because it has sophisticated tables structure and documents flow mechanism.
  • Data Conversion.  We recommend you to deploy Great Plains Integration manager to import Vendor and Customers plus open documents.  Historical transactions, if needed should be moved by outside consultant.  Microsoft CRM has import tool try it first and subcontract more complex attachments, for example.

Good luck with implementation and customization and if you have issues or concerns we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com


Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Great Plains, Microsoft CRM customization company, serving clients  in Chicago, California, Texas, Florida, New York, Georgia, Arizona, Minnesota, UK, Australia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: andrewk@albaspectrum.com

 

Labels: , , , , , ,

Wednesday, January 23, 2008

Microsoft CRM implementation & customization: MS CRM Fax Gateway

With this small article we are continuing Microsoft Business Solutions CRM customization, development, modification, setup and implementation discussion.
Microsoft CRM at this moment doesnt have advanced fax automation you can register the fact of fax receiving or sending, but it is not sufficient for your daily work with your clients. User should be able to send and receive faxes in her/his work environment it is in MS CRM

Fax software automation market is very mature and we dont have to re-invite the bicycle here. All we have to do is integrate one of the reliable solutions into Microsoft CRM. Lets look at the technical aspects of the integration:

  • Modification should be based on the standard event Fax Activity logic alteration. Standard CRM version allows in- or out-going fax info saving into SQL database. Alternative form should have additional parameters for fax delivering
  • Immediately after the moment of fax saving into CRM database, Albaspectrum MS CRM Universal Fax Connector takes over the logic, more precisely its fax sending portion of the logic, realized as MS CRM Post-Callout, registered for Fax Activity addition and update. At the moment of new fax activity creation, our module considers attached documents as subject to be transferred to the addressee.
  •  Depending on the fax application/extension you use, call parameters are transferred to the appropriate plug-in, which in turn communicates with fax application.
  • Fax sending might be done through specialized systems or direct hardware control via MS FAX API.
  • Initially we plan to support GFI FaxMaker and Captaris RightFax via their printing & integration system with email servers MS Exchange and Lotus Domino
  • Documents, delivered or received through fax extension could be integrated into MS SharePoint via our proposed product Albaspectrum MS CRM Document Gateway. This allows you to revise and versionize document with automatic fax delivery to the addressees involved
  • For incoming faxes we suggest capturing via special handlers on the MTA (MS Exchange or Lotus Domino) level their task is to take over fax transfer and saving it for the addressee in CRM and Fax Activity creation in MS CRM
  • This approach provides seamless incoming and outgoing fax document workflow in MS CRM.

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

Andrew Karasev 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.

Labels: , , ,

Sunday, January 20, 2008

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

Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business System or CRM: Lotus Notes Domino, Oracle, DB2

There are multiple opinions on building your established large business IT system.  Some companies prefer to be Microsoft shop, others prefer to stick to Java world.  In our opinion large company should try balance its ERP in several layers: Hardware, Operating System, Database Platform, ERP/CRM software vendor.  The history always proofs that staking on one thing statistically has a chance to fail, remember Windows/Mac battle in the middle of 1990th?  Then Java resurrected UNIX world in the end of the 20th century.  All these facts just tell us that any prediction of the future should not be accurate, because the factors we could consider in the prediction formula will be superceded by new conceptions.  Good example would be C cross-platform programming language however now we are crazy about thin client so where is C longevity?  So, in 2004 we merged several companies to serve large corporate businesses, positioning us as cross platform integrators and the company, envisioning harmony between multiple computer platforms and conceptions.  Let us give you our bullets below:

  • Microsoft Business Solutions pluses old conception that OS should be separate from the DB platform and from your accounting application doesnt work when we consider modern Microsoft: it now offers all in one: Microsoft Great Plains/Navision/Axapta/Solomon/Microsoft CRM/Small Business Financials ERP, based on MS SQL Server DB platform and all this nice suite is working under Microsoft Windows 2003 Server.  This is very nice to have and the price would be lower, however you are in the business space and conceptions of Microsoft corporation, which really deserves you to consider either ERP or CRM solution to be trusted and handled into Microsoft guys
  • ERP/Accounting/MRP - we suppose that the old days of expensive ERP application are going to the history.  Nowadays we see the trend to use reasonably inexpensive and functionally sufficient applications, based in decent SQL platform.  So, our suggestion is do not pay for high end ERP/Accounting system and rather consider reliable budget solution as a platform for light customization
  • Business System/CRM CRM market should be considered a mature one in 2010, when such pioneers as Siebel will cross 15 years of the existence.  Again in our opinion youd rather pay for small or moderate customization to budget CRM solution to have work done.  Microsoft CRM or SalesLogix would do the job
  • Oracle Financials we are supporters of the companies who decided to go with Oracle Financials or SAP and have their CRM/Business Management System to be placed on the Microsoft Windows platform.  Microsoft CRM would integrate with Oracle smoothly
  • Microsoft CRM in our opinion large publicly traded company should consider using Lotus Notes Domino for document workflow and CRM and when adopting MS CRM it should consider using Domino as primary email server see our MS CRM Lotus Notes Domino email connector description.

Good luck and you can always seek our help in customization, implementation, integration and support.  Call us: 1-866-528-0577 or 1-630-961-5918, help@albaspectrum.com


Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Great Plains, Microsoft CRM customization company, serving Chicago, California, Arizona, Texas, Florida, Georgia, New York, Australia, UK, Canada, Germany, Continental Europe, Russia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer

 

Labels:

Friday, January 18, 2008

Microsoft CRM: data conversion import from Act!

Best Software Act! is very popular CRM for small and mid-size organization.   This system attracts business owner by its low price, plus system is very easy to use.  However if your business is growing you should reach the moment to implement more advanced CRM solution.  Natural question is how do we convert the data from Act! to new CRM solution and the mapping of your objects for conversion.  You would probably like to avoid operator data entry with potential numerous errors and mistypes.  Assuming that you are IT specialist, well give you technical side of Act to MS CRM data migration

This system attracts business owner by its low price, plus system is very easy to use.  However if your business is growing you should reach the moment to implement more advanced CRM solution.  Natural question is how do we convert the data from Act! to new CRM solution and the mapping of your objects for conversion.  You would probably like to avoid operator data entry with potential numerous errors and mistypes.  Assuming that you are IT specialist, well give you technical side of Act to MS CRM data migration:

  • First you need to download Act! SDK from Best Software website
  • Install Act! SDK on the computer, where you plan to do programming
  • Well use asynchronous data export/import model, this means that well design the system, containing two parts: export into XML and this XML file import into the CRM
  • Lets code Act! data export application, well use C# to address Act Framework classes, well need these libraries:

using Act.Framework;
using Act.Framework.Activities;
using Act.Framework.Companies;
using Act.Framework.ComponentModel;
using Act.Framework.Contacts;
using Act.Framework.Database;
using Act.Framework.Groups;
using Act.Framework.Histories;
using Act.Framework.Lookups;
using Act.Framework.MutableEntities;
using Act.Framework.Notes;
using Act.Framework.Opportunities;
using Act.Framework.Users;
using Act.Shared.Collections;

  • To connect to Act! database:

ActFramework framework = new ActFramework();
framework.LogOn("Act Username", "password", "SERVER, "Database");

  • Now we need Act field names to map them with the fields in the MS CRM:

private void ShowContactsFieldsDescriptions(ActFramework framework) {

    ContactFieldDescriptor[] cFields = framework.Contacts.GetContactFieldDescriptors();

    ContactFieldDescriptor cField;

    for(int x = 0; x < cFields.Length; x++)

        {

            cField = cFields[x];
            Console.WriteLine("Table Name:tt{0}", cField.TableName);
            Console.WriteLine("Column Name:t{0}", cField.ColumnName);
            Console.WriteLine("Display Name:t{0}", cField.DisplayName);
            Console.WriteLine("ACT Field Type:t{0}", cField.ACTFieldType);
            Console.WriteLine("");

         }

}

  • Lets get contact list and create the file for import instructions to MS CRM:

ContactList cList = framework.Contacts.GetContacts(null);
FileInfo t = new FileInfo("Contacts.xml");
StreamWriter stw = t.CreateText();

  • Now we form export data:

for (int i = 0; i < cList.Count; i++) {

    string strContactXml = "<contact>";

    ContactFieldDescriptor cField;
    Object oValue;

    // First Name
    cField = framework.Contacts.GetContactFieldDescriptor("TBL_CONTACT.FIRSTNAME");
    oValue = cField.GetValue(cList[i]);
    if (oValue != null && !(oValue.ToString().Trim().Equals("")))
 strContactXml += "<firstname><![CDATA[" + oValue.ToString() + "]]></firstname>";

    // Last Name
    cField = framework.Contacts.GetContactFieldDescriptor("TBL_CONTACT.LASTNAME");
    oValue = cField.GetValue(cList[i]);

    if (oValue != null && !(oValue.ToString().Trim().Equals("")))
 strContactXml += "<lastname><![CDATA[" + oValue.ToString() + "]]></lastname>";
    else
 strContactXml += "<lastname>" + "N/A" + "</lastname>";

    // Salutation
    cField = framework.Contacts.GetContactFieldDescriptor("TBL_CONTACT.SALUTATION");
    oValue = cField.GetValue(cList[i]);
    if (oValue != null && !(oValue.ToString().Trim().Equals("")))
 strContactXml += "<salutation><![CDATA[" + oValue.ToString() + "]]></salutation>";

    // Job Title
    cField = framework.Contacts.GetContactFieldDescriptor("TBL_CONTACT.JOBTITLE");
    oValue = cField.GetValue(cList[i]);

    if (oValue != null && !(oValue.ToString().Trim().Equals("")))
 strContactXml += "<jobtitle><![CDATA[" + Regex.Replace(oValue.ToString(), "rn", "<BR>") + "]]></jobtitle>";

  • This is only portion of the data, that could be transferred into CRM, the whole list of fields is too long for small article, but your could design the whole list of desired fields.  Please, pay special attention to replace <BR> HTML tag this is required for text data transfer into CRM
  • Next is import application creation.  We will not describe here connection to MS CRM details please read Microsoft CRM SDK if you need this examples.  Well concentrate on the nature of the import.

 The XML export file should look like this:

<contact><firstname><![CDATA[John]]></firstname><lastname><![CDATA[Smith]]></lastname><salutation><![CDATA[John]]></salutation><address1_line1><![CDATA[1234 W. Big River]]></address1_line1><address1_city><![CDATA[Chicago]]></address1_city><address1_stateorprovince><![CDATA[IL]]></address1_stateorprovince><address1_postalcode><![CDATA[123456]]></address1_postalcode><description><![CDATA[Toy Corporation]]></description><ownerid type="8">{4F1849C3-9184-48B5-BB09-078ED7AB2DAD}</ownerid></contact>

  • Reading, parsing and MS CRM object creation look is relatively simple:

        Microsoft.Crm.Platform.Proxy.BizUser bizUser = new Microsoft.Crm.Platform.Proxy.BizUser();

        ICredentials credentials = new NetworkCredential(crmUsername, crmPassword, crmDomain);

        bizUser.Url = crmDir + "BizUser.srf";

        bizUser.Credentials = credentials;

        Microsoft.Crm.Platform.Proxy.CUserAuth userAuth = bizUser.WhoAmI();

        // CRMContact proxy object

        Microsoft.Crm.Platform.Proxy.CRMContact contact = new Microsoft.Crm.Platform.Proxy.CRMContact ();

        contact.Credentials = credentials;
        contact.Url = crmDir + "CRMContact.srf";
        CorrectXML("Contacts.xml", userAuth.UserId);
        StreamReader reader = File.OpenText("Contacts.xml");

        string input = null;                       

        while ((input = reader.ReadLine()) != null)

        {

            string strContactId = contact.Create(userAuth, input);
            Console.WriteLine("Contact {0} is created", strContactId);
            log.Debug("Contact " + strContactId + " is created");

}

  • Just consider in more details CorrectXML function it places OwnerId into XML contact tree:

        private void CorrectXML(string fileName, string userId) {

           File.Move(fileName, fileName + ".old");
           StreamReader reader = File.OpenText(fileName + ".old");
           FileInfo t = new FileInfo(fileName);
           StreamWriter writer = t.CreateText();
           string input = null;

           while ((input = reader.ReadLine()) != null) {

               input = Regex.Replace(input, "{_REPLACE_ME_}", userId);
               writer.WriteLine(input);

           }

           reader.Close();
           writer.Close();
           File.Delete(fileName + ".old");

        }

  • Finally, we are launching export, import, opening MS CRM and looking at the contact list, transferred from Act!
  • Separate task would be Sales data from Act!, Notes etc. we plan to describe them in the future articles

Good luck with integration!  If you want us to do the job - give us a call 1-630-961-5918 or 1-866-528-0577! help@albaspectrum.com


Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com ), serving Microsoft Great Plains, CRM, Navision to mid-size and large clients in California, Illinois, New York, Georgia, Florida, Texas, Arizona, Washington, Minnesota, Ohio, Michigan

 

Labels: , , , ,

Microsoft CRM Implementation for Large Corporation overview

Microsoft Business Solutions CRM is now approaching the phase of being mature product and the CRM solution you may consider for large publicly traded company.  Our view point considers the fact of multiple platforms and systems coexistence and balancing: UNIX, Linux, Microsoft Windows, Java, .Net, PC, AS/400, RS6000, Microsoft Exchange, Lotus Notes Domino, etc.  This increases the cost of maintenance, but decreases the risk of being trapped to one vendor/solution.

Microsoft Business Solutions CRM is now approaching the phase of being mature product and the CRM solution you may consider for large publicly traded company.  Our view point considers the fact of multiple platforms and systems coexistence and balancing: UNIX, Linux, Microsoft Windows, Java, .Net, PC, AS/400, RS6000, Microsoft Exchange, Lotus Notes Domino, etc.  This increases the cost of maintenance, but decreases the risk of being trapped to one vendor/solution.  So far weve seen successful implementations of Microsoft CRM in the following industries: Distribution, Logistics, Non-Profit, Chemicals, Pharmaceutical, Placement/Recruiting, Medicare/Hospitals, Retail, Wholesale, Education, Beverages, Services, Defense, Aerospace, Oil & Gas.

  • In-house Implementation.  This is non-expected paradox.  Multiple clients, especially large companies, do it themselves.  The reason is Microsoft CRM utilizes all spectrum Microsoft Technologies: Exchange, Active Directory, .Net, Full-text search, etc.  Microsoft oriented IT people understand it and like to be involved.  So, you should consider self-implementation first.
  • Integration.  Microsoft CRM has relatively simple business logic and sits in Microsoft SQL Server, which enables customization and integration with third party systems and databases.  If you have Microsoft Great Plains you can use MBS CRM-GP integration tool, based on BizTalk.  If you have UNIX-based ERP/Accounting, you can deploy MS SQL linked server to bridge MS CRM and ERP.  The same would work for Oracle ERP Oracle Financials.  Navision has third party integration tool and the one from Microsoft is on the way to be released.  Axapta is also candidate for the integration.
  • Customization.  Microsoft CRM SDK describes majority of MS CRM objects and classes and enable VB.Net or C#.Net developer to build-in custom .Net application for Microsoft CRM existing screens.  And this is actually the way of the integration you realize integration in the custom .Net application.
  • Messaging.  Microsoft CRM uses MS CRM-Exchange connector in its standard functionality.  However if you have IBM Lotus Domino email server you can deploy MS CRM-Lotus connector, developed and supported by Alba Spectrum Technologies.
  • Data Conversion.  You should use Scribe for initial data migration.  However you need some programming work if you plan on bringing advanced data (email attachments from Siebel, for example)
  • External consultants.  You should consider customization and integration initial design as candidates for outsourcing.  Then, when coding is done and implemented you may switch to your internal developers to support custom pieces.
  • Nation-wide support.  Microsoft CRM is very innovative from the support side.  It means that Microsoft CRM partners tend to go to the nation-wide and international market to sell, implement and support the application.  Being web application Microsoft CRM could be accessed, customized and modified from anywhere.
  • Internationalization.  Microsoft Business Solutions promotes MS CRM worldwide and has local versions of the product.

You can always have us help you, give us a call: 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com


Andrew Karasev is consultant and CTO in Alba Spectrum Technologies ( http://www.albaspectrum.com ) Microsoft Business Solutions partner, serving clients in Illinois, New York, California, Florida, Georgia, Texas, Arizona, Virginia, Minnesota, Canada, UK, Europe, Australia, New Zealand, Asia, Russia.  He is Microsoft Great Plains certified master, Great Plains Dexterity, Microsoft CRM SDK C#.Net, Crystal Repots developer.  You can reach Andrew: akarasev@albaspectrum.com

Labels: , , , ,

Thursday, January 17, 2008

Lotus Notes Domino and Microsoft CRM Integration

Well, even if  the combination might look very unusual, we see the coexistence of these two systems, especially in large corporations, non-profit organizations.  Technically Lotus Notes Domino has parallel structure, including Domino email server.  Lotus is extremely flexible and you can program your own CRM or purchase CRM for Lotus, however Microsoft CRM has Microsoft SQL Server database and very simple Sales automation module.  Lets look at the integration reasons and scenarios. 

Well, even if  the combination might look very unusual, we see the coexistence of these two systems, especially in large corporations, non-profit organizations. Technically Lotus Notes Domino has parallel structure, including Domino email server.  Lotus is extremely flexible and you can program your own CRM or purchase CRM for Lotus, however Microsoft CRM has Microsoft SQL Server database and very simple Sales automation module.  Lets look at the integration reasons and scenarios.  Be sure that each specific case requires custom programming, tuning and support.

  • Why Lotus & MS CRM?  There are several reasons to combine the two.  First Lotus Domino has very long history and is present on the market over 15 years.  Corporations might have business system built upon the Lotus Notes Domino platform and it is not desirable or even feasible from the complexity standpoint to phase it out.  The second reason is possible IT strategy to balance multiple platforms to avoid over-dependence on one vendor (such as Microsoft).  There might be also licensing issue if corporation has several hundred Lotus licenses it doesnt want to lose them and pay for 200 Microsoft CRM users.  In this case MS CRM might be the solution for Sales department and all the other departments should stay on Lotus.
  • Lotus Domino as Messaging for MS CRM.  There is no need to program this custom piece, just use MS CRM Lotus Domino connector, supported by Alba Spectrum Technologies.  It has advanced functionality, versus standard MS CRM Exchange connector.  Instead of using GUID in the email header, it scans Contacts, Accounts, Leads emails for matching.
  • Lotus Workflow.  Workflow is possible in Lotus and MS CRM.  In Lotus, however workflow is the most advanced.  You can use Lotus Workflow and then upon the completion it can transfer control to Microsoft CRM.  This is typical Microsoft CRM SDK (to program MS CRM) and Lotus Java Agent programming from the side of Lotus.  Lotus workflow may work with integration to your ERP/Accounting application, such as Microsoft Great Plains, Navision, Axapta, however this is outside of the scope of this article.
  • Lotus/CRM Activities Synchronization.  One of the popular requirements is the synchronization of Microsoft CRM Activities: Appointment, Phone Call, Fax, etc. with Lotus TOTOs.  This should allow users work on the same project sharing Lotus and MS CRM data space.

If you need help in the integration or customization, feel free to call us: 1-630-961-5918, 1-866-528-0577, help@albaspectrum.com


Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com ) - Microsoft Business Solutions and IBM Lotus Domino Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing and having locations in multiple states and internationally.

Labels: , , , , ,

The new Customer Relationship Management CRM functions

 C.MeloPublishing Guidelines: You may publish my article in your newsletter, on your website or in your print publication provided you include the resource box at the end. Notification would be appreciated but is not required.

The new Customer Relationship Management CRM functions

By J.C.Melo

The Customer Relationship Management CRM system was born because of the need for a software to analyze customer's data - as for example its preferences - changing rough data that usually exists in any customer's database, into important information about the same customer. That is to say, a new modern sales & marketing tool.

In this first period the data of an online and real-time accounting & management system was analyzed by this stand-alone CRM software, and in the following period those accounting & management systems integrated this initial marketing & sales functions of a CRM.

Soon after, this new accounting & management system - now integrated with the CRM functions - included a Call Center system of the last generation with or without a voice processing system - input and output - through the telephone system usually so loved by us.

Soon after appeared an obvious question: If the CRM support my customers, why don't change it to support all the external functions of my company, as for example my suppliers, distributors, representatives, branches, affiliated companies, employees's families, etc., each one with different needs and processings?

This is the current Customer Relationship Management CRM system, for everything concerning the external world of a company, and consequently its original name no longer represents its current functions in spite to be widely used.

Today we should split the IT system of a company in two great sides but in the near future will be only one system:

1. Enterprise Resources Planning ERP, for the internal world of a company, on which we will write another article in the near future,

2. Customer Relationship Management CRM, for the external world of a company.

However it's absolutely necessary to understand that a CRM is not a software package that can be installed and immediately will be ready to work, but yes a system that obligatorily should be implemented by IT specialists together with the whole company in a continuous job, besides to be adapted to the specific needs of the company. And because the CRM was not interpreted correctly by a large amount of companies, recent research showed that 42% of purchased CRM systems are inoperative for been interpreted as a push-button software.

However if very well designed and installed, a CRM is a powerful tool for a company to grow on this digital business Century, certainly surpassing your competition and generating reasonable ROI Return on Investment.


The new Customer Relationship Management CRM functions

By J.C.Melo

The Customer Relationship Management CRM system was born because of the need for a software to analyze customer's data - as for example its preferences - changing rough data that usually exists in any customer's database, into important information about the same customer. That is to say, a new modern sales & marketing tool.

In this first period the data of an online and real-time accounting & management system was analyzed by this stand-alone CRM software, and in the following period those accounting & management systems integrated this initial marketing & sales functions of a CRM.

Soon after, this new accounting & management system - now integrated with the CRM functions - included a Call Center system of the last generation with or without a voice processing system - input and output - through the telephone system usually so loved by us.

Soon after appeared an obvious question: If the CRM support my customers, why don't change it to support all the external functions of my company, as for example my suppliers, distributors, representatives, branches, affiliated companies, employees's families, etc., each one with different needs and processings?

This is the current Customer Relationship Management CRM system, for everything concerning the external world of a company, and consequently its original name no longer represents its current functions in spite to be widely used.

Today we should split the IT system of a company in two great sides but in the near future will be only one system:

1. Enterprise Resources Planning ERP, for the internal world of a company, on which we will write another article in the near future,

2. Customer Relationship Management CRM, for the external world of a company.

However it's absolutely necessary to understand that a CRM is not a software package that can be installed and immediately will be ready to work, but yes a system that obligatorily should be implemented by IT specialists together with the whole company in a continuous job, besides to be adapted to the specific needs of the company. And because the CRM was not interpreted correctly by a large amount of companies, recent research showed that 42% of purchased CRM systems are inoperative for been interpreted as a push-button software.

However if very well designed and installed, a CRM is a powerful tool for a company to grow on this digital business Century, certainly surpassing your competition and generating reasonable ROI Return on Investment.


J.C.Melo is a 73-years old IT professional with 54 years of experience in computer science & technology entrepreneurship. He was the owner of the first minicomputer factory in South America and Consultant for the U.S. Government in several contracts. Now is the CEO of the organization
http://mba-open-university.net.

 

Labels: ,

Microsoft CRM messaging through Lotus Domino email server - balanced solution

Microsoft CRM and IBM Lotus Notes Domino seem to be taking completely different paths and if company is Microsoft oriented - we see MS CRM, MS Exchange, MS SQL Server, SharePoint, etc. In the case of Lotus Domino - it is opposite - Lotus is corporate Information Media and could technically play CRM role with internal messaging coming through Lotus Domino server. However realities of modern corporation give us multiple examples when Microsoft CRM and Lotus Domino should coexist in compromise. There are several reasons why corporation doesn't like to stick to one platform:
1. Balancing several platforms not to be trapped to the one-vendor solution. Imagine, that you placed all the eggs into one basket and then this basket went into the trouble (lawsuit, bankruptcy, mismanagement, hostile takeover - to name a few in the life of the modern American corporation)
2. Legacy-dependence. If your corporation uses such product as Lotus Notes/Domino for 10 plus years - you can expect that majority of documents are stored in the Lotus databases. Just conversion of this legacy database is multi-million dollars project. And again - we could not predict the future accurately - who will win or lose - IBM or Microsoft - or maybe they will merge
3. Procedures and flowcharts. Nowadays corporation works and builds its business model around computer business system, consider things like users training, functional flowcharts/diagrams, reporting to investors, IDE with company vendors and customer. And we'd dare to say that these things are computer application platform dependent (even being designed in the heads of corporation founding leaders as abstract business processes - then they were placed into the computer platform and had to fit to its pluses and minuses)
Considering these arguments and having multiple requests from Microsoft Business Solutions and directly from our prospects and customer, we have realized the connector, which allows Microsoft CRM use Lotus Domino email server with similar messaging functionality as Microsoft Exchange 2003/2000
Microsoft CRM Exchange connector needs to be installed and its DLL based functionality is superceded by our own DLL, which communicates with Lotus Domino server via Java Agents
You can always have us help you with the integration and customization. Call us: 1-866-528-0577, 1-630-961-5918.

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Microsoft CRM, Microsoft Great Plains customization company, serving clients in Chicago, California, Texas, New York, Georgia, Arizona, Louisiana, Michigan, Florida, Canada, UK, Australia, South Africa and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

Labels: , , , ,

Friday, January 11, 2008

CRM: Technology vs Culture

CRM: Its at the forefront of todays business vocabulary. $6.7 billion was spent globally on CRM software in 2001 - communication, behaviour and culture are equally crucial factors in making CRM successful too.
CRM: Technology v Culture By Cheryl Rickman

CRM: Its at the forefront of todays business vocabulary and, according to Meridien Research, $6.7 billion was spent globally on Customer Relationship Management software in 2001. However, businesses are increasingly learning that technology and software alone cannot make a CRM system successful, and that communication, behaviour and culture are equally crucial factors in developing a successful CRM strategy.

New Internet technologies have arisen, such as Computer Internet Integration (CII), Chat, Push, and Callback, which enable one-to-one customer/consultant conversations and let advisors take control of the customers browser to help them navigate and buy. However, in the same way that companies have traditionally had problems managing effective in-house call centres, today web companies are finding live customer service to be time consuming and labour-intensive.

Some companies say they have the solution. Microsoft (obviously in there somewhere) will be releasing their new customer relationship management product, MSCRM, due out by the end of the year. This promises increased sales force automation for small businesses and is, apparently, not aiming at the enterprise market.

A company aiming at the both the SME and enterprise market is SalesForce. They aim to become the world's first "enterprise automation utility" by delivering (CRM), sales force automation (SFA) and financial software over the Web, competing directly with giants such as Siebel, PeopleSoft, SAP and Microsoft Great Plains. And with customers paying as little as $65 per month for their low-end service, its a more affordable CRM application, which is apparently quick and easy to implement.

The Professional Edition application (its current offering) does not allow for real-time integration with back-office systems and offers only limited customisation. To address these shortcomings Salesforce.com has announced its Enterprise Edition, which is aimed at larger companies, plus an introductory offline edition, available for use on a laptop, and a wireless version accessible via any PalmOS device.

Another solution comes from Transform People International (TPI). Unlike the aforementioned companies, TPI is not a software company. Its a management consultancy, specialising in behavioural analysis and transformation, organisational change and training. Naturally they focus less on the technology and more on developing connections and transforming behaviour, attitudes and styles the grass roots of CRM know how your customer thinks, what their needs and wants are; how you think and how to best engage effectively with each person to generate optimum results.

Its the value of knowledge about customer needs and buying habits that is becoming more important along with changing business cultures and deepening connections with customers. TPI understand this and have launched their new Connections Tool as a result: an online diagnostic tool that aims to improve connection and communication with customers in 4 simple steps. Rising above regular sales techniques, the Connection Tool builds on both CRM technology and behavioural understanding. The output provides a written summary of the main characteristics of the person, with an overview of how they act when under pressure. It also provides an overview of what drives that person, with key tactics and strategies for better connection. http://www.transformpeople.com/connections/tpiintroduction.htm

The TPI Connections Tool grew out of Transform People Internationals experience in delivering organisational change in many global corporations across a wide cross-section of vertical markets ranging from communications and technology to packaging. As well as an acute awareness that, by understanding behaviour, businesses can improve communication and develop relationships more successfully.

Technology V Culture

An Information Masters survey revealed that, Technology and information are responsible for, at most, 25 per cent of your CRM competence. Other assets that are important include brands, messages (sadly neglected), staff knowledge, policies, processes and rules.

And, according to Robert Shaw, founding director of the consultancy CRM Best Practice, The danger is that many organisations are now investing huge sums in the wrong things. The technology is excellent in many cases, the problem lies with how we apply it. We invest too much time in selecting one-hit solutions and too little time in creating the business vision, adds Robert. Bad CRM is easy. You just read the press, go to a few exhibitions, choose some software, hire some systems implementers, and bingo, you have a Web site, a call centre, or a mailing database. Most important for good CRM is to have an offensive strategy, not a defensive one. Waiting until competitors threaten you, then responding to them or copying them is a recipe for failure. You need to take time out to create the vision.

And that vision includes developing an analytical attitude towards customer, staff and client behaviour. A vision mirrored by Transform People.

How you asses the person youre developing a relationship with, how you assess your own behaviour and your organisational behaviour, and how you engage with people are crucial to making CRM more effective, Says Ian Mills, Director of Transform People International.

Arthur OConnor, leading expert on CRM and columnist for www.ecrmguide.com, agrees, Some businesses spend a fortune striving to engage, attract, and sell prospects -- only to take extreme measures to avoid interacting with these same people after they become customers.

He adds that the Call Centre hasnt been the best choice for those striving to improve CRM. Many companies brought in poorly trained, ill-equipped people to serve as their primary customer interface, says Athur. Resulting in Corporate Schizophrenia.

Evidently then, it is the behaviour of staff, the behaviour and experience of your customers, combined with a winning strategy and good technology that will improve a CRM strategys chances of success.

Afterall, a CRM package only has real and tangible value if it is backed by a strategy, agrees Ronni T. Marshak, senior vice president of the Patricia Seybold Group.

In building a robust customer relationship objectives should include reducing the cost of acquiring new customers, cross-selling and up-selling to existing customers, closing more sales, targeting more lucrative markets, and creating conditions to make those goals more obtainable. "Most of those conditions have nothing to do with CRM technology itself," says Marshak.

"A company that wants to become truly customer-centric rather than just paying lip service to the notion may have to reengineer fundamental business processes and change prevailing attitudes altogether," he concludes.

Evidently then, the success of CRM rests on both technology and organisational change and the willingness of organisations and individuals to assess and analyse behaviour to improve connection and deepen relationships.

The best technology in the world cannot incur the required cultural, organisational and behavioural change that is needed to drive effective CRM strategies. The difficulty is getting people to change the way they work, to use the technology and to interact with the customer differently. So says Micheal Juer, Director of Sales Pathways Ltd.

There is now a shift occurring where businesses are beginning to realise that they have to work with their customers, and technology is becoming a secondary issue to that. But it is that cultural shift that you need to do, in order to actually deliver good customer service and differentiate yourself from your competitors in the market place.

Customer relationship management should be seen as a strategic response to a set of customer, staff and business needs. And as long as businesses focus on those crucial points and not just technology alone: working with customers and facing organisational and cultural change, their CRM results will improve.

7 Tips for CRM Success:

Define your business objectives and goals against which results can be measured. Give each CRM project three dimensions: people, processes and technology. Establish a systematic approach to project management including team development, IT, marketing, services, sales and management, as well as software. Clearly identify corporate and customer needs. Research requirements, behaviour and how to engage and deliver effectively. Manage organisational change effectively. The human factor is imperative to a projects success. Invest in training more essential than any piece of software. Focus on proactive selling, management and relationship building to effectively upsell and cross-sell.

Cheryl Rickman is author of '111 winning ways to promote your website successfully' and contributes regularly to Better Business magazine, Digitrends.com and Internet.com. She offers website appraisals, copywriting and marketing via http://www.webcritique.co.uk

Labels: , , , , , ,

CRM - An evolutionary concept to communicate with your customers

An evolutionary concept in communicating with customers
There is probably no other time in history when business conditions have been as difficult and competitive as they are today. Companies are pressuring their managers to work harder and smarter to sell their products. One vital factor that most companies tend to forget is that customers are the only reason they are in business. In turn, customers are curtailing their buying, because the tough times are impacting them as well. It is time Australian corporations realise that customers are not just numbers on a sales graph. They need to help their customers to run a more efficient and profitable business so that they can keep them as customers and keep them coming back.

Existing customers - prime prospects! It should really go without saying that your prime source of new business is your existing customers. You already have a track record with them. They trust you and your products. It is easier to sell more to them than it is to find new prospects. It is less expensive too. Management guru Peter Drucker said it all when he said "On average it costs you five times as much to get a new customer as it does to hold an existing one". Jan Carlzon, the man who turned SAS from a huge loss maker into a profitable airline in less than two years echoed Druckers thought when he said, "All profits come from customer satisfaction". Both were right and their advice is exactly what is needed today.

Communicating with customers There is a myriad of ways to communicate with your customers. All the old time methods, such as, sales letters, telemarketing, brochures and so on, sometimes work, most times they dont. It is a hit and miss situation. If we are to retain our customer base we need to upgrade our communication methods to take advantage of todays technology.

Lets look at one area that companies use to communicate with customers, the customer newsletter. The main problem with customer newsletters today is, that in the main they are self-serving and not at all what a customer wants or needs. They waffle on about how good the company is and the brilliance of their products. Emphasis is placed on their company instead of where the emphasis should be placed, on their customers. The main objective is to retain existing customers and hope that they in turn recommend our products. To do this we must ensure that they see our communications as being useful and valuable to them. Our communications must assist our customers to do better in their businesses, which means that they will be able to spend more money with our company. We cannot achieve this objective if we continue to send out communications that prattle on about how good we are. Remember that, your customer is only concerned with that which benefits their company.

With the traditional media so fragmented and expensive, it is proving difficult to reach the right target audience at a cost-effective price. Your customers are also more sophisticated than ever before so you need to be the same. Your customers are constantly looking for ways to improve themselves, their people and their operations and any help you can give them to improve their business operation will undoubtedly have considerable benefits for you.

Communicating with customers A new way of communicating with customers is just being introduced onto the corporate business scene. With Internet marketing being the modern way to reach your prospects you can now send your own fortnightly business magazine to your existing customer base to help them to improve their businesses and by doing so cement your relations with them.

By doing this you offer your customers meaningful help. In corporate communication content is king and this magazine contains articles on management from over 150 of the greatest management gurus in the world. Experts like Anthony Robbins, Al Ries, Zig Ziglar, Amanda Gore and scores of other great thinkers whose combined wisdom will help your customers do better business leading to better business for you from your existing customers who, of course, are your prime prospects. The magazine also contains your advertising and articles from your company. Such a company communication puts your sales messages on your customers desk every fortnight. Using this idea you get the biggest names in business working for your company every issue. You can get full details on how you can make this idea achieve your CRM and sales goals by visiting http://jamesgaw.com/magazine or by calling James on (617) 32893889 (Australia)

James Gaw is a management educator, international speaker and author of the in-house training product QuickCourse. He can be contacted on (07) 3283 3889 or by email at amarquis@petrie.starway.net.au. Website: http://jamesgaw.com

Labels: , ,

Thursday, January 10, 2008

ERP Role in selling your mid-size business Microsoft Great Plains and CRM example

If you own the mid-size business and actively work in it as executive manager or lead, say marketing, you probably know exactly what needs to be done on the daily basis to keep it running. However, in many cases this business critical knowledge exists in your head only. This means that if you would like to sell your business it has little value without your participation. So, ahead of the selling time you should formalize the business to make it work within the systems and rules, independent of people. Lets consider the parts we will need.
Functional Diagram. Well one may think that he doesnt have to reinvent the wheel, but we think that this is the only possible way to start from the top level of formalization. Functional diagram should show the process of getting new customer as a prospect, the sales process up to the closing, then customer order executing. And this diagram should reflect the interaction of your departments and key employees/positions.
Sales Control. When you want to formalize sales you are looking for the system, which allows you to distribute leads to your sales people and then have a tight monitoring of the closing rates and the quality of the closed prospects by salesperson. This system will allow you to create formal position: Sales or Marketing director, who can generate new business for the company through this Sales automation system. In our opinion this is 60% of the formalization success.
Order Execution. You need standard ERP to control order fulfillment. Usually such a system is implemented on one of the Accounting applications platforms. In the case of small and mid-size business, we would encourage you to map to your functional diagram, described above and clarify all your needs with the consultant, who will help you with the implementation. Order Execution automation will allow you to introduce another formal position Controller.
CRM/ERP market. You could find variety of the systems on the market. Here you need to stick to the quality rules. When you implement the computer system you should probably take the leaders on the market and be sure that they will stay or get additional market share in the future. In the case of mid-size business in our opinion you should be selecting between two leaders: Microsoft Business Solutions with its ERP: Great Plains, Navision, Solomon, Microsoft CRM, and Best Software with their MAS 5000
Microsoft Great Plains & CRM. These two systems are integrated and allow you to implement Sales Control and Order Execution, if you decide to stake on Microsoft brand.

You can always have us help you with the implementation & customization. Call us: 1-866-528-0577, 1-630-961-5918.

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Microsoft CRM, Microsoft Great Plains customization company, serving clients in Chicago, California, Texas, New York, Georgia, Arizona, Louisiana, Michigan, Florida, Canada, UK, Australia, South Africa and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

Labels: , ,

What is Customer Relationship Management (CRM)?

 Customer Relationship Management (CRM) is a phenomenon that is becoming a major discipline within business. CRM can be traced back to the airlines attempt to gather information about their customer flying habits in order to stop their high-fare airliners choosing low-fare carriers, however, the concept was invented even further back, when the shop owner knew all his customers by first name and they knew his name.

In 1998 The Economist Intelligence Unit (EIU) in conjunction with Andersen Consulting published the result of a CRM survey of different companies around the world. The survey revealed a new heightened focus on CRM as a discipline, where companies increased their customer focus and using a process approach to customer relationship management. This was a market shift from the traditional transaction-based and functionally managed approach where the relationship with customer was divided up and dealt with by different departments. The EIU report also showed that between 1994 and 1997 the spending on customer relationship management software and services grew from $200 million to $1.1 billion in the USA. The EIU report is one of many investigations that indicate a growing interest in CRM and some literature concerning CRM even postulate that companies will have to adapt it to survive.


Several researchers define CRM differently. Couldwell defines CRM as:

Customer relationship management is a combination of business process and technology that seeks to understand a companys customer from the perspective of who they are, what they do, and what they like

and Hobby, defines CRM as:
A management approach that enables organisations to identify, attract and increase retention of profitable customers by managing relationships with them".

However, I have found the following definition of CRM, to be the most adequately:

"CRM is a business strategy - an attitude to employees and customers - that is supported by certain processes and systems. The goal is to build long-term relationships by understanding individual needs and preferences - and in this way add value to the enterprise and the customer".


This definition places the strategy of adding value to the customer in the focus, whereas the first mentioned definition gives technology and processor first priority. As the chosen definition explains, the systems and processes are vital support elements in creating value for the customer. The second-mentioned definition is found to be somewhat thin and practical useless but it notice an important aspect of CRM, that the organisation has to learn how to listening to customers. In the definition, CRM is defined as a business strategy. This is an important aspect, as CRM is not to be seen as a concept or a project but as a business strategy, which affects all parts of the company.

CRM is about identifying, retaining, and maximising the value of a companys customers. CRM is a sales- and service business strategy where the organisation wraps itself around the customer, so that whenever there is an interaction, the information exchanged is relevant for that customer. This means knowing all about that customer and what the profitability of that customer is going to be. CRM is an effort to create the whole picture of a given customer, bringing together consistent, comprehensive and credible information on all aspects of the existing relationship, such as profitability information, risk profiles and cross-sell potential.


To keep customers satisfied and make them return, CRM, as a strategy, is not a new phenomenon. Every company wants profitable and loyal customers. The new aspect is that companies start to measure this profitability and loyalty and use this information to segment customers and develop strategies for approaching these customers.


However, before implementing CRM, companies need to have some basic foundations settled. First of all, the basic quality of the products has to be in order, i.e. if the product does not live up to the expectations of the customer, he will not be satisfied, hence loyal for long. The typical strategies prior to CRM are quality control systems such as Total Quality Management (TQM). Secondly, companies also have to know more about their customers before implementing CRM. I.e. they have to evaluate, which customers are most valuable in terms of profitability, loyalty and future expectations. Thirdly, the companies have to have the necessary technology to enable the employees to access information about customers in order to offer customers the best service. Finally, CRM needs full support from the management of the company to stand a chance of success.
Rasmus Nielsen has specialised in CRM for several years and been consulting to various companies in Denmark and Australia on the topic.
Rasmus also holds a M.Sc. International Business Economics

Labels: , , ,

Monday, January 7, 2008

CRM Business Relationship

 A business relationship is different from any other kind of relationship, being a personal or a social relationship. However, to understand what a business relationship means, it is necessary to identify what a relationship is.
A relationship is according to the Oxford Advanced Learners Dictionary a connection between things. A different definition is that it is a memory of past interactions. Both definitions say something about a relationship even though that they do not say exactly the same. However, the definitions do not differ between business relationships and personal relationships, which is important because there is a different objective between the two kinds of relationships. Therefore, a business relationship can be defined as: A bond based on a rational objective, which is to do business with each other.However, as the interaction between the two actors increases, a certain relationship evolves and the knowledge about the other part is increased. Together they create a combined understanding and view of reality. The more common output of the relationship is a decrease in transaction costs, as transactions becomes routinely and the bond between the two companies is strengthening.
When talking about a business relationship, trust comes to mind, because relationships build on trust. However, can a relationship survive without trust? It is possible for a professional relationship to exist without trust, though in most cases trust is a part of the professional relationship. Various authors, such as Paul Greenberg in CRM at the speed of light, 2000, has argued that relationships build on memories of past interactions, because on the first encounter you do not know each other, however, on the second encounter you build the relationship on the previous encounter. He believes that it is the previous encounter that counts in the eyes of the customer. It is true that a need can create a genuine relationship, however, a long-term relationship needs trusts to be able to survive. Furthermore, the better one get to know the other, the better conditions the relationship has to succeed, if there is a honest approach to build the relationship. To some degree the two approaches towards creating a business relationship agree, however, if the objective is to create loyalty both the successful encounter and trust must be accomplished in order to create a successful long-term business relationship.
Rasmus Nielsen has specialised in CRM for several years and been consulting to various companies in Denmark and Australia on the topic. Rasmus also holds a M.Sc. International Business Economics
Other Articles from Rasmus Nielsen
www.frejaweb.net

Labels: , , , , , ,

3 Reasons Why CRM Strategies Fail

 Customer relationship management (CRM) is one of the most effective tools for improving customer relationships and therefore increasing revenue, customer satisfaction, and customer retention. Unfortunately, some CRM strategies fail. This leaves CRM vendors and their customers baffled, but there a few common reasons why a CRM strategy will fail.

1. Too much focus on the CRM vendor and technology. Some companies get too caught up in having the best possible CRM strategy out there. Some companies want entire call-centers, On-Demand CRM, Web-based, and Blackberry devices which allow their IT people to enter customer information wirelessly. While these technologies are extremely helpful, too much emphasis on them can lead any company astray. It is naturally very important to select the best CRM vendor for your company, but best does not always mean flashiest.

2. Not enough focus on the customer. Companies can focus too much on technology and strategy, and not enough on what is at the core of CRM: the customer. The first letter in CRM stands for Customer and so the customer should be first when thinking about any CRM strategy. A call-center can be wonderful if it is customer friendly. However, some call centers are too complicated and alienate the customer from the company. Alienation is the exact opposite of what companies want to achieve when implementing CRM. The real ROI of CRM is found in customer retention and the acquisition of new customers. In order to have success with CRM, a company must work towards building a strong relationship with its customers. CRM is the path through which the customer and the company can understand each other. Focusing on technologies and ignoring the basics of customer service will cause even the most technologically advanced CRM strategy to go wrong.

3. Rushing into CRM adaptation. Sometimes, company presidents get the idea of CRM into their head and decide that their entire company must be CRM-ready as fast as possible. Rushing into CRM is a recipe for disaster. IT workers need to understand the concept of CRM. Someone who understands the importance of CRM will be better suited to deal with customers and reach the companys goals concerning CRM. Rushing into CRM does not allow ample time for all IT people to be briefed on the basics of CRM and how it will be implemented within the business. Some companies implementing CRM have to create entire departments that never existed before. The greatest care must always be taken when creating an entire new section of a company. CRM should generally be implemented across the entire company. If this is rushed, it can lead to all sorts of compatibility issues, customer confusion, and even employee confusion. Data collected must be viewed across many applications, and ample time must be given for networks to be set up. Companies using CRM technology such as Blackberry devices, or Call-centers must be even more careful when implementing CRM for the first time. Technology is not perfect, and problems can occur at any time. Any company that sends their sales force out into the market with unchecked technology is asking for disaster.

Some say that it is impossible to determine whether CRM is a success or a failure. The true ROI of CRM lies with the customer. A company that avoids the pitfalls of CRM implementation will notice a dramatic increase in customer satisfaction, retention, and acquisition. CRM can help any company significantly if it is used correctly, carefully, but still efficiently. CRM technology can also help companies if it is used thoughtfully and timely. The entire company must be prepared for CRM when it is implemented. A company cannot expect exact numbers immediately after putting CRM into effect. CRM is a long-term strategy that will help achieve long-term goals of a company. Customer focus is essential and will help any CRM strategy to become a success.
Matt Hogansworth enjoys writing about CRM topics and CRM software vendors such as Salesforce ( http://www.salesforce.com).

Labels: , , ,

Friday, January 4, 2008

Is Your CRM System Destined To Fail?

 Its time to put your trusty CRM software to work; to let it earn its keep. You're about to blast an email out to several thousand potential customers. First you run a search of people and companies you want to target. You soon realize somethings wrong when your list is far smaller than anticipated. A quick check reveals many profiles have not been filled in or are missing email addresses. Further inspection shows numerous records are incorrect; others are riddled with typos. And thats just for starters. With a sinking feeling, you realize this email blast isnt going to happen anytime soon.

Time for some damage control or preventative maintenance

Fortunately one of the most common reasons cited for the high failure rate of CRM systems - poor data quality - is also one of the easiest to avoid. Your CRM software is only as good as the information it contains. As the old programmers motto goes garbage in, garbage out. So how can you avoid incomplete, incorrect, irrelevant or out-of-date and generally unfit-for-use data from permeating your CRM software?

You need to gather your key CRM users together and write a standard guideline document, defining the CRM system rules of use.

10 questions that should be addressed:

1. Identify who has what rights to the system; who can Create, Insert,
Modify or Delete records? Forward this information to your system
administrator to record.
2. Decide on a procedure to check for any duplicates before creating a
record. Depending on what de-duping or data scrubbing features your
system has, this might require some simple searches before starting a new
record.
3. Do you allow abbreviations or acronyms? For example: IBM, or I.B.M,
or International Business Machines Inc. A policy on ensuring consistency
of input will help to avoid duplications in future.
4. Are records going to be created in Upper and Lower case and when are
CAPS acceptable?
5. By when do you expect records, notes and so on to be created or
updated? Same day, on return to the office?
6. Is the primary address of clients to be created as a postal or a
physical address?
7. Make sure everyone checks spellings if they are unsure. When in
doubt, ask the client or Google it.
8. Make rules for creating new tabs or Custom Objects (as
salesforce.com CRM calls them.) Every time a new Custom Object is needed,
it should first be approved.
9. Ensure that email addresses are put in correctly. Basic but common
mistake!
10. Set up procedures, if not supported by your crm software, of how to
create records from inbound emails.

Once your document is finished, get everyone to sign off on it. As
standard practice, ensure that document is handed to all new employees at
your company.

How do I reinforce this as time goes on?
Try this: select a couple of records - both good and bad - every week, to
put on the overhead at staff meetings. Make sure you dont unduly
embarrass anybody but watch this become the light-relief highlight of your
meetings! People learn best when having fun!

What if your database is in one unholy mess?
Has the rot set in so deeply that your database needs a complete overhaul?
Turn this seemingly insurmountable task into an opportunity to you. This
is an excellent excuse to re-establish contact with your clients and let
them know you care.

Importantly, help your staff understand what you need from the data to
facilitate more accurate marketing and reporting and hence the success of
your business and their careers.

By creating a sense of pride and ownership in the company database, you
are nurturing the essential process of buy-in, necessary for the success
of your CRM initiative. Dont compromise this critical tool by allowing
your CRM software to be infected by inferior data.
David Cowgill is a Senior Marketing Manager in San Francisco. His coverage area focuses on the technologies that facilitate managing CRM analytics and lead generation.

For further information contact:
David Cowgill
CRM Blog Founder
http://crm.blogs.com

 

Labels: , , , , ,