Tuesday, April 28, 2015

Powershell Script to fetch the GUID and Document Name for Null DOCID 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
###############################################################
#Script Function : Script will fetch the GUID and Document Name for Null DOCID,
#Developed: Sanjiv kumar                

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


If ((Get-PSSnapIn -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null )
{ Add-PSSnapIn -Name Microsoft.SharePoint.PowerShell }
#Get SPWeb and Our List we are targeting.
 try
    {
        $web = Get-SPWeb "http://sp2010:23934/"
        $list = $web.Lists["Resumes"]
        $Datetime= Get-Date -Format dd_MM_yyyy_HH.mm.ss
  
        #Log file for Missing DocID
        $LogFileName=([string]::Concat("Output_DocID_Missing_Log " , $Datetime ,".csv"))
        New-Item  .\$LogFileName  -ItemType file
       
        #Log file for Error
        $LogFileName_Error=([string]::Concat("Error_DocID_Missing_Log " , $Datetime ,".txt"))
        New-Item  .\$LogFileName_Error  -ItemType file
       
       
        Add-Content  .\$LogFileName -Value $webUrl
        Add-Content  .\$LogFileName -Value "Number of Folders : $folderscount"
        Add-Content .\$LogFileName -Value ([string]::Concat("GUID_Name" +","+ "File_Name"))
       
       
       
       
        #Build Query
        $spQuery = New-Object Microsoft.SharePoint.SPQuery
        #CAML Query Using a DateTime Value and and Offset of Today
        $query = ''
        $spQuery.ViewAttributes = "Scope = 'Recursive'"
        $spQuery.Query = $query
        $spQuery.RowLimit = $list.ItemCount
        $spListItemCol = $list.GetItems($spQuery)
       
        #Writting the data to CSV
        foreach ($item in $spListItemCol)
        {
         #write-host "PD GUID:" $item["PDIGUID"] "File Name:" $item["Name"] -ForegroundColor Green
         Add-Content .\$LogFileName -Value ([string]::Concat($item["PDIGUID"] +","+ $item["Name"]))
        }
       
        $web.Dispose()
  }
  catch [System.Exception]
  {
   #write-host -f red $_.Exception.ToString()
   #write-host -f red $_.Exception.Message
   
     #write-host -f red $Error[0].Exception.Message
             #$ErrorVar= $_.Exception.ToString()
                    Add-Content .\$LogFileName_Error -Value ([string]::Concat("************************************"))
                 
                    Add-Content .\$LogFileName_Error -Value ([string]::Concat("System Message: "+ $ErrorVar))
                    #Add-Content .\$LogFileName_Error -Value ([string]::Concat("System Message: "+ $Error[0]))
                   
                    #Add-Content .\$LogFileName_Error -Value ([string]::Concat("System Message: "+ $_.Exception.ItemName))
                    Add-Content .\$LogFileName_Error -Value ([string]::Concat("************************************"))
                    continue
 
  }

  Remove-PSSnapin Microsoft.SharePoint.PowerShell
By at No comments:

Wednesday, April 22, 2015

PowerShell to get list of SharePoint Folders Names , Files counts and File Name in the CSV format 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")


$webUrl ="http://sp2010:23934/TEST" # Weburl till the Library
$listName = "TEST" # Document Library Name
$destination=".\"

$Datetime= Get-Date -Format dd_MM_yyyy_HH.mm.ss 
$LogFileName=([string]::Concat("DPN_LogFile " , $Datetime ,".csv"))
     New-Item  .\$LogFileName  -ItemType file 
        "variable initialization completed.."
        


$sc = New-Object Microsoft.SharePoint.SPSite($webURL)
$web = $sc.OpenWeb()
$list = $web.Lists[$listName]
$folderscount = 0
$folderswithresumes =0
$filesCount =0
$folderscount = $list.Folders.Count
Add-Content  .\$LogFileName -Value $webUrl
 Add-Content  .\$LogFileName -Value "Number of Folders : $folderscount"
 Add-Content .\$LogFileName -Value ([string]::Concat("GUID_Name" +","+ "Files_Count"+","+ "File_Name"))

 #Folder Name in each of the folder
foreach ($folder in $list.Folders) 
{
   $FileNames=""
   $foldFirstLvl = $list.ParentWeb.GetFolder($web.Url + "/" + $list.RootFolder.Url + "/" + $folder.Name)
   $filesCount = $foldFirstLvl.Files.Count
   
   #File Counts from each SP folder
   foreach ($file in $foldFirstLvl.Files) 
   {
 $FileNames = $FileNames + ","+ $file.Name
   }
   $FileNames = $FileNames.trim(",")
   Add-Content .\$LogFileName -Value ([string]::Concat($folder.Name +","+ $filesCount +","+ $FileNames))
   
   
}


$web.Dispose()
By at No comments:

PowerShell to delete the SPFolder from the SharePoint Document Library using input CSV file. 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
$snapinName = "Microsoft.SharePoint.PowerShell"  
 if ((Get-PSSnapin | Where-Object {$_.Name -eq $snapinName }) -eq $NULL) {  
  write-host "SharePoint SnapIn not loaded. Loading..."  
  Add-PSSnapin $snapinName -ErrorAction SilentlyContinue  
 }  
 #Change the URL for different environment.  
 #$webUrl = "http://usdttdevbq005:1000/sites/Test/"  
 #$listUrl = "http://usdttdevbq005:1000/sites/Test/Resumes/"  
 $webUrl = "http://sp2010:23934/"  
 $listUrl = "http://sp2010:23934/TEST/"  
 $destination=".\"  
 $Datetime= Get-Date -Format dd_MM_yyyy_HH.mm.ss   
 $InputCSVFile=".\Input_GUID.csv"  
 #Log file name   
 $LogFileName=([string]::Concat("Output_GRR_Bulk_DeleteFolder_Log" , $Datetime ,".txt"))  
 $ListOfGuidNotFound=""  
  Try  
     { # Start Try  
    New-Item .\$LogFileName -ItemType file   
     "variable initialization completed.."  
     Add-Content .\$LogFileName -Value "--->  variable initialization completed.."  
     $web = Get-SPWeb -Identity $webUrl  
     $list = $web.GetList($listUrl)  
     "Document Library access.."  
     Add-Content .\$LogFileName -Value "--->  Document Library access.."  
     $userGUIDCollection=import-Csv $InputCSVFile | where {$_.key -eq $keyword} |select UserGUID   
     "Read the CSV.."  
     Add-Content .\$LogFileName -Value "--->  Read the CSV.."  
 #Main start  
 #Download files in folders  
  foreach($VaruserGUID in $userGUIDCollection)  
  {  
     "working for CSV GUID : " + $VaruserGUID.UserGUID.Trim().ToString()  
      Add-Content .\$LogFileName -Value ([string]::Concat("`r`n--->  working for CSV GUID : ",$VaruserGUID.UserGUID.Trim().ToString()))  
    $varTemp = 0  
   foreach ($folder in $list.Folders)   
   {# Start of For  
       If($VaruserGUID.UserGUID.Trim().ToString() -eq $folder.DisplayName.Trim().ToString())  
     {  
       "GUID Matches : " + $VaruserGUID.UserGUID.Trim().ToString()  
       Add-Content .\$LogFileName -Value ([string]::Concat("--->  GUID Matches with Resume folder name : "+ $VaruserGUID.UserGUID.Trim().ToString() ))  
       $list.Folders.DeleteItemById($folder.ID)   
                  Add-Content .\$LogFileName -Value ([string]::Concat("--->  Folder has been deleted for : "+ $VaruserGUID.UserGUID.Trim().ToString() ))  
        $varTemp = 1  
     }  
   }#End of For  
       If($varTemp -eq 0) # Checking that the GUID is found in Resume folder, Yes or No  
     {  
       $ListOfGuidNotFound = $ListOfGuidNotFound.Trim().ToString() +"`r`n"+ $VaruserGUID.UserGUID.Trim().ToString()  
     }    
 }  
   Add-Content .\$LogFileName -Value ([string]::Concat("`r`n*******START*** GUID Not Matches with Resume folder for GUID Start***********`r`n"+ $ListOfGuidNotFound +"*******END*** GUID Not Matches with Resume folder for GUID END***********`r`n"))  
     } # End Try  
   catch   
   {  
           $ErrorMessage = $_.Exception.Message  
           Add-Content .\$LogFileName -Value ([string]::Concat("************************************"))  
           Add-Content .\$LogFileName -Value ([string]::Concat("**********Error with writing files to folder*******************"))  
           Add-Content .\$LogFileName -Value ([string]::Concat("System Message: ",$ErrorMessage))  
           Add-Content .\$LogFileName -Value ([string]::Concat("************************************"))  
           continue  
   }
By at No comments:

Powershell to create SharePoint folder in SharePoint Library with adding two different set of files 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
#Create Folder from the given Range and copy the file
# Keep the file in C:\mydoc.txt

$snapinName = "Microsoft.SharePoint.PowerShell"
if ((Get-PSSnapin | Where-Object {$_.Name -eq $snapinName }) -eq $NULL) {
  write-host "SharePoint SnapIn not loaded. Loading..."
  Add-PSSnapin $snapinName -ErrorAction SilentlyContinue
}
$webUrl = "http://sp2010:23934/"
$listName = "TEST" #Document Library
$StartCounterGUID=1000; #Starting Folder number
$EndCounterGUID = 1003; #End Folder number



 Try
       { # Start Try 
       
                # Open web and library
                $web = Get-SPWeb $webUrl
                $list = $web.Lists[$listName]
                 
                # Create desired number of subfolders
                for($i=$StartCounterGUID; $i -le $EndCounterGUID; $i++)
                {
                $folder = $list.AddItem("", [Microsoft.SharePoint.SPFileSystemObjectType]::Folder, "$i")
                $folder.Update()

                $spFolder = $web.GetFolder("$listName\$i")
                # Get the file on Disk that we want to upload
                $file = Get-Item C:\mydoc.txt
                # upload the file.
                write-host "$listName\$i\mydoc.txt"
                [Microsoft.SharePoint.SPFile]$spFile = $spFolder.Files.Add("$i"+"mydoc.txt",$file.OpenRead(),$false)
                     
                $spFile.Item["Title"] = "$i"+"mydoc.txt"           
                $spFile.Item.Update()

                write-host "$listName\$i\yourdoc.doc"
                [Microsoft.SharePoint.SPFile]$spFile = $spFolder.Files.Add("$i"+"yourdoc.doc",$file.OpenRead(),$false)
                     
                $spFile.Item["Title"] = "$i"+"yourdoc.doc"    
                 #$spFile.Item["GUID"] = "$i"+"yourdoc.doc"          
                $spFile.Item.Update()

                write-host $i
                }
                $web.Dispose() 
              
              
    }
     
                
     catch 
   {

                 
      $web.Dispose() 
                    write-host  "Web Disposed"
                    $ErrorMessage = $_.Exception.Message
                    write-host  $ErrorMessage
                    continue
   
    }
By at No comments:
Subscribe to: Posts (Atom)

HTML

Script:

JS