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

learn more… | top users | synonyms

1
vote
1answer
12 views

SharePoint 2013 BCS and SQL Views

I have setup my SharePoint 2013 publishing site with BCS and Secure Store so that users can access multiple external lists within the site and if they have the correct permissions setup in Secure ...
0
votes
0answers
7 views

External Content Type does not match the schema version for the form

When I try to edit or view the item within the External List view the error message is as followed: Error InfoPath cannot open the form because of an application configuration error: The schema ...
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
7 views

External Content type column causes an error in the list view

I have a siet column/field of External Data type called "ABVictName". The problem with this field is that whenever I insert it in the List View it throws an error. In the logs I found this message: ...
0
votes
2answers
26 views

External Content Type - SQL - Filters

I create a new external list via a new external content type SQL . I retreive my data and i can display it. BDC Service allows us to view 2000 items . 1st Issue: I can filtered through a ...
0
votes
1answer
12 views

How to make user edit data in business data list?

I set up a business data list to get data from SQL server through external content type. It works very well and users are able to see the data from SQL server on their SharePoint UI. But now I'm ...
0
votes
0answers
6 views

How to change view style of Business data list?

When having a Business Data List webpart, we are able to search for an item. However the items don't allow a right click to edit the item. Do anyone have any ideas to help me change the view style ...
0
votes
0answers
8 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
9 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
21 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
28 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
22 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
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
16 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
65 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
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
1answer
25 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
27 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
1answer
20 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
1answer
31 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
74 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
20 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
21 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
24 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
38 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
127 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
33 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
634 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
51 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
36 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
21 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
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
56 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
20 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
34 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
128 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
25 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
492 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
63 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
266 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
74 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
48 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
51 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
143 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 ...