Sunday, August 30, 2009

Progress Bar in Sharepoint Task List

My client makes use of most of the out of box features that are available with Sharepoint, many of the company managers frequently make use of the out of box sharepoint task list for resource assignment, tracking etc. Recently one of the group managers asked me if it is possible to create a visual indicator of the task, meaning he wanted a visual progress bar for the status of each task. After researching on the subject I discovered that Bamboo solution have a product for this need and can meet what exactly he was looking for. It would have done what we expected but the product does not seems to be more customizable so I started to look for doing this myself with some customization efforts.

I was able to do this using little html knowledge and a great javascript available from the pathtosharepoint website. Below are the steps that I did to achieve this.



1. Created a calculated column called "Progress Bar" and "Progress Bar 2" and then added the following formulas to each of the columns.

- Progress Bar:

=”<DIV style=’background-color:blue; width:”&([% Complete]*100)&”%;’>&nbsp;</DIV>”



- Progress Bar 2:

=”<DIV style=’background-color:red;’><DIV style=’background-color:LimeGreen; width:”&([% Complete]*100)&”%;’>&nbsp;</DIV></DIV>”



2. I downloaded a script from the pathtosharepoint site, added it to an content editor webpart on the same page as my task list. To download the code please click here

3.Once the content editor webpart is saved, you will see that the progress bar will start to show up in the columns Progress Bar and Progress Bar 2 as I have shown in the screen image above.

I also recommend my blog readers to visit http://pathtosharepoint.com , the author has really put great efforts to build and present some of the cool sharepoint custom components that are very useful in today's custom needs for Sharepoint.

I have always enjoyed working with sharepoint customizations and I am hoping that my research and these small tips help someone in Sharepoint development world.

Keep watching this space for more sharepoint development tips. Cheers to Sharepoint !!!

Saturday, August 29, 2009

Is Box.net better than Sharepoint 2010 ?

Box.net claims that it is a better collaborative tool than Sharepoint or even better than the upcoming Sharepoint version Twenty Ten. Video below talks in detail what the product offers and how it is better product for collabration compared to Sharepoint.

Friday, August 21, 2009

How to hide view selector in list view webpart ?

I am working on an initiative where I have to present multiple views of a sharepoint list, these views have sensitive information in certain columns that cannot be shared among other views of the same list. Here the idea is create unique views for each group of users with their sensitive columns and then not allowing the users to switch to each others view, point to note is all of these views are public views.

I was scratching my head figuring out a solution to restrict the view selection from pages that are generated for each views. My theory was there has to be a way to handle the view selector ?? I opened sharepoint designer to see if I can figure this out. I opened one of the existing view page for a list (AllItems.aspx) and then was looking for some kind of view selector control in the list webpart that was displayed. It took me few hours to figure out that only converting the list view webpart to the XSLT dataview will generate a selector control in the XSLT code, something like the line of code below.

<sharepoint:viewselectormenu runat="server" visible="false"”> </sharepoint:viewselectormenu”>


The line of code is the view selector control that is responsible to cause the switch, I simply added the visible attribute setting it to false to make the control unswitchable.

Other way would be to completely get rid of the control to give a clean user experience. It took few hours for me figure this out, but I am hoping this will help somebody do this quickly in this amazing world of sharepoint.

Thursday, August 13, 2009

NY Times article on Sharepoint

Microsoft’s SharePoint Thrives in the Recession

By Ashlee Vance

Hang around at Microsoft’s Redmond, Wash., headquarters for five or ten minutes and someone dressed in khaki pants and a blue shirt is bound to tell you about the wonders of SharePoint — one of the company’s most successful and increasingly controversial lines of software. Think of SharePoint as the jack-of-all-trades in the business software realm. Companies use it to create Web sites and then manage content for those sites. It can help workers collaborate on projects and documents. And it has a variety of corporate search and business intelligence tools too.


Microsoft wraps all of this software up into a package and sells the bundle at a reasonable price. In fact, the total cost of the bundle often comes in below what specialist companies would charge for a single application in, say, the business intelligence or corporate search fields. It can’t do everything. Executives at Microsoft will readily admit that the bits and pieces of SharePoint lack the more sophisticated features found in products from specialist software makers.


“We don’t claim we do everything,” said Chris Capossela, a senior vice president at Microsoft. “If we do 50 percent of the functions that these other companies do, but they’re the ones customers really want, that’s fine. The magic is that end users actually like to use the software.”
This strategy seems to have worked even during the recession.


While Microsoft’s Windows sales fell for the first time in history this year, its SharePoint sales have gone up. Microsoft declines to break out the exact sales figures for the software but said that SharePoint broke the $1 billion revenue mark last year and continued to rise past that total this year, making it the hottest selling server-side product ever for the company. Companies like Ferrari, Starbucks and Viacom have used SharePoint to create their public-facing Web sites and for various other tasks. All told, more than 17,000 customers use SharePoint.


In many ways, SharePoint mimics the strategy Microsoft took with Office by linking together numerous applications into a single unit. This approach appeals to customers looking to save money and also represents a real threat to a variety of business software makers. Many of these specialists like Cognos, a business intelligence software maker, and Documentum, a content management software maker, have been gobbled up by larger players looking to create their own suites. I.B.M., for example, bought Cognos, while EMC bought Documentum. Other companies like Autonomy, a maker of top-of-the-line corporate search software, remain independent.


Crucially, Microsoft has found a way to create ties between SharePoint and its more traditional products like Office and Exchange. Companies can tweak Office documents through SharePoint and receive information like whether a worker is online or not through tools in Exchange. These links have Microsoft carrying along its old-line software as it builds a more Internet-focused software line.


“SharePoint is saving Microsoft’s Office business even as it paves the way for a new era of Microsoft lock-in,” said Matt Asay, an executive at Alfresco, which makes an open-source content management system. “It is simultaneously the most interesting and dangerous Microsoft technology, and has largely caught its competitors napping.” Along these lines, Steve Ballmer, Microsoft’s chief executive, has talked about SharePoint as the company’s next big operating system.


Microsoft has managed to undercut even the panoply of open-source companies playing in the business software market by giving away a free basic license to SharePoint if they already have Windows Server. “It’s a brilliant strategy that mimics open source in its viral, free distribution, but transcends open source in its ability to lock customers into a complete, not-free-at-all Microsoft stack - one for which they’ll pay more and more the deeper they get into SharePoint,” Mr. Asay said.


A number of smaller software companies have been eager to piggyback on SharePoint’s success. Based in San Diego , Sharepoint360 provides consulting services and software development help around the product. The company started after employees at a construction company built some Sharepoint applications and decided to market the software to other construction firms. The start-up has help ed construction companies create systems for managing projects, allowing various people to check-in on the progress of a building and keep track of documents tied to the site. It has also expanded beyond the construction area doing work for NASA, Nestle and Toshiba, according to Paul West, a co-founder of SharePoint360.


The company offers to host SharePoint applications for customers. Microsoft too wants to host more software for companies as it moves toward the cloud computing model. Mr. West recognizes that Microsoft may begin stepping on its partners’ toes. “It may certainly come to pass that they pull the switch,” he said. “That would have implications for us.” In the meantime, however, Microsoft subsidizes training courses and consulting work for companies like Sharepoint360.


Next year, Microsoft plans to release a new version of the software packed full of more advanced features, including stronger ties to the corporate search technology it acquired in the $1.2 billion purchase of Fast Search and Transfer, a Norwegian start-up. Best Buy uses the Fast technology today to provide on-the-fly pricing information to customers performing product searches on its Web site.


By making these more sophisticated tools available to customers, Microsoft thinks it can keep pushing niche software makers out of the way and give business people, rather than just the tech folks, a way to work with business applications.

“We believe customers can turn off some of these point solutions,” said Kirk Koenigsbauer, a general manager in Microsoft’s business software group. “With SharePoint, we can deliver a very, very approachable application to end users.”

Saturday, August 1, 2009

Top Sharepoint sites around the world

While going through Ian Morish's WSS demo site happen to go through some of the best looking internet sites hosted around the world, Ian's website below gives a wonderful preview of these websites.

http://www.wssdemo.com/Pages/topwebsites.aspx

I am simply amazed not to see these sites built with sharepoint but the core value that sharepoint is bringing to these websites in terms of Content Management, Enterprise integration etc. Thats why I always say SharepointAge Rocks !!!! I have been a follower of Microsoft since inception of dotnet 1.0 and have lot of faith that they are going to change the shape of technology with these cool platforms ..... happen to look at bing search looks very promising.