Querying SharePoint List Items using jQuery

Very good article by Jan Tielen about using jQuery in Sharepoint. He uses a web content editor webpart in conjunction with jQuery to load Tasks from Task list. This example queries list webservices from client side and loads task in a unordered list. Easy to use code, sort of plug-in play!

Sharepoint Resources

Tools

• STSAdm Win 2007 - Windows GUI for STSAdm
• STSDev - Sharepoint Solution Generator
• CAML Query Builder - Very good tool when working with Sharepoint webservices
• SmartPart - Webpart to host asp.net usercontrol
  

Documentation/Tutorial

• MSDN Sharepoint WSS 3.0
  

Sharepoint WSS/MOSS CSS Reference

Very good CSS reference at HeatherSolomon.com. Very helpful when you need to use Sharepoint CSS to match with your piece of UI. It shows examples with each selector or class and there is button to copy the css to easily copy in clipboard.

Add icons to your file extensions in WSS 3.0

By default there is no icon for PDF. In order to add one, modification is required in DOCICON.XML in 12 Hive XML folder. Following steps I got from a blog which is located at

Link: http://servergrrl.blogspot.com/2008/02/adding-pdf-icons-to-wss-30-and-what.html

Quote:

Steps
1). Download the icon file from adobe (or whereever, some people have better ones). Make sure it's small (the default from adobe is 17x17). http://www.adobe.com/misc/linking.html#pdficon

2). Save the icon to the c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\IMAGES folder. I renamed it "icpdf.gif" myself, just so it matches the format of all the other doc icon files used in the DOCICON.XML.

3). Open the DOCICON.XML file in notepad (the DOCICON.XML file is located in the c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\XML folder).

4). Once in the DOCICON.XML file, go to the "" section (see figure above) and add the tag: ""(minus the quotes, they're just there to tell you what you are supposed to type-- again, blogger hates it when you add non- html tags)

The tag means that the icon "icpdf.gif" (or whatever you named your pdf icon file) will be mapped to the .pdf extension. I do not have an open control (like using Word to edit a doc file) for pdfs, so I left it blank between the quotes.

5). Save the file, then drop to a command prompt and do an IISRESET. This should let sharepoint know there has been a change and repopulate the pages with new icons appropriately.

IISReset is required after all the above

Modifying the width & height of a Sharepoint Page Viewer web part dynamically

Issue:
By default Page viewer web part doesn't allow you to have height expand dynamically. It expects a unit for the height. This small javascript I got from GuiCreate.com does a great job. Basically this script needs to be copied into the page which needs to be displayed in the web part.

JavaScript code:

function resizeMe(that) {
window.resizeTo(document.body.scrollWidth, document.body.scrollHeight);
}
window.attachEvent("onload", function() {
window.setTimeout("resizeMe()", 100);
});

Link: http://www.guicreative.com/blog/sharepoint-2007/modifying-the-width-height-of-a-sharepoint-page-viewer-web-part-dynamically/

WSS Sharepoint Search - no results

In order to turn search ON in WSS 3.0, There two steps

1). Under Operations > Services on Server setup Windows Sharepoint Search Service. Use a domain account when setting this up. If service is already running then skip Step 1 but make sure its properly setup.

2). Under Application Management > Content Databases, click on your content database and then on the page make sure Search Server is selected.

After the above two steps, wait few minutes so Sharepoint crawls your site collection. WSS only lets you search a single site collection. Anything you search under a sub site will give you result at the site collection level.

Sharepoint Developer Videos - Kirk Evans Blog

Free tutorial videos for Sharepoint geared towards developers.

Link: http://blogs.msdn.com/kaevans/archive/2009/03/15/point8020-com.aspx

Rename Sharepoint WSS 3.0 /MOSS 2007 Machine

Very good steps to perform a machine name change. Look at the comments of the post if you encounter any issues.

Link: http://www.raoulpop.com/2007/how-to-rename-a-wss-30-server/

Response.End and download file problem using asp.net code inside sharepoint

Issue:

To download file from Sharepoint doesn’t work but works fine in plain asp.net environment.

Solution:

Solution is very simple, Add the following code for the button or link which initiates the download:

MyButton.OnClientClick = "document.getElementById(""" & Me.Page.Form.ClientID & """).onsubmit = function() {return true;}"

Link: http://social.msdn.microsoft.com/forums/en-US/sharepointdevelopment/thread/107b2c17-07fe-4a15-ad81-dcb31e1e9c84

SPTraceView - Lightweight Tool for Monitoring the SharePoint Diagnostic Logging in Real-Time

Very small application, only 65kb zip, great tool for SharePoint diagnostic tracing

Quote:

SPTraceView moniors in real time all SharePoint diagnostic tracing (also called ULS tracing) and can notify you using a balloon-style messages in the tray bar when any information of particular interest to you is sent (traced) by any of the MOSS services and components.

Link: http://hristopavlov.wordpress.com/2008/06/19/sptraceview-lightweight-tool-for-monitoring-the-sharepoint-diagnostic-logging-in-real-time/

SharePoint Object Browser

Code project article for Sharepoint object browser. It comes very handy when doing programming with sharepoint.

Link:

http://www.codeproject.com/KB/sharepoint/sharepoint_object_browser.aspx

Import/Export Sharepoint site

Recently we had to transfer a site from one sharepoint site to a different domain. Sharepoint does give you ability to export site/list templates but it has a limit of 10MB. There are ways to increase the limit through stsadm.exe (max 500MB) but if the file gets too big for export then it doesn't work.

Found this very good and short post which does it without any problems. It uses stsadm to import/export.

Quote:

* stsadm.exe -o export -url http://intranet/test -includeusersecurity -nofilecompression -filename C:\backup

Once you finish your export use the stsadm import command with the same nofilecompression attribute. For example:

* stsadm.exe -o import -url http://intranet/test -includeusersecurity -nofilecompression -filename C:\backup

Link:

http://ragavj.blogspot.com/2008/02/failure-decompressing-data-from-cabinet.html