Button Display Over Folder Level

Hi,

We have a document library with top 3 parent folders i.e. folder1,folder2 and folder3

Now this document library has been added to the page through list view web part.

We had a requirement of displaying custom button over folder level i.e.

Once user navigates to page, user shouldn’t be able to see the button.

Post clicking on the folder1,user should be able to see the button

Post clicking on the folder2, user shouldn’t be able to see the button.

Post clicking on the sub folder inside folder2, user should be able to see the button.

Post clicking on the folder3, user shouldn’t be able to see the button.

Post clicking on the sub folder inside folder3, user should be able to see the button.

For this we have added the below script

<script>

$(document).ready(function() {

setTimeout(function(){

var qstring = window.location.search.substring(1);

var url = window.location.href; //console.log(url.split('%2F'));   

var getQueryLength=0;

if(qstring.indexOf('%2F') > -1)

{

getQueryLength = qstring.split('%2F');

}

else

{

getQueryLength = qstring.split('/');

}

if(getQueryLength.length > 5 || (qstring.indexOf('folder1') > -1) )

{

$('.create_subfolder_sec .save-btn').css('display','block');

$('#Hero-WPQ3').css('display','block');

}

else

{

$('.create_subfolder_sec .save-btn').css('display','none');

$('#Hero-WPQ3').css('display','none');

}

}, 5);

});

</script>

Content Search vs Content Query Webpart

Compare the strengths and limitations of the Web Parts

It’s important that you understand the strengths and limitations of the two Web Parts because if you choose the wrong one, your site could run into performance problems. You can use both Web Parts to show content that is based on a query. In a simplified world, here’s how you can decide between the two:

·         Use the CQWP when you have a limited amount of content, your query is simple, and you don’t expect your content to grow much in the future.

·         Use the CSWP in all other scenarios when you want to show content that is based on a query.

The table below gives a comparison of the two Web Parts:

Web Part behavior	Content Query Web Part	Content Search Web Part
Query configuration	Easy	You’ll need to know about certain search features such as managed properties.
Query across large amounts of content	Limited	Yes
Handle complex queries	Limited	Yes
Scale to handle future content growth	Limited	Yes
Display content from other site collections	No	Yes (see section below)
Design of query results can be customized	Yes, by using XSLT.	Yes, by using HTML.
Maintenance cost in a complex site architecture	High	Small (see section below)
Narrow down the query results that are displayed in the Web Part	No	Yes, in combination with the Refinement Web Part.

Folder Level Search in SharePoint 2013

Hi,

In SharePoint 2010,we had a scope creator but in SharePoint 2013 scope creator doesn’t exists

Now post migrating our application from SharePoint 2010 to SharePoint 2013.

Below is the strategy that has been followed to enable folder level search in SharePoint 2013

First we have created a document library of name Search Result.

Have uploaded the pages as below inside the document library

Post that, we have created two lists SearchScopes, SearchSource

In the SearchScopes list, section search has been created as an item

In the SearchSource list, we have created the columns as below

Post this, items in the list have updated as below

Full crawl has been executed with respective site url

After adding the SharePoint search web part on the page

Update the group ID in the search web part properties

PowerShell Script To Get Documents Last Updated Details

Hi,

We had requirement to get the below details of all the files in a document library of last month as report.

This report needs to be sent to customer as an attachment through email.

For this we have written the PowerShell script as below

if ((Get-PSSnapin -Name Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue) -eq $null )

{

    Add-PSSnapin Microsoft.SharePoint.Powershell

}

#Global Variables

$site=Get-SPSite "siteurl"

$web=get-SPWeb "weburl"

$list=$web.Lists["doclibname"]

$fromaddress = "abc@domain.com"

$toaddress = " def@domain.com "

$ccaddress = "xyz@domain.com "

$auditloglib=$web.Lists["AuditLogReports"]

$reportid=Get-Random

$context = Get-SPServiceContext $site

  $date = get-date

        $numdays = $date.Day

        $ed = $date.AddDays(-$numdays)

        $numdays = $ed.Day

        $sd = $ed.AddDays( -$numdays + 1)

        $sd = ((($sd.AddHours(0-$sd.hour)).AddMinutes(0-$sd.Minute)).AddSeconds(0-$sd.Second)).AddMilliseconds(0-$sd.millisecond)

        $ed = $ed.AddDays(1)

        $ed = ((($ed.AddHours(0-$ed.hour)).AddMinutes(0-$ed.Minute)).AddSeconds(0-$ed.Second)).AddMilliseconds(0-$ed.millisecond)

#EndRegion Global Variables

#Region Last Updated Data

try

   {

   

    

    $Headers = 'FileName,Description,Modified,Created By,Modified By,Path,Created'

    $filename = "D:\filename-" + $sd.Date.Date.ToString("MMM") + $sd.Date.Date.ToString("yy")+$reportid + ".csv"

   

    Add-Content $filename $Headers

    $Items = $list.items

    Write-Host  "Item Count" + $Items.Count

               

    foreach($MItem in $Items)   

    

    {

        Write-Host $Items.Count

        Write-Host $MItem["Name"]

        Write-Host $MItem["Description"]

        Write-Host $MItem["Modified"]

        Write-Host $MItem["Created By"]

        Write-Host $MItem["Modified By"]

        Write-Host $MItem["Path"]

        Write-Host $MItem["Created"]       

        

        $DocDetails = $MItem["Name"]+","+$MItem["Description"]+","+$MItem["Modified"]+","+$MItem["Created By"].Split("#")[1] +","+$MItem["Modified By"].Split("#")[1]+","+$MItem["Path"]+","+$MItem["Created"]       

        Add-Content $filename $DocDetails

    }

    $files = Get-ChildItem -Path $filename -Force -Recurse

foreach ($file in $files)

        {

          

          $stream = $file.OpenRead()

          $done= $auditloglib.RootFolder.Files.Add($file.Name, $stream, $true)

          $stream.Close()

         

          Write-Host $done.Name  "Uploaded into the Document Library"$auditloglib -BackgroundColor Green   

               

        }

Write-Host "Last Updated Report Uploaded successfully into"+$auditloglib

#############Email for Last Updated Data####################################

$Subject = "Sales Tools Last Updated-" + $sd.Date.Date.ToString("MMM")+$sd.Date.Date.ToString("yy")

$body = "Hi, Please find attached Last Updated report for the Month :" + $sd.Date.Date.ToString("MMM") +$sd.Date.Date.ToString("yy")

$attachment = $filename

#SMTP IP Address of Production

$smtpserver = "0.0.0.0"

$message = new-object System.Net.Mail.MailMessage

$message.From = $fromaddress

$message.To.Add($toaddress)

$message.To.Add($ccaddress)

$message.IsBodyHtml = $True

$message.Subject = $Subject

$attach = new-object Net.Mail.Attachment($attachment)

$message.Attachments.Add($attach)

$message.body = $body

$smtp = new-object Net.Mail.SmtpClient($smtpserver)

$smtp.Send($message)

$message.Dispose()

$smtp.Dispose()

$file.Delete()

#######################################################    

  }

  catch

    {

  

   Add-Content D:\Logs\LastUpdatedLogReport.txt $DocNameError

    }

#EndRegion Last Updated Data

Post generating the report through csv file.

We are uploading the same to document library and

We are deleting the same from the physical path through Power Shell script

PowerShell Script of new Additions of a Document Library

Hi,

There was a requirement to our customer i.e.

Every month email should be triggered to the customer with count of new document uploads of the preceding month.

Along with this customer requires the below details of additions as an attachment

For this, first we have created site columns as below

Below are settings of the view that has been created

"]

$fromaddress = "abc@domain.com"

$toaddress = " abc@domain.com "

$ccaddress = " abc@domain.com "

$auditloglib=$web.Lists["AuditLogReports"]

$reportid=Get-Random

$context = Get-SPServiceContext $site

  $date = get-date

        $numdays = $date.Day

        $ed = $date.AddDays(-$numdays)

        $numdays = $ed.Day

        $sd = $ed.AddDays( -$numdays + 1)

        $sd = ((($sd.AddHours(0-$sd.hour)).AddMinutes(0-$sd.Minute)).AddSeconds(0-$sd.Second)).AddMilliseconds(0-$sd.millisecond)

        $ed = $ed.AddDays(1)

        $ed = ((($ed.AddHours(0-$ed.hour)).AddMinutes(0-$ed.Minute)).AddSeconds(0-$ed.Second)).AddMilliseconds(0-$ed.millisecond)

#EndRegion Global Variables

#Region Sales Workshop Additions

$view = $stlist.Views["CurrentMonth"]

$items = $stlist.GetItems($view)

$salestoolsadditions = 0

$salestoolsadditions = $items.Count

$Headers = 'FileName,Description,Modified,Created By,Modified By,Created'

$filename = "D:\NewAdditions-" + $sd.Date.Date.ToString("MMM") + $sd.Date.Date.ToString("yy")+$reportid + ".csv"

Add-Content $filename $Headers

foreach($MItem in $items)

{

        Write-Host $MItem["Name"]

        Write-Host $MItem["Description"]

        Write-Host $MItem["Modified"]

        Write-Host $MItem["Created By"]

        Write-Host $MItem["Modified By"]       

        Write-Host $MItem["Created"]

        

        $DocDetails = $MItem["Name"]+","+$MItem["Description"]+","+$MItem["Modified"]+","+$MItem["Created By"].Split("#")[1] +","+$MItem["Modified By"].Split("#")[1]+","+$MItem["Created"]       

        Add-Content $filename $DocDetails      

}

$files = Get-ChildItem -Path $filename -Force -Recurse

foreach ($salestoolsadditionsfile in $files)

        {

          

          $stream = $salestoolsadditionsfile.OpenRead()

          $done= $auditloglib.RootFolder.Files.Add($salestoolsadditionsfile.Name, $stream, $true)

          $stream.Close()

         

          Write-Host $done.Name  "Uploaded into the Document Library"$auditloglib -BackgroundColor Green   

               

        }       

    

#EndRegion Sales Tools Additions

#############Email for New Additions ####################################

$Subject = "New Additions for the Month of -" + $sd.Date.Date.ToString("MMM")+$sd.Date.Date.ToString("yy")

$body = "--------------------------------------------------------------------------------------------"<br>New Additions in Sales Tools are - "+$salestoolsadditions<br> -------------------------------------------------------------------------------------------------"

$attachment = $filename

#SMTP IP Address of Production

$smtpserver = "IP Address"

$message = new-object System.Net.Mail.MailMessage

$message.From = $fromaddress

$message.To.Add($toaddress)

$message.To.Add($ccaddress)

$message.IsBodyHtml = $True

$message.Subject = $Subject

$attach = new-object Net.Mail.Attachment($attachment)

$message.Attachments.Add($attach)

$message.body = $body

$smtp = new-object Net.Mail.SmtpClient($smtpserver)

$smtp.Send($message)

$message.Dispose()

$smtp.Dispose()

$salestoolsadditionsfile.Delete()

#######################################################

}

catch

{

Add-Content D:\Logs\SalesToolsNewAdditionsLogReport.txt $DocNameError

}

###################################### Email for New Additions ###########################################################################

Finally the output is as below through attachment in the mail

PowerShell Script to get the Usage Report

Hi,

We had a requirement of Usage Report of preceding month i.e.

The usage of files in a document library needs to be sent for customer as an attachment

For this we have fetched the data from audit logs as below

if ((Get-PSSnapin -Name Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue) -eq $null )

{

    Add-PSSnapin Microsoft.SharePoint.Powershell

}

#Global Variables

$site=Get-SPSite "siteurl"

$web=get-SPWeb "weburl"

$list=$web.Lists["doclibname"]

$fromaddress = "abc@domain.com"

$toaddress = "def@domain.com"

$ccaddress = "ghi@domain.com"

$auditloglib=$web.Lists["AuditLogReports"]

$reportid=Get-Random

$context = Get-SPServiceContext $site

  $date = get-date

        $numdays = $date.Day

        $ed = $date.AddDays(-$numdays)

        $numdays = $ed.Day

        $sd = $ed.AddDays( -$numdays + 1)

        $sd = ((($sd.AddHours(0-$sd.hour)).AddMinutes(0-$sd.Minute)).AddSeconds(0-$sd.Second)).AddMilliseconds(0-$sd.millisecond)

        $ed = $ed.AddDays(1)

        $ed = ((($ed.AddHours(0-$ed.hour)).AddMinutes(0-$ed.Minute)).AddSeconds(0-$ed.Second)).AddMilliseconds(0-$ed.millisecond)

#EndRegion Global Variables

#Region Nucleus Usage Report

$wssQuery = New-Object -TypeName Microsoft.SharePoint.SPAuditQuery($site)

try

   {

   

    

    $Headers = 'Section,Folder,    File,Noof Downloads,Noof ViewCounts,Document Path,Last Updated,Vertical / Service line related details1,Vertical / Service line related details2,Vertical / Service line related details3'

    $filename = "D:\UsageReports\UsageReport-" + $sd.Date.Date.ToString("MMM") + $sd.Date.Date.ToString("yy")+$reportid + ".csv"

   

    Add-Content $filename $Headers

    $Items = $list.items

    Write-Host  "Item Count" + $Items.Count

                $wssquery.SetRangeStart($sd)

        $wssquery.SetRangeEnd($ed)

    foreach($MItem in $Items)

   

    

    {

        $wssquery.RestrictToListItem($MItem)

        $auditCol = $site.Audit.GetEntries($wssQuery)

        Write-Host "Audit Count" + $auditCol.Count

         $viewcount = 0

         $DownloadCount = 0

        if($auditCol.Count -gt 0)

        {

            foreach($auditEntry in $auditCol)

                {

                    if($auditEntry.EventSource -eq 'SharePoint')

                        {

                            $DownloadCount++

                        }

                            elseif($auditEntry.EventSource -eq 'ObjectModel')

                                        {

                                            $viewcount++

                                        }

                }

$ItemDetails = $MItem.Url.Split('/')

#switch($ItemDetails.count)

#{

Write-Host "Item Count" + $ItemDetails.Count

if($ItemDetails.Count -eq 2) { $DocDetails = "Sales Tools" + "," + "NA" + "," + $ItemDetails[1] +  "," + $DownloadCount + "," + $viewcount + "," + $MItem.Url + "," +  $MItem["Modified"] + "," + "NA" + "," + "NA" + "," + "NA" + "," + $MItem.Url}

ElseIf($ItemDetails.Count -eq 3) { $DocDetails = "Sales Tools" + "," + $ItemDetails[1] + "," + $ItemDetails[2] +  "," + $DownloadCount + "," + $viewcount + "," + $MItem.Url + "," +  $MItem["Modified"] + "," + "NA" + "," + "NA" + "," + "NA" + "," + $MItem.Url}                                                             

ElseIf($ItemDetails.Count -eq 4) { $DocDetails = "Sales Tools" + "," + $ItemDetails[1] + "," + $ItemDetails[3] +  "," + $DownloadCount + "," + $viewcount + "," + $MItem.Url + "," +  $MItem["Modified"] + "," + $ItemDetails[2] + "," + "NA" + "," + "NA" + "," + $MItem.Url}

ElseIf($ItemDetails.Count -eq 5) { $DocDetails = "Sales Tools" + "," + $ItemDetails[1] + "," + $ItemDetails[4] +  "," + $DownloadCount + "," + $viewcount + "," + $MItem.Url + "," +  $MItem["Modified"] + "," + $ItemDetails[2] + "," + $ItemDetails[3] + "," + "NA" + "," + $MItem.Url}

ElseIf($ItemDetails.Count -eq 6) { $DocDetails = "Sales Tools" + "," + $ItemDetails[1] + "," + $ItemDetails[5] +  "," + $DownloadCount + "," + $viewcount + "," + $MItem.Url + "," +  $MItem["Modified"] + "," + $ItemDetails[2] + "," + $ItemDetails[3] + "," + $ItemDetails[4] + "," + $MItem.Url}

else

  { $DocDetails = "Sales Tools" + "," + $ItemDetails[1] + "," + $ItemDetails[5] +  "," + $DownloadCount + "," + $viewcount + "," + $MItem.Url + "," +  $MItem["Modified"] + "," + $ItemDetails[2] + "," + $ItemDetails[3] + "," + $ItemDetails[4] + "," + $MItem.Url}         

#default {}

#}

Write-Host $DocDetails

#$DocDetails = "Sales Tools" + ","  + $viewcount + "," + $DownloadCount + "," + $MItem.Url + "," +  $MItem["Modified"]

Add-Content $filename $DocDetails

}

               

    }

$files = Get-ChildItem -Path $filename -Force -Recurse

foreach ($file in $files)

        {

          

          $stream = $file.OpenRead()

          $done= $auditloglib.RootFolder.Files.Add($file.Name, $stream, $true)

          $stream.Close()

         

          Write-Host $done.Name  "Uploaded into the Document Library"$auditloglib -BackgroundColor Green   

               

        }

#############Email for Usage Report####################################

$Subject = "Usage Report-" + $sd.Date.Date.ToString("MMM")+$sd.Date.Date.ToString("yy")

$body = "Hi, Please find attached Usage report for the Month :" + $sd.Date.Date.ToString("MMM") +$sd.Date.Date.ToString("yy")

$attachment = $filename

#SMTP IP Address of Production

$smtpserver = "IP Address"

$message = new-object System.Net.Mail.MailMessage

$message.From = $fromaddress

$message.To.Add($toaddress)

$message.To.Add($ccaddress)

$message.IsBodyHtml = $True

$message.Subject = $Subject

$attach = new-object Net.Mail.Attachment($attachment)

$message.Attachments.Add($attach)

$message.body = $body

$smtp = new-object Net.Mail.SmtpClient($smtpserver)

$smtp.Send($message)

$message.Dispose()

$smtp.Dispose()

$file.Delete();

#######################################################

}

catch

    {

   Write-Host "Error for File : " $i."Name"

   Add-Content D:\Logs\UsageReport\UsageLogReport.txt $DocNameError

    }

#EndRegion Usage Report       

  

Finally we got the required email triggered as an attachment as below

Attachment