Forum Discussion

Nick's avatar
Nick
Frequent Visitor
9 years ago

Getting SharePoint List items with full history version?

Hi,   We do have a SharePoint list to manage Fleet inventory of asset: mainly their attribution (who own it) and their status (active, lost, broken, etc.). We did activated the SharePoint Version ...
Need Help
llaumans's avatar
llaumans
Frequent Visitor
9 years ago

Hi Nick,

 

did you ever figure out how to retrieve the history for items in a SharePoint list so you could run historical reports on your data? I would be very interested to learn how you managed to get this done!

 

Thanks in advance!

 

Kind Regards,

 

Lucas

 

Nick's avatar
Nick
Frequent Visitor
9 years ago

Hi Lucas,

 

The current workaround I'm currently using since I don't have access to SharePoint DB/Framework is via R script:

 

Here I'm taking snapshot of Group, Status, Id, and ExtractDate data into a local CSV file, everytime I'm refreshing the Data Source.

 

Not fancy but it does the job for now.

Hope that will help.

 

Nick

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    This one worked for me:

    https://sharepoint.stackexchange.com/questions/190021/exporting-item-list-version-history

    :manhappy:

     

    Short explaination:

    The "&IncludeVersions=TRUE" gives all changes form all versions (form all fields)

    Make a Sharepoint List which only contains the columns you need. (or split it up in several views and repeat this trick)

     

    Open the XML in Excel en there you can create a PivotTable and if you include the version field in SharePoint view.

    You can see the version number in the Pivot :smileyvery-happy: Just sort on this version number and you will see the latest and all previous versions.