How to export appended text from a Sharepoint List

Hey folks, I need to export a list from WSS into excel and maintain the appended text. Is there a view to do such a thing? The problem is, I have made many notes on a series of list items and when I export it, its only exporting the last note, none of the appended text is being exported. Is there a special view I can change to get all this stuff? Thanks!~

Microsoft Server AppsMicrosoft SharePoint

Last Comment

ledfortr

8/22/2022 - Mon

raybies

3/16/2009

You're out of luck.

But you can make a console app that gets the versions:

SPListItemVersionCollection oVC = SPList.Versions[];
foreach(SPListItemVersion oV in VC)
{
....
}

OR make a custom field type that contains all versions.

ledfortr

4/6/2009

ASKER

I don't have rights to make code changes, as a site moderator, somehow i am locked down for sharepoint designer.

raybies

4/6/2009

SharePoint designer is such a pile of ****.

But you could create a DataView and call the GetVersionCollection of the list web service... of course you'll need to paste the results in to excel.

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Walt Forbes

ledfortr

4/20/2009

ASKER

That sounds like it could work, how would i call the GetVersionCollection?

raybies

4/20/2009

From SharePoint designer (SPD) you add a DataView > data source web service > Lists > GetVersionCollection.

I don't have SPD so I'm going by memory.

ledfortr

4/21/2009

ASKER

Ok, i was able to get to Data View > Manage Data Sources then you next instructions are unclear. I was able to figure out how to get out of contributor mode SPD so maybe that opens up some doors with your earlier suggestions regarding the console app...getting closer and closer!!! Thanks for the help and fast responses so far.

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

ASKER CERTIFIED SOLUTION

raybies

4/21/2009

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

raybies

4/21/2009

U could also add a list view web part and connect it to the data view having it pass it's parameters.

So every time u clicked a list item it would show the version info...

Google and play around.

ledfortr

4/29/2009

ASKER

Thanks!