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
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 ...
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 ...
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 ...
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 ...
0
votes
1answer
19 views

Case of an external list being inaccessible

I have an external list that I created with a bdc, but it might happen that the external source is not available is there any way that the sharepoint saves a last access? if not what is the best ...
1
vote
1answer
89 views

External List (List view) change layout to multiple columns

I'm using Sharepoint 2013. I have an external list. In the list view, I want to add 3 web parts horizontally. (side by side) That means I need to change the page layout. But couldn't find where to ...
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 ...
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
1answer
131 views

External List : XsltListViewWebPart not loading view (Team Site)

Scenario: I have external list and I want to show specific view on team sites homepage. I add XsltListViewWebPart with featurereceiver because I can init specific settings and view to it when creating ...
1
vote
2answers
127 views

How can I get external content crawled into SharePoint online index

I have SharePoint online and I want to add external content to the index. So far I have it set up that the external content is put into an external list using BCS. The content passes through a WCF ...
1
vote
1answer
55 views

The query against the database caused an error

I have two farms. I restored a custom SQL Server database from farm1 to farm2. After this when I try to access my external list which fetches data from one of the tables, it is showing error: The ...
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 ...
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 ...
2
votes
1answer
72 views

Create External List on SharePoint online

Does anyone knows if it's possible to create an external list from another external list? Is it possible to create an external list on SharePoint Online from an existing external list on SharePoint ...
0
votes
1answer
43 views

XSLT not displaying data from Arabic column external list

I have an external list named "users". It is coming from SQL Server and has following two columns: English_Name varchar(300) Arabic_Name nvarchar(300) Notice the Arabic_Name field has data ...
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 ...
0
votes
1answer
99 views

How SP generates ID for each list item

When you click open an item in an external list, you have a url like this: ...
0
votes
1answer
77 views

Secondary lookup columns for external content types not displaying data in list after refreshing from primary

I have created a SharePoint list that has a lookup column to an external list. I also have instructed SharePoint to display several secondary columns that are related to that primary external lookup ...
1
vote
2answers
480 views

How to get the current custom view name of my SharePoint List

I am using the following JQuery to get the current name of the View for External SharePoint list. var ctx = GetCurrentCtx(); var listName =ctx.ListTitle; var currentView = ...
0
votes
2answers
96 views

JSLink doesn't work when it got redirected from list item page

I have a JSLink file to customise an external list and list items. context.Templates.Fields["VM_NAME"] = { "View": VmNameRenderCallback }; ...
2
votes
1answer
75 views

[Today]-15 filter not working on external list

I have an external list which is getting data from SQL Server. The table structure is as follows: Name InsertDate Where InsertDate is the date when record was inserted. I am trying to show only ...
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
1answer
86 views

Open item from a different External List (BDC connector)

I have a "Quote List" and "Task List". Both are external lists, using BDCM custom connector (from WCF services) I'm using Sharepoint 2013. A new task will be create when a quote is approved. So on ...
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
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
1answer
267 views

External List - changing a column to dropdown in Sharepoint 2013

I'm on Sharepoint foundation 2013. I have a external list (based on a WCF) For the new and edit form, I'd like to have some columns to be a dropdown (list to be populated from another WCF) Is ...
1
vote
1answer
142 views

External List - change a column to dropdown (Sharepoint 2013)

I'm on Sharepoint foundation 2013. I have a external list (based on a WCF) For the new and edit form, I'd like to have some columns to be a dropdown (list of selections to be populated from another ...
1
vote
1answer
30 views

Do I need Kerbros when I want to configure external list?

I am assigned a task to configure external list, and I am reading that if I want to delegate authentication to external sources, I need to set up Kerbros, do I need to configure Kerbros on the ...
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 ...
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 ...
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. ...
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
1answer
128 views

How do I manipulate an external list view's columns with javascript?

I want to manipulate the columns of an external list view (XsltListViewWebPart), however, as the data loads asynchronously I must wait for the data to load and the table to be generated before my code ...
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
1answer
99 views

Configure “Check if item exists” in external item picker

I work on the edit form of an external list. I can pick items from an associated content type with a picker. There is the option to "Check if item exists", but currently it only accepts IDs. Can I ...
0
votes
2answers
183 views

save fails with controlmode=“display” on form field based upon an association

I have a sharepoint external list with an edit form containing a form field based upon an association. The field is not nullable. I want to prevent edits on the field, so I set controlmode="display". ...
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 ...
0
votes
1answer
523 views

Add Column to External List from Updated External Content Type

We are currently trying to understand the relationship between External Content Types and External Lists within SharePoint 2013. We have a read-only ECT which we defined based on a SQL Server View. ...
0
votes
1answer
52 views

Problem showing External List in a page

I have a external content type that is showed in section of lists (Insert in Ribbon). I want to add it to a page but when is added, It shows list of BDC Identity, and when I click on them, main data ...