What is the easiest approach to exporting a Sharepoint list in xml format?

D

7

11

Pretty self explanatory. I just need to export lists easily to xml format. Are there any tools that accomplish this?

Delvalle answered 7/11, 2008 at 4:32 Comment(0)

U

16

This is the method I use:

http://servername/site/_vti_bin/owssvr.dll?Cmd=Display&List=YOURUNIQUELISTID&XMLDATA=TRUE

Works like a charm.

Ultraviolet answered 9/3, 2009 at 20:41 Comment(4)

In rejected edit, @reuben.ahmed suggests that one should, "replace the server name and the query string value with specific values." – Complaisance 1/7, 2011 at 20:24

Here's a link that works: sharepointsolutions.blogspot.com/2009/04/… – Inequity 13/3, 2012 at 20:42

Also note that you can append a View querystring variable to filter the results and/or get values from more site columns in the output. get the View ID from the address bar after clicking "Modify View" from the ribbon. – Changsha 4/4, 2012 at 14:40

Actually this didn't work for me. I had to change Cmd=ExportList – Fieldsman 27/9, 2017 at 1:27

R

4

You could also use the Lists webservice. http://server/_vti_bin/Lists.asmx

Rochelle answered 19/11, 2008 at 16:24 Comment(0)

V

3

You can write a c# application pretty easily to connect to the sp list and export it out yourself.

A quick search on codeplex search comes up with one such program already made for this purpose! Hope this can help you: http://www.codeplex.com/SPListReader http://www.codeplex.com/SPListReader/Release/ProjectReleases.aspx?ReleaseId=15420

Vosges answered 7/11, 2008 at 6:0 Comment(0)

U

3

Any chance that the RSS feed is going to be XML enough for you?

Ubangi answered 8/11, 2008 at 3:30 Comment(1)

Very interesting idea. I never thought of transforming the RSS feed. Thanks! – Delvalle 8/11, 2008 at 16:3

H

1

On the SharePoint list click Actions > Open With Access > Right click on the table and choose export to xml.

Haven answered 7/11, 2008 at 9:42 Comment(3)

What version of SharePoint? I just tried this and I don't have an "Open with Access" action. I can export to an Excel workbook, but it links to the SP list and doesn't let you export it. – Wulfila 7/11, 2008 at 12:27

ad "What version of SharePoint?": Can you edit your original question to clarify what SharePoint version you are using? – Archivist 7/11, 2008 at 17:43

Well, it's tagged MOSS. That can only mean SP 2007 – Delvalle 30/1, 2009 at 14:53

L

0

In the actions menu of the list, select export to spreadsheet. Then open the exported Excel Web Query file and from the File menu, select "Save as" and save it as XML.

Lessielessing answered 10/11, 2008 at 4:17 Comment(0)

B

0

You can create a 'Content Query Tool Part' to export a list of pages on your SharePoint environment to a generated XML list. My favorite feature with this tool is that you can sort and filter the content you want generated on your XML file. You can learn more about it here through this tutorial by Waldek Mastykarz

Boldface answered 3/4, 2012 at 20:11 Comment(0)

Recommended topics

Hot tags