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
2answers
27 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 ...
1
vote
1answer
776 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 ...
0
votes
0answers
8 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
1answer
579 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 ...
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
1answer
528 views

SharePoint 2013 External Content type. Populate secondary fields

I am trying to migrate data to a document library that contains a external content type using the SharePoint 2013 client object model. The external content type is pulling from a sql server 2012 ...
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
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
0answers
107 views

Custom BCS External Content Type Error handling

Using SharePoint 2013. I have created a custom BCS model (bdcm with custom assembly deployed to GAC) to create external content types to connect to an proprietary external data source. I have created ...
1
vote
1answer
654 views

How to create new External Content Type on SharePoint Designer

I'm trying to create a new External Content Type on Sharepint Designer , but where I try to insert the web services wisdom into the "New Connection -> WCF Connection " I get the following error: ...
1
vote
1answer
673 views

Throttled While Crawling Large External Databases

I created an ECT using SPD2013 last week. It connects to a SQL DB while using the Secure Store to impersonate a domain user for a particular DB View. Last week, I used my personal (farm admin) ...
0
votes
1answer
23 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
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
1answer
22 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
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
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
31 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
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 ...
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
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 ...
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
77 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
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
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
826 views

How to create an external list from an ECT using powershell

I have an External Content Type in my Metadata store and I want to create an external list using that ECT, using Powershell script. I tried to use $Web.Lists.Add() with SiteTemplate = "External ...
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 ...
2
votes
2answers
2k views

How to connect multiple external tables into one SharePoint list to perform CRUD operations

I am working with SharePoint 2013 and I have a requirement where I have to perform CRUD operations on multiple external tables (SQL Server) with SharePoint in one List and vice versa. I am able to ...
0
votes
0answers
39 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
1answer
885 views

Secure Store Application ID credentials don't work when creating ECT

I have been going crazy trying to figure out why this is not working. I followed Fabian Williams blog entry to the letter. I have a development farm with everything on a single farm. I DID NOT use ...
0
votes
3answers
2k views

Update and Create Problem with Adding Columns to an Existing External Content Type in SharePoint 2010

I used SharePoint Designer 2010 to create an external content type (ECT) that consumes and writes data to SQL Server. [Went through the process of connecting to a database table, then right-clicking ...
2
votes
2answers
653 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 ...
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 ...
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
0answers
124 views

create a BCS External Content Type based on a WCF web Service using Visual Studio.

How to create a BCS External Content Type or list Based on a WCF Web Service using Visual Studio. The link provided shows the requirement through Designer. ...
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
1answer
108 views

BCS Managed Client Code Get all method instances

When using the class Microsoft.BusinessData.MetadataModel.Entity entity; does anyone know how to get all the External Content type operation method instances so i can dynamically pass the value to ...
0
votes
0answers
65 views

Filter BCS Data by Users AD Group

I'd like to know if it is possible (and if so, how) to filter the BCS data results by the AD group a user belongs to. For example. User A belongs to AD group 'group1'. In the external data that ...
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 ...