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

learn more… | top users | synonyms

1
vote
1answer
461 views

BDC Model for ActiveDirectory

I am trying to build a BDC Model and a custom .net connector for ActiveDirectory so that users can search for data in AD from Sharepoint as well as create lists (ie: Users list that will show users ...
1
vote
1answer
1k views

Synchronization of SharePoint 2010 List with SQL Server Table

I need to create a list such that the values on the list can be stored in SQL table as well. I need to attach workflows to the list item as well. Its a simple workflow with two approval process ...
0
votes
1answer
177 views

Best to way to populated external database?

I have a requirement where I need to populated a SQL Server database (tbl_Customer) with sharepoint List. I am not sure about the best approach. approach 1: bcs to external database and scheduled ...
2
votes
0answers
880 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 ...
0
votes
1answer
154 views

Customize the InfoPath form of an External Content List

I generated an InfoPath form which OOTB gives me the ability to edit items in an External List, which in turn, updates a database table. This form however uses the Sharepoint ribbon control to show ...
0
votes
1answer
971 views

External content type based on OData is invisible in SPD2013 (but visible in a web browser)

I am trying to connect external list based on OData to Outlook, I could create it, but can't map its fields to Office Item type because it is invisible in SPD2013. I made screenshots of all the steps ...
1
vote
2answers
100 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 ...
2
votes
2answers
1k 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 ...
0
votes
2answers
162 views

External list not implementing TimeSpan field

I am developing an external content type with sharepoint designer, based on a microsoft sql server table. One of the columns has the time(0) format. This is interpreted by sharepoint designer as ...
0
votes
1answer
445 views

Getting Large External Data set into SharePoint list

I have a list of "Customers" in a SQL database table with some very basic data:Id, Name, DoB, Mobile, Email, CusotmerType. There are currently about 80,000 customers I wanted to use an External ...
0
votes
1answer
949 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 ...
1
vote
1answer
873 views

How to create a dynamic external content type (the DB tables can change)

I want to create an external content type based on SQL Server tables. My external content is a list of Cats and its source is a database table also named Cats. However, I have a different Cats table ...
1
vote
5answers
3k 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: http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2010/02/02/it-s-easy-to-configure-an-external-list-with-...
2
votes
0answers
77 views

What CMIS services are required if Fast Search is used to query an external CMIS repository

For a repository to be CMIS compliant, it must implement a number of services. Query services are not mandatory. I want to incorporate a CMIS repository in SharePoint 2010 as an External Content Type. ...
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
502 views

BDC external contet type SharePoint Designer

I have problem with Business Data Connectivity, when I try to create new external content type in SharePoint Designer - I "Add Connection" then I choose SQL Server I fill Database Server and Name and ...
5
votes
3answers
2k 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. That'...
0
votes
2answers
1k views

An empty pipe element is not allowed - the Powershell I copied fails

I am just trying to fix something to get my BCS external list created. All indications are that the server has too many rows for BCS so here is what I put into the Powershell IDE running as ...
0
votes
1answer
229 views

External List & Picking pictures from a Picture Library

I have an external data source (BDC) based on which I created an external list. The (external) entity provides a field which can store / contain the link to an image. Now there is an Image Library ...
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 ...
1
vote
2answers
1k 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
0answers
457 views

Create a survey in sharepoint 2010 where question text is from external content type

I have a small issue. I need to create a survey page in SharePoint 2010. This page needs to have dynamic number of questions where text values for this questions are retrieved from SQL Server database ...
0
votes
1answer
358 views

Error when adding new external content type from azure hosted service

trying to set-up and consume a web service within SP using azure hosted services. I have written really simple code which compiles and deploys as a package. Followed this excellent walkthough... ...
1
vote
0answers
199 views

SPQuery on ECT very slow

I am creating a custom web part which is supposed to return results from an External Content Type(ECT) List which contains almost 40,000 records. There are multiple ways the items can be searched and ...
1
vote
0answers
166 views

Use Secure Store Credentials to connect to database with Windows Authentication in Visual Studio solution?

Background: I have an external content type that has been developed in a Visual Studio 2010 solution. This content type is based mostly off elements in a database that are accessed via stored ...
0
votes
1answer
221 views

Set permissions for external content type from C#

When adding a new external content type you have to go into the CA and the Business Data Connectivity Service and then "Set Object Permissions" for each external contant type. Is it possible to do ...
0
votes
1answer
54 views

ECT: Agregate view, differing update and create forms

In short, I have a complex database containing documentation for IP addresses, servers, network switches and so on. This database should be manageable in SharePoint using, I think, external content ...
0
votes
1answer
118 views

Trying to create list with ECT

I'm trying to create list from External content types with powershell. I'm trying to get the model, through this line : $Model = Get-SPBusinessDataCatalogMetadataObject -BdcObjectType Model -Name ...
0
votes
1answer
588 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 =&...
3
votes
1answer
393 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 ...
1
vote
3answers
7k 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 ...
2
votes
1answer
751 views

ReadList with Association for External Content Type via Visual Studio

I would have thought this is a common requirement but I just cannot seem to find any resources addressing this. I have several Entities defined along with Associations between them. They deploy ...
0
votes
1answer
32 views

Which logs are SQL Error Messages returned by an External Content Type (retrieving data from an MSSQL db) stored in?

I'm a SQL DBA, a customer's external content type had its database schema changed from underneath it. Using SQL Profiler we could easily determine that the query included a column that no longer ...
1
vote
1answer
2k 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
1answer
348 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, ...
2
votes
0answers
495 views

Business Connectivity Services over OData : caching and paging?

I'm planing a new application for a customer that requires to read data from an external system. Basically, the external system will expose a read-only OData service (to be defined actually). The ...
1
vote
0answers
533 views

Association created by VS does not work

I am trying to create several ECT with Associations between them. Been playing around with several tools and reading/watching a handful of tutorials. I have gotten my pieces to work when playing ...
0
votes
1answer
1k views

External Content Type and Entity Framework

I have been struggling with this project for about two weeks now. I have successfully created an External Content Type using Visual Studio and have deployed it. I was also able to use the SharePoint ...
0
votes
3answers
907 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
694 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 ...
0
votes
0answers
223 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
0answers
589 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
493 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
577 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 ...
1
vote
2answers
1k 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 ...
2
votes
2answers
3k 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 ...
0
votes
1answer
434 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
6k 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: ...
1
vote
2answers
2k 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 ...
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 ...