Forum Discussion

smaharms-wende's avatar
smaharms-wende
Copper Contributor
Feb 08, 2023

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

  • SvenSieverding's avatar
    SvenSieverding
    Bronze 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-wende's avatar
      smaharms-wende
      Copper 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 Jong's avatar
    Paul de Jong
    Iron Contributor

    smaharms-wende 

    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/.

     

Resources