Saturday, July 2, 2016

How managed metadata works in CQWP

Please read the below good articles before go with querying the managed metadata column values through Content Query Web part:

https://chrisjohnson.tech/2014/03/25/sharepoint-querying-on-multiple-select-managed-metadata-columns-in-content-query-web-parts/

-Thanks to Chris.

https://blogs.msdn.microsoft.com/ecm/2010/05/14/whats-new-with-the-content-query-web-part/ 

Saturday, June 18, 2016

Lists and Libraries: Class Day3

In this article, We will cover below mentioned topics on SharePoint Lists and libraries. please feel free to reach me if have any clarifications or more information required on it.

Topics:
1) List and Library
2) site columns and List columns
3) site content type and list content type
4) Views
4) Cascade Delete
5) Restrict Delete
6) Enforce uniqueness
7) Calculated columns
8) lookup columns
9) Permissions
10) List Threshold
11) Indexing
12) Versioning, Checked-In/Out and Publish
13) Update Vs SystemUpdate Vs UpdateOverWriteversion
14) SharePoint real-time scenarios
15) SharePoint interview questions and answers
16) Read-Only columns(Eg: Created/Created By, Modified/Modified By etc..).\
17) File URL length restriction.
18) SPBuiltInFieldId


Basics on the List and Libraries:
  1. By default, Content type option is disabled at the list/library: To enable it: Go to list/library settings-->Advanced settings--> Make it as "Yes" to allow management of content type.
  2. By default, Threshold limit for the user:5000 items and for administrators: 20000. These values are hard-coded at the central admin level but Microsoft recommended is should not increase/change the default threshold values to avoid the performance issues.
  3. Best practice to handle the threshold: 1) Indexing the columns 2) Avoid threshold exception by maintaining the data/items in a folder structure( SharePoint considers Folder is an item and we can maintain 2000 items in it).
  4. Always go with the internal column names(Reason: Display name can be modified but internal can't be modified) to fetch the data and update an items.
  5. Go with the creating site columns option rather creating it in each list/library if the same column is used in more than one lists/libraries.
  6. Go with the site content types option if more than one site columns needs to preferred in the each lists/libraries.
  7. In views, Filter by [Me] if wants to show the results of current logged user only.
  8. Upload size limit of files to the document library is: By default: 50MB and max 2GB(SP2013) and max 10GB(SP2016).
  9. The files into the library should always be in published mode to get the updated changes by others.
  10. By default, SharePoint recommended support for indexing is 20.
  11. SharePoint handles the permissions at the lists/libraries and even items level also.
  12. Only option to change the list/library URL is through SharePoint designer.
  13. By default list/library permissions are inherited from parent but we can have an option to maintain the unique permissions at it.
  14. We don't have an option to add users/groups directly at the lists/library level in inheritance mode. If needs, break the inheritance and then add users/groups.
  15. Users should have minimum "contribute" level permissions to make CRUD operation at the list/library.
  16. Steps to support large files upload: 1) Increase the default value(Default: 50MB and Max support: 2GB) to the desired value 2) Increase the IIS request length 3) Increase the IIS connection timeout length. https://angler.wordpress.com/2012/03/21/increase-the-sharepoint-2010-upload-file-size-limit/ 
Please go the below articles for complete details:

RunWithElevatedprivileges
http://sharepointquicksolutions.blogspot.in/2012/11/all-ways-of-runwithelevatedprivileges.html

AllowUnsafeUpdates
http://sharepointquicksolutions.blogspot.in/2012/03/whenwherewhy-use-allowunsafeupdates-in.html

ForDigest Control
http://sharepointquicksolutions.blogspot.in/2012/03/wherewhenwhy-formdigest-control.html

Interviews questions with answers:
http://sharepointquicksolutions.blogspot.in/2013/01/list-vs-library-sharepoint-interview.html
http://sharepointquicksolutions.blogspot.in/2015/07/sharepoint-faqslistvslibrary.html
http://sharepointquicksolutions.blogspot.in/2012/06/content-types-in-sharepoint.html

PowerShell Scripts:
http://sharepointquicksolutions.blogspot.in//search/label/PowerShell


Your valuable suggestions/feedback helps me to give best outputs/results.

SharePoint 2016 tutorials: Class Day2

In Day 1 session, we discussed why  SharePoint technology is now on demand and how much the importance of having an clear idea about on software and hardware boundaries.

In Day 2 session, we will cover the below topics:
  1. SharePoint configuration.
  2. SharePoint farms and its types. Use of it.(Small/Medium/Large farms).
  3. 12/14/15/16 hive folder structure.
  4. SharePoint site hierarchy.
  5. SharePoint features.
  6. web application, Inetmgr, content DB.
  7. Real time examples.

Refer the below article for interview questions with answers and also covered with some real-time scenarios.

Friday, May 27, 2016

SharePoint 2016 tutorials: Class Day 1

What/Why is SharePoint and use of it?
  • SharePoint is browser based collaboration/web  platform. You can access it from anywhere.
  • Enterprise Content management
  • Example: Document Management [Sharing/versionsing/Checkin&Checkout/Permisisions/Search/Workflow process/Recycle Bin]
  • Calendar(create tasks/schedule meeting/). We can easily integrate the outlook to SharePoint.
  • services( BCS/Excel service and Reporting services etc..)
  • Rich browser based UI Interface( like drap/drop of files to the document library etc.. )
  • Authentication and Authorization: Single Sign on etc..
  • yammer integration( Its similar to Face book, Twitter but only difference is these are public social networks and Yammer is private social network).
  • Mutli-Language supports( 12 hive means it supports English language)
  • REST API: Through REST API, we can interact directly with SharePoint objects by using any technology that support REST web request and can be easily perform CRUD operations.
  • Office 365
  • Apps, Cloud model


Software and hardware boundaries:
We should have basic understanding about on SharePoint software and hardware requirements before proceeding with the SharePoint. This helps us to decide whether  to go with SharePoint or not.

Example:
Migrate.net application project to SharePoint 2010/2013?
Before proceed to go with the migration, we should think about whether it really supports or not. For that it's better  to have an idea about on the software/hardware boundaries.  Let's say SharePoint 2010 supports .Net framework 3.5 but they have used  .Net framework 4.0/4.5 framework to develop the project. in this case SharePoint won't support it and migration is not possible.

Note: SharePoint always supports backward compatibility.

Please go through the below article for the software and hardware boundaries:
http://www.sharepointpitstop.com/2012/10/sharepoint2013-hardware-and-software.html
https://technet.microsoft.com/en-IN/library/cc262485.aspx

Technologies:

C#, Asp.net, HTML, CSS, JavaScript, JQuery, Angular JS, Bootstrap, REST API, Apps, SharePoint 2010/2013/2016. Workflows.


Wednesday, January 20, 2016

SharePoint Interview Questions and Answers: EventRecievers1

  1. How to handle the access denied event for RunWithElevatedPrivileges?
  2. How to define/use SPSite and SPWeb objects in event receivers?
  3. How to handle the event receiver scope level  in event receiver?
  4. The Modified By/Modified columns should not be updated if there no changes made in the SharePoint list/library?
  5. Dispose objects in event receivers?

<<Prev Post>>                                                                                             <<Next Post>>

Answers for the above questions are in progress and published soon.