CRM...

Roger J. BurkeHere is my latest article. It may be freely used in ezines, on websites or in e-books, as long as the Resource Box is left intact.

I would appreciate notification of where it was used, and if possible, a copy of the ezine or newsletter that it was used in. Please send notification mailto:webmaster@online-wealth.com

=========================

I hate computers.

Now, coming from a person who's been involved with them since 1967, you might think that's a bit over the top.

Well...it's not *actually* the computers that's the problem, of course, it's the software - the programs that run in them, that I *really* hate.

I also hate ATMs. Now, that's a double whammy for the poor, dumb machines!

But, like computers on the desk, ATMs are everywhere, and by golly, there're *so* convenient, aren't they? However, now that we have ATMs and computers in an unholy alliance, specifically designed to ruin your day at any nanosecond, I was happy - *well, almost* - when I had to turn to the customer service desk at my local bank for help.

Y'see, the ATM had just swallowed my cash card and had issued this terse message: "Invalid transaction - card retained", to be immediately followed by another: "Please use another card and try again." Huh? I didn't *have* another card on me right now, did I! And, I knew that there was sufficient money in the account...

Naturally I was annoyed but, resisting the urge to give it a Coke machine kick, I went instead to the customer service desk to sort the problem out. Here, I thought, I'd get the attention I deserve as a good customer, you know, talk to a *real* person, blah, blah, blah...

Ever been to la-la land? Well, we all get there, once in a while I guess, but...at 9.30 in the morning? Bear with me, for a few moments, while I relate the nadir of Customer Relationship Management - aka CRM for all internet aficionados - a la local bank style...

ME: "Look...er...my son, Danny Burke, asked me to get some money from the machine, and that one" - me pointing accusingly -"just upped and took it. Would you be able to help, please?" I smile helpfully (I tried to look a bit sheepish also - that sometimes helps).

SHE: "You shouldn't have done that!" Slightly frowning, and a bit of a sharp note to her voice.

ME (nonplussed, eyebrows raised): "Huh...what...oh, yes, well, he gave me his PIN...he's in school now" - glancing at my watch - "so, he can't be..."

SHE (cutting in): "You're not supposed to use his PIN - unless of course you're AUTHORIZED." Voice definitely rising now, but not yet shrill. Glares at me, accusingly.

ME (defensively and now, a bit angry): "Hey...I know about PINs and their use...and I don't need a lecture from you!" (glaring back now). I had been part of the online systems development team, at one of the major Canadian banks, in the mid 70s...so, I knew whereof I spoke.

SHE (slightly retreating now): "Well!" A pause. "Well, where is the card, you say?" I point to the machine again.
"Well, I suppose I'll go and get it...one moment...please" (almost an afterthought, by the sound of it).

She stalks off. Idly, I contemplate darkly how hard I can jam some old receipts down an ATM slot when I leave...if I ever get outta here, as the band said, yeah, if I *ever* get outta here...where are *my* wings, I wonder?

Her shrill voice breaks my vengeful reverie.

SHE: "Well, here it is," waving it about triumphantly, "but you can't have the card back. It's *not* yours, you know...you'll have to get authorization from your son...a letter...to pick it up." Emphatically, she puts the card in a drawer, slams it shut. Thud! Smiling now, full set of ivories, dripping insincerity.

ME: "Huh...what?" (I know, I know...I tend to repeat myself!) But, before I could go on...

SHE: "Anyway, what happened? Why did the ATM take the card? Did you enter something incorrectly?" I couldn't believe her accusing tone. At any moment, I expected her to start shaking her finger at me.

I look at her blankly, but I'm thinking. Now that was the funny thing about this whole mess - I'd followed everything to the letter...er, number: key in PIN, hit WITHDRAW CASH, select correct account...hmmm, must be SAVINGS, Danny has no CHEQUE account, but just after I key-entered 140, the ATM issued the above messages and ate the card. That's it...kaput! I felt that I'd just been executed. Maybe it was some kind of read error on the unit? Most unlikely...the card had already been accepted - PIN, account, the lot! But, what then?

ME (finally shrugging, shaking my head): "Hmmm...well, no...there's no obvious reason...that I can think of..." Brow furrows, bites lip pensively.

SHE (primly): "Never mind, never MIND, either fill this form out for a new card", handing me another bank form, as if I didn't have enough already, "or get your son to bring a letter back...and then you can get the card back!" She said the last with more false bonhomie, teeth glittering.

As I walked away muttering, I glanced back at the large sign above the area: "Customer Service Desk". Some service, I thought; more like "Customer Punishment Area - SFA (that's Self Flagellation Acceptable)"! My only option now was to return with some sort of letter to satisfy these goons and their procedures...so much for *this* bank's customer relationship management program.

That woman on the service desk failed miserably at CRM: the cardinal rule is that the customer is always right, even when s/he's wrong. She didn't *have* to tell me that using another's PIN is not recommended; from Spitzbergen to Tierra del Fuego, everybody knows *that*, already! Additionally, she didn't even have the courtesy to address me by my name...

And, to cap it all, instead of apologizing to *me* for the inconvenience, she made me feel as though I had been the one to inconvenience *her*. Some service, huh?

Y'see, she was intent *only* on enforcing procedure, even to my detriment, instead of trying to get to the root cause of the problem...which, by the way, may also be happening to other customers. Even as I speak...

I was thinking about *that* as I drove back home, but put it aside, while I enlisted the aid of She-Who-Must-Be-Obeyed. First things first, after all: get the card back, then worry about why I was card-swiped! This was going to be interesting, I thought, as I knew that Sherry had already had a run-in with the personnel in *that* particular branch some months ago...

Oh, the joys of online banking! ;-)

P.S. Part 2 will complete this sorry saga...

I would appreciate notification of where it was used, and if possible, a copy of the ezine or newsletter that it was used in. Please send notification mailto:webmaster@online-wealth.com

=========================

I hate computers.

Now, coming from a person who's been involved with them since 1967, you might think that's a bit over the top.

Well...it's not *actually* the computers that's the problem, of course, it's the software - the programs that run in them, that I *really* hate.

I also hate ATMs. Now, that's a double whammy for the poor, dumb machines!

But, like computers on the desk, ATMs are everywhere, and by golly, there're *so* convenient, aren't they? However, now that we have ATMs and computers in an unholy alliance, specifically designed to ruin your day at any nanosecond, I was happy - *well, almost* - when I had to turn to the customer service desk at my local bank for help.

Y'see, the ATM had just swallowed my cash card and had issued this terse message: "Invalid transaction - card retained", to be immediately followed by another: "Please use another card and try again." Huh? I didn't *have* another card on me right now, did I! And, I knew that there was sufficient money in the account...

Naturally I was annoyed but, resisting the urge to give it a Coke machine kick, I went instead to the customer service desk to sort the problem out. Here, I thought, I'd get the attention I deserve as a good customer, you know, talk to a *real* person, blah, blah, blah...

Ever been to la-la land? Well, we all get there, once in a while I guess, but...at 9.30 in the morning? Bear with me, for a few moments, while I relate the nadir of Customer Relationship Management - aka CRM for all internet aficionados - a la local bank style...

ME: "Look...er...my son, Danny Burke, asked me to get some money from the machine, and that one" - me pointing accusingly -"just upped and took it. Would you be able to help, please?" I smile helpfully (I tried to look a bit sheepish also - that sometimes helps).

SHE: "You shouldn't have done that!" Slightly frowning, and a bit of a sharp note to her voice.

ME (nonplussed, eyebrows raised): "Huh...what...oh, yes, well, he gave me his PIN...he's in school now" - glancing at my watch - "so, he can't be..."

SHE (cutting in): "You're not supposed to use his PIN - unless of course you're AUTHORIZED." Voice definitely rising now, but not yet shrill. Glares at me, accusingly.

ME (defensively and now, a bit angry): "Hey...I know about PINs and their use...and I don't need a lecture from you!" (glaring back now). I had been part of the online systems development team, at one of the major Canadian banks, in the mid 70s...so, I knew whereof I spoke.

SHE (slightly retreating now): "Well!" A pause. "Well, where is the card, you say?" I point to the machine again.
"Well, I suppose I'll go and get it...one moment...please" (almost an afterthought, by the sound of it).

She stalks off. Idly, I contemplate darkly how hard I can jam some old receipts down an ATM slot when I leave...if I ever get outta here, as the band said, yeah, if I *ever* get outta here...where are *my* wings, I wonder?

Her shrill voice breaks my vengeful reverie.

SHE: "Well, here it is," waving it about triumphantly, "but you can't have the card back. It's *not* yours, you know...you'll have to get authorization from your son...a letter...to pick it up." Emphatically, she puts the card in a drawer, slams it shut. Thud! Smiling now, full set of ivories, dripping insincerity.

ME: "Huh...what?" (I know, I know...I tend to repeat myself!) But, before I could go on...

SHE: "Anyway, what happened? Why did the ATM take the card? Did you enter something incorrectly?" I couldn't believe her accusing tone. At any moment, I expected her to start shaking her finger at me.

I look at her blankly, but I'm thinking. Now that was the funny thing about this whole mess - I'd followed everything to the letter...er, number: key in PIN, hit WITHDRAW CASH, select correct account...hmmm, must be SAVINGS, Danny has no CHEQUE account, but just after I key-entered 140, the ATM issued the above messages and ate the card. That's it...kaput! I felt that I'd just been executed. Maybe it was some kind of read error on the unit? Most unlikely...the card had already been accepted - PIN, account, the lot! But, what then?

ME (finally shrugging, shaking my head): "Hmmm...well, no...there's no obvious reason...that I can think of..." Brow furrows, bites lip pensively.

SHE (primly): "Never mind, never MIND, either fill this form out for a new card", handing me another bank form, as if I didn't have enough already, "or get your son to bring a letter back...and then you can get the card back!" She said the last with more false bonhomie, teeth glittering.

As I walked away muttering, I glanced back at the large sign above the area: "Customer Service Desk". Some service, I thought; more like "Customer Punishment Area - SFA (that's Self Flagellation Acceptable)"! My only option now was to return with some sort of letter to satisfy these goons and their procedures...so much for *this* bank's customer relationship management program.

That woman on the service desk failed miserably at CRM: the cardinal rule is that the customer is always right, even when s/he's wrong. She didn't *have* to tell me that using another's PIN is not recommended; from Spitzbergen to Tierra del Fuego, everybody knows *that*, already! Additionally, she didn't even have the courtesy to address me by my name...

And, to cap it all, instead of apologizing to *me* for the inconvenience, she made me feel as though I had been the one to inconvenience *her*. Some service, huh?

Y'see, she was intent *only* on enforcing procedure, even to my detriment, instead of trying to get to the root cause of the problem...which, by the way, may also be happening to other customers. Even as I speak...

I was thinking about *that* as I drove back home, but put it aside, while I enlisted the aid of She-Who-Must-Be-Obeyed. First things first, after all: get the card back, then worry about why I was card-swiped! This was going to be interesting, I thought, as I knew that Sherry had already had a run-in with the personnel in *that* particular branch some months ago...

Oh, the joys of online banking! ;-)

P.S. Part 2 will complete this sorry saga...

Roger Burke has been involved with computers since 1967, and has managed to break quite a few, over the years. He, and his wife Sherry, are now actively engaged in online self-publishing and promoting specific affiliate programs at http://online-wealth.com . If you have any comments or questions about this article, please send emails to mailto:webmaster@online-wealth.com

Microsoft CRM Integration: Siebel Email Attachments Import - C# and MS Transact SQL example

Microsoft CRM CRM answer from Microsoft Business Solutions has aggressive pricing, going down and making it affordable for small companies. We see cases when Microsoft CRM replaces such traditional CRM systems as Siebel. It is not necessary, that clients decided to replace it themselves they may be victims of their systems the example: Great Plains had alliance with Siebel several years ago and we saw multiple clients with Great Plains Siebel tandem. Now Great Plains integrates with MS CRM.

This article is for programmer, who needs data to be migrated from Siebel or other CRM to MS CRM.

Todays topic is Siebel emails, stored in the files, import into MS CRM database. Each message exists in the form of separate file in the import directory. We will use custom SQL table, created in MS SQL Server 2000:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CrmAttachImporter]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[CrmAttachImporter]GO#BREAK#

Microsoft Great Plains & CRM in Transportation & Logistics overview

Microsoft Business Solutions Great Plains and MS CRM (client relation management system) are very popular in various industries and market niches. In previous article we described Microsoft Great Plains implementation for transportation & logistics company. Having more material, we would like to share with you how you can leverage Microsoft Business Solutions products to automate your business. Well try to be both technical and business processes specific and be laconic to comply the rules of tiny article.

• Cargo/Shipment Tracking System. Transportation & Logistics industry is pretty mature and you more likely have industry standard (like Efreight) or custom system. So, if you plan to implement new ERP it should be tightly integrated with your cargo tracking system.

• Customer Base. This is the question of the core application. If you have to sell to a large number of prospects and track their relatively small shipments you should first consider Microsoft CRM, which has Sales and Service modules. In this case you should enable shipment status lookup from MS CRM screens. In the case when you ship to limited number of large customers you are focusing on the profitability of the shipments and looking at Great Plains as the core system.

• Agent Settlement. This seems to be logistics industry feature. You use agents and settle their AR/AP invoices on the monthly or weekly basis. In Great Plains you should use customer/vendor consolidation, available for Great Plains Professional version. Plus you will need Great Plains Dexterity or .Net customization to link SOP and POP invoices in the settlement process.

• eConnect. Each logistics business has unique business processes and this is why we see software developers in staff plus strong IT department. This makes eConnect (Microsoft Great Plains SDK) very popular among logistics companies. You can create Great Plains objects: Customers, Invoices, Purchase Orders, etc. Plus it allows you to eliminate GP licenses cost you can have users work with Great Plains through web forms

• Integration Technology. In the case of both Great Plains and Microsoft CRM you use MS SQL Server linked server technology. Then you deploy MS CRM SDK, Dexterity, Heterogeneous Stored Procedures.

• Programming Tools. You use Visual Studio.Net to program MS CRM lookups, in some cases you can use WebMatrix, but we do not recommend tools, which do not have rich debugging features.

• Reporting. Crystal Reports is the tool of choice. You should create heterogeneous SQL view and base you Crystal Report on this view. Microsoft CRM security suggests you to use MS CRM SDK or built-in Crystal Reports Enterprise to comply.

• MS CRM Messaging. Microsoft CRM Exchange connector has relatively straightforward mechanism GUID in the message header. If you need advanced messaging capturing emails, based on contact email or domain you main consider advanced connector, developed and supported by Alba Spectrum Technologies. In some cases you would like to use Lotus Notes Domino as email server this is also possible.

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, Asia, Russia. He is Microsoft Great Plains certified master, Great Plains Dexterity, Microsoft CRM SDK C#.Net, Crystal Repots developer.

help@albaspectrum.com

Microsoft CRM USA Nationwide Remote Support

Remember old good days when your company probably had Great Plains Dynamics? If you are in San Francisco Bay Area you had local Great Plains Software partner consulting company, who served you basically coming onsite and charging you four hours minimum, even if the problem deserved 5-min fix? This was at the end of 20th century and remote support technologies were not very advanced Citrix was making good progress and taking market over from Symantec PCAnywhere. Today, when Microsoft Terminal Server and Citrix are remote support standards and IT department uses them to host application server for nation-wide and world-wide users, you should probably be thinking of getting remote support for your ERP and CRM systems. In this small article well take a look at Microsoft CRM remote support, customization, reporting, implementation and integration.

• Why Microsoft CRM Remote Support? Microsoft CRM market niche is still narrow and MS CRM consulting companies do not have enough clientele in their respected locals markets: Houston, Los Angeles, Chicago, New York even in these hypermarkets. In order to survive Microsoft CRM VAR went to nationwide and even international markets to get clients base.

• Technology-driven consulting companies. Microsoft CRM has web and MS Outlook clients and so by its nature it is web application. When you are considering hosting your web site you typically do not care where hosting company is located you consider price and quality. Microsoft CRM could be hosted with .Net hosting companies and implementation could be done remotely with web-session-based training.

• Customization. Today, even if Microsoft Business Solutions has open technology Microsoft CRM SDK the complexity of the specific tasks (messaging through Lotus Notes Domino, generic MAPI, advanced MS CRM Exchange connector) requires precision programming, which should be outsourced to nationwide development centers. As our experience indicates clients are demanding the expertise, not just cheap generic developers. Whoever comes for the cheap price they usually get poor results.

• Large Business ERP. Microsoft CRM proved its market strength and ability to automate large publicly traded corporation. It sits in Microsoft SQL Server and uses all the spectrum of Microsoft technologies: .Net, Active Directories, MS Exchange, Full-Text Search, Crystal Reports Enterprise. We are confident in Microsoft CRM ability to automate Aerospace & Defense, Pharmaceutical, Supply Chain Management, Medical & Hospitals, Distribution & Logistics, Oil & Gas, Wholesale & Retail, Education, Non-for-profit

• Integration. Microsoft CRM has standard integration tool with Microsoft Great Plains, Navision and Axapta integrations are on the way. However you can integrate Microsoft CRM with heterogeneous databases, such as Oracle, DB2, Lotus Notes Domino, Sybase, Pervasive SQL or Ctree/Faircomm.

• Web-Sessions and Skype training. Web Seminars are normal these days and you should be OK with the idea of remote web training. This will allow you to get the best expertise with moderate price.

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, Asia, Russia. He is Microsoft Great Plains certified master, Great Plains Dexterity, Microsoft CRM SDK C#.Net, Crystal Repots developer.

help@albaspectrum.com

The Reality About Customer Relationship Management (CRM)

While Customer Relationship Management (CRM) technology has promised much, the reality for many has been disappointing. Industry analysts estimate 50-60% of implementations fail, or produce marginal return on investment. Our exposure to small and medium enterprises (SME) suggests that this rate may well be significantly higher. The irony is that the problem lies less with the technology itself (though that may receive much of the blame), but in much more easily addressed flaws in the way that organizations approach and implement CRM projects.

CRM technology should help organizations generate more leads, convert a higher

proportion of them, and retain customers longer through enhanced service, and more profitably through the more effective promotion of additional products and services.

CRM technology is a unifying technology supporting the operational needs of ?front-office? departments such as sales, marketing, and customer support, sharing a single database of information about customers, prospective customers, channel partners, suppliers, competitors etc. The CRM database works as a central repository of data typically integrated into other key systems such as finance. The system is designed to be accessed remotely to meet the needs of organizations spread across multiple locations, and staff who may not be office based. Typically this unifying CRM technology aims to benefit marketing, sales and service departments.

Successful CRM isn?t that difficult, but there?s more complexity involved, and more commitment required than many organizations had envisaged. With greater levels of planning, executive support, and awareness of the challenges surrounding user adoption, organizations can effectively drive CRM technology to deliver the promised vision. With so many struggling to get it right, the rewards for those that do will remain very high.

In summary, CRM technology should help organizations generate more leads, convert a higher proportion of them, and retain customers longer through enhanced service, and more profitably through the more effective promotion of additional products and services. Our ?Vision and Reality? white paper sets out our views on why this has happened, and outlines strategies for minimizing the risks and maximizing the returns from CRM.

Read more about why the current approach to CRM - Customer Relationship Management is marginalizing returns on investment and why you should work with an independent CRM consultant at http://www.mareeba.co.uk

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