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

1
vote
0answers
72 views

Custom List Form works fine in Infopath but gets stuck when deployed

I have a custom list form for whenever I add a new item to a custom list. This form connects to an external sharepoint list that has 3000 records. When you type a client ID it will connect to the ...
0
votes
2answers
133 views

Get Items from View of an Extrenal List(BCS List) programmatically

I have created a external content type (BCS list) in SharePoint. I am using the below code in order to get items from bcs list. SPQuery query = new SPQuery(); query.Query = ...
1
vote
1answer
145 views

Copy data from external List Item to New Form

I have an external list that I want to add action to copy list item to NewForm. or any othwer way to take data from external list item to a new form. From display form, edit form any way will be ...
1
vote
0answers
65 views

External lists: Field GUIDs always empty?

I want to turn an external list into a DataTable using the ID/GUID values of external list's Fields as the DataTable column names; however, I've noticed for the external list I'm using, all of the ...
1
vote
2answers
190 views

SharePoint 2010 - To use content database or not to use

SP newbie here. I need to build a SharePoint 2010 application to track customer support cases. This will be the first time we've used SP, and I can set it up how I please. The built-in template for ...
0
votes
1answer
434 views

External Content Type not found in Business Data List picker

I have just created several ECTs along with lists to go with them and they work fine. Just my luck im on the final one and im stuck. Here's what I've done... 1. Created ECT and List 2. Given the ...
0
votes
3answers
190 views

Caching expensive query to use in a Web Part

I have a Web Part that connects to a SQL server and pulls summary data for the current user. (Think "dashboard".) Unfortunately this query is expensive to run so I'd like to cache the results to ...
2
votes
0answers
188 views

How to set selected value of external item picker

I have developed a custom edit form with an external item picker as application page in visual studio. The picker is populated with data using the following method. private ItemPickerExtendedData ...
0
votes
2answers
95 views

Filters get removed from external list when document is deleted from XsltListViewWebPart on same webpage

I have a webpage on Sharepoint 2010 that has: 1) An external list 2) A webpart that has XsltListViewWebPart referring to a document library When a filter is applied to External list, it filters out ...
1
vote
0answers
64 views

Bulk-Edit in external lists (Sharepoint 2010)

I try to provide bulk editing for external lists. I heard that the datasheet view is a convenient tool, but it is not enabled for external lists. Is there any way to get an easy, user-friendly bulk ...
1
vote
0answers
51 views

How do I change SQL connection from one server to another on an an External list

I have an external list that points to SQL Server A. Server A is being de-commission and the database is moving to SQL Server B. I need to change my connection for my lists. I created a new ...
1
vote
1answer
438 views

Querying an External Content Type without creating an External List

The typical scenario, on which every tutorial and walkthrough seems to advise, is to create an External Content Type with ReadList, ReadItem, Create, Update methods and then create an External List to ...
1
vote
1answer
351 views

Hide some fields from EditForm

I have some troubles with EditForm in Sharepoint. In SPD 2010 i have created External Type and defined CRUD method for him. I want to show in Disp form all item fields, but in Create and Edit form ...
1
vote
0answers
142 views

user lookup field for external lists

Guys please don't beat me too much, I want to add user lookup field into my external content type to use sharepoint people picker in my external list, the price doesn't stand up. So is it ever ...
1
vote
1answer
788 views

Event fire and Workflow Attach to External List?

What is the best way approach to attach workflow and Event Receiver on External List? How to store Directly External Data to SharePoint Custom List?List
1
vote
1answer
86 views

Associated ECT only displays ID (not title) in external list

I have created two ECTs, let's call them country and city for clarity. I have also created an association with city as the child and country as the parent. When I create an external list for city, ...
1
vote
1answer
203 views

Customizing external list form

I need to create external list and i need customize display and edit forms. I want add something like tabs, i.e. i want to input some fields in one tabs, and some in another. I must use ClientObject ...
1
vote
0answers
124 views

SPFieldUrl does not work

I have an external list, items in that list have a field that contains an url. I want to show this url as a link in sharepoint form. I found this example and defined in my Creator and Updater methods ...
1
vote
1answer
362 views

Custom form template with external list does not work

I have following .ascx file <%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register TagPrefix="SharePoint" ...
0
votes
1answer
40 views

need support/materials for developing external lists with visual studio 2010

Up to now, I have mostly used Sharepoint designer to develop external content types and lists. Due to the lack of source control and for other reasons, we would like to move the development process ...
2
votes
2answers
438 views

Custom forms for external lists guidance

I need guidance/suggestions developing an app which will be hosted in SharePoint using external content types. So far I have a BDC model which works fine for reading the data und displaying it in an ...
0
votes
2answers
95 views

How do I retrieve associations items for list field using JavaScript

I have any ExternalContentTypes(ECT) with associations between them. One ECT is shown in an external list. I want to add a custom button on that external list ribbon. And it must change value ...
1
vote
0answers
42 views

How add personal list for all users

I want to integrate Sharepoint with my external system. Sharepoint should load tasks from my system and show them in the list on user personal page. Integration should be done using Sharepoint ...
0
votes
2answers
317 views

How i can get “item ID” column through “BDC Identity” column

I create external list for display external items from my wcf service and add custom action on that list EditForm through ClientObjectModel with this url: ...
1
vote
0answers
84 views

Run custom javascript when external list table loaded

Is there any way to run custom javascript after table with external custom list is loaded on page? The external list table is loaded on page with some delay and I would like to modify its content ...
0
votes
2answers
174 views

update external list data using infopath codebehind

I know that I can update my ECT record (using InfoPath forms I created for the external lists), by passing the BdcIdentity (ID) to the form and it will find that record and enable me to edit. How do ...
0
votes
0answers
42 views

Can't read by loop foreach Externall List

If I tried to view in Element one of three External List I geting this error: Unable to display this Web part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint ...
0
votes
0answers
106 views

Reading a data from External Lists

I have got a problem to read data from External List. I getting this error while I reading a External Lists: Exception Details: System.Xml.XmlException: Name cannot begin with the '-' character, ...
0
votes
1answer
189 views

Display an External List in a DataView webpart

My scenario is as follows: I have a dataview wp which currently displays list items (from ECT). In the DataView wp I filter the data according to a parameter passed in from another wp. The current ...
1
vote
0answers
61 views

How to get External List Item URl?

I want to get Item URL of External List. I tried using ListItem.URL but it is returning BLANK. Can anybody help me. Its Urgent..
1
vote
2answers
578 views

Use the same InfoPath form for inserts and updates

I am using an InfoPath form to add records to a database table. I do this by creating an External Content Type in Sharepoint Designer. Then from the content type I create an External Sharepoint List. ...
2
votes
2answers
621 views

External lists do not display data though data are available

I have external lists connected to a sql server database. Since the last day, some of the lists do not display data; the lists are empty, only headers are shown. (Some lists still display data, ...
0
votes
1answer
53 views

Problem with performance of External List

In my company a person which are Administraiting the CRM Microsoft Dinamics give me one of External list with a Vacation of Workers in Company. I try first with list local in my project, and this list ...
2
votes
1answer
1k views

External List from External Content Type: missing and/or error

I've created an ECT w/ Read List and Read Item operations using SharePoint Designer, saved it, and given myself permissions. The ECT's external data source is a WCF service. When I try to create an ...
0
votes
1answer
859 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
781 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
129 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
152 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
104 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
321 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
381 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
646 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
335 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
524 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
41 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
895 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
697 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
149 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
725 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 ...