My APPL vs MSFT discourse

*Not really SharePoint related*

I got sooo into a Google Finance MSFT discussion that I just spent the last 2 hours typing (was watching Donny Deutsch’s The Big Idea @ the same time – must see TV) my response below…

Apparently most people here don’t understand the foundation and far-reaching effects of Microsoft’s enterprise software. Businesses large and small are greatly investing in information technology for information workers – which are primarily the results of either Microsoft produced or partner developed/enhanced software. There is also great growth in Microsoft based server products particularly SharePoint technologies (totally understated sleeper – fastest growing product family of all time for all of Microsoft’s products).

Given that the Office suite is a business staple, as web based collaboration (SharePoint) technologies continue to grow, businesses will have no choice but to keep their Office clients up to date in order to be able to take advantage of new features – technology based competitive advantage. Derivatives of this trend include the systems/products that are required to support them. These are Windows based servers and SQL databases. And need I mention the proliferation of Exchange + the emergence and continued growth of Unified Communications?

Currently, I don’t even think Microsoft has competition in the business world until CIO/CTOs really think switching to something like OpenOffice is a good idea. I don’t see this happening anytime in the near future. Who doesn’t use Microsoft Outlook at work? Can you imagine any financial analyst using anything other than Microsoft Excel?

Now let’s assume there’s a rogue Executive out there that mandates a non-Microsoft productivity suite for there business. Unfortunately, they will not be as competitive in their respective industries just by the fact that their employees will be wasting an unsurmountable of productivity trying to make their documents compatible with business partners.

Well what about custom software you ask? Guess what jobs are paying the big bucks? Say hello to Microsoft based .NET technologies. This isn’t exactly my area of expertise but I believe the speed and ease of which custom solutions can be built on top existing Microsoft platforms is another driver for enterprise growth.

And what about web-based technologies? That’s a mixed bag right now. But the next time you visit your favorite websites, take a peek at the page extensions. If they end in asp or aspx, chances are they are being served by Microsoft based servers.

As far as the Apple vs Microsoft debate goes, Apple is purely a consumer product and is completely being driven by hype. This hype is driven by the perceived ease of entrance into technology for your everyday mom,pop,non-techies that only needs to browse the web. Notice that I am not mentioning design folks as they have generally always been Apple users. The recent growth has really been from people that are buying Apple products for the ‘cool’ factor believe it or not. I really believe the root cause of their growth is not because of OS X, but because of their innovative and aesthetically pleasing hardware design. The operating system is almost a second thought to most average Joe/Jane consumers – hence, this is why everyone seems to ask what they need on their Macs to run Windows. So as long as Apple can continue to deliver ‘cool’ consumer products, I don’t see any growth hindrances.

But I do see possible threats to both Microsoft and Apple personal computers coming in the form of virtualization and VMWare, hence Mircosoft’s recent public pushes in this territory for their own hypervisor.

So in conclusion, Microsoft and Apple are competitors, but they are really competing in two really different universes. Microsoft’s ecosystem of products and presence in business productivity is just too great for any other vendor to throughly penetrate and overtake them in market share. Luckily for Apple, that leaves room in the consumer world for them conquer as they are.

Disclaimer: I have 30 shares of AAPL and Zero shares of MSFT. I believe in the hype.

How to move/migrate SharePoint list items/documents and preserve metadata properties at the same time

I think it’s been pretty common knowledge that you can open up a Document Library in Windows Explorer view to move mass documents to other folders or libraries. But there’s a drawback to that method because the document’s properties get updated in the process – mainly the modified date/time as well as the user would take on the role of the person that ‘Last modified’ the document. This also applies to copying list data in data sheet view from one list to another.

Some have figured out a different way where you can save the current list or Document Library as a template with content included and redeploying that to other locations. Unfortunately this method will also overwrite the last modified timestamps and also the ‘Created by’ property with the time that the list was recreated and by the person that created it, respectively.

So if you want to move the contents of a SharePoint Document Library or List and be able to preserve the item’s metadata/property values at the same time you should use this method:

1. Create a blank destination List or Document Library. You don’t have to worry about recreating custom fields and whatnot. The move process will do this for you.

2. Go to the ‘Site Content and Structure’ page. You can access this site with either Site Actions > Site Settings or http://portal/_Layouts/sitemanager.aspx

3. Navigate to your source List or Document Library and mark all the items that you would like to have moved. Then click on Actions > Move…

4. You’ll then be prompted with a pop-up that will let you navigate to your destination List or Document Library. After you find that, just press the OK button and you’ll be good to go!

So by using this method, you’ll be able to preserve all of the document properties/metadata while moving list items or documents from one location to another!

Whoa! WordPress supports publishing from Word 2007!

Just found this out and thought this was pretty spiffy. Word 2007 lets you publish blogs to WordPress and a bunch of other blog servers too! This totally rocks for being able to easily cut and paste screenshots and then have Word publish everything in one shot. Kudos to Microsoft.

010808-0521-whoawordpre1.png

Custom SharePoint Designer Subject Lines with Calculated Fields

A way long time ago (back in October) I was working on building workflows with SharePoint Designer 2007 but for the life of me couldn’t figure out how to make custom Subject lines. Out of the box SharePoint Designer will only let you select one workflow variable or one field from the current item to display in the Email Subject. It will not let you build dynamic strings with multiple values. So I was digging around for a while and Paul Galvin
gave me a hint about using a workflow variable to build the string and then plugging that variable into the Subject line. That worked great. So I was thinking hmmโ€ฆ how about calculated fieldsโ€ฆ And guess what? That works too! So here are your 2 options:

  1. Define a String Variable in SharePoint Designer:

     

    OR

     

  2. Use a Calculated Field to store a string with item information:

     

So which way is better? I think it depends on whether or not you want to make that field viewable by your users or not. Variables stay hidden in the workflow data while Calculated Fields will be part of the item and can view viewed. What do you think?

Dave Chenault Rocks

Yeah I know, I told myself I was going to stop blogging for the rest of the year but I just had to get this out. Dave Chenault from DynTek is an awesome SharePoint speaker/presenter. I’m not only saying this because they and Microsoft treated about 50 people to lunch at Morton’s but he really knows how to present SharePoint. He’s great at getting to the point with his demos as well as being able to cleanly recap and transition important take aways without being too repetitive. Perfect for C-level executives and non-techies. I always walk away from his talks with some new presentation skills.

Dave also hosts a SharePoint User Group in Orange County, Ca about once a month in case anyone’s interested. Cheers!

Going on a SharePoint blogging hiatus for a few more weeks.

I’ve been on overdrive probably for the last 8 months or so and I’d life to start the upcoming new year re-energized so I’m going to go on a SharePoint blogging hiatus. In the meantime you can check out my new personal blog! ๐Ÿ™‚

How to change the permissions for hundreds of thousands of files and sub-folders (file shares)

I recently had a client decide to take the route of putting martial law on their file shares in order to force SharePoint adoption for document storage and management. So in case you’re ever asked to do the same, here’s an easy way to change the permissions on all the files and folders of a network drive:

Use CACLS! (It’s a command line thing)

DevConnections Recap & Other Observations

DevConnections Las Vegas has come and gone again. I was there for you guessed it, the SharePoint tracks and all in all it was a pretty good experience. Always good to see broken demos and speakers breaking a sweat…

<rant> damnit, had this post all typed out in wordpress, spent an hour on it then my browser crashes and this is where it left me off. *waving fist @ IE7* here’s the short version…</rant>

Speakers were awesome and better than last year. The sessions I most enjoyed:

  • Eray Chou from Microsoft on Building Composite Apps with SharePoint Designer
  • Dustin Miller on SharePoint Designer and the Data View Web Part

It was awesome meeting other SharePointers that I’ve spoken to online but had never met in person. Most notably SharePoint MVP Bob Fox. Bumped into him at the end of one of the sessions. He didn’t recognize me at first but when I introduced myself he proceeded to shake me violently with both hands while exclaiming “Heeeyyy buddddyy!” Great guy :). If you’re ever at a SharePoint conference you can’t miss him, he’s easily the tallest guy in the crowd a lot of times. Oh and make sure you ask him lots of dev questions.

MVP Eric Shupps from Binary Wave was also extremely accommodating to some questions I had.

The most interesting session, I think, was actually the closing round table discussions. In comparison, last year was full of hype and hope but this year it was quite an eye-opener to hear about all of the complaints/gripes that was associated with SharePoint (WSS v3, MOSS 2007) since the RTM about a year ago. Given the growth and adoption rate has been phenomenal this year, there is still a universe of improvements that can be made. I’ll leave it at that but here are some of my observations/recommendations:

  • For medium to large business – If you can spare a couple of developers, SharePoint is the best bang for the buck in regards to custom portals, information dashboards, enterprise systems integrations, and enabling developers to quickly create web-based solutions. SharePoint will be the convergence point in which all of your other enterprise systems’ data can be rolled up into a web-base UI. It’s a very powerful development platform where you can knock yourselves out with customizations.
  • For small to medium business – SharePoint out of the box is a great tool for web-based collaboration, searching across data stores, and empowering end users to create their own ad-hoc workspaces. But I would leave at that if you’re not going to have a dedicated resource to managing and/or developing SharePoint. Do not knock yourselves out with customizations.
  • Governance – This was one of those open-ended topics with no real solution but can make or break your SharePoint initiative. This is something that organizations at all levels have to really think about and tailor a policy to their own needs.
  • Partners/Consulting Services – They’re all going hallelujah! High times for them…

So in conclusion, SharePoint is can be a beast. In general, use it for what it’s good at (ad-hoc web-based collaboration) and you’ll be ok. Anything more and you’ll want a dedicated SharePoint Pro.

See you in Vegas for DevConnections/SharePoint Connections!

I’ll be at DevConnections all week – Sunday through Saturday for the SharePoint tracks and staying at the Luxor. Unfortunately I’ll be there without knowing anyone personally so feel free to tap me on the shoulder if you happen to see me wandering around. Heck, you can even send me messages via the comments below or my Facebook or something. I’d hate to have to eat out by myself all week. Always good to make some new friends! ๐Ÿ™‚

How to make MOSS 2007 search results open in new window

I was searching around for information on how I could enhance my SharePoint search results and came across this blog with some tips. The tip about opening links in new windows instead of the same window was a great idea but I couldn’t use the same tips since it was for SPS 2003. I wanted to be able to open links in new windows since I noticed a lot of users often times were searching for say PDF’s and then they would accidentally close the browser instead of hitting the back button. Big annoyance for them.

So I was snooping around the Search Core Results Web Part’s XSL Editor to see if I could edit the XSL to open links in new windows instead. It’s actually pretty easy, here are the steps:

1. Go to http://portal/searchcenter/pages/results.aspx

2. Modify Shared Web Part for the Search Core Results WebPart

3. Click on the XSL Editor Button

4. I’d suggest copying the contents of the pop up into notepad/wordpad to do your editing.

5. Search for the following lines:

<span class=”srch-Icon”>
<a href=”{$url}” id=”{concat(‘CSR_IMG_’,$id)}” title=”{$url}”>

______________________________________________

<span class=”srch-Title”>
<a href=”{$url}” id=”{concat(‘CSR_’,$id)}” title=”{$url}”>

____________________________________________________

<xsl:choose>
<xsl:when test=”$IsThisListScope = ‘True’ and contentclass[. = ‘STS_ListItem_PictureLibrary’] and picturethumbnailurl[. != ”]”>
<div style=”padding-top: 2px; padding-bottom: 2px;”>
<a href=”{$url}” id=”{concat(‘CSR_P’,$id)}” title=”{title}”>

__________________________________________

<span class=”srch-URL”>
<a href=”{$url}” id=”{concat(‘CSR_U_’,$id)}” title=”{$url}” dir=”ltr”>

____________________________________________

6. At the ends of each of the <a href= > tags, you’ll want to add on target=”_blank”

For example to make the link attached to the document icon open in a new window, the full tag would be like this:

<span class=”srch-Icon”>
<a href=”{$url}” id=”{concat(‘CSR_IMG_’,$id)}” title=”{$url}” target=”_blank”>

Using the same XSL Editor you can also manipulate how your search results are displayed and even include custom content types if you wanted to!

Design a site like this with WordPress.com
Get started