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

learn more… | top users | synonyms

2
votes
0answers
468 views

Alerts on SharePoint 2013 External List

I have created an external list using an external content type reading from a database server on our network that is not on the same machine as our SharePoint database server. I am also sysadmin on ...
1
vote
1answer
72 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
47 views

Update list from external list on a timer

I have an external list which is generated from an external content type pointing towards my WCF service. I want to expose this list to my users but I don't want to spam the WCF service every time a ...
0
votes
1answer
624 views

Create external content type with impersonated custom identity

I'm developing a SharePoint Application. I have SharePoint Foudation 2010. I have created a External Content Type with Impersonated Custom Identity(Connection to SQL Server 2012). After I created a ...
0
votes
1answer
531 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 ...
0
votes
0answers
51 views

External Content Type grab last rows of SQL table instead of first

I'm working with a limit filter on an external content type that grabs the first 1000 rows of my table. Is it possible to instead grab the LAST 1000 rows?
1
vote
1answer
986 views

External Content Type in sharepoint 2013 Office 365 environment

Can we create external content type for SharePoint online environment? If yes then how can we create it using visual studio 2012? Any suggestion or anyone have done something like this? I have a ...
0
votes
0answers
93 views

Cant get items from external list

I have an External list based on an External Content Type that is connected to Dynamics CRM. In an event receiver (C#), I successfully get an SPList instance that is able to print the 'Title' and ...
0
votes
1answer
78 views

When delete BDC Service, the External Content Type and External System are removed too?

I have this problem in my SharePoint 2013 farm, when I use the search feature the system returns this error: "The load balancer is not provisioned. Verify the load balancer was provisioned ...
1
vote
1answer
317 views

External Content Type creating problems in Saving Site as Template on SharePoint 2010

I'm having trouble trying to save a SharePoint 2010 site as template. SPSolutionExporter: Microsoft.SharePoint.SPException: Feature definition with Id a4fbae30-a689-43d0-8f75-484a940336cf ...
0
votes
1answer
460 views

External content type from SQL Query

Can I create a external content type based on an SQL query? Can I make an external list based on that content type. Can I make a list with a lookup column to that new list, and make that field as ...
2
votes
2answers
1k 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 ...
1
vote
0answers
636 views

Problems Connecting to SQL Server external list

I'm a newbie. I was exploring how to view/edit SQL Server database tables in Sharepoint. After some research I did a two-step process Create an external content type (using Sharepoint Designer) to ...
3
votes
0answers
56 views

Crawled Properties from Business Data not getting created

I have created a content source crawling exteranl data using business data connectivity service. I can sucessfully crawl the business data content source without any errors. In crawl logs also I ...
0
votes
1answer
1k views

Add Column to External List from Updated External Content Type

We are currently trying to understand the relationship between External Content Types and External Lists within SharePoint 2013. We have a read-only ECT which we defined based on a SQL Server View. ...
0
votes
1answer
59 views

Problem showing External List in a page

I have a external content type that is showed in section of lists (Insert in Ribbon). I want to add it to a page but when is added, It shows list of BDC Identity, and when I click on them, main data ...
1
vote
2answers
60 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?
0
votes
1answer
442 views

Sharepoint Designer crashing when trying to add new External Content Type

Sharepoint Designer is crashing when trying to add new External Content Type with below error message: Description: Stopped working Problem signature: Problem Event Name: CLR20r3 Problem ...
0
votes
1answer
253 views

Search External Content type not returning all records

I have a sql view that returns 449 records. I have setup my external content type to point to this view and have implemented via SPD the read item and read list operations. I have created the ...
0
votes
0answers
50 views

Add Connection is empty-External Content Type

When I click on Add Connection the drop down list comes empty. What should I do? Why can't I see the drop down list?
0
votes
1answer
934 views

External Content Type not found in Business Data List picker

I have just created several ECTs along with lists to go with them and they work fine. Just my luck im on the final one and im stuck. Here's what I've done... 1. Created ECT and List 2. Given the ...
1
vote
1answer
741 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
467 views

Hide some fields from EditForm

I have some troubles with EditForm in Sharepoint. In SPD 2010 i have created External Type and defined CRUD method for him. I want to show in Disp form all item fields, but in Create and Edit form ...
1
vote
0answers
159 views

user lookup field for external lists

Guys please don't beat me too much, I want to add user lookup field into my external content type to use sharepoint people picker in my external list, the price doesn't stand up. So is it ever ...
1
vote
1answer
157 views

Associated ECT only displays ID (not title) in external list

I have created two ECTs, let's call them country and city for clarity. I have also created an association with city as the child and country as the parent. When I create an external list for city, ...
3
votes
2answers
147 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 ...
0
votes
1answer
53 views

need support/materials for developing external lists with visual studio 2010

Up to now, I have mostly used Sharepoint designer to develop external content types and lists. Due to the lack of source control and for other reasons, we would like to move the development process ...
0
votes
2answers
116 views

How do I retrieve associations items for list field using JavaScript

I have any ExternalContentTypes(ECT) with associations between them. One ECT is shown in an external list. I want to add a custom button on that external list ribbon. And it must change value ...
0
votes
2answers
229 views

update external list data using infopath codebehind

I know that I can update my ECT record (using InfoPath forms I created for the external lists), by passing the BdcIdentity (ID) to the form and it will find that record and enable me to edit. How do ...
0
votes
1answer
114 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
233 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
275 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
534 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
172 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
822 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
837 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
1k 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
323 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
159 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
144 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
167 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
343 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
784 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
146 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
64 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
98 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
388 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
768 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
754 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 ...