[SharePoint 2007] Update SharePoint Document Property from Excel VBA

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint 2007 to manage and keep track of these documents. You would like values from your worksheet to populate SharePoint properties in the document library. For instance, you would [...]

[SharePoint 2007] Remove Commas From Number Column Workaround

I thought this article was a brilliant workaround and wanted to share. It was original posted over at: http://sharenotes.wordpress.com/2010/05/11/workaround-format-sharepoint-number-column-to-remove-commas/ Let’s say you have a column named “TicketNumber” of number type in your list. By default SharePoint formats it to show with commas. If your requirement is not to show those comma’s then here is a [...]

[SharePoint 2007] Immediate Alerts Console Application

For SharePoint 2007 I had a need to write a console application that fires the Immediate Alerts timer job manually. The Immediate Alerts timer job executes every 5 minutes by default to send out the email alerts setup by users in SharePoint. For most cases, simply changing the interval of the timer service with stsadm [...]

iPhone AI Illustrator Sketch GUI Elements

Teehan+Lax have posted another useful mock up toolset. This time they have created an Adobe Illustrator file with sketch versions of the iPhone interface. Great for storyboarding and creating instructional material for applications. http://www.teehanlax.com/blog/2010/05/17/iphone-sketch-elements-ai/ iPhone_Sketch_Elements_v1.zip

ASP.NET Proxy Page – Used for Cross Domain Requests from AJAX and JavaScript

One of the pain points with developing AJAX, JavaScript, JQuery, and other client-side behaviors is that JavaScript doesn’t allow for cross domain request for pulling content. For example, JavaScript code on www.sharepointjohn.com could not pull content or data from www.bing.com. One way to overcome this issue is by using a server-side proxy on the site [...]