Questions tagged [external-content-type]
A variation of a content type that stores content outside of SharePoint. External Content Types are part of the configuration for Business Connectivity Services (BCS).
305
questions
14
votes
3
answers
14k
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 ...
- 578
14
votes
4
answers
13k
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 (...
- 1,494
7
votes
2
answers
8k
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.
- 83
5
votes
3
answers
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'...
- 174
5
votes
3
answers
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,949
5
votes
1
answer
312
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 ...
- 51
5
votes
0
answers
177
views
How to provision External content Type using CSOM
Is it possible to provision External Content type and list using CSOM?
- 2,019
4
votes
2
answers
3k
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 ...
- 157
4
votes
1
answer
878
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 ...
- 722
4
votes
1
answer
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 ...
- 163
4
votes
1
answer
1k
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 ...
- 45
4
votes
1
answer
1k
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 ...
- 141
4
votes
1
answer
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 ...
- 263
4
votes
1
answer
771
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,934
4
votes
3
answers
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 ...
- 51
4
votes
1
answer
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 ...
- 147
3
votes
3
answers
10k
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 ...
- 247
3
votes
2
answers
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 ...
- 683
3
votes
1
answer
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, ...
- 795
3
votes
3
answers
18k
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 ...
- 25.5k
3
votes
1
answer
6k
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,250
3
votes
1
answer
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.
- 441
3
votes
2
answers
730
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
1
answer
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). ...
- 285
3
votes
1
answer
5k
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 ...
- 425
3
votes
2
answers
174
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 ...
- 71
3
votes
2
answers
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
1
answer
924
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 ...
- 587
3
votes
2
answers
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 ...
- 141
3
votes
1
answer
1k
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 ...
- 157
3
votes
1
answer
1k
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 ...
- 1,169
3
votes
1
answer
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 ...
- 111
3
votes
0
answers
314
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 ...
- 468
3
votes
0
answers
215
views
Display additional fields on forms (External lists)
I have a external list where I have employee information. I am trying to do a lookup where I can select the employee and display it's corresponding department with the additional columns possibility.
...
- 399
3
votes
0
answers
676
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
0
answers
74
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'...
- 313
3
votes
1
answer
592
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
1
answer
823
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:
"...
- 681
2
votes
1
answer
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 ...
- 1,680
2
votes
3
answers
652
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.
- 506
2
votes
1
answer
79
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 ...
- 1,745
2
votes
1
answer
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 ...
- 71
2
votes
2
answers
8k
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:
...
- 1,494
2
votes
3
answers
3k
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 ...
- 105
2
votes
2
answers
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-...
- 135
2
votes
1
answer
1k
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 ...
- 781
2
votes
1
answer
343
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 ...
- 203
2
votes
2
answers
2k
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:
...
- 293
2
votes
1
answer
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 ...
- 487
2
votes
1
answer
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, ...
- 1,169