Hot answers tagged

11

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

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


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

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


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

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

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


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


2

I am sure, we can create external content type for SharePoint online environment. See the attached image where I can see the option to select external content type name. Need to find out how this is done in VS 2012. I tried Napa tools but that doesn't have any option to create external content type. Hopefully, SharePoint Designer could help. As I promised, ...


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

OOTB SharePoint hasn't this feature, btw you could use the RBS Implementation: http://technet.microsoft.com/en-us/library/ee748649.aspx or a solution from Avepoint or Metalogix


2

After further research, it appears that the column was not displaying in the External List because it was of type Int64. Apparently those can't be displayed within Sharepoint. In my SQL View I converted them down to Int32 and they were then able to be displayed within an External List. The External List then needed to be updated to display the new column. ...


2

I would suggest that you should setup Business Connectivity Services if you can. This will allow you to connect to your external data sources in a managed way. You would then setup an External Content type and generate an external list from that. From there you would then query the list for your data and display the results with the dropdown list. A lot 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

Business Connectivity Services is what you are looking for! BDC was in SharePoint 2007 which was evolved to BCS in SharePoint 2010 There are few limitations when you work with External Lists, External Content Types and Business Connectivity Services... One of the most important is that you cannot associate workflows with them!, a complete list can be found ...


2

My ECT's Read List and Read Item operations returned columns whose type were complex. Once I changed the return columns to all be simple/native/value types, I was able to create an External List based on my ECT in either the browser or SharePoint Designer.


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.


2

You can use a content query web part. Then customize it in such a way it can be set to display image instead of the url. I am not sure whether you can customize the entire External List. When you are using the Content query Web Part you can customize the XSLT in it. There then set it to view the image instead of url.


2

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


2

As it turned out, I needed to configure an External Content Type Profile Page Host within the Business Data Connectivity Service. When the ECT Profile Page Host was configured, I could connect to the database and see the tables from the database within SharePoint Designer.


2

You can use below code to start with: var context = SP.ClientContext.get_current();//Get current app web context var mylist; this.web = context.get_web(); mylist = this.web.get_lists().getByTitle('My List'); var camlQuery = new SP.CamlQuery(); camlQuery.set_viewXml('<Query><OrderBy><FieldRef ...


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

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

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



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