Update List/Library Metadata of SharePoint List(Online) using PNP PowerShell

cls
$error.Clear()

#get the location of the script file
$scriptBase=Split-Path $SCRIPT:MyInvocation.MyCommand.Path -Parent

 Set-Location $scriptBase 

$path=Get-Location 

$FilePath="$path\"+"Documents.csv" 

#Output log file name
$outputFile="updateMetadataLog.csv" 

$outputfilepath="$path\"+$outputFile 

#Portal url
$SiteURL= "SITEURL" 

#Connect to PnP Online
Connect-PnPOnline -Url $SiteURL -ClientId CLIENTID
#Get the Root Web
$Web = Get-PnPWeb

#Get the Site Title
Write-host -f Green $Web.Title 

# Library Name
$libraryName="DOCUMENT LIBRARY"
$DocId=""
$srcFileName=""
$metadatastatus="" 

#function to export to log file

function exporttoLog()
{
   $data = @{ 

           "SourceFileName"=$srcFileName        
           "Status"=$metadatastatus
           }
   New-Object PSObject -Property $data
}

 function UpdateMetadataForDocs()

{
    $arr=@{}

    Write-Host "Path"  $FilePath 

    #Get Source CSV. this CSV has my columns data that need to be updated in the list/library
    $Documents=Import-Csv -Path $FilePath -UseCulture

     foreach($row in $Documents)

    {
        $srcFileName=$row.FileName
        $FolderPath=$row.FilePath
        $SiteRelativeURL="PATH TILL LIBRARY NAME"+$FolderPath+"/"+$srcFileName
        Write-Host -f yellow "Source File name --- " $srcFileName
        Write-Host -f yellow "Folder Path ---- " $SiteRelativeURL

         $FileItem=Get-PnPFile -Url $SiteRelativeURL -AsListItem

         Write-Host -f Green  "Item from Doc Lib --- " $FileItem["Title"]

        Write-Host -f Green "Id of the File Item --- " $FileItem["ID"]

         # Update column values for documents 

        try
        {

    $li= Set-PnPListItem -List $libraryName  -Identity $FileItem["ID"]  -Values @{'Title' = $row.DocumentTitle;'Department'=$row.Department;'Status'=$row.Status;'Author'=$row.CreatedBy;'Created'=$row.Created;'Modified'=$row.Modified;'Editor'=$row.ModifiedBy;}

                 $metadatastatus="Updated successfully"

                 Write-host -f Red "Metadata Update" for $FileItem["Title"]

        }

        catch
        {
          $metadatastatus=$_.Exception.Message

           Write-Host  $_.Exception.Message  

         }

   exporttoLog  

     }

     }

UpdateMetadataForDocs |  Export-Csv -NoTypeInformation -Path $outputfilepath

Comments

Post a Comment

Popular posts from this blog

Developing Custom workflows in SharePoint 2007 using Visual Studio 2005

Image
There are two types of custom workflows we can develop in SharePoint 2007     1.     SharePoint Designer workflows : These workflows are developed using SharePoint Designer 2007.     2.     Visual Studio Designer workflows : These workflows are developed using Visual studio Designer for which we need to install Visual Studio 2005 Extensions for Windows Workflow Foundation . In this article I am going to explain about how to develop custom workflows using Visual Studio 2005 using InfoPath 2007 forms as Task forms. Design a Task form using InfoPath 2007 1.     Open Microsoft Office InfoPath 2007 2.     Click on “ Design a Form Template ” under “ Design a Form ” as shown below:   3.     Select “ Form Template ” and also ensure that “ Enable Browser compatible features only ” check box is selected, select blank template and click “ OK ”. 4.   ...
Read more

Sharepoint 2010:ECMA script to retrieve list data

Sharepoint 2010 has got new greate feature called "Client object Model" which is very useful. Client object model helps developers in making things easier to develop client side applications in sharepoint 2010. Using client object model we can do many of things with out writing server side code. you will find enough of information on msdn about Client Object model and differerent platforms where it can be used,so iam will concentrating on ECMA script. ECMA script:have you ever thought of using sharepoint objects in client(javascript) and updating the list items without having to write server code and with out having to deploy it as feature? Yes its possible and here where ECMA script comes in to picture. In this blog i am going to write about retrieving the list data using ECMA script. Please find the code below to retrieve list data using ECMA script:            <script type="text/javascript">     ...
Read more

Tabs for sharepoint list forms using Jquery

Image
When the fields on the Form exceeds the viewable range and we get a vertical scroll, we need to customize the sharepoint forms to display the page with out scroll. scrolling is something that should be avoided for a optimum user experience. we can customize our sharepoint forms to display the content in a different way so that user does not have to scroll to fill the details in the list form. one of the best solution is to display the fields in tabbed format. lets she how w can cusstomizae our sharepoint list to display the fields on tabs using JQuery.     First download the required JQuery files from Jquery.com as given below      http://code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css       http://code.jquery.com/jquery-1.10.2.js       http://code.jquery.com/ui/1.11.4/jquery-ui.js       Go to SharePoint Designer       Create a page as shown below:   ...
Read more