Checkinn script for SharePoint documents in the library

sns 9,241

Checkinn scrript for SharePoint documents in the librrary.

is there any sccript to check in ( unlock ) the locked files in the libbrary, all are from one library only. And if we ran that script how long it may take?

Thank you in Advance.

1 answer

Xuyan Ding - MSFT 7,586 Reputation points

2023-01-24T09:31:37.54+00:00
Hi @sns,

You can check in by selecting all documents. If you need PowerShell, you can take a look at this article: Check In All Documents in a SharePoint Library using PowerShell. Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

If the user cannot edit the document after checking in, then it should not be that someone has performed a batch checkout operation on the documents of this library. The reason for locking the document may be that a service was not called when the document was closed. At this point, you may need to fix it by disabling the cache removal option in word or at worst try to install the latest CU.

==================Update

$WebURL="http://sp2016/sites/sp" $LibraryName="Documents" $Web = Get-SPWeb $WebURL $DocLib = $Web.Lists.TryGetList($LibraryName) $CheckedOutFiles = $DocLib.Items | Where-Object { $_.File.CheckOutStatus -ne "None"} ForEach($item in $CheckedOutFiles) { $DocLib.GetItemById($item.Id).file.CheckIn("Checked in by xx\administrator") }

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
sns 9,241 Reputation points

2023-01-24T10:38:44.01+00:00

Hi Xuyan Ding,

Thank you for the response. It is SP 2016, Could you please clarify below 5 follow up questions:

1.

how end user might have performed batch checkout operation? is there any to do it? If yes could you please tell.

2.

Disabling the cache, how it is possible for all the word documents? Can you please suggest here?

3.

what is the latest CU article? I mean which CU update can you provide me link and which is month is the latest one?

4.

and above script seems to be not working, we executed it but prompt came up to normal, however no output. and later I verified when open the random folders inside this particular library , we don't see any documents, but when we see from library settings it is showing 45000 count , and user is saying still issue remains.

5.

and also since it is 2016 library where I should find bulk check in option?

Thank you

Xuyan Ding - MSFT 7,586 Reputation points

2023-01-26T08:43:48.2666667+00:00

Hi sns,

Sorry for the late reply, I was on vacation yesterday.

The following is my SharePoint 2016 environment. End users with permissions can select all files and click the Check Out option on the panel.

Disabling caching was a solution for a previous user, and some users had problems with a service call. Open the problematic file again, this part of users can take this method to achieve the purpose of re-awakening the service call.

The updated article for SharePoint is here.

The operation of Check in is similar to that of Check out.

Xuyan Ding - MSFT 7,586 Reputation points

2023-02-02T02:18:53.8366667+00:00

Hi @sns,

I’m checking how the things are going on about this issue.

sns 9,241 Reputation points

2023-02-02T07:06:14.5+00:00

Hi Xuyan Ding,

NO one is able to see the documents in the library although it is showing count of documents in the library settings.

Please suggest further on this

sns 9,241 Reputation points

2023-02-02T08:50:00.86+00:00

Hi Xuyan Ding,

When we clicked on Mange files in checked out from libary settings , it is taking longer time to load ( FEW hours and it is still loading )

is there any power shell command to check in all the files showing under option "Manage files which have no checked in version" from library settings. If yes please share

Xuyan Ding - MSFT 7,586 Reputation points

2023-02-03T06:39:10.1966667+00:00

Hi @sns,

It may be due to the threshold limit of the library, which causes the file to load slowly. You can try the command below, it works in my test environment.

$WebURL="http://sp2016/sites/sp" $LibraryName="Documents" $Web = Get-SPWeb $WebURL $DocLib = $Web.Lists.TryGetList($LibraryName) $CheckedOutFiles = $DocLib.Items | Where-Object { $_.File.CheckOutStatus -ne "None"} ForEach($item in $CheckedOutFiles) { $DocLib.GetItemById($item.Id).file.CheckIn("Checked in by xx\administrator") }

sns 9,241 Reputation points

2023-02-03T06:43:40.17+00:00

HI Xuyan DIng,

Looks like you have shared command but I am not able to see in the comments section,

can you share once again? I could see of it in the notification form through mobile.

sns 9,241 Reputation points

2023-02-03T06:45:39.9533333+00:00

Hi Xuyan Ding,

It is sub site where document resides, can we give subsite URL in the $WebURL place?

Xuyan Ding - MSFT 7,586 Reputation points

2023-02-03T06:52:55.61+00:00

Yes. I'll update my previous answer to make sure you can see the original code.

sns 9,241 Reputation points

2023-02-05T16:38:24.8166667+00:00

Hi Xuyan Ding,

I have tried above script, the script showed same output like yours , meaning it worked. However, From Library when we navigate to folder and looked for the document, as usual no documents are showing in the folders.

and when we verified and checked in one or 2 files manually from Managed files check in versions list under library settings, it is working.

I would like to know why there is no progress from script, although we executed correctly twice and no sign of errors?

secondly, since those bulk documents were checked out by only person, is there any other alternatives to checkin documents which are checked out by that particular person alone?

or any other alternatives? Please suggest, thank you for help and follow up.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Checkinn script for SharePoint documents in the library

1 answer

Your answer