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

learn more… | top users | synonyms

3
votes
0answers
59 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 ...
2
votes
0answers
61 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 ...
2
votes
0answers
31 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 ...
2
votes
0answers
83 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 ...
2
votes
0answers
60 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 ...
2
votes
0answers
418 views

Getting External Data from Oracle to O365?

We have an on-premise oracle database with customer info (lets say roughly 10,000 rows), that we need to make available in our SharePoint Online (2013) environment in O365. The requirement is that ...
2
votes
0answers
511 views

Alerts on SharePoint 2013 External List

I have created an external list using an external content type reading from a database server on our network that is not on the same machine as our SharePoint database server. I am also sysadmin on ...
2
votes
0answers
68 views

What CMIS services are required if Fast Search is used to query an external CMIS repository

For a repository to be CMIS compliant, it must implement a number of services. Query services are not mandatory. I want to incorporate a CMIS repository in SharePoint 2010 as an External Content Type. ...
2
votes
0answers
447 views

Business Connectivity Services over OData : caching and paging?

I'm planing a new application for a customer that requires to read data from an external system. Basically, the external system will expose a read-only OData service (to be defined actually). The ...
2
votes
0answers
774 views

Sharepoint external list problem

I'm taking my first crack at creating an External list in Sharepoint 2010. I've taken 3 training classes in Sharepoint 2010, and am now trying to transfer my knowledge to my own development ...
1
vote
0answers
29 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 ...
1
vote
0answers
55 views

How to provision External content Type using CSOM

Is it possible to provision External Content type and list using CSOM? Thanks in advance.
1
vote
0answers
108 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
0answers
14 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
0answers
117 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 ...
1
vote
0answers
48 views

ExecuteWcFOperation http://www.microsoft… slow performance

I am troubleshooting a performance issue and I see some log entries like: Leaving Monitored Scope ...
1
vote
0answers
185 views

Handling identity column when managing SQL database table using external content type \ external list

I have a SQL table (with a primary key identity column) which I want to perform CRUD operations on using a SharePoint external list as a front end. I have setup stored procedures to perform the CRUD ...
1
vote
0answers
130 views

Authentication between SharePoint O365 and external OData web service

We are using SharePoint Online (O365) with ADFS. We are also building an on-premise OData web service to provide data into the cloud as an External Content Type. We understand generally how to use ...
1
vote
0answers
239 views

Business Data Connectivity Metadata Store is currently unavailable in Sharepoint designer 2013

I use SharePoint 2013. When I use SharePoint Designer and open my SharePoint website and select External Content Types I get this error : Business Data Connectivity Metadata Store is currently ...
1
vote
0answers
672 views

Problems Connecting to SQL Server external list

I'm a newbie. I was exploring how to view/edit SQL Server database tables in Sharepoint. After some research I did a two-step process Create an external content type (using Sharepoint Designer) to ...
1
vote
0answers
167 views

user lookup field for external lists

Guys please don't beat me too much, I want to add user lookup field into my external content type to use sharepoint people picker in my external list, the price doesn't stand up. So is it ever ...
1
vote
0answers
189 views

SPQuery on ECT very slow

I am creating a custom web part which is supposed to return results from an External Content Type(ECT) List which contains almost 40,000 records. There are multiple ways the items can be searched and ...
1
vote
0answers
160 views

Use Secure Store Credentials to connect to database with Windows Authentication in Visual Studio solution?

Background: I have an external content type that has been developed in a Visual Studio 2010 solution. This content type is based mostly off elements in a database that are accessed via stored ...
1
vote
0answers
242 views

Does BCS support creating an external list from an existing list in a different web application using List Web Services

I have sharepoint 2010 farm where there are multiple web applications. I am trying to understand BCS and its capabilities. This is the structure I have :- Web Application A > Site Collection > ...
1
vote
0answers
382 views

Create a survey in sharepoint 2010 where question text is from external content type

I have a small issue. I need to create a survey page in SharePoint 2010. This page needs to have dynamic number of questions where text values for this questions are retrieved from SQL Server database ...
1
vote
0answers
493 views

Association created by VS does not work

I am trying to create several ECT with Associations between them. Been playing around with several tools and reading/watching a handful of tutorials. I have gotten my pieces to work when playing ...
1
vote
0answers
562 views

PageNumber-Fillter for Finder in .Net Assembly Connector

I'm currently trying to use an PageNumber-Filter for an Finder-Method in an .NET Assembly Connector. The relevant Part of the Method-Definition of the ReadList-Method looks the following. <Method ...
1
vote
0answers
522 views

Problem with Refresh button on External data column

I'm struggling with refreshing items on list with external data. So far I have been able to make the refresh button work, but only when I add items to list in a standard way (via browser). When I add ...
1
vote
0answers
136 views

Could not find IEntity

I have a SharePoint 2010 site collection, which is mainly used to create projects. These projects can contain different phases, which becomes a new subsite when a new project is created. The phases ...
0
votes
0answers
6 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
0answers
7 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
0answers
15 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
8 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 ...
0
votes
0answers
9 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
20 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
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
22 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
0answers
22 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
14 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
0answers
17 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
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 ...
0
votes
0answers
37 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
0answers
20 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
18 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
49 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
19 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 ...
0
votes
0answers
24 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 = ...
0
votes
0answers
41 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 ...
0
votes
0answers
67 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 ...