Tagged Questions

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

learn more… | top users | synonyms

3
votes
1answer
638 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 ...
0
votes
3answers
647 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
2k 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 ...
0
votes
1answer
497 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 ...
0
votes
1answer
964 views

drop down list for an external list

If a guy were to want to allow a user to change data in an external list (based on an ECT of a SQL Server Table), and he had a particular field in that list (say a status field) that only needs to be ...
2
votes
1answer
1k 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, ...
3
votes
2answers
770 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
515 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
381 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
498 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 ...
3
votes
1answer
963 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
608 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
784 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
865 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
387 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
503 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
134 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
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
1answer
4k 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
927 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
541 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
702 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
529 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
185 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
329 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
262 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
654 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
810 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
845 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
5k 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
689 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
238 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
492 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
471 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
155 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
632 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.