Tag Info

Hot answers tagged

10

Thus far, using the object model has been the only way I have been able to successfully do this. I encountered the same issues as you when using PowerShell. Using Jaspers' post SP2010: Setting BCS column and related fields as my guide, I used the following code to iterate through all the items in my Resumes document library, read the value from the ...


6

Thanks, guys, I'm already create paging and sorting with BCS. In my case BCS works fine with WCF services. At first I'm develop web service with follow contract: [OperationContract] IEnumerable<Employee> GetEmployeesPaged(int startRowNumber, int pageCount, string sortColumn, string sortDir); then I'm created BDC definition with Read List Method for ...


5

SharePoint Designer will also expose any views or stored procedures you have. You can set those up for use in the external contenttype. If you go into the data source explorer in sharepoint designer you will see views and routines in the tree under your database. If you can add a view or a stored procedure in SQL, then it will show up there and you can take ...


5

In terms of technology opportunities and capabilities you could : 1. Create your own Visual Studio BDC Model where you could create your own Entities, with relationships mirroring your configurations - additionally you could rely on Stored Procedures for various operations not available otherwise, e.g. Updates across multiple tables, View selecting from ...


3

Option 3 does seem like a no brainer until you start learning about all the limitations of external lists, such as: No datasheet view True server side paging is difficult, especially in a .NET connectivity scenario. The paging that you configure on a list will not be server side. Here is an approach to a 'pseudo' server side paging (it always does top N) ...


3

Large List Threshold in 5,000 items for users, and 20,000 for site collection admins. When list hits this threshold you can't query whole list, view filters can be applied only to indexed columns. On paged views there is no difference, on Data Sheet View will fail. External lists have no Data Sheet View (!), REST interface, RSS. You can't query more than ...


3

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 ...


3

You can create a custom webpart where you can query your external list using CAML. There is already a question how to pass parameter to ReadList function to return filtered items, in your case you can pass identifier entered by user as the required parameter. You just have to create FilterDescriptor when creating external CT/List. Source: CAML and External ...


3

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 ...


2

If it is a single administrative action, you can simply use SharePoint Designer for creating a ribbon button: http://msdn.microsoft.com/en-us/library/ee558387.aspx For performing your field update, you can then use workflow or Application Page with query string parameters. If you need reusable solution (for wsp), I recommend you to use SharePoint 2010 ...


2

The use of BCS for external content types and lists is more suitable for surfacing external data in a familiar format that business users can consume - a SharePoint List. I don't see much of an advantage using it the way you are suggesting. Have you considered using BCS to augment user profiles to pull in the bio information as a mapped property? This would ...


2

I have written this blog post which shows how to do what you are after: In Visual Studio http://www.lightningtools.com/blog/archive/2011/01/10/sharepoint-external-listndash-using-the-picker-for-foreign-keys.aspx In SharePoint Designer http://lightningtools.com/bcs/lookup-foreign-key-values-in-external-lists/ Also make sure you set the 'Title' column for ...


2

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 ...


2

There is an article in the DUET info on MSDN that shows you how to do this: http://msdn.microsoft.com/en-us/library/gg271157.aspx I think you can do it as follows as well (since an external content type is still a content type; however I have not tested this): - Create your external list from the external content type - Go into the external lists you ...


2

I managed to get my form created! I'm posting the solution that worked for me in case someone else stumbles on the same problem. The forums and blogs I've read were correct. You have to delete the external list and recreate it. I've already done this several times and it didn't work. But today I changed the name of the list (until now I was always ...


2

I think so (although I never done it on external content type just on 'regular' lists). You can create new external list (via UI or via Sharepoint Designer). Then you can use Sharepoint Designer to modify your NewForm.aspx (pick your list and click NewForm under Forms tab). Before doing some editing consult Google and look for some examples (mainly 2007 ...


2

Right, I think your error is that the user you are trying to use with BCS is unable to connect to the SQL database. You actually have two different authentication elements to deal with here: 1) Who the User connects to the BCS Service as. 2) Who the BCS service connects to the SQL database as. You actually need to set up 2), then 1) For point 2 you'll ...


2

The answer to my question is "Yes, there are potentially some differences in some parts of accessing external lists from PowerShell". I believe I figured out all the errors I ran into that I posted in my question, updates and comments. Exception calling "GetItemById" with "1" argument(s): "Attempted to perform an unauthorized operation." This error ...


2

The solution is using BCS resources. How to create and import BCS resources: 1) create a file with .bdcr extension 2) add content there like <Model xmlns="http://schemas.microsoft.com/windows/2007/BusinessDataCatalog/Resources" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Name="..."> <LobSystems> <LobSystem ...


2

You'll need to configure the external content source, the simplest approach is to use SharePoint Designer and externa list, this blog post from the Lightening Tools guys will help: http://www.lightningtools.com/blog/archive/2010/01/05/spd-external-content-type-from-wcf.aspx


2

Please refer to the below link. It explains very concisely how to do that http://techdhaan.wordpress.com/2010/02/16/consuming-external-content-typesbcs-in-infopath-forms/ Working with External Content Types and Infopath http://msdn.microsoft.com/en-us/library/ee554886.aspx ...


2

Depending on how much if any of the external list / content type features you are looking to use I would be on board with Marius as far as avoiding InfoPath and the BCS goes. In a situation like this I would create a custom web part and use plain old ASP.NET combined with the data access type of your choice (Entity Framework, LINQ to Entities, SQL / Stored ...


2

I had a similar issue with an application I was working on at work. I tried customizing the BCS input pages, writing my own BCS data access components (makes the data access overly complex), and a few other options including LINQ to SQL in a custom web part. Ultimately, what I ended up doing was creating an external (WCF) web service hosted outside of ...


2

Hassib, If you are using WCF Web Service to bring SQL Server data to your SharePoint environment, you can have a look at How to: Create an External Content Type Based on a Web Service You don't need to add SharePoint Admin account to SQL Server in this case, because database connection will be made by Web Service and Web Service account will be used for ...


2

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 ...


2

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 ...


2

I think this is the correct way of doing it. Copying the data from Old List to new List using datasheet view would have made copying data easy, but datasheet view is not available in External list. You can create a console application or PowerShell script which will read data from old list and insert it into new External list.


1

Looking at that tutorial, the part that stood out to me was this: Workflows accessing Business Data Connectivity (BDC) service always run as a service account, even under the impersonation step. A workflow always runs as a service account and is supported only when using Secure Store Service or RevertToSelf (which is disabled by default because ...


1

Central Administration > Application Management > Service Applications > Manage service applications > Business Data Connectivity Service Select your external content type, click Set Object permissions and edit them. Set permissions on an external content type


1

You can create a lookup column based on an external list, but you can't have multiple selections or bring in additional columns. This is a limitation of the external list data in SharePoint 2010. See MSDN.



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