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

learn more… | top users | synonyms

2
votes
0answers
577 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
2answers
740 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
784 views

Custom BDC External Data column errors “No exact match was found”

I've created a custom BCD for SharePoint 2010. It works well, i can create a list, view all the items, click on an item and view it. I am now adding this to a list as an External Data column. The ...
0
votes
1answer
373 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
4k 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
1answer
455 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 ...
1
vote
0answers
133 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 ...
1
vote
2answers
1k 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 ...
11
votes
4answers
6k 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
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 ...
2
votes
3answers
1k 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
1answer
3k views

Why won't the “New Item Form” create for an external list?

I'm using SharePoint Foundation 2010 and I have an external list created from an external content type. The external content type uses a WCF service as datasource. The WCF service has only three ...
0
votes
1answer
872 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 ...
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?
0
votes
1answer
515 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 ...
0
votes
1answer
651 views

Getting an error while creating external content type based on WCF service

I created a WCF Service in Visual Studio and wanted to create an external content type based on it but I get an error message while creating the content type: "Error loading URL ... this normally ...
3
votes
1answer
507 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 ...
0
votes
0answers
176 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 ...
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() { ...
1
vote
2answers
5k 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
0answers
315 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 ...
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 ...
4
votes
3answers
3k 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 ...
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
1answer
1k 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
260 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 ...
2
votes
2answers
3k 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
628 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 ...
1
vote
2answers
784 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 ...
2
votes
2answers
800 views

Supplementing User Profile with information from BCS

I've got my external content type and BCS all sorted and working - the list view of the external list shows 100% in the site and the external content type shows under my BCS service application. Now ...
2
votes
2answers
4k 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 ...
0
votes
1answer
6k views

[SharePoint Designer 2010] Connecting to an external data source

I'm using SPD 2010 to connect to an external SQL database hosted on a different server. External data source type selection is SQL Server. I then filled up the connection properties , choose "Connect ...
1
vote
2answers
610 views

BDC external type with dropdown data entry

I would like to be able to have a BDC entity setup such that when you create a list from the external content type the new item form automatically comes setup with a lookup field for one of the ...
0
votes
1answer
235 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 ...
0
votes
2answers
448 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 ...
0
votes
1answer
457 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 ...
1
vote
1answer
152 views

SPBuiltInFieldId structure for BCS - is there any const for “BdcIdentity”?

For SPListItem's built-in field values we have SPBuiltInFieldId class with many guids - SPBuiltInFieldId.Title and so on. Now I am working with BCS and I can't find any built-in object for ...
1
vote
3answers
3k views

Problems configuring External List on Sharepoint Foundation 2010

I have created a new database on MS SQL SERVER SHAREPOINT instace that contains two simple tables. Then I tried to link values defined in these tables by implementing External Content Types using ...
2
votes
3answers
630 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
674 views

Cannot see External Content Type when debugging BDC Model project

I am trying to create a basic External Content Type in Visual Studio 2010 that returns data from a database. I've created the BDC Model, pressed F5 to deploy, but I cannot see the external content ...
1
vote
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 ...
2
votes
2answers
460 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?
0
votes
1answer
1k views

ECMAScript Client OM with External List

In SharePoint 2010, for a regular "custom" list calling SP.ListOperation.Selection.getSelectedItems() using the ECMAScript client object model returns an array of item IDs. These IDs correspond to the ...
3
votes
3answers
1k 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 ...
1
vote
5answers
2k views

Get foreign key in external content type to show up in list view

I have come across blogs about how to setup an external content type. For example: ...
2
votes
1answer
2k 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). ...
8
votes
5answers
8k 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 ...