SharePoint IRM Issue Opening Documents

Ok, I’m still learning about Windows Rights Management Services (RMS) and SharePoint Information Rights Management (IRM) and the configuration black art that it is … so … precision and accuracy of the solution below is not guaranteed.

Problem
A document library configured with information rights management protection will not display the contents of Office documents after they’re originally created/uploaded.  When you try and open, for example, a Word document from the IRM protected SharePoint library all you see is this:

image

Solution
SharePoint IRM and Windows RMS require that the user’s email address be present for both the user account (AD account or local account) AND for the user’s SharePoint profile.

The reason why the email attribute is so important goes something like this: RMS uses the email address to uniquely identify each user and the first time a user tries to protect content, RMS will provision a client certificate from the RMS server.  So, I guess this infers that without the email attribute, RMS can’t get a certificate for the user and, therefore, doesn’t know if the user can legitimately see the document and, therefore, does not show the document just in case?  Make sense?

Anyway, I had seen/heard somewhere that the email attribute must be present for the user’s Active Directory account.  So, I ensured that my test user had an AD email attribute.  But things still didn’t work (i.e. blank documents as above).  Then, on a call with Microsoft Product Support, we were told that when using SharePoint Information Rights Management (which uses RMS), the user’s SharePoint profile must also have an email address for the “Work  e-mail” attribute as shown here:

image

After ensuring this e-mail attribute was set then, voila, things started working with IRM protected SharePoint document libraries.  If your environment is using Active Directory and the user’s AD “E-mail” attributes contain email addresses, then using SharePoint profile import will automatically import the email addresses for the SharePoint user profiles.

Technorati Logo , , ,

McKinsey Quarterly Offshoring Rethink

… one company, based in Paris, used [macro and micro level offshoring diversification] to its advantage… The company was looking to offshore 2,000 specialized, high-end IT jobs and initially planned on sourcing the entire project in India. It opted for an alternative scenario, however, after running the numbers as part of its due diligence. With a view to minimizing its exposure to geographic, currency, and labor issues, the company tiered the work across several locations, placing roughly two-thirds of the project in India and splitting the remaining third across three other regions. It kept 100 jobs in Lille, France, and nearshored 300 more in low-cost Romania, because of the proximity of these locations to European markets. A further 300 were placed in Egypt, where government programs have substantially broadened the talent base. The company then housed the remaining 1,300 roles in Bangalore. By diversifying in this way, the company significantly lowered its overall portfolio risk while incurring only marginally higher costs than it would have under the all-India approach.

Wow!  Such a diversified offshoring model begs lots of questions about the details of the Paris company’s project, products, services, IT roles being outsourced, how it “ran the numbers” as part of its due diligence, etc.  Anyone happen to know the details?  What degree of collaboration (communication, coordination, etc) is required between all those offshore/outsourced centres and the client company in Paris?  Have they fully taken into account all the hidden costs of offshoring?  I would be very surprised if they did not factor in the hidden costs as part of their due diligence exercise.  It’s hard to believe that such a diversified offshoring model could yield the right balance of cost savings and quality.

That excerpt is from McKinsey Quarterly’s recent publication called “Rethinking the model for offshoring services”.  (If you’re on Facebook and become a Fan of the McKinsey Quarterly page your should be able to find and access the full publication … otherwise you will need a premium membership to read the full article from the McKinsey site).

The McKinsey publication makes the case that offshore providers should diversify at both the macro level (geographic … outside of the standard offshoring locations such as India) and micro level (expansion of range of work performed in any one offshore centre) in order to mitigate risk, obtain better cost certainty, and to foster better coordination, flexibility, and responsiveness.  They liken it to the portfolio diversification approach taken by financial managers to manage investment risk.

Sure, diversification as a means to manage risk makes a lot of sense for all kinds of things, but the valuation of a multi-geographic, multi-language, multi-time zone offshoring model obviously needs to account for much more than the valuation of a portfolio of financial instruments.  I sense that the same valuation mistakes will be made as when outsourcing first became popular.  That is not factoring everything into the valuation and thereby overvaluing the diversified offshoring model (especially for offshored software development services).  The publication does make mention of some factors that can diminish the value of offshoring but does not go into a deeper analysis:

Qualitative factors—such as time zone, the suitability of the local skill base, the region’s proximity to key customers, and the existence of government initiatives—also play an important role. Although Eastern European countries are more expensive, for example, they bring strong specialist talent, the requisite language skills, and excellent infrastructures; these factors may often compensate for the higher cost.

Technorati Logo , ,

ZoomIt Damn It!

ZoomIt is a fantastic little zoom tool from Windows Sysinternals that I regularly use to ensure my audience can clearly see the areas of my demo screens that I’m discussing.  When adeptly used, ZoomIt can add a lot of professional polish to your software demos and help retain your audience’s attention.  I’m constantly amazed at how many people do not use such a tool to present their demos and lose their audience’s focus by presenting busy, hard to see, screens.  Smart people, good presenters, good material, lots of effort put into building the demo, then they apologize for the screen being hard to see.  Come on!  Zoom tools have been around for a while and yet I rarely see them used; I would say less than 10% of the many software demo presentations I’ve attended.

If you present software demos, use ZoomIt or risk having your audience fall asleep, leave, talk, do email, play with their iPhone which they’ll be doing regardless … anything except try to read your demo screen.  It’s easy to become adept at using ZoomIt and it will add professional polish to your demos.

Technorati Logo , ,

An Outsourcing “Mess”

Recently I dealt with a software development company that used an outsourced development model which comprised the following locations:

  • India: Development centres comprising dozens of developers.
  • Canada: Technical management and some development.
  • USA: Data center hosting test and production servers.

My exposure to the company was relatively brief but from what I saw and heard the model was a mess.  It was a mess because:

  • There were software quality issues and inadequate quality metrics.
  • There were network communication latency and availability issues between India and North America.  Acquiring high volumes of software artefacts from India was a time consuming process and there were regular network outages.
  • Language and time zone differences created communication issues between India and Canada.
  • The huge time zone difference sometimes required Canadian personnel to regularly meet during evening hours when Indian personnel were available.

Pretty standard issues that have plagued outsourcing since it became in vogue.

I am sure some of their quality issues can be addressed with the introduction of better practices and tools.   But I bet that a number of quality issues are directly related to the software development being done in a different country, in a radically different time and “language” zone.

I am not suggesting that all software development outsourcing models are subject to quality issues.  And I am not suggesting that a well thought out strategic approach to developing an outsourcing partnership is going to yield a mess.  However, I’ve been “around” outsourcing enough now to know that if the company in question added up all the hidden costs of their outsourced model (related to poor quality, management/translation overhead, communication, etc), they would likely find the costs savings to be either minimal or non existent compared to a “home sourced” model.

A “home sourced” model includes what I see as the very viable rural sourcing approach as provided by companies such as Rural SourcingMonty Hamilton has recently taken over as CEO, and has big plans to increase and improve the company’s presence and profile.  Rural Sourcing’s labor cost is reported to be about $60/hour, around double what it would cost in India but at least half the cost of using a big consultancy.  So, although the “on paper” labor rate is higher than the Indian labor rate, taking the hidden costs of oursourcing into account should make a rural sourced rate of $60/hour very attractive.  Costs are certainly very important but think of the huge advantages of having your development team based in North America and within a reasonable time zone.  It’s especially advantageous when developing business oriented solutions that require extensive collaboration and communication around the team of peers (and I’m including team leads and management as well in the term “peers”!).  Of course, that comparison will be changing as the Indian market changes to address the current economic conditions and what I’m seeing as an ever increasing propensity by businesses to either not outsource, or to “backshore” their tech shops.

Back to the company in question that’s got itself in an outsourcing “mess”.  I would love to be involved in building the business case to move that company from an Indian based development centre to a rural sourced presence somewhere in North America.  I think it would be a slam dunk win for backshoring.

Technorati Logo , ,

0.0.0.0 Default Gateway

You’re having trouble connecting to the internet from your Windows Server (or Vista as I’ve read elsewhere).  You ping an internet site and see the IP address but receive “destination host unreachable”. You go to the command prompt and type “ipconfig /all” to investigate your IP settings.  You see that the default gateway is set to “0.0.0.0” as the first default gateway IP address.  Doesn’t look right, of course.  You check the IP settings and don’t see “0.0.0.0” specified as a default gateway.  What to do?  This is what I did to resolve the problem for my Windows Server 2008 machine:

  1. Open a command prompt.
  2. Type “route delete 0.0.0.0”.
  3. Configure the IP settings to add back your correct default gateway IP address.

That did the trick.

Technorati Logo , , , , ,



Bad Behavior has blocked 79 access attempts in the last 7 days.