The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [external-content-type]

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

Filter by
Sorted by
Tagged with
14
votes
3answers
13k views

Paging and sorting with BCS

I going to use the new exciting External Content Type feature to display a list of data from an external LOB system. The list is potentially long, so paging with filtering at the LOB system side is ...
14
votes
4answers
12k views

How to automate entry of external column data in BCS?

I have a document library, Resumes, that has a large number of resumes in it. There is a regular column on that library, called EmployeeID, that is already populated. I have an external content type (...
5
votes
3answers
3k views

Integrating an external database into Sharepoint

One of my current projects involves integrating a client's database into an overall CRM system design. Part of the process was updating their legacy database and porting it over to SQL Server. That'...
5
votes
1answer
303 views

How to use BCS in Word for editing BLOBs

If I have an External Content type defined with a StreamAccessor that will end up referencing Word docx files stored in another system (reason for using BCS), what options do I have for updating the ...
5
votes
0answers
172 views

How to provision External content Type using CSOM

Is it possible to provision External Content type and list using CSOM?
4
votes
1answer
5k views

BCS in Sharepoint Online

What are the features and limitations of BCS in Sharepoint online. Can we create an external content type using Stored procedure in Sharepoint online.
4
votes
1answer
556 views

Update column having external data as data type using CSOM

I have a list which contains a column having data type as "External Data". I want to update that particular column using CSOM. I have tried below code: ClientContext clientContext = new ...
4
votes
1answer
2k views

Timestamp in Sharepoint external content type not matching value in SQL table

I have an external content type in SharePoint 2010 pulling data from a SQL 2008R2 DB using BCS. All the data comes back fine but the Time stamp column is off by 2 hours when I compare the values ...
4
votes
3answers
6k views

Date Only format with BCS

I have created an External Content Type through SharePoint Designer. One of the fields that I'm getting from my database is a DateTime column. In SharePoint, however, I want to format this as a Date ...
4
votes
1answer
905 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 ...
4
votes
1answer
1k 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 ...
4
votes
1answer
700 views

How do I access an SQL image column using an External Content Type list?

I have a External Content Type (list) which pulls the data from an SQL Server. The image field in SQL can be stored in binary format or just the image path is stored (currently I am storing the path ...
4
votes
3answers
2k views

Validation for external lists / external content types

Where does one put validation for external content types? Let's say one field on my ECT represents an email address that must be unique in our system. Where would I put the validation that checks to ...
4
votes
1answer
3k 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 ...
3
votes
2answers
6k views

External Content Type - limitations

This is my scenario: I have an external SQL Server db with about 100.000 items in one table. These items may be grouped into 5 categories. Now the we'd like to add a sharepoint interface on top of ...
3
votes
2answers
1k views

Problem with limit of Items in External list

My Web part consumes a list that presents this error: The Database Connector limited the response. The database response contains more than '2000' rows. The maximum number of rows that can be read ...
3
votes
3answers
15k 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 ...
3
votes
1answer
5k 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 ...
3
votes
1answer
3k views

Send current user's parameter to External Content Type

Is it possible to send the current user's username as a parameter for my External Content Type query? I am on SharePoint 2010 Standard.
3
votes
2answers
708 views

External content types across site collections

I have used Sharepoint designer 2010 to make SQL server tables available as external content types (and lists) for a site collection but what about across multiple site collections--can this be done?
3
votes
1answer
3k views

No Business Data Connectivity Service associated with current web context error

I am running on a new dev setup for SharePoint 2010 and trying to setup some External Content types. I think that I have setup BCS correctly (since I see it running in the central administration). ...
3
votes
1answer
4k views

External Content Type in SharePoint Online

Can we create external content type for SharePoint online environment? If yes then how can we create it using visual studio 2012? Any suggestion or anyone have done something like this? I have a ...
3
votes
2answers
166 views

Game On - DVWP in the Ribbon

I have a 2010 Enterprise Farm, and I am attempting to place a Data View Web Part in the Ribbon to display content from an external SQL database as part of a gamification initiative. Basically, I need ...
3
votes
1answer
814 views

Search terms containing period, “.”, does not yield any results.

Using external content types, I am trying to create an asset management system for administering, among other things, IP addresses. Using an enterprise search center, the crawler indexes the external ...
3
votes
2answers
1k views

DropDownList to display External Content Type?

I am creating a visual web part in Visual Studio 2010 for SharePoint 2010 Server. I would like to use a DropDownList that shows data from an external content type (that is tied to a SQL Database ...
3
votes
1answer
910 views

ReadList with Association for External Content Type via Visual Studio

I would have thought this is a common requirement but I just cannot seem to find any resources addressing this. I have several Entities defined along with Associations between them. They deploy ...
3
votes
2answers
1k views

Search in External content type

I am new to SharePoint. I am trying to add a search box to a list but I can't figure out how to do it. I have added an external content type and want to be able to search in it. So what I did was ...
3
votes
1answer
518 views

How to change the external content type of a list?

I have a webpart that consumes and displays items from a list that has an external content type. The problem is that the list is consuming the wrong font and I would like to know If it is possible ...
3
votes
1answer
988 views

Paging and sorting with BCS - Is it really possible?

I'm trying to add paging on an external list and so far it does not work 100%. The best references I could find (that actually... kinda... work) are these: Paging and sorting with BCS Paging and ...
3
votes
1answer
1k views

External Item Picker problems in InfoPath 2010 with ECT

I have used SPD to create and ECT to a standard SQL Database, and then a view. In the view there is an ID field, and then another field of a string type that stores codes (consisting mainly of ...
3
votes
0answers
233 views

SharePoint external list (sql) with multi lined text field

I have an external content type with one of the fields having huge text in it. (SQL type: varchar(MAX)). When I create the external list and open a new form, the field is a single line textbox and it ...
3
votes
0answers
628 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 ...
3
votes
0answers
71 views

Crawled Properties from Business Data not getting created

I have created a content source crawling exteranl data using business data connectivity service. I can sucessfully crawl the business data content source without any errors. In crawl logs also I didn'...
3
votes
1answer
476 views

Problems with External List and Creating New Item with Webservice

can anybody verify that inserting new Items through SharePoint Webservice Method Lists.UpdateListItems is errornous? I always get the Error: 0x80070057Bad parameter passed to Web Server Extensions....
3
votes
1answer
805 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: "...
2
votes
3answers
8k views

How can I get external content crawled into SharePoint online index

I have SharePoint online and I want to add external content to the index. So far I have it set up that the external content is put into an external list using BCS. The content passes through a WCF ...
2
votes
1answer
2k views

Creating an external list from SQL query using BCS

I'm developing a visualization application on SharePoint Enterprise 2010. This involves doing some SQL queries I would love to expose as external lists in SharePoint. All interfacing with the database ...
2
votes
3answers
646 views

Connect to Outlook button not enabled on external list

I created an external content type connected to a SQL table and chose announcements as the office item type.
2
votes
1answer
67 views

Creating External List [closed]

I have been asked to research External Lists. After exploration I came to know that in order to use data which isn't there on SharePoint we make use of External List. Now can anyone tell me a real ...
2
votes
1answer
2k views

Create External Content Type in SharePoint 2016

I would like to crawl (Search) a custom database/table using SharePoint 2016. I know this is possible and doable using SharePoint Designer. What I am wondering is since Microsoft has discontinued, ...
2
votes
1answer
3k views

External wcf (Soap/rest) datasource to external content type

I'm looking for a way to use an external datasource (WCF SOAP or REST) and include the results in a list. Using the External Content Type directly for a WCF service does not work, as I get a XML error ...
2
votes
2answers
7k views

How to read items in a BCS external list with PowerShell?

Is there a way that you get information from an external list (created from SPD for a specific ECT) differently than you do from a "normal" SharePoint list when using PowerShell? I did the following: ...
2
votes
3answers
2k views

How to authenticate BDC to the external system?

I'm using the following tutorial to define a workflow on a SharePoint list to create an element in and external List. When the workflow action tries to create the item in the external list, it fails ...
2
votes
2answers
4k views

Custom Action with postback (or another approach) - SP 2010

I'm trying to create a custom action that does a postback when clicked. I've followed the following articles with no luck whatsoever: http://makarandrkulkarni.blogspot.com/2010/01/sharepoint-2010-...
2
votes
1answer
317 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 ...
2
votes
2answers
1k views

How to choose the right datatype when creating external content types?

assuming I want to create a SPList using external content types, in my case SQL server tables. When I create my ECT in Sharepoint Designer 2010 SQL data types are mapped to the List as follows: ...
2
votes
1answer
3k views

External List from External Content Type: missing and/or error

I've created an ECT w/ Read List and Read Item operations using SharePoint Designer, saved it, and given myself permissions. The ECT's external data source is a WCF service. When I try to create an ...
2
votes
1answer
3k views

External list with friendly display names for columns

I have an external content type that I'm accessing through a .NET assembly. So I created a BDC model with Type="DotNetAssembly" (for now with just finder and specific finder operations). It works, ...
2
votes
1answer
802 views

Using BCS and External Content Types to create Publishing Pages

I'm starting a new SharePoint 2010 web content management project where a portion of the site's content is driven by an external system (SQL Server based). Think employee bios... The external system ...
2
votes
3answers
1k views

Synchronize User Profile data from an external list

I would like to use additional properties from another datasource (SQL server) as additional user properties, then push them back to active directory. I setup a sample BCS to the sql server ...