An external list is a list published outside of the scope of SharePoint usually with the tool Business Connectivity Services (BCS).

learn more… | top users | synonyms

0
votes
1answer
902 views

Synchronization of SharePoint 2010 List with SQL Server Table

I need to create a list such that the values on the list can be stored in SQL table as well. I need to attach workflows to the list item as well. Its a simple workflow with two approval process ...
1
vote
2answers
1k views

Show time only of datetime field in edit form of external list

I have an external list containing a datetime column called "Opening". I would like to show only the time portion of this column in all views (list, edit etc.). I know how to do this in the list view, ...
0
votes
1answer
134 views

Customize the InfoPath form of an External Content List

I generated an InfoPath form which OOTB gives me the ability to edit items in an External List, which in turn, updates a database table. This form however uses the Sharepoint ribbon control to show ...
0
votes
1answer
157 views

Best to way to populated external database?

I have a requirement where I need to populated a SQL Server database (tbl_Customer) with sharepoint List. I am not sure about the best approach. approach 1: bcs to external database and scheduled ...
0
votes
2answers
117 views

External list not implementing TimeSpan field

I am developing an external content type with sharepoint designer, based on a microsoft sql server table. One of the columns has the time(0) format. This is interpreted by sharepoint designer as ...
0
votes
1answer
347 views

Getting Large External Data set into SharePoint list

I have a list of "Customers" in a SQL database table with some very basic data:Id, Name, DoB, Mobile, Email, CusotmerType. There are currently about 80,000 customers I wanted to use an External ...
0
votes
1answer
499 views

How to create an external list from an ECT using powershell

I have an External Content Type in my Metadata store and I want to create an external list using that ECT, using Powershell script. I tried to use $Web.Lists.Add() with SiteTemplate = "External ...
1
vote
2answers
720 views

How to Access External List Data via Code?

Any suggestions would be helpful... I am attemting to access an external list using the Server OM. The external list is configured to use pass through credentials. The list functions perfectly in the ...
0
votes
1answer
398 views

BDC external contet type SharePoint Designer

I have problem with Business Data Connectivity, when I try to create new external content type in SharePoint Designer - I "Add Connection" then I choose SQL Server I fill Database Server and Name and ...
0
votes
1answer
593 views

How to have integer fields in an external list display without thousands separators on the display form?

I am using the Business Connectivity Services in SharePoint 2010 to display the content of a database table in an External List on my site. One of the fields in the database table is of int type and ...
1
vote
1answer
43 views

Parameterized External Content Types?

Suppose I have multiple instances of some line of business app in my environment. Is there a way to create a single External Content Type that can be parametrized and reused? If I have 5 instances, is ...
5
votes
3answers
1k views

Integrating an external database into Sharepoint

One of my current projects involves integrating a client's database into an overall CRM system design. Part of the process was updating their legacy database and porting it over to SQL Server. ...
1
vote
1answer
1k views

BCS External Item picker

There are two external lists like 'Project' and 'Task'. Task referencing project by using field ProjectID. I've created external content types. For 'Project' content type I've marked field ...
0
votes
2answers
772 views

An empty pipe element is not allowed - the Powershell I copied fails

I am just trying to fix something to get my BCS external list created. All indications are that the server has too many rows for BCS so here is what I put into the Powershell IDE running as ...
0
votes
1answer
171 views

External List & Picking pictures from a Picture Library

I have an external data source (BDC) based on which I created an external list. The (external) entity provides a field which can store / contain the link to an image. Now there is an Image Library ...
0
votes
1answer
851 views

What are the BCS/External List Limitations for ECMA CSOM?

I cannot seem to find any documentation on this topic. Are there any limitations for what I can or cannot do with the JavaScript CSOM in SharePoint Server Standard 2010 External Lists as compared to ...
0
votes
1answer
87 views

External List and External ContentTypes passing persistence errors back to the user

I have created an External Content Type in my Sharepoint 2010 installation that gets its data through a WCF Service from a remote database. I have implemented all the CRUD operations without issue. I ...
1
vote
2answers
2k views

working and filtering with large external lists using BCS

I have a large set of orders (about 7500) that I want to show in my SharePoint site. I'm using BCS because I also want to link the orders to documents. I also have an external list with these ...
2
votes
0answers
116 views

BCS and External List: Validations and Business Logic

I have been able to define an External List through a WCF Service. This works well, but I am now moving onto more advanced scenarios - I would like my Create, Update and Delete methods to implement ...
1
vote
0answers
185 views

Does BCS support creating an external list from an existing list in a different web application using List Web Services

I have sharepoint 2010 farm where there are multiple web applications. I am trying to understand BCS and its capabilities. This is the structure I have :- Web Application A > Site Collection > ...
0
votes
1answer
54 views

ECT: Agregate view, differing update and create forms

In short, I have a complex database containing documentation for IP addresses, servers, network switches and so on. This database should be manageable in SharePoint using, I think, external content ...
0
votes
1answer
2k views

Error with External Content Type List: “Unable to display this web part”

I have deployed an external content type to my local Sharepoint 2010 Server using a Visual Studio solution. The deployment appears to work. I can view the details of the content part in the central ...
2
votes
1answer
434 views

Have External Lists And / Or Event Receivers?

I am fairly new to Sharepoint. I am in the early stages of developing a SP2010 LOB app that will finally have like 50 lists which are quite interrelated with each other. I am asking for your help ...
0
votes
1answer
233 views

External list in SharePoint 2010 with unique item permissions

Is there any way to set permission for bdc items within external list?
0
votes
1answer
840 views

External Content Type and Entity Framework

I have been struggling with this project for about two weeks now. I have successfully created an External Content Type using Visual Studio and have deployed it. I was also able to use the SharePoint ...
3
votes
1answer
614 views

Paging and sorting with BCS - Is it really possible?

I'm trying to add paging on an external list and so far it does not work 100%. The best references I could find (that actually... kinda... work) are these: Paging and sorting with BCS Paging and ...
0
votes
3answers
587 views

SpecificFinder not called on Sharepoint 2010 BCS

I have an external content type for which I created a BDC model with a LobSystem of type dot.NET assembly. I have a SpecificFinder and a Finder method defined. I also have an external list created on ...
0
votes
1answer
309 views

lookup external list

I have two tables: Documents Project task What I am looking for is the following: I have a page with project tasks in a hierarchy list (done) Clicking on a task will open an edit screen (done) ...
0
votes
1answer
473 views

Logical AND ,OR CAML Query not working in External List

I am using ClientContext Class and CAML query to retrieve items from External List in sharepoint 2010.I have built the query with Logical AND Condition in CAML Query like this string sDataFilter ...
0
votes
2answers
2k views

How to edit InfoPath form from SharePoint Designer when it only returns an error message

I'm trying to edit an InfoPath form for an external list from SharePoint Designer. After clicking on the "Design Forms in InfoPath" button I get the following error: "Object 'blablabla.rem' has been ...
0
votes
1answer
105 views

Connect web part to list on separate Sharepoint Instance

As part of a migration process, I'd like to have a list view on the new environment(SP2010 standard) that's connected to a list in the previous environment(WSS 3). So different servers, site ...
1
vote
0answers
488 views

PageNumber-Fillter for Finder in .Net Assembly Connector

I'm currently trying to use an PageNumber-Filter for an Finder-Method in an .NET Assembly Connector. The relevant Part of the Method-Definition of the ReadList-Method looks the following. <Method ...
2
votes
2answers
935 views

Filter an External List on a datetime Field

So I have an external list in SharePoint 2010 that connects to a SQL database and pulls the data successfully. I also have 2 filters defined along with a limiting (TOP) filter. The first filter is ...
6
votes
4answers
3k views

Working with large external lists using BCS

I have a database that I want to display the content in SharePoint 2010. I am not displaying the content in a list but am using a custom WebPart. The database is not updated any more as it is ...
1
vote
1answer
239 views

Association between a custom list and an external list

I have a very basic question. I have a Custom List and I'd like to add a lookup column from an External List based on a WCF Service. Is it possible? E.g. I have employers in a custom list. I'd ...
2
votes
0answers
579 views

Sharepoint external list problem

I'm taking my first crack at creating an External list in Sharepoint 2010. I've taken 3 training classes in Sharepoint 2010, and am now trying to transfer my knowledge to my own development ...
1
vote
2answers
741 views

External list with bulk amount of data does not work properly

I have created and external content type to fetch data from a SQL table. The table currently contains 8000 records. So when I create an external list from that content type the list does not display ...
2
votes
2answers
4k views

How to read items in a BCS external list with PowerShell?

Is there a way that you get information from an external list (created from SPD for a specific ECT) differently than you do from a "normal" SharePoint list when using PowerShell? I did the following: ...
2
votes
3answers
1k views

How to authenticate BDC to the external system?

I'm using the following tutorial to define a workflow on a SharePoint list to create an element in and external List. When the workflow action tries to create the item in the external list, it fails ...
2
votes
3answers
4k views

How do I associate Workflows to SharePoint 2010 External Lists?

I've read that you can't associate workflows to SharePoint 2010 external lists but that there are workarounds for doing it. What do those workarounds involve? Can I do all of it in the Sharepoint ...
1
vote
2answers
336 views

Additional datasource in infopath

Is there any way to add additional datasources to an infopath form when using an external list? Infopath always complains about the form not being valid, because of the addinal datasource.
1
vote
1answer
1k views

Custom NewForm for external content type?

Is it possible to create a custom NewForm for an external content type without using InfoPath?
0
votes
0answers
176 views

Enterprise - External Task List - Connect to Outlook- setting Assigned To

I've got an External List coming from an External Content Type which has Office Item Type of "Task". It comes from an external system which has its own concept of a task, and I'm pulling them into ...
1
vote
1answer
552 views

Custom View Header Rendering Twice on External List

I'm starting to work with custom view stylesheets on an external list. I am finding the header is rendering twice - once upon initial page render and again after the data is returned from the server: ...
3
votes
2answers
706 views

Is it possible to programmatically invoke a workflow on external list items?

Is it possible to invoke a workflow on an external list programmatically and pass parameters into the workflow? Is there an example using SharePoint 2010?
3
votes
1answer
427 views

How can we use multiple fields from an external list in a survey?

We are trying to build a survey, that uses data from an external list. It works fine for a single field. But what we would like to do is to bring about 10 fields back from the external system and ...
0
votes
1answer
423 views

How can I update an external list connected to SQL?

I am working with Project Server 2010 and SQL Server 2008. I would like to create a multiple item form that connects to SQL Server. I tried using an external list in SharePoint that connects to SQL. ...