Forum Discussion
Bulk Upload files and meta data from file share into sharepoint online doclib
Hi,
We have a requirement to upload image files from fileserver shares into a document library.
In addition we need to upload meta data e.g. (Title | Description | Productfamily....) into the corresponding columns of the document lbrary.
We prefer to use PowerQuery to extract folder content, transform /add the additional meta data information. So far I haven't found a solution to upload files and meta data.
Thank's for a feedback
Best regards Stefan
3 Replies
- SvenSieverdingBronze Contributor
Hi smaharms-wende ,
I would use the SharePoint Migration Tool (https://spmt.sharepointonline.com/install/default.htm ) to upload the files themselves (This handles uploads of bulk data very well).
Then i would store all the metadata in a CSV file and use PnP PowerShell to update the metadata of the files#Url;Doclib;Title;Othervalue #/sites/mysite/Documents/Document.docx;Documents;New Title;New Othervalue $CSVData = Import-CSV $filepath Connect-PnPOnline https://yourtenant.sharepoint.com/sites/mysite -Interactive $CSVData |foreach-object { $item=Get-PnPFile -Url $_.Url -AsListItem Set-PnPListItem -List $_.Doclib -Identity $item.Id -Values @{Title=$_.Title;Othervalue=$_.Othervalue} }
Best Regards,
Sven- smaharms-wendeCopper Contributor
Hi Sven,
thank's a lot for your fast reply. I will download SPMT and test your solution asap.
Best regards
Stefan
- Paul de JongIron Contributor
Are the metadata fields present as properties within the image files or in a separate file / system?
In case the metadata fields are present within the image files you can use tools to upload the images and automatically extract the metadata. See https://directory.collab365.com/listing/slim-companion-explorer/.