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

learn more… | top users | synonyms

0
votes
1answer
311 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 ...
2
votes
1answer
15 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
1answer
28 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 ...
0
votes
1answer
768 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 ...
1
vote
2answers
536 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
8 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
9 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 ...
0
votes
0answers
10 views

top level external list used in subsites?

We have SharePoint Foundation. I created an external content type along with a list in my main site collection. I created a bunch of different views (one for each department of the organization). I ...
0
votes
1answer
29 views

Throttled While Crawling Large External Databases

I created an ECT using SPD2013 last week. It connects to a SQL DB while using the Secure Store to impersonate a domain user for a particular DB View. Last week, I used my personal (farm admin) ...
0
votes
0answers
12 views

External Content Type Update method messes item update field values

I have one external content type which is connected to sql server database. ECT is created with SharePoint 2013 designer. It has simple field number fields to be shown in a ext list. The site ...
0
votes
0answers
11 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
458 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
21 views

BCS Question (changing data source of a web service)

We are going to be building a Web Service (on-premise) to connect our data to SharePoint online (o365) using BCS and OData. If we migrate our database from one location (in Oracle) to another (e.g. ...
0
votes
1answer
45 views

Display friendly field values in SharePoint 2010 list

I have an SQL table where I with the help of an Externl Content Type has created a list in SharePoint 2010. The table has a foreign key to a dim table where the display friendly names are listed. How ...
0
votes
1answer
373 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 ...
3
votes
2answers
838 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
62 views

Cross-Domain access limited or not happening

I am having issues connecting to the Host Site of the App, to query a List and obtain information. If i manually navigate to the url, ...
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 ...
2
votes
1answer
21 views

Impersonated Windows Identity vs Impersonated Custom Identity

Could anyone explain the difference between Impersonated Windows Identity and Impersonated Custom identity in SharePoint?
0
votes
1answer
38 views

External Content Type = access denied

I have an External Content Type created. It connects to a SQL Server 2005 db, using "Impersonate Windows Identity" authentication, with an account over in Secure Store Service. I've got a Read List ...
0
votes
1answer
381 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
0answers
31 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 ...
2
votes
1answer
41 views

Timestamp in Sharepoint external content type not matching value in SQL table

I have an external content type in SharePoint 2010 pulling data from a SQL 2008R2 DB using BCS. All the data comes back fine but the Time stamp column is off by 2 hours when I compare the values ...
2
votes
1answer
559 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
594 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 ...
1
vote
2answers
127 views

How can I get external content crawled into SharePoint online index

I have SharePoint online and I want to add external content to the index. So far I have it set up that the external content is put into an external list using BCS. The content passes through a WCF ...
2
votes
1answer
49 views

SP Designer 2013 - External Content Types & BCS

I'm currently setting up an experimental 2013 environment with BCS, following the instructions in the AdventureWorks white paper found here - ...
2
votes
0answers
50 views

Getting External Data from Oracle to O365?

We have an on-premise oracle database with customer info (lets say roughly 10,000 rows), that we need to make available in our SharePoint Online (2013) environment in O365. The requirement is that ...
1
vote
0answers
18 views

namespace on external content type

I have noticed that when moving BCS lists/external content types from my development computer to our production server, it keeps the namespace of my development computer. For example, all the ...
3
votes
1answer
484 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 ...
2
votes
0answers
155 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 ...
11
votes
4answers
5k 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 ...
0
votes
0answers
29 views

How to perform CRUD operations in SharePoint 2010 on External datasources

I have been working with SharePoint 2010 for sometime now but haven't been able to come up with a solution that can perform CRUD operations on external sources WITHOUT having to rely on an External ...
0
votes
1answer
76 views

Entity (External Content Type) cannot be found with Namespace = 'http://server1', Name = 'user_information'

I restored site collection backup from one farm to another. I am displaying data from this content type on one of my publishing site page. I had already created this external content type before ...
1
vote
0answers
124 views

Business Data Connectivity Metadata Store is currently unavailable in Sharepoint designer 2013

I use SharePoint 2013. When I use SharePoint Designer and open my SharePoint website and select External Content Types I get this error : Business Data Connectivity Metadata Store is currently ...
3
votes
1answer
566 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
1answer
24 views

Workflow to Copy Item to a Library with External Data field?

I have a workflow that is triggered when a item is approved, it looks at the status and copies it over to a archive library with a external data field. Problem I am having is when the copy happens ...
0
votes
0answers
22 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
34 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
0answers
20 views

List created from ECT getting null reference error

I've created an SP list from an ECT in the past. The data is being pulled from a WCF service. Really the only adjustment I've made to my service is that I've added an endpoint to allow for ajax jsonp ...
0
votes
1answer
95 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
0answers
48 views

Migrating BDC fields from SP 2007 to 2013

Hopefully someone could point me in the right direction. We had a SP 2007 library which had an External Data Field in it. We have migrated the library to 2013 (via 2010 using attach-contentDB), all ...
0
votes
1answer
77 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
35 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?
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
0answers
73 views

BCS: multiple input parameters for delete operation in ECT possible? How to pass them? SharePoint 2013

I'm currently designing an external content type that should be able to view a list, an item, insert and delete items. The first three work without problems, but I still can't get the delete operation ...
0
votes
0answers
51 views

BCS: external data from SQL Server - Image column not showing

I created an external content type based on a view in the external SQL Server database with SharePoint Designer. So far it worked fine, but when I create a list of this ECT there are two columns ...
1
vote
1answer
261 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
36 views

Association between external lists. Get selected item

I have two external list ("Projects" and "Development process"). I connected this lists by associated key "project". When i create item in "Development process" i choose project in external list ...
0
votes
0answers
67 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 ...