I tried exporting a list, and a markup-type text file was generated. It looks like that file has the list contents, but how does one read this file in a user-friendly format? The end-user who wants this export needs to be able to look at any given list (13k+) and easily browser it. I tried to view it in IE but it's not a valid XML file. Thanks.
Unfortunately, the intent for the exported data wasn't to provide an alternative source for a readable view, but to collect that data so it can be imported somewhere else (i.e., data migration) or processed elsewhere for purposes of additional analysis.
Exporting list data that includes enhanced rich text columns adds complexity to the export since the exported file is a text file but includes the html markup from the enhanced rich text.
thanks Julia. I didn't realize that it was the rich text fields that were responsible for the markup within the file. That will help me to determine if this solution will work for us. There are apparently 13K+ lists on this site, so I need to find the most efficient conversion solution.
Is the intent to get the data out of SharePoint for good? Have you tried exporting to Excel (that may handle the rich text better)?
Are the lists all the same type? or similar? How many items (approx.) in each - lots?
Yes, the intent is to get the data out of SharePoint for good (we have to shut down the '03 server it's running on). I did view the data in Excel, and it didn't render the rich text, but now that I know what we are dealing with, I think we could parse out the tags and just leave the plain text.
On another note, can you verify that this app will not export document libraries? It only seems to export documents attached to list items. Is that correct? If so, do you have another tool that can do both? Basically like a site dump to disk kind of application. Thanks.
You should be able to export files from Document libraries too. Are you having trouble exporting from libraries?
When I was first using the tool, it didn't appear that I could, but on 2nd try, yes I can export document libraries. Thanks.