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

3
votes
1answer
272 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
1answer
61 views

bulk update the external list sharepoint 2010

I try to provide bulk editing and updating 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, ...
1
vote
1answer
781 views

Permissions to write to External List from Workflow

I'm attempting to create a SharePoint workflow that creates a new item in an external list using the "Create item in [External List Name]" action available in SharePoint Designer. Currently, I keep ...
3
votes
0answers
145 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
296 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
451 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
549 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
266 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
127 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
781 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
22 views

Sharepoint 2013 accessing external list in workflows

I have created an external list using WCF connections. I have in that list all the information that I need. Now I need to access that data from another list workflow(sharepoint 2013 platform ...
1
vote
0answers
124 views

Display Search box on an external list

I have an external list on a sharepoint site, from a BDC connector on sharepoint 2013. I want an inline Search box so that a search can be done on that list only. When i go into the web part and ...
1
vote
0answers
62 views

Can I get beyond SharePoint Throttling on External List without altering the threshold?

The SharePoint throttle for External Lists has been met in my most recent attempt to connect securely to an external SQL Database with approximately 5000 records. Of course, I get the correlation ...
1
vote
0answers
193 views

Handling identity column when managing SQL database table using external content type \ external list

I have a SQL table (with a primary key identity column) which I want to perform CRUD operations on using a SharePoint external list as a front end. I have setup stored procedures to perform the CRUD ...
1
vote
0answers
44 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
255 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
121 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
235 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
100 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
84 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
85 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
172 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
167 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
44 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
100 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
72 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
246 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
563 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
8 views

External Content Type based on SQL View allow insert/update/delete

I have two tables in SQL, one of them is read only (it is the "master"). The other is a detail table. They are joined on column 'VNO'. It is constructed with a left join on the master table, so ...
0
votes
0answers
11 views

SharePoint Designer not creating NewForm or EditForm for Stored Proc

I have created an external list using an external content type which uses stored procs for create, update, and delete operations. When I try adding a new item to that list using a Web Part, I'm ...
0
votes
0answers
33 views

Updating External List after Updating BCS: SharePoint 2013

I am using SharePoint 2013 and SQL Server 2012, both Enterprise Editions. Earlier I had created an External Content Type and created its External List. I have no problem performing various options ...
0
votes
0answers
69 views

JS Link on External list views (BCS)

How can I apply SharePoint Client Side rendering (JSLink) on an external List?
0
votes
0answers
14 views

WCF based External List Columns Type in Sharepoint 2010

In my Sharepoint 2010 I've created External List that uses WCF service as data source. This is my data type that is exposed by the service: [DataContract] public class Item { [DataMember] ...
0
votes
0answers
20 views

SP Designer 2010 external content type - database moved

I must be overlooking something really simple. I have custom forms in Sharepoint 2010, built on an external list that's tied to an ECT created in Designer 2010. The SQL Server database that contains ...
0
votes
0answers
8 views

Display some data collected from external sources to external customers?

we're looking the way how to display some data collected from external sources in SP to external customers. We have the list of projects handled in SQL. Every project has own number, name and status ...
0
votes
0answers
433 views

How to create list item in an external list using SharePoint workflow?

Environment: SharePoint 2013 SP1 I have an External List displaying data exposed through a WCF service. Creating, Reading, Updating and Deleting (CRUD) items in the external list works fine in the ...
0
votes
0answers
76 views

BCS OData navigation properties are not shown in SharePoint Hosted App external list

I have created a WCF Data Service that is hosted on Azure. I use this service as the data source for my SharePoint Hosted App's external lists. I noticed I was missing all navigation properties from ...
0
votes
0answers
52 views

“Connect to Outlook” button disabled on an External List based on “Contact”

I'm using SharePoint's Business Data Connectivity to connect to external source with contacts information. I created a .NET Assembly connector (BDC Model project in VS) with ReadItem and ReadList ...
0
votes
0answers
18 views

Business Data Connectivity Model based on Contact

I'm trying to create a .NET assembly connector for BDC. I'm creating the Business Data Connectivity Model and I'd like my entity to behave in SharePoint as a contact - so that I could use "Connect to ...
0
votes
0answers
39 views

Copy a list using a workflow

I have an external list that pulls in info from an SQL database, I would like to create a workflow to copy the contents of the external list into a custom list How would I do this? I can only see ...
0
votes
0answers
57 views

Calendar view for external content type

I have created a new external content type / external list that pulls information from an SQL database, the list has a start date column and end date column so what I wanted to do is create a calendar ...
0
votes
0answers
148 views

How to retrieve BDC Identity from External List programmatically?

I need to do a lookup on an External List (in SharePoint Online - Office 365) to retrieve the value of the BDC Identity. BCS is talking to an OData web service. (I'm not a Visual Studio guy), so ...
0
votes
0answers
105 views

Why can't i get data from External List within my workflow?

Im trying to load a value (string) into my SPD 2010 workflow from an external list. I want to save that value in a workflow variable, so I lookup for that external list and set up my filter's ...
0
votes
0answers
74 views

External List filter by Current User

How to field Current user on External Content make from the View. I have got a View with one field with the user name and Surname. How to Filter a External Content to see only the records wchich the ...
0
votes
0answers
817 views

External list - Access denied by Business Data Connectivity - Cannot add permissions

I created an external list, and got the "Access denied by Business Data Connectivity" error. So I tried to fix it by adding permissions on BDC Service, according to google, this is exactly what I have ...
0
votes
0answers
96 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
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
46 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
138 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
209 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 ...