A great toolkit for SharePoint multiple files operations

This article describes how you can easy solve any SharePoint bulk files issue, using Virto SharePoint Bulk Operations Toolkit.

SharePoint Alerts and Reminders
SharePoint Gantt Chart Web Part

This tool consists of eight Virto components intended to quick working with SharePoint bulk files. You can copy, upload/download, delete, unzip, check in and edit multiple files, using this ready-to-use web parts for SharePoint bulk operations.

SharePoint Bulk File Upload allows you to upload multiple files into the document library with drag & drop and helps you get the job done! You can monitor the file uploading process and overwrite existing files if it is required.


You can also try a Html5-based SharePoint File Upload Web Part for SharePoint 2013. Using this web part, you can easily drag and drop SharePoint bulk files without adding files one by one.

SharePoint Bulk File Download Web Part allows you to download multiple files from SharePoint 2013, 2010 or 2007 libraries into single .zip archive. Just choose multiple files for downloading with checkboxes and store it at your local disk.


SharePoint Bulk File Unzip web part allows you to easily unpack bulk archives and save extracted files to the document library, keeping structure of original zipped folder. Existing files overwriting option is also supported. 

Also, you can quickly delete multiple files with SharePoint Bulk File Delete web part. Save your time by deleting SharePoint files in large, instead of deleting them individually.


SharePoint Bulk Data Edit web part allows you to edit multiple data all at once, just open a SharePoint list or Document Library and choose fields for editing. You can configure Bulk Edit web part for any SharePoint list or site scopes. With SharePoint Bilk Data Edit, you can save enormous amount of time without manually editing each document individually.


With SharePoint Bulk Check In and Approve web part, you can quickly check in and approve a large group of previously uploaded and currently checked-out documents. You can decide whether the files are checked in as published or draft versions. 


Using SharePoint Bulk File Copy and Move web part you can copy and move multiple files from SharePoint Library to a certain place. You can display all files of the chosen Document Library as a tree and choose files for moving. 


You can try every single web part or all this components combined in a single bundle. Enjoy all eight components of SharePoint bulk operations toolkit at a very attractive price. Learn more about this special offer and save over 40%!

Exclude search results for a specific site

Exclude search results for a specific site
In this article we can learn how to exclude search results for a specific site collection/site while creating a new result source in SharePoint 2013.


We are having a web application's URL’s and site collection URL that you want to exclude.

http://includeresults.com/ -------- we can search
http://SearchResults.com/  ------  we can search
http://SearchResults.com/sites/exclude  - we want to exclude this site from search   
          
Now we want to exclude this site collection/Site from the (http://SearchResults.com/sites/exclude) search results. Same way we can exclude the sites/sub sites also.


We are excluding the site using the property filter “not contains”, Please check the below screen shot.

Once everything is done, click on OK and finally save the Result Source.

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

How to send email using nintex workflow

 In this article we are showing a basic example how to send email using nintex workflow.

Here we are having a list with name “Basic Nintex Work Flow” with columns Title and Send mail columns as shown below.



In the top ribbon click on Workflow Settings to Create a Nintex Workflow

Select the Temple, we are selecting the Blank Template.
Click on Create


Drag and Drop the Send Notification as per the below screen shot


Click on drop down and click on configure.
Click on Addressbook
Click on Lookup in item properties select the field that you want to add on To address click ok.

Enter the Subject and adding test content inside the Body for Mail.


Click on Save.
In top ribbon workflow setting, we can trigger the workflow based on our requirement, in our case we are triggering the work flow once item is added or modified in the list.

Finally save and publish the workflow

Again go the list, enter the item with Title name and Send mail column with valid user.

Conclusion:
Now everyone know how to create a basic work flow in Nintex.
Please let me know having any doubts on this article.

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

SharePoint Interview Questions

SharePoint Interview Questions
In this Post we can able to see the SharePoint Interview Questions on Master Page.
These question will be same for SharePoint 2010 and 2013.

1) What is the difference between SharePoint 2010 and 2013?
2) What is master page in SharePoint?
3) How many ways we can customize master page?
4) What is Feature Stapling?
5) What is Layout Page?
6) What are different type of master pages in SharePoint 2010 and 2013?
7) How to maintain custom master page for a particular site?
8) How to hide search box in a master page?
9) How to hide the Site Contents in a master page?
10) How to add user control in master page?

11) How to inherit the master page from site collection level to sites and its sub sites?

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

How to Schedule PowerShell Script

In this article we are able to show how to Schedule PowerShell script using task scheduler.
Scheduling the PowerShell script is very easy, once we schedule the task it will start automatically without our interaction.

Start Programs -> Enter Task Scheduler.
 PowerShell
Right Click on Task Scheduler and click on Create Task as shown below.
In General Tab
Enter the Name and Change the options as per the Screen Shot
 PowerShell
In Triggers Tab, Click on New schedule the task as per your requirement.
In Actions Tab
Program/Script option browse the PowerShell.exe location
C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
Add Arguments (optional):- Add the PowerShell that you want to schedule.
Click on Ok.
In the Task Scheduler library we can able to see the Scheduled Jobs.
It will run automatically as per your scheduled time.
Please let me know having any doubts on this article.

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

How to debug PowerShell

Here we are able to learn how to debug PowerShell script, without an error we cannot complete the script in a single shot, we have to debug the code have to identify the issue need to fix it.
In PowerShell for debugger we can use windows PowerShell ISE
In Start enter the name PowerShell
Open the Windows PowerShell ISE


If you want to debug the code
Place the cursor and Press F9 or in the top menu place the cursor click on the Toggle Break Point where ever in the code you want o debug.


F10 is used to debug line by line in the current function or method.
F11 is used to debug line by line and also to debug inside the Methods or Functions.


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

How to upload zip files in blogger

We want to upload zip files in to our blogger to download the source code for readers, but we did not find any option in the blog settings to add ZIP or RAR files.
Using the Google sites we can able to add the ZIP files in to our blog.
Login with your Gmail account credentials.

Click on CREATE.
As per the screen shot below
Select the Template that you want to create
Enter the Name of your site
Site location
At last check the Check box “I’m not a robot
Click on to Create page
Enter the Page Name
In the Template to use select “File Cabinet
Click on Add file, Select the file that you want to upload.
In the browser we can able to see the URL, Give the URL link  in the Blog Post, so that everyone can able to download  the ZIP or RAR Files easily.

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

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.



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

 Read xml in PowerShell
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

How to create a field in SharePoint using client object model

How to create a field in SharePoint using client object model
In this article we want to show how to create a field in list using client object model
We are having a requirement to create a new fields in SharePoint site which is in different server, so we created a console application and implemented the code using client object model to create a new fields in the list as shown below.

This is a sample example to create new fields.

using Microsoft.SharePoint.Client;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Text;
using System.Threading.Tasks;

namespace Newfield

{
    class Program
    {
        static void Main(string[] args)

        {
            ClientContext context = new ClientContext( "http://dotnetsharepoint.com/sites/sharepoint/");
            context.Credentials = new NetworkCredential("username", "password", "domain");
            context.Load(context.Web);
            List c_list = context.Web.Lists.GetByTitle("YourListName");
             Field newfields = c_list.Fields.AddFieldAsXml("<Field
DisplayName = 'YourFieldName' Type = 'Text' />", true, AddFieldOptions .DefaultValue);
            FieldText textfield = context.CastTo<FieldText>(newfields);

            textfield.Update();
               context.ExecuteQuery();

        }
    }
}




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

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.

We tried to delete the list in SharePoint 2013, we clicked on remove suddenly we got the error message like “The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator”.


Cause: As per the error message we identified that we have to change the list view threshold at Central Admin Level.
Resolution:
Open CentralAdmin->Manage webapplciations->Select the Particular web application (that you are getting the threshold error)->In the Top ribbon->Click on General Settings->Click on Resource Throttling .
In the first option we can able to see the List View Threshold default value is 5000, change the value as per your error, in my case I am changing to 25000, Click on ok.

Now we can able to delete list without any issues.

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

Hide the list in SharePoint using PowerShell

In this article we are able to see how to hide list from SharePoint site collection, site or sub site.
We don’t want to show the list’s or document libraries to the Users in the site and also we want to hide it from quick launch, for that we can hide it easily using PowerShell script.

Add-PSSnapin Microsoft.SharePoint.Powershell
$web = Get-SPWeb "http://dotentsharepoint.com/sites/sharepoint/hidelist";
$list = $web.Lists["HideList"];
$list.Hidden = 1; //hiding the list in site contents
$list.OnQuickLaunch = $false; // hiding the list in quick launch
$list.Update();


In this same way if you want to show it again use the below script

Add-PSSnapin Microsoft.SharePoint.Powershell
$web = Get-SPWeb "http://dotentsharepoint.com/sites/sharepoint/hidelist";
$list = $web.Lists["HideList"];
$list.Hidden = 0; //showing the list in site contents
$list.OnQuickLaunch = $true; // showing the list in quick launch
$list.Update();


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

SharePoint Alerts and Reminders by VirtoSoftware

SharePoint users often need to send group and individual SharePoint notifications and alerts about creating, deleting or changing  list items (item level alert), documents, lists (list level alert), or document libraries via email.  Alerts in SharePoint Services often require more comprehensive adjustment in addition and can seem very limited.



Virto SharePoint Alerts and Reminders Web Part provides you with additional adjustment features. Now you can manage all your SharePoint notifications from a user friendly, centralized interface.

 SharePoint Alerts and Reminders by VirtoSoftware

SharePoint Alerts and Reminders Web Part allows sending SharePoint alerts and notifications not only by e-mails, but also by SMS or XMPP-Server to Jabber or Miranda Users. SharePoint alerts can be managed by users and administrators and customized by developers. Easy-to-use interface allows setting up different terms and conditions for SharePoint notifications which makes SharePoint Alerts System even more flexible and useful.
When there are too many reasons for sending SharePoint alerts and reminders to users, it is hard not to get lost in these lots of alerts. With SharePoint Alerts and Reminder web part you can use message templates and just define the frequency of sending. You'll save much time! Combine several SharePoint alerts for a user into one message and inform users on all system changes in a single SharePoint alert. This may help you avoid spamming your team or remind them of specific messages.

An important feature with the SharePoint Alerts and Reminder Web Part is the ability to create your own SharePoint alerts in Rich Text format.
 SharePoint Alerts and Reminders by VirtoSoftware
You can also define the frequency of SharePoint alerts by simple choosing one of the following options: send alert immediately, hourly, daily or weekly. SharePoint notifications can also be sent within a specified timetable (i.e., send email or sms alert only within business hours — from 8 AM to 5 PM)
With Virto SharePoint Alerts and Reminders Web Part it’s hard to skip or forget you task and events. So you can improve business processes and increase productivity.

Further information about the product and a free 30-day trial can be found at the product page.


How to populate values from one list to another list using JQuery in SharePoint

In this article we have to show, how to populate values from one list to another list.
We are having two lists one is Config and other one is SharePoint List
In Config list we are having columns like Title and Body

In SharePoint List Having Title, Platform and Body
While creating the Platform Column we selected the lookup type selected the Config List and Click Ok.
We uploaded the Script in the Site Assets Library, in the SharePoint List in the NewForm.aspx edit the page add the content editor refer the script path.
<script type="text/javascript" src="/sites/dotnetsharepoint/SiteAssets/jquery-1.11.0.min.js"></script>
<script type="text/javascript" src="/sites/dotnetsharepoint /SiteAssets/jquery.SPServices-2014.01.min.js"></script>
<script language="javascript" type="text/javascript">
$(document).ready(function()
{
$('select[title^="PlatForm"]').change(function() {

pathName=$("select[title^='PlatForm'] option:selected").text();

$(".ms-rtestate-write").html('');
                $().SPServices({
                                                operation: "GetListItems",
                                                async: false,
                                                listName: "Config",
                                                CAMLQuery:"<Query><Where><Eq><FieldRef Name='Title'/><Value Type='Text'>"+pathName
+"</Value></Eq></Where></Query>",
                                                completefunc: function (xData, Status)
                                                {
                                                                $(xData.responseXML).SPFilterNode("z:row").each(function()
                                                                {
                                                                               
                                                                bodycontent= $(this).attr("ows_Body");
                                                                                $(".ms-rtestate-write").html(bodycontent);
                                                                                $("span[role='alert']").hide();
                                                                });
                                                }
                 });
});
$('select[title^="PlatForm"]').prepend('<option selected ="selected" value="">Select</option>');
$('select[title^="PlatForm"]').eq(0).selectedIndex = 0;
$('select[title^="PlatForm"]').val('');
});
</script>
Finally we can able to see the Output as shown below.
  
 SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

How to delete items in list using PowerShell

How to delete items in list using PowerShell
In this article we are able to see how o delete items in the list using PowerShell.
Some cases we have to delete items from the list, doing it manually it will take time to delete items, we can do it easily while spending a little bit time on PowerShell and we can reuse the PowerShell where ever we need.
$web = Get-SPweb "http://dotnetsharepoint.com/sites/sharepoint/deleteitems"
$list = $web.Lists[“ListNameHere”]
$items = $list.items
foreach ($item in items)
{
$deleteitem=$list.GetItemById($item.ID)
$deleteitem.Delete()

}

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

How to create calculated formula in SharePoint using PowerShell

How to create calculated formula in SharePoint using PowerShell

What is calculated field?
Calculated field option is available in the “Out Of the Box”, which we are able to combine two or more fields, comparing the dates to get the output as per the user requirement.

 Add-PSSnapin Microsoft.SharePoint.PowerShell
 $web = Get-SPweb "http://dotnetsharepoint.com/sites/sharepoint/calcalated"
$list=$web.Lists["EmployeeInfo"]
 $list.Fields.Add("Full Name", "Calculated", 0)
 $field = $list.Fields.GetField("Full Name")
 $field.OutputType="Text"
 $field.Formula="=CONCATENATE([FirstName],[LastName])"
 $field.update()
$web.Dispose()

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

How to create a site collection using PowerShell

How to create a site collection using PowerShell
In most of the times we will use PowerShell commands to create a site collection, also we can easily specify the database name that we want to point to that particular site collection using PowerShell.


New-SPsite: is used to create to a top level site URL
-OwnerAlias: is the owner of that site collection
-Template: is used to create a template type based on requirement
-Name: is the name of our site collection
-Description: is to give description about our site collection

Creating Site Collection Command
New-SPsite -Url http://dotnetsharepoint.com/sites/sharepoint  -OwnerAlias domain\username             -Template "STS#0" -Name "site name" -Description "description about the site”

Creating Site Collection with particular database Command

New-SPsite -Url http://dotnetsharepoint.com/sites/sharepoint  -OwnerAlias domain\username             -ContentDatabase  databasename -Template "STS#0" -Name "site name" -Description "description about the site”


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

Hide columns in list using client side object model in SharePoint

Hide columns in list using client side object model in SharePoint
We are having a requirement to hide the unwanted columns in the NewForm.aspx and EditForm.aspx using client side object model.
We are using the Properties SetShowInNewForm, SetShowInEditForm to hide the fields in a particular list, if you want to show it again change it to (true)


using Microsoft.SharePoint;
using Microsoft.SharePoint.Client;
using Microsoft.SharePoint.Client;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace hidecolumns
{
    class Program
    {
        static void Main(string[] args)
        {
            ClientContext clicon = new ClientContext("http://dotnetsharepoint.com/sites/SharePoint");
            List list =clicon.Web.Lists.GetByTitle("yourlistname");
            clicon.Load(list);
            list.Fields.GetByInternalNameOrTitle("YourColumnName").SetShowInNewForm(false);
            list.Fields.GetByInternalNameOrTitle("YourColumnName").SetShowInEditForm(false);
            clicon.ExecuteQuery();
            list.Update();
      
        }
    }

}

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

SharePoint Gantt Chart Web Part

I recently had the opportunity to write some reviews for different SharePoint products.
I will start with Gantt Chart App by VirtoSoftware, this is a project planning solution for viewing SharePoint tasks as a Gantt Chart. 
 I’ve looked this software over a bit and had conversations with the people behind the offerings and I’ve been very impressed with the overall functionality of this software as it pertains to the enterprise and how complete it`s capabilities are. 

About This Software
Virto Gantt Chart App is a highly customizable SharePoint project management tool intended for displaying and managing SharePoint tasks in a Gantt Chart view. This app is providing you a rich and interactive Gantt user interface for managing SharePoint project tasks and resources.  It is available as an app for SharePoint Online and as a web part for SharePoint 2013, 2010 and 2007.

Even non-technical user can easily maneuver the product with intuitive interface.
http://www.virtosoftware.com/sharepoint/gantt-chart-view-web-part?utm_source=dotsharepoint&utm_medium=blog&utm_campaign=bloggers
Here are a few more reasons why I would recommend Virto Gantt Chart as the tool of choice for SharePoint project management:

You can display several lists with tasks in one SharePoint Gantt chart and define colors for tasks/summary tasks/milestones/percent complete. It is easy to customize the look and visualize tasks and regions of interest with custom colors.

http://www.virtosoftware.com/sharepoint/gantt-chart-view-web-part?utm_source=dotsharepoint&utm_medium=blog&utm_campaign=bloggers
You can edit (adding/moving/deleting/resizing) tasks or milestones directly in the Gantt chart.
http://www.virtosoftware.com/sharepoint/gantt-chart-view-web-part?utm_source=dotsharepoint&utm_medium=blog&utm_campaign=bloggers
You are able to apply different timescales to view items (day, week, month, year) and scroll Gantt chart to the required period of time, e.g. scroll to current day tasks.
http://www.virtosoftware.com/sharepoint/gantt-chart-view-web-part?utm_source=dotsharepoint&utm_medium=blog&utm_campaign=bloggers
You can create sub tasks for selected tasks, define finish-to-start relations between tasks and create successors and predecessors by simple arrows drag-and-drop.
http://www.virtosoftware.com/sharepoint/gantt-chart-view-web-part?utm_source=dotsharepoint&utm_medium=blog&utm_campaign=bloggers
It is easy to change task duration and percentage of completion with drag and drop.
http://www.virtosoftware.com/sharepoint/gantt-chart-view-web-part?utm_source=dotsharepoint&utm_medium=blog&utm_campaign=bloggers


Try it for yourself!

If you would like to try Virto Gantt Chart for yourself, I highly encourage you to start a
30-Day Trial where you can experience the entire product for free.
You can download Gantt Chart app or Gantt chart web part for SharePoint 2013, 2010 and 2007.

For more information about VirtoSoftware, visit their website http://www.virtosoftware.com/


Enable the calculated value option in SharePoint using PowerShell.

In this example we are able to show how to select the calculated value property using PowerShell, as per our requirement we have to show the X years date while creating a new item using the calculated formula we are unable to the field in NewForm.aspx, but using the Calculated value option we can show the filed in the NewForm.aspx Page.

  Import Data from excel to SharePoint List using PowerShell
 How to add fields to list in sharepoint using powershell 
Copy value from one filed to another field using PowerShell - See more at: http://www.dotnetsharepoint.com/2015/07/copy-value-from-one-filed-to-another.html#sthash.QPHZ7Tjz.dpuf
 Copy value from one filed to another field using PowerShell 
Date formula in SharePoint calculated value
 Date formula in SharePoint calculated value 

Add-PSSnapin Microsoft.SharePoint.PowerShell
$web = Get-SPWeb "http://dotnetsharepoint.com/sites/sharepoint/enableformula"
$list = $web.lists["ListName"]
if($list.Fields.ContainsField("Date") -eq $true)
 {
      Write-Host  "Field Date already avilable in the list"
      }
 else
 {
 $list.Fields.Add("Date","Date",$false)
 $list.Fields["Date"].DisplayFormat = "DateOnly"
 $DateField = $list.Fields.GetField("Date") #Get the field
 $DateField.DefaultFormula = "=DATE(YEAR(Today)+3,MONTH(Today),DAY(Today))"
 $DateField.update();
}


Once this PowerShell is completed we can able to see the Date field Calculated Value as shown below. 

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