从SharePoint Online库中删除重复的文档 [英] Deleting duplicate documents from SharePoint Online libraries

问题描述

我不确定这是否是解决此问题的合适论坛.如果没有，请指出正确的方向.

I'm not sure this is the right forum for this question. If not, please point me in the right direction.

我们正在将许多IBM(Lotus)Domino文档库迁移到SharePoint Online. AvePoint的DocAve是我们使用的软件，它正在SharePoint库中创建成千上万个(有时甚至成千上万个)重复文档.供应商 解决该问题并没有太大帮助，我可以看到我将需要一种方法来识别和删除重复项.

We are migrating a number of IBM (Lotus) Domino dofument libraries to SharePoint Online. The software we are using, DocAve from AvePoint, is creating thousands, in some cases tens of thousands, of duplicate documents in the SharePoint libraries. The vendor is not being much help in resolving the problem and I can see that I am going to need a way to identify and delete the duplicates.

幸运的是(如果此阴云有一线希望)，当重复项被复制到SharePoint中时，DocAve软件会将下划线和序列​​号附加到文件名上，从理论上讲，这应该使它们易于识别. 谁能建议我如何使用PowerShell消除这些重复项?

Fortunately (if there is a silver lining to this dark cloud) as the duplicates are being copied into SharePoint the DocAve software is appending an underscore and a sequence number to the file names, which should theoretically make them easy to identify. Can anyone suggest how I can get rid of these duplicates using PowerShell?

任何帮助将不胜感激.

推荐答案

我会再次尝试使用AvePoint.如果他们不能再提供帮助，我会感到惊讶.

I'd try again with AvePoint. I'd be surprised if they can't help further.

另一方面，可以在SharePoint中修复它.由于是O365，因此您面临一些挑战，因为访问内容比本地部署更困难.我看一下Office 365 PnP PowerShell模块，我只是自己熟悉它们，但是有 命令以获取列表项并将其删除.应该有可能打开一个脚本，该脚本获取列表项的名称，在下划线的基础上打断字符串，并进行一些基本的模式匹配，并删除数字较小的字符串.

On the other hand yes, you can fix it in SharePoint. Since it's O365 you've got some challenges, in that accessing content is harder than on-prem. I'd look at the Office 365 PnP PowerShell modules, i'm only getting to grips with them myself but there are commands to get list items and remove them. It should be possible to knock up a script that gets list item names, breaks the strings based on an underscore and does some basic pattern matching and removes the ones where there are lower numbers.

显然，您需要小心在哪里运行该脚本，但这可能会给您带来机会.

You'd need to be careful where you run that script, obviously, but that might give you a chance.

这篇关于从SharePoint Online库中删除重复的文档的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！