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

The service might be running but make sure that you have associated the service with your Web Application. Go to Central Admin > Manage Web Applications > Select the Web Application > Click Service Connections in the Ribbon. In the dialog make sure that the BDC Service is checked.


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

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

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

External content types are available at farm level so you should have no problems accessing them across site collections. Just make sure you have the permissions set correctly.


2

Try using SharePoint Designer to edit the Entity you mapped to an announcement. In my experience SharePoint Designer reports more warnings than a BDC Model import.


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

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

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

MOVED FROM COMMENT BY @chris-m (marked as CW) Solution: Turns out the issue was caused by the configuration of the scope rule, ContentSource = NameOfContentSource (which we had incorrectly named after the ECT). The name was misleading because a content source represents an external data source not an individual ECT. Over time we added several ECTs that ...


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

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

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

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



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