Archive | SharePoint 2010 RSS for this section

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!! 🙂

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!!

SharePoint 2010 Development Series – Part 2

There are two ways we can make a site collection:

1.  Through Central Administration

2.  Programmatically

We show how to create site collection through Central Administration in Part 1 of this article. I’ll explain how to create site collection Programmatically (Using Visual Studio 2010) in this article.

2. Programmatically

1. Click on Start -> All Programs -> Microsoft SharePoint 2010 Products -> SharePoint 2010 Central Administration

2. Under Application Management, select Create site collections

3. Please add the details like Title, Description, URL and site template etc. (See into the screen shots for details)

4. Press OK Button.

5.  After you press OK Button, You will see your newly created SharePoint 2010 Site Collection Successful Message.

6.  Click on URL.

Thanks and Have fun!!

Show/Display Multiple InfoPath Views using InfoPath Form Web Part in SharePoint 2010

Hey Folks!!

I guess I have already answered your question (if you have searched it on search engines 😛 )

That is, How To Show/Display Multiple InfoPath Views?

A little bit of background, I had a requirement where I need to create an InfoPath form with some data.

The catch was, I should create two views, Manager & Employee, and I needed to show the multiple views with direct link to the page.

Usually, you can right click on model dialog page where InfoPath forms opens, right click & copy the URL and directly assign it the way you like it.

But the problem is the InfoPath form will show the tab to switch between the views, also I didn’t wanted the users to switch to the views anyhow.

So, the answer is to use InfoPath Form Web Part

To be continued….

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>

SharePoint Code Analysis Framework (SPCAF) BETA Free

Finally Matthias Einig and Torsten Mandelkow published the SharePoint Code Analysis Framework (SPCAF) as the first public beta release.

Get it from here
Watch a demo video here

The SharePoint Code Analysis Framework (SPCAF) provides tools to analyze SharePoint code. This includes

  • SharePoint solutions (.wsp) for SharePoint 2007 / 2010 / 2013
  • SharePoint 2013 apps

SPCAF cannot only analyze assemblies like other tools as FxCop or SPDisposeCheck. It can also analyze all the XML code in SharePoint packages like Features, ContentTypes, ListTemplates and all the other files like controls (.ascx), pages (.aspx) and master pages (.master) etc.

SPCAF can be used directly in Visual Studio 2012 or 2010 to analyze SharePoint projects. It also provides a client application to analyze existing WSP packages, can be integrated into a Team Build via a custom build activity, it can be run on command line or as MSBuild task during each local build.

Highlights

Sample analysis results

Who should use it?

  • SharePoint Architects can ensure proper application design and detect violations against best practices
  • SharePoint Developers can ensure that their code is correct and that errors in XML code can be found early directly in Visual Studio and not only after deployment to SharePoint.
  • SharePoint Quality Assurance can ensure that WSP packages are developed according to the best practices and the e.g. Customization Policies are not violated.
  • IT Pros can ensure that the WSP files does not contain “dangerous” code and that they can install the packages without fear. The inventory reports gives a detailed overview about the contents in the packages and is a good documentation of the code.

Use SPCAF directly in Visual Studio

Get Errors and Warnings and open the files directly in VS

Visualize Dependencies

Use the client application to analyze existing WSPs or APPs

MSDN Blog Post

E-Book Gallery for Microsoft Technologies

Download content for ASP.NET, Office, SQL Server, Windows Azure, SharePoint Server and other Microsoft technologies in e-book formats. Reference, guide, and step-by-step information are all available. All the e-books are free. New books will be posted as they become available at here

E-Books in English

Lync Microsoft Lync Server 2013 Step by Step for Anyone 
Office Deployment guide for Office 2013
First Look: Microsoft Office 2010
Microsoft Office 365: Connect and Collaborate Virtually Anywhere, Anytime
Microsoft Office 365 for professionals and small businesses: Help and How To
Security and Privacy for Microsoft Office 2010 Users
SharePoint Explore SharePoint 2013
Deployment guide for SharePoint 2013
Create a Balanced Scorecard
Configure Kerberos Authentication for SharePoint 2010 Products
SharePoint Server for Business Intelligence
Get started with SharePoint Server 2010
Deployment guide for SharePoint Server 2010
Upgrading to SharePoint Server 2010
Profile synchronization guide for SharePoint Server 2010
Remote BLOB storage for Microsoft SharePoint Server 2010
Governance guide for Microsoft SharePoint Server 2010
Business continuity management for SharePoint Server 2010
Technical reference for Microsoft SharePoint Server 2010
SQL Server 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012
A Hitchiker’s Guide to Microsoft StreamInsight Queries
Books Online: Backup and Restore of SQL Server Databases
Books Online: Data Analysis Expressions (DAX) Reference
Books Online: Data Mining Extensions (DMX) Reference
Books Online: Data Quality Services
Books Online: High Availability Solutions
Books Online: Master Data Services
Books Online: Monitor and Tune for Performance
Books Online: Multidimensional Expressions (MDX) Reference
Books Online: SQL Server Distributed Replay
Books Online: Transact-SQL Data Definition Language (DDL) Reference
Books Online: Transact-SQL Data Manipulation Language (DML) Reference
Books Online: XQuery Language Reference
Extracting and Loading SharePoint Data in SQL Server Integration Services
Introducing Microsoft SQL Server 2008 R2
Introducing Microsoft SQL Server 2012
Master Data Services Capacity Guidelines
Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery
Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide
Optimized Bulk Loading of Data into Oracle
Planning Disaster Recovery for Microsoft SQL Server Reporting Services in SharePoint Integrated Mode
QuickStart: Learn DAX Basics in 30 Minutes
SQL Server 2012 Tutorials: Analysis Services – Data Mining
SQL Server 2012 Tutorials: Analysis Services – Multidimensional Modeling
SQL Server 2012 Tutorials: Analysis Services – Tabular Modeling
SQL Server 2012 Tutorials: Reporting Services
SQL Server 2012 Tutorials: Writing Transact-SQL Statements
SQL Server 2012 Upgrade Technical Guide
SQL Server Community FAQs Manual
Visual Studio Moving to Microsoft Visual Studio 2010
Upgrade Team Foundation Server 2012: the ultimate upgrade guide
Web Development Deploying an ASP.NET Web Application to a Hosting Provider using Visual Studio
Developing Modern Mobile Web Apps
The Entity Framework 4.0 and ASP.NET Web Forms – Getting Started
Getting Started with ASP.NET 4.5 Web Forms (Beta)
Getting Started with the Entity Framework 4.1 using ASP.NET MVC
Intro to ASP.NET MVC 4 with Visual Studio (Beta)
Introducing ASP.NET Web Pages 2
Project Silk: Client-Side Web Development for Modern Browsers
Windows Deploying Windows 7: Essential Guidance
Programming Windows 8 Apps with HTML, CSS, and JavaScript
Windows Azure Autoscaling Application Block and Transient Fault Handling Application Block Reference
Building Elastic and Resilient Cloud Applications – Developer’s Guide to the Enterprise Library 5.0 Integration Pack for Windows Azure
Building Hybrid Applications in the Cloud on Windows Azure
Create Your First Application – Node.js and Windows Azure
Drupal on Windows Azure
Migrating Data-Centric Applications to Windows Azure
Moving Applications to the Cloud, 2nd Edition
Using Windows Azure Mobile Services to Cloud-Enable your iOS Apps
Using Windows Azure Mobile Services to Cloud-Enable Your Windows Phone 8 Apps
Using Windows Azure Mobile Services to Cloud-Enable your Windows Store Apps in C#
Using Windows Azure Mobile Services to Cloud-Enable Your Windows Store Apps in JavaScript
Windows Azure and SQL Database Tutorials
Windows Azure Prescriptive Guidance
Windows Azure Service Bus Reference
Windows Phone Developing an Advanced Windows Phone 7.5 App that Connects to the Cloud
Programming Windows Phone 7
Windows Server A Guide to Claims-Based Identity and Access Control, Second Edition
Introducing Windows Server 2008 R2
Introducing Windows Server 2012
Understanding Microsoft Virtualization Solutions: From the Desktop to the Datacenter, Second Edition
Career Own Your Future: Update Your Skills with Resources and Career Ideas from Microsoft
%d bloggers like this: