Tagged Questions

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

learn more… | top users | synonyms

0
votes
1answer
100 views

Filtering datas

I want to filter datas. I have a data view with 3 column (name,department,foreign languages)by a SOAP Connection but I can't make any filtering for foreign languages. I have a html form web part ...
0
votes
1answer
180 views

Data source element is of data type x, the mapped item is of data type y (Sharepoint designer)

I have built an external content type based on a database table. Originally, a certain column was of type int, but recently it has been changed to decimal. Now I get an error in the ReadList and ...
0
votes
1answer
231 views

Display an External List in a DataView webpart

My scenario is as follows: I have a dataview wp which currently displays list items (from ECT). In the DataView wp I filter the data according to a parameter passed in from another wp. The current ...
2
votes
2answers
482 views

Changelog-based Incremental Crawl of an External Content Type (ECT)

I'm trying to add incremental crawling to an External Content Type that we have defined, but I don't want to use the item time-stamp option, which seems to be so prevalent(see: link). I have a .Net ...
3
votes
1answer
138 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 ...
1
vote
2answers
703 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
682 views

403 Error connecting to ODATA via External Content Type with SharePoint

I have a tenant on SharePoint Online (the new 2013 version). In that tenant, I have a Project Online site collection. Project Online hosts a very nice OData endpoint at ...
2
votes
1answer
2k 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 ...
1
vote
1answer
264 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 ...
1
vote
1answer
146 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 ...
0
votes
1answer
139 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
162 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 ...
1
vote
1answer
307 views

Is it possible to map External Content Type to Office Item Type without using SharePoint Designer?

I need to connect Outlook to the External list and have to map its content type to the Office Item Type for that, but unfortunately I can't see it in SPD2013. Possibly it is because BDC model uses ...
0
votes
1answer
668 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 ...
0
votes
2answers
125 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 ...
1
vote
0answers
54 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. ...
1
vote
2answers
94 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 ...
0
votes
1answer
370 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
621 views

How to create an external list from an ECT using powershell

I have an External Content Type in my Metadata store and I want to create an external list using that ECT, using Powershell script. I tried to use $Web.Lists.Add() with SiteTemplate = "External ...
0
votes
1answer
673 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 ...
0
votes
1answer
439 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 ...
2
votes
1answer
999 views

Send current user's parameter to External Content Type

Is it possible to send the current user's username as a parameter for my External Content Type query? I am on SharePoint 2010 Standard.
1
vote
1answer
43 views

Parameterized External Content Types?

Suppose I have multiple instances of some line of business app in my environment. Is there a way to create a single External Content Type that can be parametrized and reused? If I have 5 instances, is ...
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. ...
1
vote
1answer
2k 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 ...
0
votes
2answers
838 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
187 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
2answers
913 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 ...
0
votes
1answer
257 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
177 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
150 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 ...
1
vote
0answers
203 views

Does BCS support creating an external list from an existing list in a different web application using List Web Services

I have sharepoint 2010 farm where there are multiple web applications. I am trying to understand BCS and its capabilities. This is the structure I have :- Web Application A > Site Collection > ...
0
votes
1answer
186 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 ...
2
votes
2answers
3k views

How to create an external List on SharePoint 2010 using MySQL table

I have a MYSQL database that contains customer related data from sugarcrm while a few order related data is stored in the MSSQL server. So far, I have been able to create an external list for the ...
1
vote
0answers
319 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
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
3k views

Error with External Content Type List: “Unable to display this web part”

I have deployed an external content type to my local Sharepoint 2010 Server using a Visual Studio solution. The deployment appears to work. I can view the details of the content part in the central ...
1
vote
0answers
65 views

Getting error while creating ECT using WCF that is hosted in SharePoint through SharePoint Designer [closed]

I am getting error while creating ECT using WCF that is hosted in SharePoint through SharePoint Designer. The error message is Object Reference. When I Host this WCF then I am able to create ECT ...
2
votes
1answer
228 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
1answer
1k 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
3answers
5k 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
692 views

Declarative (CAML) BusinessData field

I am trying to create a List template definition declaratively (using CAML) which includes a External Data column and several secondary columns. I created a custom list via the UI and exported the ...
3
votes
2answers
909 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 ...
0
votes
1answer
27 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 ...
0
votes
2answers
1k views

Update and Create Problem with Adding Columns to an Existing External Content Type in SharePoint 2010

I used SharePoint Designer 2010 to create an external content type (ECT) that consumes and writes data to SQL Server. [Went through the process of connecting to a database table, then right-clicking ...
0
votes
1answer
115 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 ...
1
vote
1answer
569 views

How to create new External Content Type on SharePoint Designer

I'm trying to create a new External Content Type on Sharepint Designer , but where I try to insert the web services wisdom into the "New Connection -> WCF Connection " I get the following error: ...
1
vote
1answer
293 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
2answers
546 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 ...