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

co authoring excel sharepoint 2010 / SharePoint 2013

TechNet article provides guidance for administrators to configure co-authoring for their organization. Many of these are using Windows PowerShell cmdlets.

Save site as template: SP2010 + SP2013 + SP2007

Sandboxed Solutions - SharePoint 2010

Business Data Connectivity: SP2010 + SP2013

How to create business data connectivity service application

Access Denied by Business Data Connectivity – Resolved

Business Data Connectivity metadata store is currently unavailable

InfoPath Error: This session has exceeded the amount of allowable resources

Hello, 

I have published an infopath form on my SharePoint 2010 site collection and getting the following error message while opening: 

InfoPath Error: This session has exceeded the amount of allowable resources 

Resolution is very simple.


Here are the details:

Increase the form actions in configuring InfoPath services section as mentioned below:- 

Go to Central Administration of the SharePoint server. 

Click on Application Management 

In the section "InfoPath Forms Services"-->select Configure InfoPath Forms Services. 

In the Number of Actions per Post back, enter some max value around 250 or 300 depends on your project form requirement.

Last Access date / time for site collection

How to find out dead sites? 

How to find out unused sites? 

How to find out the sites which has not been updated from a long time? 


http://sharepointknowledgebase.blogspot.com/2014/02/last-access-date.html

access denied business data connectivity

Create an External Content type based on backend SQL Server Database and create an External list based on it.

Open the Site in SharePoint Designer 2010: http://portal.contoso.com


Provide username and password in the promotion for open the site


Opening the site http://portal.contoso.com by communicating with the Web service


Retrieving External Content type Report



Create new external content type: Define General Properties for External Content type


Content type name: Contact; Name Space: http://portal.contoso.com; Office Item Type: Contact; Enable offline Sync to External list 

External System: Click here to discover external data sources and define operations 

Add Connection 

Managing Connections to external data sources and the operations for this external content type

External Data Source Type Selection: SQL Server -> Open the SQL Server Connection


SQL Server Connection: Populate the Database Server and Database name in the box


 Navigate to the appropriate database (AdventureWorks) and scroll through the required table (Contact)  

Table: Verify the available operations for that table

Operations for External content type means action that can be performed on the data associated with the external system -> Click on Create all Operations


Specify the parameters for the Operation


Example: Get the “Last Name” parameter-> Office property: Last Name; Check the Show in Picker box.


Filter Parameter Configuration


Add Filter Parameter: Add a Limit filter to the Query Item List Operation


Add Filter Type: Limit (Strongly Recommended to add a filter of type ‘Limit’ for this operation type)  



Filter Filed: None; Default value given as “100” for the limit filter type

Save the Content type to the Business Data Connectivity Metadata Store


Create an External List for the External Content type


External List : Business Contacts ; System Instance : AdventureWorks

External List: Business Contacts Created


Set Business Connectivity Store Permissions

List and Libraries -> External List-> Business Contacts -> Open Preview in Browser


Access is being denied by Business Data Connectivity Service (Reason: There is no permission for viewing this list)


Set the permission: Open CA->App mgmt. ->Manage Service Applications-> Business Data Connectivity Service->Manage->Set Metadata Store Permissions 


 Add Contoso\Administrator and feed all the (Edit, Execute, Selectable in Clients, Set Permissions) permission to the user.

Propagate permissions to all BDC Models, External Systems and External Content types in the BDC Metadata Store.


Work with External Content type in the Browser: Navigate to the http://portal.contoso.com


List will display with the no permission error now


Edit Item: Edit any of the lists and include any data in the list.


Example: Data Included in one of the List


If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Help with list view threshold error

I am sure we have all encountered the list-view threshold limit of 5000 items many times. However, this is a scenario I have not encountered: We have libraries that exceed the threshold limit that the users have organized into folders. I am recommending splitting these out into different libraries to keep below the threshold but Microsoft articles advise that this is a reasonable way to manage large lists.

Here is my problem: what if I want to change the URL of the site? When I go to change the site title and URL I am hit with an error prohibiting the operation due to exceeding the 5000 item threshold. I assume that this is because SharePoint is updating each list item with the new site URL as the path for the item is a hidden metadata field.

Are we expected to never change the site name if we have large lists or am I missing something? I will get around this issue in the short-term by splitting the library but I am unsure what to tell future clients, especially since I can't find any articles on this specific issue online.

Please provide your suggestions / advice / recommendations by means of COMMENTS

SharePoint Server 2013 Licensing + Downloads + Prerequsites + Browser Support



Difference between SharePoint Standard CAL and SharePoint Enterprise CAL:

Download SharePoint Server 2013 (180 day trail): http://technet.microsoft.com/en-in/evalcenter/hh973397.aspx

Download SharePoint Foundation 2013 (180 day trail):

Available in:
1.       64-bit ISO
2.       These languages: Arabic, Chinese (Simplified), Chinese (Traditional), Dutch, English, French, German, Hebrew, Italian, Japanese, Korean, Portuguese (Brazil), Russian, Spanish

Download SharePoint 2013 Pre-requisites:

SharePoint 2013 Web browser support/ Supported web browsers:
Internet Explorer 8 or later: supported
Google Chrome (latest version): supported
Mozilla Firefox 19 or later: supported
Safari (latest version): supported

IE 6 is not supported to work with any SharePoint 2010 or later, but will work with SharePoint 2007 and before. IE 8 and below has issues with SharePoint 2013 or below. Some functionality in SharePoint 2013 requires ActiveX controls which results in restrictions to all browser versions that are not Internet Explorer with 32 bit, Internet Explorer 10 has to be in desktop mode.

Popular Posts