Tag Info

Hot answers tagged

13

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


7

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


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

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


6

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


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


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

There is no need to sync the SQL table and SharePoint list - instead use Business Connectivity Services (BCS) and create an external list. Read more here: http://msdn.microsoft.com/en-us/library/ee558778.aspx


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.


4

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


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

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

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

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

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

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

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

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

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

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

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

Have you enabled the site feature: Offline Synchronization for External Lists?


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



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