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

learn more… | top users | synonyms

0
votes
1answer
31 views

SharePoint: Perform a query to load data into external list and display the results in a list within the webpart

I am relatively new to coding and I am trying to complete a project in Sharepoint. I have a webpart which includes Peoplepicker. When the submit button is pressed the first username passed is used as ...
0
votes
0answers
14 views

Create external content type without using SharePoint Designer

I have a web service and I need to create an external content type. I am using SPD but that is not working. It is asking me to select at least one field and the errors will not go away. So I am stuck ...
3
votes
1answer
120 views

Adding a non WCF SOAP wsdl as external content type in sharepoint manager

This is location to my wsdl, it is WSDL created by Spring WS: http://foo.bar/local/rpc/file.wsdl I am trying to add the connection to external data source from sharepoint designer. In the selection ...
0
votes
1answer
556 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 ...
1
vote
1answer
545 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: ...
0
votes
0answers
13 views

External List filter by Current User

How to field Current user on External Content make from the View. I have got a View with one field with the user name and Surname. How to Filter a External Content to see only the records wchich the ...
0
votes
1answer
308 views

Secondary lookup columns for external content types not displaying data in list after refreshing from primary

I have created a SharePoint list that has a lookup column to an external list. I also have instructed SharePoint to display several secondary columns that are related to that primary external lookup ...
2
votes
1answer
38 views

Sharepoint 2010 External List Image column

I have a SQL table with 5 columns in it (EmployeeName, StartDt, EndDt, Location, PictureUrl). I want to display this data in a Sharepoint List. I want the image to be displayed in my sharepoint list's ...
0
votes
0answers
23 views

Display Search box on an external list

I have an external list on a sharepoint site, from a BDC connector on sharepoint 2013. I want an inline Search box so that a search can be done on that list only. When i go into the web part and ...
0
votes
1answer
38 views

BCS Question (scenarios when data source is unreachable)

I have a few real-world (hopefully simple) BCS questions for on-premise database and SharePoint Online (O365) connected by OData web service: In the scenario where the data source is ...
0
votes
1answer
586 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 ...
0
votes
0answers
9 views

Actions listed in “Navigate Association” section of a External List Profile Page

I have two external content types. One called clients and the second called Client Guidelines. I created an association from Client Guidelines to clients. I also created a profile action for clients ...
0
votes
0answers
23 views

Warning when opening an InfoPath form with data sources linked to external lists

I am replacing a colleague for the support of a SharePoint 2010 intranet. A library contains InfoPath 2010 forms. The form template contains data sources linked to external lists. Each external list ...
0
votes
1answer
19 views

How to change URL in search results from custom quelle

Given a database table with following columns: ID, TEXT, URL. This table contains some useful links to external sites. In Sharepoint 2010 we have added this table as a custom search source. How to map ...
1
vote
1answer
39 views

CAML query on external list not looking beyond ECT filter limit

I have an external list which is tied to an external content type. The external content type is tied to a SQL table with about 3000 records. I have set up a Read Item operation, and a Read List ...
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 ...
0
votes
0answers
20 views

Sharepoint 2013 :How to populate multiple associated external data lists with a workflow?

I'm facing an issue where I have a workflow with an initiation form prompting multiple parameter to create items in multiple External data lists that are constrained by Foreign key. Initiation form : ...
0
votes
1answer
26 views

Send extra parameter(s) in BCS/BDC-call to WCF-service

Ok, this question got lengthy, but I wanted to give all details, actual question is in bold below. I have defined an External content type, let's call it ExternalCustomer. I use an ...
0
votes
0answers
35 views

How to get security to work with Secure Store Service?

I have an External List/content type in SharePoint 2010 using Secure Store Service. It is for an MSSQL DB access with an SQL user for a group of users. I set up Secure Store Service with Target ...
1
vote
0answers
27 views

Updated external content type but connection not updated in central admin

I have an external content type for a sql server view, all working well. I add a new field to the view and save (SPD), in central admin I go to BDC and click on the content type - I can see the added ...
0
votes
0answers
20 views

External content type not working on one web front end server

An external content type that a colleague has created does not display on one of the WFE. Receive the error message of "unable to display this webpart". At first it seemed an intermittent issue (on ...
0
votes
0answers
14 views

External List based on authentication

I have an External list with so many items.I want to restrict some items in the list to some user based on custom property.How should I do it
0
votes
1answer
24 views

Customizing details page link in BCS list or custom details page redirection with SarePoint 2013

I'm having fun with Sharepoint 2013 and studio 2013, just started dev few months ago -) I have some external lists pointing to external content type, I would like to redirect to a custom detail page ...
1
vote
1answer
84 views

Secure Store Application ID credentials don't work when creating ECT

I have been going crazy trying to figure out why this is not working. I followed Fabian Williams blog entry to the letter. I have a development farm with everything on a single farm. I DID NOT use ...
1
vote
1answer
52 views

How to create a External Content Type equivalent to a Document Set?

I'd like to create an External Content Type either inheriting from or equivalent to a Document Set. I'm not finding any good examples and Document Sets are derived from folders, so the API must be ...
0
votes
1answer
36 views

How do I populate the VALUEs in one column with the FIELD NAMES of another list?

I'm trying to create a 'request update form' where the user selects an entry which is incorrect and then which field is incorrect and writes a comment and that form will get submitted via workflow to ...
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 ...
0
votes
0answers
44 views

External List “fail” on create item

So I have an external list with all the read list / read item / create item operations set up. When I creates an item on the list webpage, SharePoint gives me this error: Operation ...
0
votes
0answers
8 views

How to have environment specific details in Declarative ECT,VS 2012, SP 2013

I have developed a declarative ECT from VS 2012 to connect and read data from Oracle. I have to specify "RdbConnection Data Source" property that points to Oracle DB. How to have that property as ...
0
votes
1answer
937 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 ...
0
votes
1answer
34 views

External content types for specific web applications

Is there any way that we can limit the ECTs are available only for few web applications/site collections rather than across the farm?
1
vote
0answers
27 views

ExecuteWcFOperation http://www.microsoft… slow performance

I am troubleshooting a performance issue and I see some log entries like: Leaving Monitored Scope ...
0
votes
2answers
718 views

How to connect multiple external tables into one SharePoint list to perform CRUD operations

I am working with SharePoint 2013 and I have a requirement where I have to perform CRUD operations on multiple external tables (SQL Server) with SharePoint in one List and vice versa. I am able to ...
3
votes
2answers
890 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
0answers
28 views

sharepoint 2013 search external content type not seen in search results

The problem is we are able to crawl external content type but search results doesn't show up these
1
vote
0answers
70 views

Handling identity column when managing SQL database table using external content type \ external list

I have a SQL table (with a primary key identity column) which I want to perform CRUD operations on using a SharePoint external list as a front end. I have setup stored procedures to perform the CRUD ...
0
votes
0answers
36 views

Edit row information using BDC

I want to make simple database table insert/edit/delete using BDC. What I have tried: I have created External Content type mapped to database table and using external content type created list. But ...
1
vote
0answers
192 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
0answers
55 views

Folder content Type and document sets

Can you add a External Content type column to either a folder content type or a document set? It doesn't appear to be available for either one. Update You can create columns with external data but ...
1
vote
1answer
91 views

Permissions to write to External List from Workflow

I'm attempting to create a SharePoint workflow that creates a new item in an external list using the "Create item in [External List Name]" action available in SharePoint Designer. Currently, I keep ...
0
votes
0answers
54 views

BCS Managed Client Code Get all method instances

When using the class Microsoft.BusinessData.MetadataModel.Entity entity; does anyone know how to get all the External Content type operation method instances so i can dynamically pass the value to ...
0
votes
1answer
138 views

SharePoint 2013 External Content type. Populate secondary fields

I am trying to migrate data to a document library that contains a external content type using the SharePoint 2013 client object model. The external content type is pulling from a sql server 2012 ...
1
vote
0answers
84 views

Authentication between SharePoint O365 and external OData web service

We are using SharePoint Online (O365) with ADFS. We are also building an on-premise OData web service to provide data into the cloud as an External Content Type. We understand generally how to use ...
0
votes
0answers
172 views

SharePoint 2013 BCS External Data Column

How do I return all entities without using entity.GetFilters() ? I have the following and I can only seem to produce a FilterCollection. I would much rather have just all the enities because i am ...
2
votes
2answers
61 views

How to choose the right datatype when creating external content types?

assuming I want to create a SPList using external content types, in my case SQL server tables. When I create my ECT in Sharepoint Designer 2010 SQL data types are mapped to the List as follows: ...
0
votes
0answers
44 views

Use Dictionary from WCF in External Content Type

Is it possible to use a Dictionary which is returned from a custom WCF Service for an External Content Type in SharePoint (2013)? So far I was not able to use a Dictionary in SPD because I cannot ...
0
votes
1answer
147 views

Is it possible to link existing Sharepoint 2010 lists to SQL server databases?

I created a SQL server database and added a table to it. Then I used Sharepoint Designer 2010 to create an external Content Type using this table. Now I can alter the according Sharepoint list which ...
1
vote
2answers
652 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
0answers
28 views

update external content type automatically based on sql table structure for external list sharepoint 2013

I have created an external list from a SQL server table. Now I have changed the structure of table and I also want to change the schema that I have created for my List. problem is that the external ...
0
votes
0answers
23 views

external list linked to different external list

I created an external content type and then a list from that. It shows the departments of the organization along with the phone and fax number. So when I click on the Department Name, it ...