Tag Info

Hot answers tagged

12

Business Connectivity Services (BCS) is the way to go...here's a nice 3 part series on setting it up as well as programatically working with it: http://www.zimmergren.net/archive/2010/01/18/sp-2010-getting-started-with-business-connectivity-services-bcs-in-sharepoint-2010.aspx Tons of data out there if you want to do additional research...google SharePoint ...


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


6

In my experience, this would work best as a webpart. When editing the displayforms, to play nice with SP, you have to keep that listview webpart on the page. Fortunately, you can make it hidden. So, what I would do is create a webpart that duplicates the functionality of your application page. Edit the displayform page using the browser, edit the webpart ...


6

Got it! <View> <Method Name='ReadList'> <Filter Name='PartnerName' Value='{0}'/> </Method> <Query> <Where> <Contains> <FieldRef Name='Name'/> <Value Type='Text'>{0}</Value> </Contains> ...


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


4

External list data is stored in the external system, and not in SharePoint. SharePoint stores connection information and the schema of the external data. For client systems only, there is a cache component for the external data (using SQL CE). I think this is the source of the confusion.


4

Our solution was to go to SP Central Admin > System Settings > Services on Server and start the "Claims to Windows Token Service". We also found this error in the logs which helped lead us to this as the solution: SPSecurityContext.WindowsIdentity: Could not retrieve a valid windows identity for NTName='PRMM-SP\polyadmin', ...


4

DropBox does have an API with a REST interface - described here. I think REST may be the way to go compared to BCS. There's an article showing how it is used (via .NET) - Create, delete and move folders with the Dropbox REST API.


3

It sounds like you need to set permissions on the BCS entity. In Central Admin go to Application Management, then Manage Service Applications. Open the Business Data Connectivity Service and select your entity, then select Set permission from the context menu or click on the Set Object Permission button. Once you have permission to the entity the error ...


3

As usual, there's several ways to pull this off, some better than others. The "most SharePoint-y" way to do it is using Business Connectivity Services (BCS). That link includes a intro/tutorial on how to use BCS to create "faux lists" that are backed by an external data source, such as SQL (or much more exotic sources!). Secondly, Sahil Malik wrote a great ...


3

Apparently this is a bug. A possible solution is to use http://localhost/ as the URL, but I think this may still get overwritten by VS when you next open the project. In that case a custom build action may be the way to go for the time being.


3

In case you do not want to use BCS (I am personally not a fan of BCS) there are some third party alternatives. This component from Layer2 for example is very easy to use but maybe best suited for lists without a feature based content type: http://www.layer2.de/en/products/Pages/SharePoint-Business-Data-List-Connector.aspx In my opinion BCS has these ...


3

You can map User Profile properties to BCS connections as long as there is a unique identifier on your SQL data that can map to a unique property in the User Profile. Here is a blog post that can walk you through it: http://www.kowalski.ms/2010/07/20/sharepoint-server-2010-supplementing-user-profile-imports-using-bcs/


3

One of the limitations I have encountered is that if you query the external list you need to specify all fields in the ViewFields collection, otherwise you will get the following error: "The given key was not present in the dictionary'. I have blogged about it here: http://sharepointnadeem.blogspot.in/2011/08/given-key-was-not-present-in-dictionary.html


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

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

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


3

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


2

The BCS can integrate with any system that can be exposed through SQL or Web Services. I have a strong preference to use Web Services for any integration so that you have a defined integration point that is easier to reuse. If Sage Timberline has published web services then you may be able to connect to them from the BCS. Worst case scenario you can ...


2

One option as you say is to leverage the Secure Store Service (SSS) and allow users to map their credentials of the account they use to access SharePoint your backend system. This mapping is done by the user in a self-service way if it can't find a match, not by an admin. However if you don't want to do that, you could implement a custom .NET Assembly ...


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

You will need to set up the External Content Type to the correct Office Item Type, by default it is generic list but there are other options available. Appointment Contact Task Post There is a good blog here: http://www.chakkaradeep.com/post/SharePoint-2010-Business-Connectivity-Services-Walkthrough.aspx If you are using a third party tool to create ...


2

A common cause of Access denied from BCS is not having permissions on the External Entity. To check this navigate to the Business Data Connectivity Service Settings (Central Admin, Manage Service Applications) You should see the list of external content types. Check the permissions on the External Entity that displayed an Access Denied error by selecting ...


2

Yes, you can. You need to create them on the External Content type, through SharePoint Designer. Edit your Read List method - and when you configure your Filters Parameters add the filters you need. You should be able to add many filters. When configuring the filters, make sure you check the "Use to create match list in external item picker". You should ...


2

The answer is adding the following code to your model: <FilterDescriptors> <FilterDescriptor Type="Wildcard" FilterField="Name" Name="Product Name" > <Properties> <Property Name="IsDefault" Type="System.Boolean">true</Property> <Property Name="UsedForDisambiguation" ...


2

Going up through the gears: 1) For a simple scenario, use SharePoint Designer to create an external content type (formerly known as entities) and an external list based on this. Then use the normal SharePoint OM to query that list (or you can use the more powerful BCS Object Model). The SPD tools are surprising powerful and include the ability to pull in ...


2

I am working on a system with exactly the issues you talk about. My observations on your points; To filter results based on unique IDs such as ClientID you can add a (comparison type) Filter Descriptor to the Finder method of your entity. The limitation I have found with External Lists is that these filters are only exposed by views on the list so for ...


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



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