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

learn more… | top users | synonyms

0
votes
0answers
67 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
300 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
90 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 ...
3
votes
2answers
2k 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
76 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
46 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
22 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
24 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
104 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
21 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
50 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
184 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
36 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
966 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 ...
2
votes
0answers
85 views

How to provision External content Type using CSOM

Is it possible to provision External Content type and list using CSOM?
0
votes
1answer
499 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 ...
1
vote
0answers
87 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 ...
1
vote
0answers
161 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 ...
1
vote
1answer
284 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
99 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
910 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
322 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
1answer
15 views

External Content type linq error

I have a list with an externa content type. I am tring to fetch the element by server side code, but i get this exception: Microsoft.BusinessData.Infrastructure.BdcException This is my ...
0
votes
0answers
27 views

Set external content type by javascript

In the NewForm, I need to set an external Content Type lookup field by javascript. How can I do it?
0
votes
1answer
148 views

Using External Content Type to display XML file data as Contacts list

My client has a contacts list in some other system and this data needs to be displayed in SharePoint as a Contacts list. This external system can provide an xml periodically with the contacts data. ...
0
votes
0answers
42 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
369 views

Sharepoint Online External Content Types WCF Service

I have this issue I can't find solution for a couple of days now as I am working on creating External Content Types for Sharepoint Online 2013 (trial period will expire in the next 5 days :( ). I ...
0
votes
1answer
46 views

External Data Editing and Modification

Can data in a SQL database be modified (new, delete, edit) through a SharePoint out-of-the-box feature or custom built feature?
1
vote
1answer
45 views

External Content Types Filters

I have created an external content type to connect to a SQL database to show client information in SharePoint 2013, once the connection was created I created a list to display all the info I then ...
2
votes
0answers
140 views

Unable to Refresh BCS External Data

I am running into a refresh issue with BCS. Whenever I hit the little refresh button in the UI, I am repeatedly getting this error. I am using an OData web service for BCS with WindowsCredentials ...
1
vote
0answers
15 views

List view of external content type with group by

I've got a list that displays data from an external content type. The view uses group by on a single column and I want it to be rendered collapsed. This view works just fine. And if I create a web ...
1
vote
2answers
414 views

How to do a Filter in a BCS External Data picker

I am using an OData web service with BCS (testing with Northwind) and I would like to define some filters when using the External Data picker. I'd like to be able to have a drop down that then ...
1
vote
1answer
463 views

BCS: how to pass input parameter in GetList operation in ECT?

Sorry for this basic question, but I am new to SharePoint and programming in general. I have a wcf web service which contains the following CRUD operation: GetFilteredCompanies(string country); // ...
0
votes
2answers
55 views

How to decide between native SharePoint Lists or External Content Types?

We need some guidance on where we should house data for an application that will have all the data entry performed through SharePoint. Our team is building a HelpDesk ticketing system in SharePoint. ...
0
votes
0answers
76 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 ...
2
votes
0answers
171 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
1answer
235 views

SharePoint: Perform a query to load data into external list and display the results in a list within the webpart

I am relatively new to coding and I am trying to complete a project in Sharepoint. I have a webpart which includes Peoplepicker. When the submit button is pressed the first username passed is used as ...
0
votes
0answers
34 views

Create external content type without using SharePoint Designer

I have a web service and I need to create an external content type. I am using SPD but that is not working. It is asking me to select at least one field and the errors will not go away. So I am stuck ...
2
votes
1answer
173 views

Sharepoint 2010 External List Image column

I have a SQL table with 5 columns in it (EmployeeName, StartDt, EndDt, Location, PictureUrl). I want to display this data in a Sharepoint List. I want the image to be displayed in my sharepoint list's ...
1
vote
0answers
172 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 ...
0
votes
1answer
120 views

How to change URL in search results from custom quelle

Given a database table with following columns: ID, TEXT, URL. This table contains some useful links to external sites. In Sharepoint 2010 we have added this table as a custom search source. How to map ...
1
vote
1answer
156 views

CAML query on external list not looking beyond ECT filter limit

I have an external list which is tied to an external content type. The external content type is tied to a SQL table with about 3000 records. I have set up a Read Item operation, and a Read List ...
2
votes
0answers
71 views

Updated external content type but connection not updated in central admin

I have an external content type for a sql server view, all working well. I add a new field to the view and save (SPD), in central admin I go to BDC and click on the content type - I can see the added ...
0
votes
1answer
67 views

Customizing details page link in BCS list or custom details page redirection with SarePoint 2013

I'm having fun with Sharepoint 2013 and studio 2013, just started dev few months ago -) I have some external lists pointing to external content type, I would like to redirect to a custom detail page ...
0
votes
1answer
102 views

Send extra parameter(s) in BCS/BDC-call to WCF-service

Ok, this question got lengthy, but I wanted to give all details, actual question is in bold below. I have defined an External content type, let's call it ExternalCustomer. I use an ...
2
votes
1answer
1k 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
1answer
166 views

How do I populate the VALUEs in one column with the FIELD NAMES of another list?

I'm trying to create a 'request update form' where the user selects an entry which is incorrect and then which field is incorrect and writes a comment and that form will get submitted via workflow to ...
0
votes
1answer
58 views

External content types for specific web applications

Is there any way that we can limit the ECTs are available only for few web applications/site collections rather than across the farm?
1
vote
0answers
58 views

ExecuteWcFOperation http://www.microsoft… slow performance

I am troubleshooting a performance issue and I see some log entries like: Leaving Monitored Scope ...