A variation of a content type that stores content outside of SharePoint.

learn more… | top users | synonyms

0
votes
0answers
3 views

SharePont Workflow initiated automatically on item create via email not able to read from external list

I created a custom SharePoint 2010 workflow using SharePoint designer for a 2013 SharePoint environment. My workflow needs to read data from an external list, and works flawlessly when the workflow ...
0
votes
0answers
6 views

Sage 50 Accounts Integration

I want to import Sage 50 Accounts information into my SharePoint Online environment as an external content type. Can this be done? Thanks
0
votes
1answer
8 views

Could not save the list changes to the server

I have an External List in SharePoint 2013. I am trying to create a new Edit Form in SharePoint Designer but unfortunately it is throwing Could not save the list changes to the server error instead of ...
0
votes
0answers
14 views

External Content type failed to save, The name domain\username cannot be resolved via Active Directory

I get the below error when I try to edit the external content type through SharePoint Designer. The Name Domail\username, is no longer with our organization. I believe he created this External Content ...
0
votes
1answer
14 views

ReadOnly columns in External List: SharePoint 2013.

I want to make some fields ReadOnly in External List in SharePoint 2013. I have tried JavaScript and SPUtility approaches as guided in this blog, but unfortunately did not work. In SharePoint ...
0
votes
0answers
7 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
7 views

Picker Control Filter for External List in SharePoint 2013

I have an External List in SharePoint 2013 as shown in image below. I have a field called Department. In the Read List operation, I have added wild card filter for Department column. For Calendar ...
0
votes
0answers
16 views

Order By clause is ignored

I've created an external content type using SharePoint designer with all 5 operations. Then, I figured it orders by the element ID. I've exported the BDCM file, opened it with Notepad, and modified to ...
2
votes
0answers
61 views

How to create multiple operator options in one filter, and how to add “contain” filter in external content type?

I'm creating external content type from SQL server to business data list. I would like to create a read list operator based on search stored procedure. I noticed in creating filter table, there's no ...
0
votes
0answers
19 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
1answer
20 views

External Content Type - Cannot connect to SQL server with user's identity

I'm trying to get some data from external content type from SQL server by using my windows identity, but when I add a new connection in SPD, and choose user's identity to connect, a error message pop ...
0
votes
0answers
4 views

How to use a web part to search a record from a external list?

There are many filters, query string filter, business data connectivity filter, business data list, and more. I need a quote or recommendation, so I can add a search filter above the external list ...
0
votes
0answers
21 views

Reference list from subsite

I want to use a list found in a parent site as a lookup in a list. As far as I could find was using external content types, however I don't know what the sql server back-end address is or what the ...
0
votes
0answers
12 views

Apps cannot use External Content Types defined in the Business Data Connectivity Shared Service Application metadata catalog

My issue is getting Unauthoraized exception while accessing external data in workflow 2013 context throw REST call (HttpSend). I read several posts suggests to create BDC model inside App package, ...
0
votes
0answers
21 views

Dynamically creating SharePoint 2013 external content type

Background: There is requirement of calling external list from SQL to SharePoint 2013. We have done it using BCS, external content Type and SecureStore. There are also some modification done using ...
0
votes
1answer
35 views

InfoPath does not support customizing the form used for this list.

How to enable this feature? "InfoPath does not support customizing the form used for this list." I want to edit the form in infopath and publish it back to SharePoint.
0
votes
0answers
14 views

Sharepoint 2013 issue when trying to edit infopath form

I have an external database in SharePoint, when I try to edit. It outputs the following error message: "The current operation requires Business Connectivity Services client components. Install ...
0
votes
0answers
17 views

External Content Type picker in Word 2013 (SharePoint 2013)

I have followed the steps at this blog (about using external columns in Word documents) and everything appears to have worked successfully - when I select "New Document" from SharePoint Word opens ...
0
votes
1answer
17 views

Create External content type using Powershell

How would one go about creating an external content type using powershell? Is it at all possible?
0
votes
0answers
23 views

Business Connectivity Services DateTime formatting

I have a SQL Server database with a number of columns of type Date. I have used BCS to create External Content Types in SharePoint 2013 for the tables in my database. However when a view these content ...
0
votes
0answers
37 views

SharePoint 2010: Unable to edit/update values in external data columns

I successfully created an external content type and external list where I can CRUD the content fine. I also needed to create a list with external data columns to the external content type but I am ...
0
votes
1answer
86 views

Create an external content type with PowerShell

Is it possible to create an external content type in SharePoint 2013 using PowerShell? For example, I have a view in a SQL database, and normally I would use SharePoint Designer to create an external ...
2
votes
0answers
31 views

Migrate external content types from 2010 to 2013

I have done a test 2010 -> 2013 migration and most things work fine. I have some user profile property mappings to BDC models I have restored the secure store, managed metadata, BDC services using ...
2
votes
2answers
400 views

Create External Content Type - Access denied by Business Data Connectivity

Following the technet articles on how to get external data into SharePoint 2013 (for testing purposes) I've created: Business Data Connectivity Service with Metadata Store Permissions Secure Store ...
0
votes
1answer
43 views

External content type: bdc identity

I have a list with an external content type. For 3 items, I have the same bdc identity. How is it possible? Is not bdc identity suppose to be unique?
0
votes
1answer
35 views

Creating a list-backed SQL Server database without using External Content Types

I'm trying to develop a list backed by a SQL Server database running on AWS in Sharepoint 2010 (also running on AWS), but I'm running into issues regarding authentication to the database. The only ...
0
votes
0answers
20 views

Unable to set permissions for an external content type (Permissions list is empty)

I created a BDC model that is connected to a WSDL web service: <LobSystem Name="TestWSModel" Type="Wcf"> <Properties> <Property Name="WcfMexDiscoMode" ...
0
votes
0answers
18 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
49 views

How do I get this field in the External List(ECT->BCS->SQL) to show up in SharePoint Designer Workflow?

I have created an External Content Type that has CRUD rights to SQL tables. Off that External Content type I have created an External List. I have a document library that has an InfoPath form on it ...
0
votes
0answers
18 views

ECT : Two SQL Tables Exact Same Schema Crawl Not Working

Background: a single sql server same DB, Table A and Table B with the exact same columns width different tuple data. I have a ECT for my SQL Server created in SP Designer 2013, Both Table objects ...
1
vote
0answers
29 views

Select Default Filter in BDCM File

When working with Business Connectivity Services (BCS) and Business Data Connectivity Model (BDCM) files, does anyone know in the code where to set the "default" Filter and hide the option? Right ...
0
votes
2answers
119 views

Creating app scoped external content type using Provider Hosted App in sharepoint 2013 using visual studio 2012

I am creating provider hosted app in Visual Studio 2012 using app scoped external content type having OData with Northwind url App manifest start page url : ODataNewAppWeb/Pages/Default.aspx ...
0
votes
0answers
24 views

External Data Field - check if item exists

I am using this code to set a external data field programmatically XmlDocument xmlData = new XmlDocument(); xmlData.LoadXml(myBCSField.SchemaXml); String bdcEntityName = ...
1
vote
1answer
376 views

External Content Types are not available. Contact your system administrator - BCS - User profile sync

I'm trying to setup a BCS connection from a SQL view -> user profile properties. I've created the external content type and got the right view. I also set the "set object permission", checked all ...
1
vote
0answers
55 views

How to provision External content Type using CSOM

Is it possible to provision External Content type and list using CSOM? Thanks in advance.
0
votes
1answer
231 views

The remote server returned an error: (407) Proxy Authentication Required.- BCS

We are trying to Consume OData in BCS using an App External Content Type. The OData service that we used is http://services.odata.org/V3/Northwind/Northwind.svc We followed ...
1
vote
1answer
28 views

External content types in sharepoint

I have an external list based webpart with 5 wild card filters. when I searched using one filter the required item is displayed but the same item is not displayed using other filter. For example if an ...
0
votes
0answers
41 views

List on External Content Type ECT modify edit form

I have a SQL 2012 table that that publishes a list in sharepoint 2013. I have been able to create some custom filters on the display page and pass those back and forth to get most of the list to ...
0
votes
0answers
67 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
32 views

SharePoint 2013 external content type query

How can I see the SQL query made by an external content type? From Central Admin in the BCS service application I can see the list of all the external content types but not the query.
0
votes
0answers
46 views

Cannot use external list data in workflow to update another list field in SP Designer 2010

I have created an external content to bring my sql table and created an external list with that table. Now I can even read the external list in the browser. My problem is that I'm not able to use the ...
0
votes
0answers
43 views

I have a list built on external content using bdc with a custom filter, I get the data but not the filter

SPD 2013, SP Enterprise 2013, SQL 2008 So I have a BDC connector setup with a SQL backend, I then built a Exernal Content List off that. I then inserted a content control webpart and inserted some ...
0
votes
0answers
119 views

How to perform Insert,update & delete operation on External Content Type by consuming the ECT operation

I am able to perform read operation on external content type using .net client object model (CSOM) but not able to find appropriate resource on Insert, update & delete. i have attached all the ...
1
vote
0answers
108 views

Error while creating external content type using SharePoint Designer 2013 against a SQL server 2012 Table

I am trying to create a external content type for my SharePoint 2013 environment using SharePoint designer 2013. The content type will be against a SQL Server 2012 table. The SQL instance is the same ...
0
votes
0answers
24 views

Set App External Content Type Connection Settings to OData Service Endpoint During Deployment

Is there anyway I can set the connection settings for the apps external content type during deployment/activation. The OData endpoint is hardcoded in the ECT file to my dev environment. Is there a ...
0
votes
1answer
169 views

SharePoint 2013 OData $filter seems broken with date functions

I am using SP2013 SP1. I am trying to perform the following OData opertaion from a client app that contains an External Content Type. The ECT points to a ASP.Net OData service. My Javascript code in ...
1
vote
1answer
57 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
votes
1answer
522 views

Custom Workflow Task with custom content type not working in VS 2012

I have created custom content type inherited from Workflow Task (SharePoint 2013) as i have to remove and add fields according to use. I also created a custom workflow task list, which uses ...
0
votes
1answer
203 views

Business Data Connectivity: error when saving External Content Type due to invalid assembly or codebase

I am trying to create an external content type that will be connected to a SOAP webservice using SharePoint Designer. To do this, I added a WCF Connection in the Operation Designer section with the ...
0
votes
0answers
34 views

Reporting server issue - external content type list

I created a new report with Report Builder, it is working fine into the client but when I open it in SharePoint I get this error: The shim execution failed unexpectedly - Proxy creation failed. ...