Hot answers tagged

9

Limitations include: There are no profile pages for external content types There is no offline availability or rich client integration There is no search integration. You will get some good reference from below links: The features of Business Connectivity Services (BCS) are distributed across different SharePoint editions. Make an External List from a SQL ...


6

To second Matt's answer, what you're asking to do is simply not possible. The reason why you can't index external content is because Microsoft doesn't provide access to the Crawl configuration. This area of the SharePoint Online implementation is a black box managed by Microsoft and Microsoft alone. It's not hidden, obfuscated or disabled "by default" - it ...


6

I had a similar issue this morning, with an external dataset with around 100,000 records. The way I worked around it was to create a SQL stored procedure to do the Read List operation, rather than querying the data directly. The Read Item operation can still be linked directly to the list, rather than requiring a second stored procedure. On the Read List ...


6

Unfortunately, it's one of the main limitations of SharePoint External List! In External List, If the number of retrieving items is more than 2000 items, the external list will not working properly. you will face a performance issue and it may be stuck to render! Fortunately, you can exceed the default max limit (2.000 items) using Set-...


5

This problem might occur because of the connections authentication mode is not assigned to BDC Identity. Below Connection properties -> Select Client -> Below Secure Store Application ID -> Select BDC Identity. For more details you can check Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’ in SharePoint Business Connectivity Service


5

It's definitely doable. On European SharePoint Conference 2015 in Stockholm, Patrick Curran showed us in a demo how this worked. From an architectural viewpoint this is how it works with the new Microsoft Identity Manager (MIM) which is the same as Forefront Identity Manager (FIM) for 2013. The presentation is available here: Expanding User Profiles with ...


4

You need to define filter parameters on your read list operation for your ECT in sharepoint designer. For example, create a wildcard filter for text filtering, and set it to default. Then that filter with your selected field will be the default search parameter in your external item picker. In SharePoint Designer, navigate to External Content Types. Right ...


4

This article seems to agree on my earlier comment, the interesting bit being: When you create an External Content Type and External List using the SharePoint Designer, DateTime fields are normalized to UTC using the NormalizeDateTime setting associated with the TypeDescriptor for the DateTime field. the fix being: <TypeDescriptor TypeName="...


4

The simple answer would be you can't on your own for anyother error apart from BCS. Get-SPOTenantLogEntry would return zero results when there are no logs present, though it can be a hit or miss sometimes. Go for a safer approach, recreate the error, wait for few moments and execute below command: $endTimeinUTC = Get-SPOTenantLogLastAvailableTimeInUtc $...


4

If you intend to use BSC External List to fetch data you should be aware of this important point If the retrieving items from LOB database are more than 2000 items you will face performance issue so I advise you to check external list limitation before you try to use BCS even if you increase its default max (2000 items)to absolute max via PowerShell ...


4

Is the recommendation to still use SPD 2013? As a short answer Yes, you can continue use SharePoint Designer 2013 to create External content type for Sharepoint 2016. For more details check my article at SharePoint Designer 2016 and InfoPath 2016 in SharePoint Server 2016, What're the alternatives? Note: To create External Content Type and working with ...


3

Forget about any third party tools. I was able to handle this very problem by modifying the sql call in the WCF service and using filtering that's built in to the BCS via SharePoint Designer. I've blogged about it here. http://www.spcrew.com/blogs/Lists/Posts/Post.aspx?ID=47 Here are the basic steps: Create a Method in WCF Service to call the database ...


3

You can actually recreate just the list forms without recreating the entire list. In Sharepoint designer, delete the original New form, ususally called "NewForm.aspx", then create a new "New" form, also called "NewForm.aspx". Any new columns will now be visible on the form.


3

Hope following article will helps, http://rompenpatrick.wordpress.com/2012/07/19/programmatically-setting-bcs-external-data-column/ When you create a BCS based, external data column within a SharePoint list there is another, hidden field created for you. This is given the name yourFieldName_ID so that if your field is called "Industry" the hidden field is ...


3

Business Connectivity Services! These are used when you want to pull data from other datasources/external data to SharePoint Environment, by other data source I mean it can be SQL Server database, Oracle, MySQL, Microsoft CRM, Microsoft Dynamics AX, in short anything! What it can offer to you? BCS can offer CRUD operations on your datasource using ...


3

BCS is the way that SharePoint can be made to understand how to access data which is not stored inside SharePoint. Its the abstraction layer between SharePoint and the external system. Because SharePoint can understand BCS then you get a lot of advantages such as External Content Types which really just present a UI for CRUD operations. With BCS you also ...


3

How about update the Deletion Policy? $SearchApplication = Get-SPEnterpriseSearchServiceApplication -Identity "Search Service Application" $SearchApplication.SetProperty("ErrorDeleteCountAllowed", 1) $SearchApplication.SetProperty("ErrorDeleteIntervalAllowed",0) Reference: http://technet.microsoft.com/en-us/library/hh127009(v=office.14).aspx


3

Ok I solved this issue after nearly a week of tinkering and Gooling, none of what I had done so far fixed it. So I gave up searching and reverted my efforts in creating another fresh instance of Sharepoint 2013, after installation I chose all defaults and check if it gives me the same error, to my surprise it didn't so I searched the differences and applied ...


3

You cannot add a content source to SharePoint Online (SPO). There are techniques to "Federate Search" between On Premise and the Cloud, but that configuration is more than I can answer here. If federation is not an option, I would suggest, now that you know this limitation, you readdress the business problem. For example, if you need to search for the "...


3

Wrong user in "set object permission", just check ther persmission and it would work!


3

I would also like to add that you can also accomplish this with SQL Table Views. So if you create a custom view within your SQL DB, you can connect to it in BCS using SP Designer as if it was a regular table. My understanding is that if the View is update-able as defined here, you will also be able to add Update controls to it. To add a view as an ECT ...


3

Like Melanie Culver alluded to a CAML query can be used to pass the parameters directly to the stored procedure. My external content type has an input parameter like this and I can specify my input parameter by name in JavaScript like: var viewXml = '<View Name="{my view GUID}" >' viewXml += ' <Method Name="GetTaskListForUserSite">' ...


3

Storing this much data is not an issue with SharePoint. But actual problem is presenting the data( reporting). In SharePoint their is thing called "List View Threshold" which had limit of 5000 items in a view. Even you stored the data in the SQL bring in Sharepoint using the BCS but again LVTH will cause the issue. What you do, create index columns, use ...


3

ok...first version of the script (with $.ajax) is the regular way to execute CRUD operations on items in lists (external and internal)..unfortunately it works only for internal list (by my experience)...so i've searched (for days) another way to execute insert statement (update and delete works with $.ajax) and I found a solution in a book (https://www....


3

Based on your question and comments, your issue is represented in creating an External Content Type without using SharePoint Designer because it's disabled in your organization for security reasons. So in your case, you can easily create Data Connectivity Model (Farm Solution Only) using Visual Studio. Once the solution is deployed, it will create an ...


2

From SharePoint designer: List and Libraries -> Click on list -> Under Views tab -> Read List Right click on the date field -> Edit formula Replace: $thisNode/@*[name()=current()/@Name] With substring-before($thisNode/@*[name()=current()/@Name], ' ')


2

Yes you can have n number of attachments by using streamaccessor method. See the code below that has two methods. One for picking up the main document and other for picking up the additional document. In the code behind you can use the same function to return the stream object. Let me know if you need any further assistance as I have already implemented this ...


2

you might try monitoring the process in the Forefront Identity Manager client (C:\Program Files\Microsoft Office Servers\14.0\Synchronization Service\UIShell\miisclient.exe). If you havent used that tool before, don't make ANY config changes with it or you could break the whole thing. However, it is a great tool to monitor the sync process as it is the ...


2

In SharePoint 2007 there is a service named as Business Data Catalog which could be used to only read external systems. However in SharePoint 2010 its re-designed as well as re-named as Business Connectivity Service or just BCS which comes with full read/write capability while interacting with external contents. Here's an MSDN article for if you want to ...


2

I also used changelog incremental crawl approach and it worked for me. Here's an example: <Method Name="ReadIncrementalList" IsStatic="false"> <FilterDescriptors> <FilterDescriptor Name="LastCrawl" Type="InputOutput"> <Properties> ...


Only top voted, non community-wiki answers of a minimum length are eligible