Showing posts with label SharePoint 2013. Show all posts
Showing posts with label SharePoint 2013. Show all posts

Jun 20, 2017

Accessing Checkbox in SharePoint using JQuery

I couldn't find anything obvious for accessing SharePoint Check Box so chucked this together, hopefully useful for someone else 😉😎
Note: The below code/solution is applicable to accessing check box in a custom SharePoint List forms using SharePoint Designer. To know how to create a custom form in SharePoint Online, read this article Get Current Logged in User & Manager using REST API in SharePoint OnlineAccessing Check Box control in SharePoint is little tricky than accessing the check box in HTML. The reason being, Check Box control is rendered as a table instead of a single control as shown below (Check Box and its preview in developer tools - Chrome):
So, each check box is rendered inside SPAN tag in a table. To access the normal SharePoint controls, we will use either ID or title property but for Check Box it is little complicated.
The actual check box control is in "input" tag 2. The values (Example here: A, B) are inside "label" tag 3. But each control (Yes & No) are represented by ID which is generated by SharePoint 4. If you look at the ID, there is "ff5" which is the ID of the control generated randomly by SharePoint
Now, open the designer, add an ID to the TD of the Check Box so that we can query it easily using JSOM as shown below:
//Get the checked values of Check Box
$("input[id ^= 'tdLanguage']").is(function(){
    var checked = $(this).is(":checked"); //is checkbox checked (true/false)?
    var theVal = $(this).next().text();  //get the label for this checkbox
    alert(checked + " : " + theVal);
});
//Check if checkbox is selected or not
($("#tdLanguage").children().find('input:checkbox').is(':checked'))
//Check box checked or not - single check box type in SharePoint
$("td[id='tdLanguage'] input:checkbox[name*='ff5']").is(":checked")
//Check all the values of checkbox
$("td[id='tdLanguage'] input:checkbox[name*='ff5']").attr('checked',true )
//Uncheck /Clear all checkbox values
$("td[id='tdLanguage'] input:checkbox[name*='ff5']").attr('checked',false )
*** "'tdLanguage'" is the ID of the SharePoint Radio Button Control, "ff5" is the unique ID of the SharePoint Control in your List form. Change this ID according to your form to get the exact result.
Please share your valuable comments which will make me write more and also share this post using the below social buttons to others.
Happy Share(ing)Point! 👍

May 5, 2017

Slide Library in SharePoint Online

When you try to migrate from SharePoint 2010 to SharePoint Online (Office 365), Slide Library template is not listed as app in the Create App section.
You can still get it with a direct URL. I would not depend on it being there forever as the Slide Library is officially not in SharePoint 2013, but for now you can create one.
The direct URL to create the old Slide Library:
http://yourserver/sites/yoursite/_layouts/15/slnew.aspx?FeatureId={0be49fe9-9bc9-409d-abf9-702753bd878d}&ListTemplate=2100


Update 22/05/2017:
Even though above solution works as expected in SharePoint 2013 & SP Online it is advisable not to use since Microsoft may remove this feature in future.

Feb 28, 2017

Challenges to be considered before migrating from SharePoint 2010 to 2016

  1. Identifying the business owners for each site / site collection
  2. Data Cleansing - identifying the old contents/obsolete data for archiving
  3. Identifying the intranet links embedded inside the documents (while migrating to SharePoint Online) 
  4. Optimize and define databases - Perform re-organization of content. For example, as you determine what will be brought over to the new environment, you may end up archiving some ‘less-used’ content to a ‘read-only’ or ‘slower’ server.Consider moving read only data to a separate SQL instance or even separate SQL farm where the data is read-only. You may also want to consider moving less frequently used content to SQL servers that have less resources and keep the higher performing SQL servers for the frequently used/collaborative content, perhaps your ‘old’ SQL server.
  5. Size of data to be migrated – this will affect the migration time
  6. Any good migration should involve a content audit. Data security (legal & audit implications should be considered) –confidential documents which are restricted for internal use cannot be migrated to SharePoint Online. Key ‘things’ like ‘Highly Visible or Critical Areas’, ‘Executive Users Permissions’, ‘Large AD Group Users’ assignments, ‘Highly Used’ Features, ‘Heavy Customizations’, Integration with other systems, etc. must be identified, and documented in order to identify where the critical data and functionality exists. Depending on the access to the content, an appropriate ‘services’ and ‘security’ model can be included in the SharePoint migration planning (and later validation).
  7. SharePoint 2010 cannot be directly migrated to 2016 and it needs to be migrated to 2013 and then to 2016 version (when Database upgrade approach is opted as an option for migration)
  8. If tool based migration (like Sharegate, Metalogix) approach is used, then direct migration from 2010 to 2016 is possible
  9. 10 GB is the new soft limit for file sizes in SharePoint 2016
  10. If custom master page is used, then the existing master page needs to be upgraded /recreated from 2010 -2013 –then 2016 version for using it in SharePoint 2016
  11. While using database upgrade (2010 to 2013 and then to 2016) approach, SharePoint 2010 sites will be made read only during migration process
  12. Any custom farm solutions should be upgraded to SharePoint 2016 before use
  13. The same connectivity/integrations to external systems in SharePoint on-premises environment may not be achieved in SharePoint Online
  14. New user ID’s needs to be created in SharePoint Online. New/ existing permission levels needs to be created in SharePoint Online
  15. End users needs to be trained for new UI/navigation, etc.

Dec 13, 2016

Character Limit using JQuery in SharePoint

In this post, we will learn how to implement Character Count (here in this example, maximum allowed 2000 characters) using JQuery in SharePoint.

Prerequisite:
1. Create a SharePoint List with a column named "Comments" - data type Multi line text with plain text as the option selected
2. SharePoint Designer 2013 for editing the SharePoint list with span and to identify the ID of the field created

Solution:
1. Open the SP site in SharePoint designer, navigate to the list -> Create a custom new form -> Edit it.
To know how to create a custom new form in SharePoint Designer, read this article.
2. Below is the HTML code for my "Comments field in SharePoint Designer:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
<tr>
    <td width="190px" valign="top" class="ms-formlabel">
        <H3 class="ms-standardheader">
   <nobr>Enter your comment:</nobr>
  </H3>
    </td>
    <td valign="top" class="ms-formbody" style="background-color:#ffffff; width:400px;">
        <SharePoint:FormField runat="server" id="ff6{$Pos}" ControlMode="New" FieldName="Comments" __designer:bind="{ddwrt:DataBind('i',concat('ff6',$Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@Comments')}" />
        <SharePoint:FieldDescription runat="server" id="ff6description{$Pos}" FieldName="Comments" ControlMode="New" />
        <span title="2000" id="commentsCount">2000</span><span> Characters Left</span>
    </td>
</tr>
Make a note that I have added a Span tag below the SharePoint control to display the Characters. Also, we have declared it as 2000 characters for this example.
Now, add a script tag or a separate file (then refer it inline) -> add the below code in it save it:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
$(document).ready(function() {
 //Character count for comments text
 $("textarea[name*='ff6']").keyup(function () {
  characterCount('ff6', '#commentsCount');
 });
});

//Character count for multiline text 
function characterCount(controlID,spanId)
{
  var controlVal = $("textarea[name*='" + controlID + "']");
  var cmax = $(spanId).attr("title");
  if(controlVal.val().length >= cmax) {
      controlVal.val(controlVal.val().substr(0, cmax));
   }
  $(spanId).text(cmax - controlVal.val().length);            
}
In this above JS, "ff6" is the ID of the SharePoint control.
Save the form and JS, try typing inside the control you can see the characters been automatically counted and decreases as you type. Cool Isn't it? 😉
Please share this post by clicking the below social buttons if this helps you😎
Happy coding! 

Jul 19, 2015

Create Business Intelligence Center in Office 365

Recently, Microsoft has updated Power BI features in SharePoint online. It has enhanced the Business Intelligence features a lot and I am sure self-service BI is the ultimate goal for Microsoft:) In this article, we will learn how to create Business Intelligence Center in Office 365.
To get  Microsoft Office 365 trail with Business Intelligence Center (this feature is not available in all the versions of the O 365), you need to sign up using the E3 license. This includes the advanced features in it.
Office 365 Enterprise E3 
Once you sign up, navigate to Office 365 admin center -> Admin -> SharePoint -> It will open the SharePoint administration

Click Site Collections -> New -> Private Site Collection -> Give the Title and Web Site Address -> Template Selection -> Enterprise tab -> Business Intelligence Center ->  Enter the site collection Admin and click OK to create it.

You will see the new BI site collection as shown below:
Soon, will post about creating dashboards and reports in SharePoint 2013. Happy Learning!
Please share this post if this helps you!

Jul 14, 2015

Could not load type ‘Microsoft.AnalysisServices.SpAddin.ReportGallery.ReportGalleryView’

Recently, I have installed the power pivot in SharePoint 2013 and then configured the power pivot service application in the Central Administration.
I tried creating a Pivot Gallery and it is successful. When I opened the pivot gallery library, it is showing the below error: 
I am sure some feature is not activated but couldn’t find it. Then, checked the Central Administration -> System Settings -> Manage Farm Solutions -> powerpivotwebapplicationsolution

This solution should be deployed to the web application in which have created the pivot gallery.

Happy learning! Please share this post if it helps you!

Jul 13, 2015

SharePoint 2013 / Office 365

I wanted to try some proof of concepts using SharePoint 2013 and been looking for various easy options to get the SP 2013.
Hence I wanted to list the easy ways to get SharePoint 2013 for the readers. Below is the list:

Office 365 Trial :

https://products.office.com/en-us/business/compare-office-365-for-business-plans

On-Premises Deployment:

https://www.microsoft.com/en-us/evalcenter/evaluate-sharepoint-server-2013

Windows Azure:

https://azure.microsoft.com/en-us/pricing/free-trial/?CR_CC=200256621&WT.mc_id=A24158309 

SharePoint Online:

https://products.office.com/en-us/SharePoint/compare-sharepoint-plans?legRedir=true&CorrelationId=08d4bcac-2e4e-4269-9981-1deb00da1ad9

SharePoint Rackspace:

http://sharepoint.rackspace.com/free-sharepoint-2013#chat 

Cloud Share:

http://www.cloudshare.com/cloudshare-template-library

This are the some of the easier ways to get the trial versions for SharePoint 2013. Please share this post if this is helpful. Happy Sharing!

Apr 23, 2015

External List in SharePoint Limitations

When I tried to connect the external DB to the SharePoint using external content types, I found lot of issues or limitations for the end users. This is same in external lists as well. I am using SharePoint 2010.
No look up:
Unfortunately the only thing that you can do a look up on in an external list is on the ID column, anything else and you are out of luck.
No Attachments:
Attachments options are not available.
No RSS Feeds:
RSS feeds is also greyed out and it really helps when you need updates from SharePoint list
No Workflows:
Workflows are very important in SharePoint lists and it plays a vital role in different business requirements. But workflows are disabled in external lists
No Ratings:
In all the SharePoint lists, you will see an option of Rating Settings under General Settings where the Rating can be enabled but this is disabled
No Inline Editing or Datasheet View:
Inline editing allows you to edit list items in list view itself. Datasheet view is a where you can easily change the data for multiple items. Neither of these is available.
No Versioning or history:
You cannot see version history for an External List. It does make sense, in many of the external systems there is no concepts of version
No Item Level Permissions:
You cannot configure item level permissions for external list items
No Export to Excel Option:
This is a frequently used option which allows the end users to export the list data to excel. But this is disabled
No Open with Access / Create Visio Diagram / Open Schedule: 
Though this not used frequently, sometimes we may need this but this is also disabled
I gone through BCS in SP 2013, it is improved a little bit:
1. Export to Excel option is included
2. Sorting and Filtering are improved
3. Event receiver on external lists is introduced

Feb 19, 2015

Update on InfoPath and SharePoint forms

As part of the update shared around the Evolution of SharePoint and the next SharePoint Server on-premises release, we are also updating the timelines for removal of InfoPath Forms Services components of SharePoint and SharePoint Online. Specifically, InfoPath Forms Services will be included in the next on-premises release of SharePoint Server 2016, as well as being fully supported in Office 365 until further notice. Customers will be able to confidently migrate to SharePoint Server 2016 knowing that their InfoPath forms will continue to work in their on-premises environments, as well as in Office 365. 
The InfoPath 2013 application remains the last version to be released and will work with SharePoint Server 2016.
This gives answer for many migration questions with regard to InfoPath forms in SharePoint lower versions.

Aug 5, 2014

OWA web parts in SharePoint 2013

When I tried finding the OWA web parts in the SharePoint 2013 OOTB web parts, I couldn't find the web parts and “Outlook Web App” category is also not available. I was thinking it is deprecated or not available in SharePoint 
2013.
After searching, I found the following solution.
Steps to add Outlook web parts
1.   Go to Web part Gallery.
2.   On Web part Gallery page, Click Files-> New Document -> New in the ribbon.
 3.   On New web part page (NewDWp.aspx), look for Microsoft.SharePoint.Portal.WebControls.OWA, select the web parts related to the outlook as shown below and populate gallery.
4.   Now, under Miscellaneous Category, you will see the web parts related to Outlook. 
Hope this helps you!

Jul 29, 2014

SharePoint 2013 & 2010 OOTB Web Parts Comparison

There are many changes made in SP 2013 in OOTB web parts. I tried creating
a summary which shows the following:
1. What category is added or removed in SP 2013?
2. What are the web parts removed from SP 2013?
3. What are the new web parts added and their functionality?

Downloadable Link for the below file: Link to download

Share the post if this helps you!

Jul 23, 2014

Promoted Links in SharePoint 2013

Promoted Links is a new list type added in SharePoint 2013.
What it is and how to use this?
1.   New app in SP 2013 available Out of Box
2.   It is similar app like “Get Started with your site” in the home page 
3.   It is a very cool feature which allows you to add images and links to it and display it in a Tile view in a page for quick navigation.
4.   Let’s create a promoted links app for our SharePoint 2013 home page.
5.   Go to “Add an App” -> Promoted Links -> Give a name “Home Page Navigation”
                    
6.   You will see a message. The list is empty, Add tiles from the All Promoted Links view. Now, start adding the images and links in the app as shown below
When you click on the “All Promoted Links” you will see a list view to add items in it.
Adding new item will have the following fields
a.    Title
b.    Background Image Location
c.    Description
d.   Link Location
e.    Launch behavior
f.     Order 

Example of one item added.
Similarly, I have added 4 items in the list.
Now, in the list, if you navigate to the Tile View, you will see the images with the links displayed with Links. Cool Isn't? It is OUT OF BOX. 
If you hover the mouse, the title automatically goes up. You can click and navigate to the desired page.
This list can be displayed in a web part in the site home page which can be used for quick navigation. Please share this if it is useful!

Jul 2, 2014

New Features of SharePoint 2013

It has been a while here, there are many reasons and I was busy as well. Let’s start it again with SharePoint 2013J
SharePoint 2013 has many new features and it is trending in the market. Let’s see the list of features which is new and what is different from the other versions of SharePoint.
  1. HTML 5 and CSS 3 support  - Cross browser compatibility and optimized browser experience.
  2. Device Manager & Device Channels – new way of designing  theme for  the site using SharePoint Designer 2013.
  3. Community Portal – Social Networking  makes collaboration within the organization easier.
  4. New Search Experience (My favorite feature J) - Continuous Crawl – yes, you get the results once you publish the new contents to the site
    Fast Search is integrated in the search feature and it is not a separate product now, licensing becomes easier.
  5. Content Search Web Part – display information from the other web apps which is not possible in other versions of SharePoint – and off course content has to be crawled and indexed for displaying in this web part
  6. Rich Workflows – New actions, no code web service call
  7. Shredded Storage  - removes the duplicate files  and hence reduces the amount of storage in the site
  8. WCM – Managed metadata for navigation and shortening of URL’s
  9. Apps & Apps Store – Create and publish apps
  10. Mobile Experience –  Mobile usage has increased drastically and this feature allows you to view the SharePoint site in three view such as Classic, Contemporary, Full Screen UI.

Oct 29, 2013

The Server could not complete your request SharePoint Designer 2013

Problem:
When I tried opening SharePoint 2013 site in SharePoint Designer, I got the following error:

When I clicked on Details, it opened another dialog and continuously pop up window is opening and not able to open the SharePoint site.

 Finally got an error message
Solution:
    1.   Go to Run -> type Inetmgr -> Open the IIS
    2.   In the Web Sites select “SharePoint Web Services” in the list


    3.   Click on the Authentication and Enable “Anonymous Authentication” as shown below:

   4.   After enabling this, I am able to open the SharePoint site in designer without any issues

Reason for the issue: Check this article http://support.microsoft.com/kb/2758431 

Aug 19, 2013

News feeds not working in SharePoint 2013 - microsoft.office.server.microfeed.microfeedexception

To know about Micro Blogging in SharePoint 2013, read this post.

When I tried to use the News Feed Feature in SharePoint 2013, it thrown exception:
microsoft.office.server.microfeed.microfeedexception
The below is the screenshot: 
 Solution:
As I mentioned in the earlier post about Micro blogging in SharePoint 2013, news feeds are related to User Profile Service.
Hence, we have to check two things which are related to User Profile Service in SharePoint 2013.
    1.   Check whether AppFabric Caching service is running with the service account which has elevated permissions. 

   2.   Next, check the account which is running the User Profile Service application:
     Open Central Administration -> Mange Service Applications -> User Profile S    Service is started and also check the permissions for the service
    
   Click on the User Profile service and in the permission section in the ribbon check whether the service account running this service has full control. 


 If all the above scenarios are properly configured in SharePoint farm, then the news feed will work properly as expected.
Feel free to comment and share this post if this helps you.

Aug 17, 2013

Micro blogging in SharePoint 2013

Introduction:
Microsoft has introduced a new social feature called “Micro blogging” in SharePoint 2013 to enhance the social networking and collaboration features.
This powerful feature is added as an OOTB web part to SharePoint 2013 and ready to useJ

So, what is micro blogging?
It is a type of blog which allows users to share their updates. This updates are called micro posts and the use of this services is called micro blogging.
Ref: http://www.webopedia.com/TERM/M/microblog.html

Micro blogging in SharePoint 2013
The SharePoint Micro Blogging feature is like Facebook and Twitter which allows the users to communicate with others easily, by posting some questions, responding, comments and etc.
Following are the list of features:
  Ø  Update picture and links in the posts and replies
  Ø  Participate in a conversation by posting comments (with rich media and
        Links in the post) and replied
  Ø  Use mentions (@) to tag a user in  a post and in the replies
  Ø  Use tags (#) to define keywords so that the users can follow and search for   the same topic easily
  Ø  Like a post, follow people, documents, sites and tags

   Also, the author’s (one who posts an update or comment or reply for a post)
   presence (online, off-line, busy, in a meeting) are also displayed.

Add the Site Feed web part to the page:
Edit the page -> Insert -> Web part -> Social Collaboration -> Site Feed

 Once added, you will see a dialogue to post your feeds as shown below:
Add a new Post in the Micro blog:
You can add a post by typing your post in the text box and hit post to update your post
Add Rich Media & Links, Delete a Post:

In the Post you can add Rich media such as Image, Video, Links, etc.. Also, you have options of deleting  the post.
Like, Reply, Copy Link to conversation, Follow up, Lock Conversation:
Like other social networking as I mentioned earlier in this post you have options of Like, Reply, Copy Link to Conversation, Follow up and Lock a Conversation :)
Also, there is an option "Show More Posts" to view the old posts.

Tagging a User and Topic
The options of Tagging a user by "@" allows the other user to specifically tag a post to a user and also Tagging a topic by "#" allows the posts to be categorized and also it helps in searching the posts easier.

 See where the Micro blog contents are stored?
This micro feed are based upon the User Profile Service in SharePoint. This feeds are stored in a list called Micro Feed by default where you will see all the details stored.
Navigate to the following path to view the Micro Feeds:
Check for the Micro Feed List
Clicking on the List, you will see a List with different columns which stores the feeds.

Hope you enjoyed the post. Feel free to share your valuable comments which always make me to write more. Also share this post to your friends if it is helpful.