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

learn more… | top users | synonyms

3
votes
1answer
484 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
163 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
891 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
4k 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
303 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
253 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
599 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
745 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
761 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
536 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
224 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
407 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
444 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
149 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
624 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
642 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
435 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 ...