How to Get XML Data From a SharePoint List – The Easy Way

September 29, 2009

Ever wanted to view your Sharepoint list as an XML data like me?

I think that you will run into a situation where you want to pull data as an XML format out of your SharePoint list some day, and to be honest i’ve found alot of ways pulling out the data to be viewed as XML.

Here i want to share this simple way to do this using  the great functionality of a file called owssvr.dll. and as a brief on this dll, i can say that the owssvr.dll file serves as the backbone of the SharePoint function. This is because the owssvr.dll file is the module that runs the mechanism for ‘export to spreadsheet and open with access’ options on the list Actions menu of SharePoint

So to get started, Simply format the following string to form the request URL:

http://{yoursite}/_vti_bin/owssvr.dll?Cmd=Display&List={list GUID}&XMLDATA=TRUE

where:

  1. {yoursite} : is the url of your site, which could be the root site of any child site.
  2. {list GUID} : is the GUID of your list.

So as an example of this request URL would be 

http://http://www.microsoft.com/_vti_bin/owssvr.dll?Cmd=Display&List=729ECA77-58B6-4739-9F50-9AE05D1FADAC&XMLDATA=TRUE

And you will get the XML view something like this:

MOSSListtoXML

In addition to viewing a list using the Cmd=Display command in the URL request, you can also return all data for a SharePoint list, but based on a specific view from that list, by adding the &View={ViewGuid} to the URL request, like the following:

http://{yoursite}/_vti_bin/owssvr.dll?Cmd=Display&List={list GUID}&View={ViewGuid}&XMLDATA=TRUE

where: {ViewGuid} : is the GUID of the list view.

The response for a simple view looks like this:

MOSSListViewtoXML

Notes:

– To find the GUID for a list, just go to the Settings page for the list and copy it from the URL. (see below)

GetListGUID


What every SharePoint and EPM administrator needs to know about Alternate Access Mappings

September 17, 2009

Here is an amazing  3-Parts-series of mastering Alternate Access Mappings(AAM), which will clarify your vision managing Web application paths, ip addresses & DNS records, specially when dealing with SharePoint:


9 Free Icon Sets By VisualPharm

September 7, 2009

VisualPharm is sharing various sets of beautiful free icons that are offered in Windows, Mac & PNG formats.

Icon sets are themed differently from animals to office space or finance icons. And, a set named “Must Have Icons” which includes 59 icons is a nice fit to be used in web applications.

FreeIcons

All sets come in 7 popular sizes: 16*16px, 24*24px, 32*32px, 48*48px, 64*64px, 128*128px & 256*256px.

They are free to use in personal & commercial projects (a link back is required).