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
1answer
142 views

Read items from External list in Sandbox Solution

Can we read an external content type using a sandbox solution for share point online? If anyone has faced this issue then please share how is it possible. Thanks
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
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
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" ...
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 ...
0
votes
1answer
95 views

Create external content type with impersonated custom identity

I'm developing a SharePoint Application. I have SharePoint Foudation 2010. I have created a External Content Type with Impersonated Custom Identity(Connection to SQL Server 2012). After I created a ...
0
votes
1answer
155 views

Return value of the dropdown list rather than text when creating an item

I'm following this example: http://www.martinhatch.com/2013/08/jslink-and-display-templates-part-3-creating-a-custom-editing-interface.html I have a dropdown on the create new item page (external ...
3
votes
0answers
86 views

Ribbon is disabled when I Filter an external list in SharePoint 2010

I created an external list in sharepoint 2010 (SP1) using SPD. The backend is sql server. The I added a wildcard filter on a column called Source_System (and a limit filter). The out of the box ...
3
votes
0answers
172 views

How to filter a paged and sorted external list

I have succesfully implented an external content type with a read list method, which can sort and page through the external data. The external content type has 4 filters (two limit and two wildcard) ...
2
votes
0answers
49 views

Getting External Data from Oracle to O365?

We have an on-premise oracle database with customer info (lets say roughly 10,000 rows), that we need to make available in our SharePoint Online (2013) environment in O365. The requirement is that ...
2
votes
0answers
154 views

Alerts on SharePoint 2013 External List

I have created an external list using an external content type reading from a database server on our network that is not on the same machine as our SharePoint database server. I am also sysadmin on ...
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 ...
2
votes
0answers
108 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 ...
2
votes
0answers
546 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
0answers
29 views

Are third party solutions really that superior to BCS?

Let us assume it is my task to establish a bidirectional connection between a SharePoint List and a SQL-database. According to Paolo Pialorsi's Developer Manual for SharePoint 2010, BCS (Business ...
1
vote
0answers
30 views

Adding a non WCF SOAP wsdl as external content type in sharepoint manager

This is location to my wsdl, it is WSDL created by Spring WS: http://foo.bar/local/rpc/file.wsdl I am trying to add the connection to external data source from sharepoint designer. In the selection ...
1
vote
0answers
18 views

namespace on external content type

I have noticed that when moving BCS lists/external content types from my development computer to our production server, it keeps the namespace of my development computer. For example, all the ...
1
vote
0answers
79 views

Sharepoint 2013 - External List view/edit item in modal dialog

I have an External List, reading from a WCF. When I open an item (view item), I want it to open in a modal dialog. The External Data Source has 'read item' and 'read list' set up from WCF services. ...
1
vote
0answers
84 views

Send email after creating New Item in External List

I am using SP 2013 and I have an external list. But when I created a new item, I want to send e-mail to the specific people. Workflow is disabled for external lists. So can we create a new method in ...
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 ...
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
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
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
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
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 ...
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 ...
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
0answers
170 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 > ...
1
vote
0answers
460 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 ...
0
votes
0answers
19 views

Sharepoint 2013 BDC : How to set Yes/No (Boolean)

I have struggled to set a Yes/No column to Yes by simply assign true on the TypeDescriptor, but it allways turns out be set to 'No". I am using Sharepoint 2013, BDC Explorer and Visual Studio 2013. ...
0
votes
0answers
20 views

How to create dashboard through CSOM to show workflow from external lists

We have following requirement. SharePoint 2013 standard edition environment is installed. SO no BI site template is possible. Development has to be through CSOM only. Vendor data is stored ...
0
votes
0answers
9 views

external list linked to different external list

I created an external content type and then a list from that. It shows the departments of the organization along with the phone and fax number. So when I click on the Department Name, it ...
0
votes
0answers
10 views

top level external list used in subsites?

We have SharePoint Foundation. I created an external content type along with a list in my main site collection. I created a bunch of different views (one for each department of the organization). I ...
0
votes
0answers
11 views

BCS Question (scenarios when data source is unreachable)

I have a few real-world (hopefully simple) BCS questions for on-premise database and SharePoint Online (O365) connected by OData web service: In the scenario where the data source is ...
0
votes
0answers
15 views

Remove “Actions Menu” from list view with external data columns

I have a list which contains two external data columns. The view for the list displays an "Actions Menu" next to each of the external columns. This "Actions Menu" appears like little box and down ...
0
votes
0answers
31 views

Access External List Items in Sharepoint Online

I have created an external content type for SharePoint Online using share point designer. Now I need to create a web part that will fetch the data from the External List and filter it and show them ...
0
votes
0answers
83 views

Use Custom rendering Template with External List

Does anyone Know if its poossible to use a custom RenderingTemplate with an External List? In my Schema.XML I have <Forms> <Form Type="DisplayForm" Url="DispForm.aspx" ...
0
votes
0answers
66 views

External List - Search (filter) on some of the columns

I have an external List. (using Sharepoint 2013 Foundation) I want to be able to search on some of the columns. (say, when you click on a column header, have a textbox to search/filter on that ...
0
votes
0answers
312 views

Get Items from External List using BdcIdentity on server

I added a ribbon Action on an external list. When the users clicks the Button in the ribbon I use SP.ListOperation.Selection.getSelectedItems() to get the ids and of thr items the user selected. ...
0
votes
0answers
51 views

BCS: external data from SQL Server - Image column not showing

I created an external content type based on a view in the external SQL Server database with SharePoint Designer. So far it worked fine, but when I create a list of this ECT there are two columns ...
0
votes
0answers
36 views

Association between external lists. Get selected item

I have two external list ("Projects" and "Development process"). I connected this lists by associated key "project". When i create item in "Development process" i choose project in external list ...
0
votes
0answers
67 views

Cant get items from external list

I have an External list based on an External Content Type that is connected to Dynamics CRM. In an event receiver (C#), I successfully get an SPList instance that is able to print the 'Title' and ...
0
votes
0answers
22 views

SP 2010 - BCS - Displaying SP List with additional columns autopopulated from External List

I want to know if the following is possible. I have an SP list called 'Orders'. The Fields are 'Number', 'Quantity','Amount', etc. I have an External List from a SQL DB called 'ExtOrders' - Fields = ...
0
votes
0answers
125 views

Copy SharePoint 2013 External List Data to Custom List

I am currently developing a solution where I have en external content type/list which pulls filtered data back from a SQL source. What I am trying to do is get this data into a SharePoint list so ...
0
votes
0answers
120 views

Question regarding office 365/SharePoint online + workflow and external lists

I have two questions I need help with please. 1)Is it possible for a SharePoint online list workflow to update an external list in SharePoint online? IE When an item status has changed in a ...
0
votes
0answers
18 views

2 External Lists Can't be together in the same Site Collection

This 2 external lists are different projects, which developed by VS 2012. So when I deploy one of them, they have to not effect eachother. But these effects eachothers. Here is the situation: ...
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
0answers
163 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 ...