Sunday, November 9, 2008

Export spread sheet option in MOSS 2007

Hi all,
Last week i had a small requirement in my project, where i need to enable "Export spread sheet" to Sharepoint Viewers group(Usually users in Viewers group will not have access to use "Export to spread sheet" option) of the sharepoint site.
To accomplish this, I have decided to create a simple web part page where in i will drag and drop the list in the web part page and add another Content Editor Web part.
Now, Modify the content editor webpart to create the html link with the following url.

http://servername/Sitename/([Subsitename]/)_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=[ListGUID]&View=[ViewGUID]&CacheControl=1

Save the changes, your job is done :-)

WSS/MOSS + There are no products affected by this package installed on this system

Hey guys,
If any of you recieve an error "There are no products affected by this package installed on this system" while installing MOSS/WSS updates. Make sure you have downloaded the appropriate windows version update from Microsoft site.
Eg: I was getting the error "There are no products affected by this package installed on this system" when I tried to install wssv3sp1-kb936988-x64-fullfile-en-us.exe, instead i have to download and install wssv3sp1-kb936988-x86-fullfile-en-us.exe for my system configuration..
Hope this helps
Happy programming :-)

Monday, October 27, 2008

Ready->Study-Go

Hi all,
This is the first blog of my life. I was inspired to blog from some of my colleagues and online friends, especially i am very much motivated by Shahil Malik's blog on sharepoint technical reference. I will try to post as much technical references related to sharepoint in the near future. Your comments and feedbacks are always welcome :-)