Why does Sharepoint lose exported 'appended' rich text data?

Export from Sharepoint to Excel.

When you export data from an 'appended' multiline, rich text data field all previous entries into that field are lost and only the last entry gets exported.  I was kinda hoping (expecting) that it would send all entries along with the respective name and date tags.  Alas, with MS Sharepoint it was not to be!!!!

Help anyone please?!

Advanced user only; MOSS 2007; Excel 2007
RichShareAsked:
Who is Participating?
 
dp_expertConnect With a Mentor Commented:
0
 
dp_expertCommented:
Hello

This is because SharePoint is just emulating the appending on the web UI - it is simply displaying the values from previous versions on the disp and edit form. They have not implemented it on the list views and webservices.

You would need to code it to get all version values for this field - see this post for more details http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_26869470.html
 and this one http://blogs.msdn.com/b/manuj/archive/2010/05/15/how-to-export-values-for-a-multiline-column-with-append-changes-to-existing-text.aspx
0
 
RichShareAuthor Commented:
This is a touch beyond me but it looks like the right solution.  I will passs it to my IT guys.  Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.