SharePoint, C#, CAML, LINQ, XML, XSLT, HTML5, CSS

3/12/2014

0
Office 365: Migrating and Managing Your Business in the Cloud (FreeeBook)

Office 365 Migrating an Managing Your Business in the Cloud
Written for the IT professional and business owner, this book provides the business and technical insight necessary to migrate your business to the cloud using Microsoft Office 365.  This is a practical look at cloud migration and the use of different technologies to support that migration.  Numerous examples of cloud migration with technical migration details are included.

Cloud technology is a tremendous opportunity for an organization to reduce IT costs, and to improve productivity with increased access, simpler administration and improved services.  Those businesses that embrace the advantages of the cloud will receive huge rewards in productivity and lower total cost of ownership over those businesses that choose to ignore it.

The challenge for those charged with implementing Microsoft Office 365 is to leverage these advantages with the minimal disruption of their organization.  This book provides practical help in moving your business to the Cloud and covers the planning, migration and the follow on management of the Office 365 Cloud services. 

What you’ll learn

-Overview of Microsoft Office 365's operation and usage for any size enterprise
-Methods of planning and migration
-Office 365 management best practices
-Using Office 365 SharePoint to improve business processes
-Troubleshooting Office 365 installations
-Using Compliance, eDiscovery and Data Loss Prevention tools
-Office 365-site management best practices for IT administrators and business owners


Who this book is for

Small-enterprise IT professionals and business owners who have the admin responsibilities for their business-IT needs. These people need refined reference information on basic set-up and configuration for their Office 365 installations, as well as best-practice-driven instruction on managing and troubleshooting their systems.

eBook Price: $0.00
Free eBook:- Office 365: Migrating and Managing Your Business in the cloud


Thanks & have fun! :)

10/21/2013

0
Site and Site Collection Retention Policy in SharePoint 2013

One of the biggest problem we face in our SharePoint environment is site retention.  Whenever our users request us with new site collections/sites, we tend to ask to them to clear the security test and we create a new site collection or site.  The problem is, managing the site collections/sites.

Lots off users request sites for either long term projects, short term projects, team spaces, etc., and then they tend to forget to manage it.  These sites will reserve a big amount of space, in addition to that is a mailboxes if they have.

So finally, to resolve all the above issues (till certain point), SharePoint 2013 has came to rescue.  The new “thing” called SharePoint Server 2013 Site (or Site Collection) Policy.

As you can see from the above figure, it allows you to create a Site (or Site Collection) Policy which can be applied to restrict site’s long living life.

Site Closure and Deletion

The difference between site closure and site deletion is, site closure means that when the site is put into the closed mode, the site will NOT be active anymore, means the site is not being updated or being actively used.  You can also manually put the site on closure but to reopen the closed site, you will have to go through the site collection administrators.  When the site is being put onto the closure mode, the system will put site into read-only mode as well.  (in this case as well, only site collection administrators will be able to reopen the site).

Though the users/admins/developers can continue using the site as well as it’s contents, whereas site deletion means the site will be permanently deleted with all of it’s content.

Now, sometimes you will have to postpone the above activity, in that case, the site owner can manually delay the site deletion for a particular period of time (assign by the site policy), if not, then the e-mail would be sent to the site owners before deletion of the site and site will be deleted if no action taken.

By using the above technique, you can always apply site collection policies to each and every new site being requested, which will be deleted if not being used for a certain period of time, ensuring you will save space on your server.  This is also helpful when you want to create a site but doesn’t want to allow any changes.

You can put the site into the closure mode, making it a read-only site and avoid the deletion (I wouldn’t recommend that ), once you define the policy to be applied, you can either directly apply it using the publishing feature from the content hub or apply them during the site creation time where in users will have an option to select.  Check out the Configuring Self Service Site Creation in SharePoint 2013.

Once you set it up, you can go to Central Administration -> Self-Service Site Creation Administration and choose from below three options to make it available to the users.

Once applied, the users will be able to choose the policies while requesting a new site.

Thanks & have fun!!

Reference : Steven Boyle

10/02/2013

0
Change List URL in SharePoint 2010

Hey Guys,

You know we always messed up with list names in SharePoint 2010, isn't it? Yeah, so me too.

Anyways, so I found the solution to change the URL of the List, basically, there are three ways (which I know of),

First of all:

You can use SharePoint Designer 2010

1.  Open your SharePoint Site using the SharePoint Designer 2010
2.  Go to your list node from all items
3.  right click onto the list node and you can rename it

You can use Windows Explorer

1.  Browse any of your document library in the site
2.  From the default view, click on the “Open with windows explorer” option from the ribbon .
3.  In the windows explorer, go to the root folder of the site.
4. From root folder, go to the library or list you want to change.
5. Right click on the folder and rename it.

You can use PowerShell

Open the list from the site and change the root folder of the site:
if($list -ne $null){
$list.RootFolder.MoveTo($list.RootFolder.Url.Replace($oldlistname, $newlistname));
}


Thanks and have fun!! :)

9/27/2013

0
Using LINQ to get roll-up data from SharePoint List (DataSet, DataTable, Excel, etc.)

Hey Guys,
You may find lots of topics and questions posted by [Me] onto the internet for this particular question.

How to use LINQ to get roll-up data?

So, here is the scenario.

I have one SharePoint List as below (you can make DataSet, DataTable, Excel anything you want)

ColumnA     ColumnB      Status
Project1      Task1.1           Completed
Project1      Task1.2           Pending
Project1      Task1.3           Completed
Project2      Task2.1           Completed
Project3      Task3.1           Completed
Project3      Task3.2           Completed
Project3      Task3.3           Completed
Project3      Task3.4           Pending
Project3      Task3.5           Pending

What I need from the above data is:

Project1 66.67 ((Completed Task / Total Task) * 100)
Project2 100
Project3 60

So basically, all I am looking for is rolling up the data and finding the total percentage of project completion.

Easy, huh?

Let's see, so here's the code: (Thanks to Paul Choquette)

var returndata = (from geo in dt.AsEnumerable()
orderby geo["ColumnA"] descending
group geo by geo["ColumnA"] into itemgroup
select new
{
Project = itemgroup.Key,
Percentage = (double)itemgroup.Count(i => (string)i["Status"] == "Complete") / (double)itemgroup.Count() * 100,
}).ToList();

That's it!!

Let me know in case you want anything more from this code ;)

Have fun!!

4/17/2013

0
Hide "Search This Site..." in SharePoint 2010

Hey Folks,

So, you want to hide "Search This Site..." Box which is located at Top-Right of the SharePoint Site?

Image

It's pretty simple!! (Though initially I tried search it a lot and got many different options but none worked!! :( )

So Finally, I found a solution which actually worked.

Steps:
  • Add a Content Editor Web Part (CEWP)
  • Edit The Web Part and click the Source Editor Button
  • Paste the following:
   <style>
     #SRSB {display:none}
   </style>


Hide It on all Pages:
  • Use SharePoint Designer to edit your master page and put the above style tag just after the SharePoint style controls
   <SharePoint:CssLink runat="server"/>
   <SharePoint:Theme runat="server"/>   <style>
     #SRSB {display:none}
   </style>