Friday, April 11, 2008

How To Calculate CRM Total Cost Of Ownership (TCO)

Although it may look and sound complicated, calculating the Total Cost of Ownership (TCO) for on demand CRM is as simple as elementary subtraction. Or to go one step further, more money will be going into your business rather than the system that struggles to support it. The on demand model affords customers greater flexibility in accessibility and product, hassle free hosting of information, upgrades year round and greater security of information, just to name a few perks!

For those not using on demand CRM allow me to break down its cost effectiveness versus out of the box or custom built solutions:

For starters you can take your current IT costs and subtract all your hours and dollars spent on system maintenance, upgrades, integration and up keep.

Now further subtract the cost incurred for hosting your current network or CRM application. If it is in house then you can deduce server costs, power costs etc... If you host via third party you can go ahead and drop that cost all together.

So things are starting to look a little brighter!

For those who currently use an out of the box CRM system, you can go ahead and knock off the costs incurred for support, training, customization and yearly upgrades, and every other hidden fee you incur.

I am sure that by now some of you are probably feeling a little skeptical; and I don?t blame you, the potential to save this much money definitely warrants some initial second guessing. But don?t let me convince you, see for yourself and put your worries to rest once and for all.

No upfront costs ? with on demand CRM, the software is already built and it is entirely hosted online, all you have to do is subscribe and start using it.

No downloads ? the on demand CRM platform ensures you are never burdened by continual downloads cluttering up your computer and network while slowly eating up your memory.

No hosting fees ? the on demand platform is designed, built and maintained by an expert IT staff, hosted at an external secure location with manned security personnel. Enabling you the user to focus solely on your business and only your business.

Customizable platform ? the on demand SaaS platform is readily customizable by expert developers and product engineers. No longer will you have to fork over thousands of dollars to mash stand alone legacy systems into a tedious and often bug ridden enterprise solution.

Free upgrades ? with the flexibility of the on demand CRM model, top CRM vendors can offer continual and seamless updates and enhancements to their solution.

Security of Information ? a common misconception with the on demand platform is the issue of information security. While many find comfort in having their information hosted on site, they are in fact more vulnerable to intruders or hackers, or disgruntled employees then they would be by using the ASP/on demand platform. A good CRM vendor out sources the hosting of their servers to ISP providers, thus guaranteeing greater security and up time for their customers.

There is no denying the aforementioned facts, on demand CRM offers you greater bang for your buck when compared to the conventional out of the box offerings. On demand CRM removes the headaches of IT maintenance along with its hefty costs, it optimizes your employee work rate and in turn, allows you to bring in more money while spending less. Not to mention your company info could not be more secure!

Colin Duffy enjoys writing about CRM subjects and on demand CRM and ERP software vendors such as Salesboom ( http://www.salesboom.com )

Labels: , , , , , ,

Sunday, March 2, 2008

Microsoft Dynamics ERP Selection: GP, AX, NAV, SL, CRM ? notes for consultant

Microsoft recently (in September 2005) renamed its ERP product: Great Plains ? Microsoft Dynamics GP, Navision ? Microsoft Dynamics NAV, Axapta ? Microsoft Dynamics AX, Solomon ? Microsoft Dynamics SL, Microsoft CRM ? Microsoft Dynamics CRM. 

Microsoft recently (in September 2005) renamed its ERP product: Great Plains ? Microsoft Dynamics GP, Navision ? Microsoft Dynamics NAV, Axapta ? Microsoft Dynamics AX, Solomon ? Microsoft Dynamics SL, Microsoft CRM ? Microsoft Dynamics CRM.  The idea is probably nice ? to unify future concordance product under Microsoft Dynamics name.  There are multiple possibilities, however in getting all MRP systems merged into one Microsoft Dynamics and what should be taken as base and what should be phased out.  We can not be judges ? we will give you some facts for you to take into consideration.  This article is planned as a first entry point to look ?under the hood? of Microsoft ERP applications and probably compare the facts with the competition: SAP (especially SAP Business One if you are small or mid-size company or international branch of multinational corporation), Oracle E-Business Suite/Oracle Financials, also referred as Oracle Applications.

  • Microsoft Dynamics GP 9.0/Microsoft Great Plains.  This ERP was initially architectured by Great Plains Software ? Great Plains Dynamics and Great eEnterprise hit the market in earlier and middle 1990th.  If you remember those old-good-days of IT boom ? nobody knew which operating system will win: Unix/Solaris, Microsoft Windows, Apple MAC OS.  This is why ? the traditional (and pioneering way) for those days was to create a shell, written in C language to abstract you from Graphical platform.  Great Plains Dexterity was this shell, programming language (sanscript).  The second fundamental idea was to abstract Great Plains Dynamics from database platform, however the abstraction was done on the level of ?budget? database platforms: Ctree/Faircomm, and Btrive, later on Pervasive SQL 2000, for Microsoft SQL Server 6.5/7.0/2000 Great Plains used atomic stored procs approach to speed up database access.  Nowadays Microsoft Dynamics GP/Great Plains versions 5.5, 6.0, 7.0, 7.5 are available for Ctree and Pervasive, however since version 8.0 Microsoft Great Plains is available on MS SQL Server/MSDE platform only.  Currently Microsoft Great Plains 9.0 is offered in USA, Latin America, Canada (including French Canadian version for Quebec), UK, Australia, New Zealand, South Africa and other countries where official language is English ? such as South East Asia, for instance.
  • Microsoft Navision/Navision Attain/Microsoft Dynamics NAV.  Some ERP analytics believe that Microsoft Great Plains Business Solutions (later renamed into Microsoft Business Solutions) bought Navision Software (est. in 1984).  The fundamental ideas of Navision come to its own shell ? C/SIDE, database proprietary platform: C/SIDE, etc. Navision was designed to be flexible and grow with your business ? from small to upper mid-market.  Navision Software had its own marketing plans prior to be purchased by Microsoft and expanded in continental Europe, UK, USA (competing with Great Plains Software and Solomon Software).  When Navision was bought by Microsoft ? Microsoft Business Solutions offered and promoted Navision in East Europe: Russia, Romania, Bulgaria, Hungary, etc.  Plus it tried Navision in Brazil (over 100 implementations - 2005).  Navision is more flexible to localization challenge (than Microsoft Great Plains)
  • Microsoft Axapta/Microsoft Dynamics AX ? it seems to be rising star for Microsoft and it can compete with upper ERP/MRP mid-market. Axapta has modern design and its ability to expand is still in its architecture modern model (versus Great Plains or Navision ? where we see integrations with MS Office, Web Fronts/Business Portal/eConnect/eCommerce type of improvements).  In late 2005 we see US and UK MBS VAR activity to sign for Axapta and consultants training.
  • Microsoft Dynamics SL/Microsoft Solomon ? this ERP is for project-driven organizations.
  • Microsoft Dynamics CRM 3.0/Microsoft CRM 3.0.  This CRM solution from Microsoft is abreast of the majority of Microsoft recent ideas and innovations: Microsoft Exchange, Active Directory, XML Web Services driven MS CRM SDK with C# and VB.Net sample code.  Currently MS CRM 1.2 and 3.0 has integration to Microsoft Dynamics GP 7.5, 8.0 (with service patch) and 9.0 (coming?)

Please do not hesitate to call or email us: USA 1-866-528-0577, 1-630-961-5918 help@albaspectrum.com

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.greatplains.com.mx http://www.enterlogix.com.br ) - Microsoft Business Solutions Great Plains, Navision, Axapta MS CRM, Oracle Financials and IBM Lotus Domino Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, 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: , , , ,

Monday, January 28, 2008

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: , , , , , ,

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: , , , ,

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: , , , , , ,

Sunday, December 9, 2007

Microsoft CRM Customization if you give up overview for consultant

Microsoft CRM is designed to be customizable. However this is new system and you could be not comfortable to do it on your own. In this small article well try to reassure you if you can do it or point to the right direction if you would like to subcontract it to professionals. Lets begin

Microsoft CRM is CRM answer from Microsoft Business Solutions to traditional CRM vendors, such as Siebel, Onyx. Microsoft CRM customization techniques are very diversified and based on the whole spectrum of recent Microsoft technologies. The main terms you should know are: Microsoft CRM SDK 1.2 and Visual Studio.Net 2003. And of course you should be familiar with all the legacy internet technologies, such as HTML, XML, XSLT, JavaScript and be good C#/VB/Net developer.

If you are developer who is asked: how do we customize Microsoft CRM read this and you will have the clues on where to look further.

1. Microsoft CRM SDK this is software development kit with C# and partly VB.net examples it is supported by Microsoft Business Solutions technical support. It is all web services based calls, if you are C# .NET developer you are excellently positioned to do this type of customizations. This is the preferred customization scenarios and this should be easily upgradeable customization.

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

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 make job done.

6. MS CRM Customization tool you can feel free to use this 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

Happy customizing! 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 in Alba Spectrum Technologies USA nationwide Microsoft CRM, Microsoft Great Plains customization company, serving Chicago, Los Angeles, San Francisco, San Diego, Denver, Houston, Phoenix, New York, Atlanta, Miami, Canada, UK, Australia, Brazil, Mexico, Russia, Germany ( http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.akarasev@albaspectrum.com

Labels: , , , , , , ,