A variation of a content type that stores content outside of SharePoint.
2
votes
2answers
2k 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
314 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
100 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
919 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 ...
10
votes
3answers
3k 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
1k 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
953 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
2k 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
594 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
362 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
436 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
400 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
131 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
713 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
3k 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
252 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
1k 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 ...
3
votes
2answers
2k 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
779 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
853 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
235 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
2k 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
523 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
656 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
595 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 ...
1
vote
3answers
3k 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
5k 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
400 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
197 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
270 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
398 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
142 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
2k 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
609 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.
1
vote
1answer
511 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
990 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
364 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
1k 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). ...
6
votes
4answers
6k 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 ...
