cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nick Frequent Visitor
Frequent Visitor

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 Control and I would like to use this information to run histroical report overtime around such assets status and ownership.

Right now, the only solution I found is to eitheir take a snapshot of the full list on a regular basis into another datasource.

Is there anyway to get such history/version data directly avoiding wruting such separate datasource?

 

Thansk in advance,

Nick

11 REPLIES 11
Highlighted
Super User
Super User

Re: Getting SharePoint List items with full history version?

Well, you can get version history like so:

 

http://<server>/<site>/_layouts/versions.aspx?list={litsID}&ID=<itemID>

 

Here are some resources that might assist:

http://stackoverflow.com/questions/24423657/sharepoint-2013-get-splistitem-versions-via-rest

http://www.c-sharpcorner.com/UploadFile/anavijai/how-to-get-the-file-versions-in-sharepoint-2013-onl...

https://social.msdn.microsoft.com/Forums/en-US/79945c1d-1581-4441-bc13-14d119aa6a64/document-version...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


v-ljerr-msft Super Contributor
Super Contributor

Re: Getting SharePoint List items with full history version?

@Nick


Right now, the only solution I found is to eitheir take a snapshot of the full list on a regular basis into another datasource.

Is there anyway to get such history/version data directly avoiding wruting such separate datasource?


You can export version history of SharePoint List Items to Microsoft Excel first. Then export that Excel table to your SharePoint List. So that the version history and  other data will be in the same datasource.

export.PNG

 

sharepointlist.PNG

Regards

Nick Frequent Visitor
Frequent Visitor

Re: Getting SharePoint List items with full history version?

@Greg_Deckler

Thanks but it looks I can only extract one version of a specific item. However thanks for sharing URLs: a solution may be around.

Nick Frequent Visitor
Frequent Visitor

Re: Getting SharePoint List items with full history version?


@v-ljerr-msft

Thanks but I can't execute PS scrript right now due to my company policies.

In addition I also wanted to avoid data multipliciation: maybe SharePoint list may not be good for what I'm looking for and I may ave to swicth to a real DB model.

thakks Regular Visitor
Regular Visitor

Re: Getting SharePoint List items with full history version?

Guys did you had any luck extracting all version from the sharepoint list by any chances..

llaumans Frequent Visitor
Frequent Visitor

Re: Getting SharePoint List items with full history version?

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 Frequent Visitor
Frequent Visitor

Re: Getting SharePoint List items with full history version?

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

FBrus Frequent Visitor
Frequent Visitor

Re: Getting SharePoint List items with full history version?

This one worked for me:

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

Man Happy

 

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 Smiley Very Happy Just sort on this version number and you will see the latest and all previous versions.

FBrus Frequent Visitor
Frequent Visitor

Re: Getting SharePoint List items with full history version?

This one worked for me:

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

Man Happy

 

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 Smiley Very Happy Just sort on this version number and you will see the latest and all previous versions.