Read xml using PowerShell in SharePoint

In this article we are showing how to read XML file using PowerShell, this is a sample example based on this we can develop the PowerShell scripts with config XML file, without touching the code modify the XML config file and send the mail based on the config file requirement, maintain the XML file will be very good and easy.

How to send email using PowerShell in SharePoint

How to send email with attachment in PowerShell

how to connect sqlserver using PowerShell

Here is the sample XML file to read the PowerShell for sending mail with to and from address with Subject and SMTP server information.

Here is the PowerShell code reading the XML file and sending Mail.

Add-PSSnapin Microsoft.SharePoint.Powershell

[xml]$xmlfile = Get-Content D:\Reading.xml

 $EmailFrom = $xmlfile.mail.mailFrom

  $EmailTo = $xmlfile.mail.mailTo

 $EmailSubject = $xmlfile.mail.mailSubject

 $SMTPServer = $xmlfile.mail.SMTPRelay

$mailmessage = New-Object system.net.mail.mailmessage

$mailmessage.from = ($EmailFrom)

$mailmessage.To.add($EmailTo)

$mailmessage.Subject = $EmailSubject

$mailmessage.IsBodyHTML = $true

$SMTPClient = New-Object  Net.Mail.SmtpClient($SMTPServer) 

$SMTPClient.Send($mailmessage)

SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

Read More»

Copy value from one filed to another field using PowerShell

In this example we are showing how to copy values from one item to another item.

We are having a column with multi-level field type we are unable to do Group by for this field, so we planned to change the field type to text and copy the values from Multi type field to Single line of Text, best option to achieve this functionality is PowerShell

 How to import users from CSV to SharePoint site using PowerShell

How to update the modified by using power shell

How to add fields to list in sharepoint using powershell

How to create topic for discussion board in sharepoint using powershell

 

 Add-PSSnapin Microsoft.Sharepoint.Powershell

    $web =  Get-SPWeb -Identity http://dotnetsharepoint.com/sites/sharepoint/copyitems

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

    $items = $list.items

    foreach ($item in $items)

    {

    $sourcevalue = $item["SourceColumn"]

    $item["DestinationColumn"] = $sourcevalue

    write-host $sourcevalue

    $item.update()

    }

    $list.update()

Please let me know having any issues.

 SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

Read More»

How to get the field guid using PowerShell

Using PowerShell we can get the field guid easily in our SharePoint.

# to get the site that you want to hide the column

$Web = Get-SPWeb  http://dotnetsharepoint.com/sites/sharepoint/

#Get the list you want to access

$listname = $web.Lists["YourListName"]

#Get the field that you want to get guid

$ListCol = $listname.Fields["YourFieldName"]

Write-host "List column GUID is:"$ListCol.id

Run the Power shell script in the Management Console, Hit Enter we can easily get the output.

Read More»

How to remove SPWebApplication using powershell script in SharePoint 2013

         Remove-SPWebApplication cmdlet deletes the Web application specified by the Identity and Zone parameters. If no zone is provided, the entire Web application and all zones are removed.

Remove particular zone:

    Get-SPWebApplication "http://sitename"|Remove-SPWebApplication -Zone "Intranet" -Confirm

    Identity: http://sitename. 

             It removes the Internet zone Web application extension on the Web application at http://sitename. This command does not remove the content databases or the IIS Web site.

Remove Perticular web application content databases and IIS website :

    Remove-SPWebApplication http://sitename -Confirm -DeleteIISSite -RemoveContentDatabases

         It removes the Web application, all content databases, and the IIS Web site at http://sitename

Read More»