Sep.22

Dragan Todorovic 0 SharePoint

Database Connector has throttled the response. The response from database contains more than ‘2000’ rows – error on external list in SharePoint

Database Connector has throttled the response. The response from database contains more than ‘2000’ rows – error on external list in SharePoint

By default, SharePoint will try to fetch 2000 rows for external list, and in case you get this error, the only way is to increase default settings by simple Powershell command in a few easy steps.

Error:
Database Connector has throttled the response. The response from database contains more than ‘2000’ rows. The maximum number of rows that can be read through Database Connector is ‘2000’. The limit can be changed via the ‘Set-SPBusinessDataCatalogThrottleConfig’ cmdlet.

Solution:

  1. Log in to SharePoint server
  2. Start SharePoint Management Shell as administrator (right-click, run as administrator)
  3. Execute the following command: Get-SPServiceApplicationProxy
  4. Note the ID value for “Business Data Con” application
  5. Execute the following:  $serviceapp = Get-SPServiceApplicationProxy -Identity 9b2e386e-ffee-455f-a416-302ff0aed069 (replace identity ID with your value from previous step)
  6. Execute the following command:  Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $serviceapp | Set-SPBusinessDataCatalogThrottleConfig -Maximum 1000000000 -Default 500000
  7. Restart IIS (iisreset /noforce)

 

Dec.15

Dragan Todorovic 0 SharePoint,Office365

May.30

Dragan Todorovic 0 SharePoint,Office365

“Save as site template” option is missing in SharePoint Online

“Save as site template” option is missing in SharePoint Online

As you probably know, once the publishing feature is activated the ‘Save site as a template‘ option will be unavailable in Site Settings. If you try to disable the feture it won`t resolve the problem, since onlu one activation will change the settings for all sites. However, there is a workaround as described below:

First ty to navigate directly to http://yoursite/_layouts/15/savetmpl.aspx  and you will get the form for creating template. Simply fill in the form and you`re done.

If you get some error, then you need to connect to SharePoint Online via powershell first, and execute the following commands:

 

$web = Get-SPWeb http://your_ site
$web.AllProperties[“SaveSiteAsTemplateEnabled”] = “true”
$web.Update()

 

then try to access above URL again!

Jul.13

Dragan Todorovic 0 SharePoint

SharePoint Designer shows up blank workflows in text-based view

You have workflows associated with list or libraries, and everything works fine, except the possibility to edit all those conditions and actions in SharePoint Designer 2013?

If you click “edit workflow”, none of the workflow steps show up – instead you see a blank page with “insert a stage by using the stage button on the ribbon”. Yes, the problem is related to SPD client and all you have to do is to install the following update from Microsoft site: https://www.microsoft.com/en-us/download/details.aspx?id=41491

Nov.04

Dragan Todorovic 0 SharePoint

How to restore deleted subsite in SharePoint 2013?

How to restore deleted subsite in SharePoint 2013?

Deleted subsites not going in Recycle Bin? Yes, unfortunately it is true. If you delete subsite and try to restore from end user recycle bin, the operation will fail beacuse there isn`t such item in trash library. But there is a solution. You can find those deleted subsites on the following URL:

 

http://server/_layouts/15/AdminRecycleBin.aspx?View=2

 

View=2 switches to view that contains deleted sites and can be used for restore actions

Oct.16

Dragan Todorovic 0 SharePoint

SharePoint URLs for SharePoint staff

Site collection level recycle bin:

/_layouts/15/AdminRecycleBin.aspx

 

Site level recycle bin:

/_layouts/RecycleBin.aspx

 

Recreate default site sp groups:

_layouts/15/permsetup.aspx

 

Load document tab initial:

?InitialTabId=Ribbon.Document

 

Display list in grid view. ‘True’ is case sensitive:

?ShowInGrid=True

 

Quick Launch settings page:

/_layouts/quiklnch.aspx

 

Navigation Settings page:

/_layouts/15/AreaNavigationSettings.aspx

 

Sandboxed Solution Gallery:

/_catalogs/solutions/Forms/AllItems.aspx

 

Workflow history hidden list:

/lists/Workflow History

 

Filter toolbar for Lists and libraries:

?Filter=1

Site usage page:

/_layouts/usage.aspx

 

Site content and structure  page:

/_layouts/sitemanager.aspx

 

Site settings page:

/_layouts/settings.aspx

 

View all site content page:

/_layouts/viewlsts.aspx

 

Manage site collection features:

/_layouts/ManageFeatures.aspx?Scope=Site

 

Manage site features:

/_layouts/ManageFeatures.aspx

 

Get the version of the SharePoint server:

/_vti_pvt/Service.cnf

 

Web Part Maintenance Page:

?Contents=1

 

Show Page in Dialog View:

?isdlg=1

 

Application page for registering SharePoint apps:

/_layouts/15/appregnew.aspx

 

Save Site as a template:

/_layouts/savetmpl.aspx

 

Sign in as a different user:

/_layouts/closeConnection.aspx?loginasanotheruser=true

 

Enable SharePoint designer:

/_layouts/SharePointDesignerSettings.aspx

 

Welcome Page (Default page settings):

/_layouts/AreaWelcomePage.aspx

 

Change Site Master Page:

/_layouts/ChangeSiteMasterPage.aspx

 

Page Layouts and Site Templates:

/_Layouts/AreaTemplateSettings.aspx

 

Master Pages library:

/_catalogs/masterpage/Forms/AllItems.aspx

 

Quick Deploy List:

Quick%20Deploy%20Items/AllItems.aspx
Open Page in Edit Mode:

?ToolPaneView=2

 

Jul.26

Dragan Todorovic 0 SharePoint

Custom RTE styles for SharePoint

Custom RTE styles for SharePoint

List of available CSS style definitions to add custom font-styles or element-styles to the RTEs in SharePoint:

.ms-rtestyle
.ms-rteelement
.ms-rtefontsize
.ms-rteforecolor
.ms-rtebackcolor
.ms-rteimage
.ms-rtetable
.ms-rteposition

Jun.24

Dragan Todorovic 0 SharePoint

How to add custom font to SharePoint 2016 RTE?

How to add custom font to SharePoint 2016 RTE?

SharePoint allows users to define new/custom fonts, font-size, text-alignment etc., to be added to the rich text editors. By default, SharePoint search for style definitions with the prefix ‘.ms-rte’  in CSS files.  The easiest way is to create a custom CSS file with the following style definition:

 .ms-rteFontFace-custom1
{
	-ms-name:"My Own Font";
	font-family:"Custom Font Face Name";
}

Add a reference to this CSS file on the SharePoint pages where ever you need the custom styles/fonts for the RTEs or add those lines in some custom global CSS on project.

Sep.07

Dragan Todorovic 0 SharePoint

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 😉

 

Sep.02

Dragan Todorovic 0 SharePoint

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