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

learn more… | top users | synonyms

0
votes
0answers
3 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 ...
1
vote
1answer
586 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: ...
0
votes
0answers
5 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
77 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
0answers
13 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.
1
vote
1answer
100 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 ...
0
votes
0answers
12 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
14 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
1answer
366 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
0answers
22 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 ...
0
votes
0answers
77 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
23 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
11 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
39 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
351 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
462 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
1answer
24 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
100 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
48 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
12 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. ...
0
votes
0answers
34 views

“Connect to Outlook” button disabled on an External List based on “Contact”

I'm using SharePoint's Business Data Connectivity to connect to external source with contacts information. I created a .NET Assembly connector (BDC Model project in VS) with ReadItem and ReadList ...
0
votes
1answer
9 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
17 views

Business Data Connectivity Model based on Contact

I'm trying to create a .NET assembly connector for BDC. I'm creating the Business Data Connectivity Model and I'd like my entity to behave in SharePoint as a contact - so that I could use "Connect to ...
0
votes
0answers
21 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
418 views

Is it possible to link existing Sharepoint 2010 lists to SQL server databases?

I created a SQL server database and added a table to it. Then I used Sharepoint Designer 2010 to create an external Content Type using this table. Now I can alter the according Sharepoint list which ...
0
votes
0answers
12 views

Connect to Report Server from SharePoint 2010 in Native Mode

I have a SharePoint 2010 installation in Native mode. As per company rules, I cannot have Integrated mode for this solution. I need to connect to a report server containing SSRS reports so that I can ...
0
votes
1answer
25 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
35 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
0answers
28 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
1answer
30 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?
0
votes
0answers
27 views

Calendar view for external content type

I have created a new external content type / external list that pulls information from an SQL database, the list has a start date column and end date column so what I wanted to do is create a calendar ...
1
vote
1answer
32 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
46 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
1answer
722 views

403 Error connecting to ODATA via External Content Type with SharePoint

I have a tenant on SharePoint Online (the new 2013 version). In that tenant, I have a Project Online site collection. Project Online hosts a very nice OData endpoint at ...
0
votes
0answers
31 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
0answers
12 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
1answer
72 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
57 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
38 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
1answer
658 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
0answers
46 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
57 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
99 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
28 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 ...
3
votes
1answer
141 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
0answers
44 views

External List filter by Current User

How to field Current user on External Content make from the View. I have got a View with one field with the user name and Surname. How to Filter a External Content to see only the records wchich the ...
2
votes
1answer
98 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
66 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
52 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
16 views

Actions listed in “Navigate Association” section of a External List Profile Page

I have two external content types. One called clients and the second called Client Guidelines. I created an association from Client Guidelines to clients. I also created a profile action for clients ...