Manage Large Amounts of Metadata with Bulk Edit Content
In this video, we will see how Sharegate can help, when it comes to modifying large quantities of metadata with the Bulk Edit Content feature. To access this feature, simply select a list or library from the Explorer screen and click on Bulk Edit Content. Then, two options are available to modify the data.
The first option is to select items you’d like to modify and click on Next. If you’ve already used the Copy Content from our Migration features, you’ll recognize the Copy template options.
For each property of your content type, you can decide to preserve the mapped values, in other words, preserve the data as-is for this property, unless you modify the properties mapping in the Mappings screen.
You can also create custom values to replace the existing one: tell Sharegate to ask you what it should replace each item with, preserve the mapped values but use a default in case the field is empty, or simply ignore the data inside that field and leave it empty. Once you’ve selected the desired options, simply click on Bulk-Edit and let Sharegate do its magic.
The second option is to select what you want to copy and then click on Export Metadata. Sharegate will then create an Excel sheet with all the items you selected and all the property columns of the list or library.
Within the sheet, you can modify all the metadata you want and use Excel at your advantage. You can use the filters, or formulas if needed. You can fill up empty columns, and modify the content types of different elements with Excel. Once you are done modifying the sheet, go back in Sharegate and click on Import & Edit and select your Excel sheet.
Sharegate will then offer you the same option seen previously if you need to add more modifications. When you click Bulk Edit, Sharegate will modify the metadata attached to the items you exported to Excel using the modifications you’ve done to the Excel sheet and the Template options.
With the Bulk Edit Content feature, standardizing Metadata and cleaning up lists and libraries get faster than ever.