SharePoint Online storage?

Customers are frequently asking what kind of storage they get with SharePoint Online and Microsoft constantly improves products and services. According to the latest informations, we have the following model (example on E plans):

 

Each Tenant (SharePoint Online instance) gets 1TB of storage space included. Then each user of the E plans will add 500MB of storage space into the shared pool. This is up from 10GB per tenant and 500MB per user.

  • For example:  A client with 100 users would get 1TB + 50GB (500MB x 100) for the main storage on SharePoint. Each extra GB is 0.20 per month.

The pooled storage is used across all sites on SharePoint Online, Office 365 Groups and Office 365 Videos

How to format date in SharePoint XSL templates?

In many projects when using CQWP web parts you need to customize date format. By default, SharePoint gives date with time, but we often need only date. Here is a simple scenario:

  1. First you need to reference the ddwrt namespace at the top of your <xsl:stylesheet> tag:
    xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime
  2. In order to display custom date format you have to use the following code (replace @ArticleStartDate with your column ):
    xsl:value-of select="ddwrt:FormatDate(@ArticleStartDate, 2057, 1)"
  3. Save. Publish. Check results 😉

 

Properties of Javascript context object (.ctx) on SharePoint 2013

1: Rank:11.27 
2: DocId:5367 
3: WorkId:5367 
4: Title:test123 
5: Author:Developer 
6: Size:0 
7: Path:http://example.com/test/DispForm.aspx?ID=1 
8: Description: 
9: Write:Mon Jun 3 19:55:58 UTC+0300 2013 
10: CollapsingStatus:0 
11: HitHighlightedSummary: 
12: HitHighlightedProperties:<HHTitle><c0>test123</c0></HHTitle><HHUrl>
13: http://example.com/test/DispForm.aspx?ID=1</HHUrl><author hashh="0">Developer</author> 
14: contentclass:STS_ListItem_GenericList 
15: PictureThumbnailURL: 
16: ServerRedirectedURL: 
17: ServerRedirectedEmbedURL: 
18: ServerRedirectedPreviewURL: 
19: FileExtension:aspx 
20: ContentTypeId:0x0100...
21: ParentLink:http://example.com/test/AllItems.aspx 
22: ViewsLifeTime: 
23: ViewsRecent: 
24: SectionNames: 
25: SectionIndexes: 
26: SiteLogo: 
27: SiteDescription: 
28: deeplinks: 
29: importance: 
30: SiteName:http://example.com
31: IsDocument:No 
32: LastModifiedTime:Monday, June 3, 2013 
33: FileType: 
34: IsContainer:No 
35: WebTemplate: 
36: SecondaryFileExtension: 
37: docaclmeta: 
38: OriginalPath:http://example.com/test/DispForm.aspx?ID=1 
39: EditorOWSUSER:Developer 
40: DisplayAuthor:Developer 
41: ResultTypeIdList:38;6 
42: PartitionId:0c37852b-34d0-418e-91c6-2ac25af4be5b 
43: UrlZone:0 
44: AAMEnabledManagedProperties:AttachmentURI;deeplinks;DefaultEncodingURL;ExternalMediaURL;HierarchyUrl;
45: OrgParentUrls;OrgUrls;OriginalPath;ParentLink;Path;PictureThumbnailURL;PictureURL;PublishingImage;
46: recommendedfor;ServerRedirectedEmbedURL;ServerRedirectedPreviewURL;ServerRedirectedURL;SiteLogo;
47: SitePath;SPSiteURL;UserEncodingURL 
48: ResultTypeId:38 
49: RenderTemplateId:~sitecollection/_catalogs/masterpage/Display Templates/Search/Item_test.js 
50: piSearchResultId:0_1 
51: ParentTableReference:[object Object] 
52: csr_id:ctl00_PlaceHolderMain_ctl01_csr2_item

Simple jQuery Autocomplete for SharePoint 2013 forms

<!doctype html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <title>jQuery UI Autocomplete - Default functionality</title>
  <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css">
  <script src="//code.jquery.com/jquery-1.10.2.js"></script>
  <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script>
  <link rel="stylesheet" href="/resources/demos/style.css">
  <script>
  $(function() {
    var availableTags = [
      "ActionScript",
      "AppleScript",
      "Asp",
      "BASIC",
      "C",
      "C++",
      "Clojure",
      "COBOL",
      "ColdFusion",
      "Erlang",
      "Fortran",
      "Groovy",
      "Haskell",
      "Java",
      "JavaScript",
      "Lisp",
      "Perl",
      "PHP",
      "Python",
      "Ruby",
      "Scala",
      "Scheme"
    ];
    $( "#tags" ).autocomplete({
      source: availableTags
    });
  });
  </script>
</head>
<body>
 
<div class="ui-widget">
  <label for="tags">Tags: </label>
  <input id="tags">
</div>
 
 
</body>
</html>

How to configure SharePoint 2013 Search service?

After you have completed setup and the SharePoint Products Configuration Wizard, you new SP server is almost ready! If you upload a few documents or create some list items, it is expected to get those details as a search results. So, where is the problem? In most cases you need to setup search service initially and index all content on site collection.

 

  1. Go to Central Administration and select Manage Service Application
    srch1
  2. Open and click the Search Service Application list menu, you will be redirected to Search Administration page
    srch2
  3. Select “Content Sources” from left side menu
    srch3
  4. Select “Start Full Crawl” from dropdown menu in order to crawl your data from the databasesrch4

After a few minutes or hours (depends on content size), your search will start showing display results!

SharePoint 2013: System.ServiceModel.ServiceActivationException 500

Running out of memory is a well known bug for SharePoint 2013 search service specially because of noderunner.exe processes. Last week we had an issue with term set navigation change because of the following error: “system.servicemodel.serviceactivationexception 500”. Simply you cannot change anything. We have temporarily killed all noderunner.exe prcoesses, but it still failed.

 

Temp solution:
Enter the Windows Services list and just restart “SharePoint Host Search Controller”. After that make you should make your changes.

 

The same bug causes problems with editing SharePoint site in SharePoint Designer, simply you cannot open it. It is resolved in the same way.

How to rename Status Approval column?

In many projects we have the same request from end users: “To rename Status Approval column”. As you already know, this column is not visible in List Settings and therefore it cannot be changed as many other columns. But here is a simple trick:

  • Open “List Settings” and edit some column (eg. Created)
  • In the address bar at the end of URL, you will see the field name (&Field=Author)
  • Replace this value with &Field=Status%Approval
  • Hit enter and you will get the edit field for existing label
  • Change and confirm!

How to disable Sync Button for SharePoint Document libraries

By default, OneDrive for Business is used to sync the documents of a SharePoint document library down to local computer for offline access. Any user that has access to the document library has the option to Sync one or more libraries. In some cases company rights and policies request to disable this option for all users. If you log into your SharePoint site, and click on a document library, you should see a Sync button on the top right corner.

 

Sync

 

 

If you want to hide that button, or just disable in global settings, you need to click the gear in the top right and go to Site Settings. Choose link that says Search and offline availability.

 

You will see a line that says Offline Client Availability, and set the the option to no, then hit OK

 

That’s it.