A variation of a content type that stores content outside of SharePoint.
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 ...
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 ...
5
votes
3answers
766 views
Integrating an external database into Sharepoint
One of my current projects involves integrating a client's database into an overall CRM system design.
Part of the process was updating their legacy database and porting it over to SQL Server. ...
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 ...
3
votes
2answers
538 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 ...
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 ...
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 ...
3
votes
0answers
62 views
Problems with External List and Creating New Item with Webservice
can anybody verify that inserting new Items through SharePoint Webservice Method Lists.UpdateListItems is errornous?
I always get the Error:
0x80070057Bad parameter passed to Web Server ...
3
votes
1answer
382 views
Paging and sorting with BCS - Is it really possible?
I'm trying to add paging on an external list and so far it does not work 100%. The best references I could find (that actually... kinda... work) are these:
Paging and sorting with BCS
Paging and ...
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 ...
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.
2
votes
1answer
852 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 ...
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
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
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?
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). ...
2
votes
1answer
457 views
External List from External Content Type: missing and/or error
I've created an ECT w/ Read List and Read Item operations using SharePoint Designer, saved it, and given myself permissions. The ECT's external data source is a WCF service.
When I try to create an ...
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 ...
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 ...
2
votes
2answers
83 views
Game On - DVWP in the Ribbon
I have a 2010 Enterprise Farm, and I am attempting to place a Data View Web Part in the Ribbon to display content from an external SQL database as part of a gamification initiative. Basically, I need ...
2
votes
1answer
108 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 ...
2
votes
1answer
230 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 ...
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 ...
2
votes
2answers
637 views
DropDownList to display External Content Type?
I am creating a visual web part in Visual Studio 2010 for SharePoint 2010 Server. I would like to use a DropDownList that shows data from an external content type (that is tied to a SQL Database ...
2
votes
0answers
561 views
External Item Picker problems in InfoPath 2010 with ECT
I have used SPD to create and ECT to a standard SQL Database, and then a view. In the view there is an ID field, and then another field of a string type that stores codes (consisting mainly of ...
2
votes
0answers
399 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 ...
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
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 ...
1
vote
1answer
162 views
Querying an External Content Type without creating an External List
The typical scenario, on which every tutorial and walkthrough seems to advise, is to create an External Content Type with ReadList, ReadItem, Create, Update methods and then create an External List to ...
1
vote
1answer
390 views
BCS External Item picker
There are two external lists like 'Project' and 'Task'. Task referencing project by using field ProjectID. I've created external content types. For 'Project' content type I've marked field ...
1
vote
2answers
20 views
External “Asset Library”
Any idea if SharePoint has an extensibility point to add an external DAM store as a normal Asset source for images or other media files?
1
vote
2answers
71 views
How can i retreive data from Web Server to my Intranet SP site
Would you please let us know the steps to connect a external Web Service that has specific attribute (GetAttributeProductsByID , GetAttributeProductsByName ... etc ) with an Intranet Sharepoint site
...
1
vote
1answer
638 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 ...
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 ...
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
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
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 ...
1
vote
2answers
328 views
Use the same InfoPath form for inserts and updates
I am using an InfoPath form to add records to a database table. I do this by creating an External Content Type in Sharepoint Designer. Then from the content type I create an External Sharepoint List.
...
1
vote
1answer
74 views
External List not returning values
I have an external list which isn't returning any values.
The list uses an external content type, which gets information from a SOAP service.
After creating the content type using a read item and ...
1
vote
2answers
407 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
3answers
3k 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
241 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, ...
1
vote
1answer
777 views
External wcf (Soap/rest) datasource to external content type
I'm looking for a way to use an external datasource (WCF SOAP or REST) and include the results in a list. Using the External Content Type directly for a WCF service does not work, as I get a XML error ...
1
vote
1answer
715 views
External list with friendly display names for columns
I have an external content type that I'm accessing through a .NET assembly. So I created a BDC model with Type="DotNetAssembly" (for now with just finder and specific finder operations).
It works, ...
1
vote
2answers
428 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
1answer
483 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 ...
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 ...
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
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 ...
1
vote
2answers
655 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 ...
