Back to Work…

I’ve been off in Costa Rica sunning and exploring for a few weeks, but now I’m back and it’s time to get back to work!

The first thing I wanted to post about is a new blog you might want to check out.  My partner in crime Sympraxis Consulting has, after a little urging, started his own blog at  Pete’s a much better writer than I, so if you watch his blog, I’m certain that you’ll not only learn a few things, but also enjoy the experience.  Pete’s first set of posts is about Adventures in SharePoint Forms Based Authentication.  If you read through these four posts, you should have a good understanding of the basics of FBA.


iPhone and Exchange Synchronization Problems – Maybe a Solution?

In a previous post, I talked about the problems that I was having getting emails on my iPhone when I was getting SharePoint alerts.  I still haven’t figured out the issue, but here’s something I’m trying to solve it.

My Exchange hosting provider recently pointed out that I had exceeded my quota, so I went on a search and destroy mission.  I noticed that I had about 18Mb of stuff in the sync error folders in Outlook.  I decided to run ScanOST (located in C:Program FilesMicrosoft OfficeOffice12 if you are running Office 2007, and probably an analogous location with previous versions) to clear this stuff out and resolve the issues.

I’m not sure if this will solve my sync errors with my iPhone, but I’m sure that it can’t hurt, and this will also clear up any sync issues for me.  My iPhone is in Boston and I’m in Costa Rica, so I’ll have to report back on the effectiveness of this idea later.

UPDATE 2009-04-02: Alas, no joy in Mudville on this.

UPDATE 2009-07-31: It occurred to me today that this hasn’t happened in a while.  Maybe the 3.0 OS upgrade fixed it, but I can’t say for sure.

SharePoint Web Services as Data Sources for DVWPs

In most cases, you won’t need to use them, but SharePoint exposes much through Web Services which can be used in DVWPs as Data Sources.  The nice thing about the Web Services is that they let you get at things *about* site contents as well as the contents themselves.  In other words, the meta-meta information.  For instance, you might want to know what values are available in a Choice column, and the Lists Web Service will allow you to get at that information.

The full set of available Web Services is available in the Office SharePoint Server 2007 SDK.  The contents of the SDK are also online at MSDN.  Here’s the quick list of available Windows SharePoint Services 3.0 Web Services as links into MSDN:

Administration Web Service
Alerts Web Service
Authentication Web Service
Copy Web Service
Document Workspace Web Service
Forms Web Service
Imaging Web Service
List Data Retrieval Web Service
Lists Web Service
Meetings Web Service
People Web Service
Permissions Web Service
SharePoint Directory Management Web Service
Site Data Web Service
Sites Web Service
Search Web Service
Users and Groups Web Service
Versions Web Service
Views Web Service
Web Part Pages Web Service
Webs Web Service
Some additional Web Services are exposed by MOSS, and the superset of Web Services adds the following:
BDC Fields Resolver Web service /_vti_bin/bdcfieldsresolver.asmx BDC Fields Resolver Web service for client applications. Reserved for internal use only.
BDC Web service /_vti_bin/businessdatacatalog.asmx Business Data Catalog metadata Web service. Reserved for internal use only.
CMS Content Area Toolbox Info Web service /_vti_bin/contentAreaToolboxService.asmx Designed for use by the Microsoft Office SharePoint Designer client to use.
Excel Services Web service /_vti_bin/ExcelService.asmx Provides methods to call Excel Services remotely or to work as a callback for Web Parts.
Forms Services proxy Web service /_vti_bin/FormsServiceProxy.asmx Provides methods for Forms Services to proxy requests to remote data sources from Web-based forms.
Forms Services Web service /_vti_bin/FormsServices.asmx Provides methods to call Forms Services remotely or to work as a callback for Web-based forms.
Official File Web service /_vti_bin/officialfile.asmx Provides methods for sending files to a records repository.
Published Links Web service /_vti_bin/publishedlinksservice.asmx Office system client applications and other applications can obtain the list of published links on the server that are targeted to the current user.
Publishing Service Web service /_vti_bin/PublishingService.asmx Provides methods to remotely work with the publishing service.
Slide Library Web service /_vti_bin/SlideLibrary.asmx Provides methods for slide library callbacks or remote publishing of slides.
Search Crawl Web service /_vti_bin/spscrawl.asmx Provides methods for remote Office SharePoint Server 2007 server farms to crawl a local farm.
User Profile Change Web service /_vti_bin/userprofilechangeservice.asmx Provides methods to query the user profiles change log remotely.
User Profile Web service /_vti_bin/userprofileservice.asmx Provides a user profile interface for remote clients.
Workflow Web service /_vti_bin/workflow.asmx Provides methods to work with workflows.

The SharePoint Central Administration Web application provides Web services in the _vti_adm directory that map to the following file system location:

%COMMONPROGRAMFILES%\Microsoft Shared\web server extensions\12\ADMISAPI

The following Web services are exposed within the Central Administration Web application. For reasons of helping to ensure security, these Web services are not available to call remotely from custom code in a hosted environment.

Admin –  /_vti_adm/admin.asmx
Provides methods for managing a deployment of Windows SharePoint Services, such as for creating or deleting sites.
Content Deployment Remote Import – /_vti_adm/ContentDeploymentRemoteImport.asmx
Provides methods for a remote server farm to use content deployment to get content into a local farm.

Depending on configuration, the Office Server Web Services Web application exposes the following internal Web services, which are not available for calls from custom code.

Search Web service –  SearchAdmin.asmx
Office SharePoint Server 2007 Search Administration Web service.
Search Application Web service – /SSP/Search/SearchAdmin.asmx
Office SharePoint Server 2007 Search Application Administration Web service.
Excel Service SOAP – /SSP/ExcelCalculationServer/ExcelService.asmx
Office SharePoint Server 2007 Excel Services Application Web service.

SharePoint Saturday Boston Presentation

Today’s SharePoint Saturday here in Boston (Microsoft’s office in Waltham, actually) was a great success by my measure.  I’m not sure how many people were there, but every session I went to was packed, the crowd was truly engaged, and the discussions were rich.

Thanks to all who came to my session: Developing with SharePoint Designer – The Middle Tier, Focus on Data View Web Parts (DVWPs).  I’ve posted my presentation at the preceding link; let me know if you have any problems accessing it.  I appreciated all of the questions in my session.  I always find it gratifying when there is a good, lively dialog.  If I didn’t get to your questions or if anything occurred to you later in the day or since, don’t hesitate to post a comment to this post or drop me an email at marc.anderson [at]

One thing that I didn’t get to because I ran out of time was to show the A. W. Chesterton site.  This is a site that I did a lot of work on, from the branding, to the layout, to the DVWPs.  If you drill into the products, every page is made up of DVWPs, and that includes the Quick Launch and breadcrumbs (note how they don’t behave “normally”).  All of the content is coming from lists.  Also note the language selector at the top of the page on the global links.  This site contains all of the bits and pieces that I talked about in my session, and of course a lot more.  It’s still a work in progress (as most sites ought to be!), so you may see some things that don’t look quite right.  If you do, please let me know.

Thanks also to all of the organizers.  Organizing events like this are a challenge I know that I couldn’t undertake successfully, and everything was arranged well and went off without a hitch.  Cheers to the gangs from SharePoint Saturday and the the International SharePoint Professionals Association (“ISPA”) as well as all of the sponsors and other speakers!