I have what would seem a simple task below but I’m afraid I'm new to Powershell and I've yet to find a solution that works.
I have a Document Library called "Archive" that will have many documents in it. All documents in this document library will have the same ContentType and hence the same columns.
The two relevant columns are: 1.WhereLegacyID (Which will not be null) 2.SetPersonID (Which will be null)
For every document within the document library my requirement is to:
‘WhereLegacyID’ is a certain value, Set SetPersonID to another value.
Those values need to be determined by reading in a spreadsheet (below) which will have 2 columns:
- Column A = WhereLegacyID and
- Column B = SetPersonID.
The number of rows should match the number of documents in the document library:
So the script would need to find any documents WhereLegacyID = 1 and SetPersonID = 11 etc
One last point, I expect that there will be multiple documents with the same WhereLegacyID and so the script would need to loop through all the documents and then set the SetPersonID accordingly.
Would anyone know how this is done?
Also, can anyone recommend any good Powershell v2 for SharePoint 2010 training resources online?
Many Thanks Jason