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

learn more… | top users | synonyms

1
vote
2answers
1k views

How to create an external data source based on a Web Service?

Can you please advise me "How to create an external data source based on a Web Service"? Usually WCF can be a data source, but I am not strong on WCF. Could I use the existing web service as an ...
1
vote
0answers
390 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 ...
0
votes
1answer
297 views

Error when adding new external content type from azure hosted service

trying to set-up and consume a web service within SP using azure hosted services. I have written really simple code which compiles and deploys as a package. Followed this excellent walkthough... ...
1
vote
0answers
70 views

Getting error while creating ECT using WCF that is hosted in SharePoint through SharePoint Designer [closed]

I am getting error while creating ECT using WCF that is hosted in SharePoint through SharePoint Designer. The error message is Object Reference. When I Host this WCF then I am able to create ECT ...
1
vote
0answers
190 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 ...
0
votes
1answer
207 views

Set permissions for external content type from C#

When adding a new external content type you have to go into the CA and the Business Data Connectivity Service and then "Set Object Permissions" for each external contant type. Is it possible to do ...
0
votes
1answer
54 views

ECT: Agregate view, differing update and create forms

In short, I have a complex database containing documentation for IP addresses, servers, network switches and so on. This database should be manageable in SharePoint using, I think, external content ...
0
votes
1answer
3k views

Error with External Content Type List: “Unable to display this web part”

I have deployed an external content type to my local Sharepoint 2010 Server using a Visual Studio solution. The deployment appears to work. I can view the details of the content part in the central ...
0
votes
1answer
117 views

Trying to create list with ECT

I'm trying to create list from External content types with powershell. I'm trying to get the model, through this line : $Model = Get-SPBusinessDataCatalogMetadataObject -BdcObjectType Model -Name ...
0
votes
1answer
550 views

Logical AND ,OR CAML Query not working in External List

I am using ClientContext Class and CAML query to retrieve items from External List in sharepoint 2010.I have built the query with Logical AND Condition in CAML Query like this string sDataFilter ...
3
votes
1answer
299 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 ...
1
vote
3answers
6k views

How to Connect to SQL database using Sharepoint 2010/Office 365

How do you get into the Central administration page and create a secure store application ID? I am trying to connect to an external database and cannot do so with my current credentials. I have a ...
1
vote
1answer
1k views

Connect ECT to SharePoint List in InfoPath?

I'm trying to create a list in Infopath 2010. I'd like one of the fields to be a drop down list that connects to an external content type list. It doesn't show any of the External Content Type Lists ...
2
votes
1answer
672 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 ...
0
votes
1answer
29 views

Which logs are SQL Error Messages returned by an External Content Type (retrieving data from an MSSQL db) stored in?

I'm a SQL DBA, a customer's external content type had its database schema changed from underneath it. Using SQL Profiler we could easily determine that the query included a column that no longer ...
2
votes
1answer
2k views

External Content Type Search not returning results

I have configured my 2010 External Content Type for search by adding the RootFinder property to the ReadList method. I have also added the ShowInSearchUI property to the LOB entry. I then set up my ...
1
vote
1answer
1k views

Custom NewForm for external content type?

Is it possible to create a custom NewForm for an external content type without using InfoPath?
1
vote
1answer
322 views

Make list item “editable”

I have created a sharepoint list from an external content type (using Sharepoint Designer) with columns Id, Name etc. The fields in the Id column are links and contain a dropdown menu (view, edit, ...
2
votes
0answers
452 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 ...
1
vote
0answers
500 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 ...
0
votes
1answer
1k views

External Content Type and Entity Framework

I have been struggling with this project for about two weeks now. I have successfully created an External Content Type using Visual Studio and have deployed it. I was also able to use the SharePoint ...
0
votes
3answers
808 views

SpecificFinder not called on Sharepoint 2010 BCS

I have an external content type for which I created a BDC model with a LobSystem of type dot.NET assembly. I have a SpecificFinder and a Finder method defined. I also have an external list created on ...
2
votes
1answer
592 views

How to customize profile pages for external content type search results?

I have set up the SP 2010 enterprise search to include searches in line-of-business data. (In my concrete case that would be data from Dynamics CRM 2011 but I hope that is not relevant). I have ...
0
votes
0answers
209 views

Enterprise - External Task List - Connect to Outlook- setting Assigned To

I've got an External List coming from an External Content Type which has Office Item Type of "Task". It comes from an external system which has its own concept of a task, and I'm pulling them into ...
3
votes
2answers
905 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 uot how to do it. I have added a external content type and want to be able to search in it. So what I did was ...
1
vote
0answers
563 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 ...
2
votes
1answer
440 views

BCS Model not deploying in Farm environment

Has anyone else seen an issue with deploying a BCS Model WSP to a farm and the External Content Type is not being deployed? The Farm feature is activated. It is working fine for a single server ...
1
vote
0answers
527 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
2answers
934 views

External list with bulk amount of data does not work properly

I have created and external content type to fetch data from a SQL table. The table currently contains 8000 records. So when I create an external list from that content type the list does not display ...
1
vote
2answers
2k views

External Data field - problem with refreshing (SP 2010)

I have created a custom list with a field (column) of 'External Data' type, connected to my external content type. External Content Type's source is an SQL view. My problem is, when I make changes on ...
0
votes
1answer
413 views

Is it possible to create an external content type from WCF service with message security?

I have an external content type that consumes a WCF service. So far it's something simple, over HTTP, no security, just for tests. Here is a sample to get an idea. Now I'm stepping up a gear and want ...
2
votes
2answers
5k 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
vote
2answers
2k views

How to Bind Data to Traditional ASP.NET Controls in SharePoint Foundation 2010?

First off, my background is ASP.NET Web Forms. I'm sure this is very simple but I'm quite new to SharePoint. We're running SP Foundation 2010. I'm going to build a WebPart in VS.NET 2010 and deploy ...
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 ...
1
vote
3answers
1k views

Accessing External List Items Programmatically

The following bit of code throws an Unauthorized Operation exception when I try to enumerate the items in the list. Any ideas? SPSecurity.RunWithElevatedPrivileges(delegate() { ...
0
votes
1answer
1k views

Is it possible to create external content types without secure store?

Our organization is going to be using Office 365 - D (BPOS-D) as our SharePoint environment. I'm told we can't use secure store in this environment. So how do we use SharePoint to connect to an ...
0
votes
1answer
595 views

Add additional columns to see properties from an external data (BDC) field in code

So I've got a list with a BDC External Data field (Sharepoint 2010). This has been added via code and works well (although some sharepoint hacking was needed!) Anyway on the front end you go to list ...
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 ...
5
votes
1answer
271 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 ...
0
votes
1answer
497 views

SharePoint 2010 BCS stops working after a while

A little background: we are using the BCS with an external content type to expose external content we provide using a WCF service. We have a webpart that uses the external content type to display a ...
0
votes
1answer
248 views

What are the best practices for storing External Content Types in SharePoint 2010?

Recently noticed that External Content Types can be accessed across sites and even site collections. This makes me think that since many different sites will be using the same ECTs, that they should ...
1
vote
2answers
6k views

Can't Create External Content Type linked to SQL Server

In Sharepoint 2010, I am trying to create an External Content Type, and use a connection to a SQL Server. But, in Sharepoint Designer, when I am in the wizard to create an ECT, I'm having trouble ...
1
vote
1answer
2k views

Allow multi-selection for a field based on an external content type?

The choice field and lookup field allow for multiple selections. I can't find that option for lookups to external content types. Is it possible to do this? (I want to assign documents to one or more ...
1
vote
2answers
891 views

sp2010 populate dropdown combo from ECT

I have absolutely struggled in creating a custom control to use an external data source to populate a dropdown combo list. Does anyone have any good examples of how to implement this? Is a custom ...
0
votes
1answer
1k views

Search Results: urls of BDC items suddendly start with bdc3://

I have a scope defined that targets an external content type (exposed through a BDC service). All was working fine until yesterday when the number of results doubled and half the urls start with the ...
2
votes
0answers
349 views

Changing the field order after BCS Association? [closed]

I’ve created and deployed an External Content Type with Associations. All of the CRUD methods I’ve implemented are working correctly. Here’s my problem – in the View Item, Edit Item and New Item ...
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: ...
2
votes
1answer
726 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 ...
0
votes
2answers
553 views

Adding Content to External Content Types

I was able to create an ECT and the first three columns of data that I used to create the ECT display on the portal. The only issue I am running into is that I want to add more columns to the ...