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

learn more… | top users | synonyms

0
votes
0answers
7 views

SharePoint External List editing

I create a page with 2 web parts. one displays the external list and 2nd web part displays the data of selected item. I would like to be able to make this 2nd web part as editable. is it possible? ...
0
votes
0answers
14 views

SharePoint 2013 BCS identity delegation with kerberos and claims

I have a question about the BCS and having it successfully pass through the current users' identity to a SQL database whilst using Claims and Kerberos. I've read a lot of contradictory information ...
0
votes
2answers
31 views

Parameters not passed to BCS External List via REST API

I have two external lists connected via external content types which are connected to stored procedures in SQL Server. I believe I have them set up identically (though evidently not because one is not ...
0
votes
1answer
30 views

How to add External Content type To custom SharePoint list?

We have a requirement Creating External Content type in sharpoint 2013 based on that SQL database Table. For example in sql i have four database(db1,db2,db3,db4) and sharepoint i have 4 custom ...
1
vote
0answers
100 views

SharePoint Designer 2013 - External Content Type, Page Number filter issue

I have created an External Content Type using SharePoint Designer. The data source is SQL table. The data in SQL table may increase up to around 25k rows. To handle this situation, we are using Page ...
0
votes
2answers
39 views

InfoPath or SharePoint Forms into SharePoint server

I am new to SharePoint and InfoPath or SharePoint designer. I am trying to do the following, could not able to find solution yet. read so many blogs. Have an external SQL server database. I want to ...
0
votes
1answer
33 views

SharePoint 2013 Unexpected Error while creating lookup column to use external list

I am using SharePoint Server 2013. In that I am creating a custom column which lookup to an external list. My ECT is based on an SQL Server table and I have created the external list in the site. I ...
2
votes
1answer
19 views

What happens to External List created using BCS from SQL query once the server goes offline?

If the database gets deleted or somehow goes offline, will the list keep the existing data or will it all be gone due to failed synchronization.
0
votes
3answers
134 views

Query String Parameter pass to Data Source Filters in External List (BDC)

Can you please guide me how to pass the Query String Parameters to Data source Fiters in external list? I have created external list based on external content type. External content type has three ...
0
votes
0answers
25 views

Connecting outside database via WEB API's to SPO

Has anyone been able to automate a connection to an outside source that uses WEB API's? We use Deltek Vision in the cloud, and would like to be able to automate some information to carry over from ...
0
votes
1answer
61 views

use external liste error :Oracle database TNS The value's length for key 'data source' exceeds it's limit of '128'

I have created xml model for external list using bcs this is the code example for my BDCM model: <?xml version="1.0" encoding="utf-8" standalone="yes"?> <Model ...
2
votes
1answer
35 views

Link Sharepoint Survey to External list

I am trying to go around the limitation of not being able to associate workflows to external lists. I am wondering if it is possible to create some form of association with a SharePoint survey. My ...
1
vote
1answer
23 views

External Content Types Error

I want to get data from SQL Server 2013. I created Business Data Connectivity Service. Then I click the External Content Types but I get error.
0
votes
0answers
39 views

Data not showing in External list of SharePoint 2013 site

I have created external content type using stored procedure. Also created read list operation, as well as read item operation. But the problem is that the stored procedure that I have created is ...
0
votes
0answers
38 views

New “Read List” operations is not showing on external list

I am working on a SharePoint 2013 environment. We use external data to display contact information. To use some other Data we created a view on the SQL-Server and added a new Read List operation for ...
1
vote
0answers
169 views

How to get the data from external SQL Server database in SharePoint 2013 site

What I want to do is retrieve the data from external SQL server database and bring it on the SharePoint 2013 site and show the graphs accordingly. So the data might be from different database tables. ...
1
vote
1answer
49 views

Not able to create External Content Type in SharePoint Designer 2013 using Stored Procedure

I want to create the external content type using stored procedure but it is giving me error such that, when I right click on routines in Data Source Explorer and then select New Read Item Operation ...
1
vote
1answer
31 views

External Content Types Office 365

I've the following: In the cloud = SharePoint (office 365) On-Premises = SQL DB's that I want to connect to from SharePoint Is it possible to connect to my On-Premises SQL DB's?
0
votes
0answers
24 views

Doing some actions into multiple Item of External list

I have an external list of Microsoft CRM 2011 Accounts in SharePoint 2013 (By BDCS Service). In SharePoint 2013 environment I want to select some items in this External List and apply an action to the ...
1
vote
0answers
90 views

How to correctly update specific columns in an external database through an ECT?

Here is the scenario: I have an External Content Type based on a specific table in an external DB. The table itself has 33 columns, my ECT exposes a total of 13 of those columns, 7 as read-only and ...
2
votes
2answers
38 views

Trouble updating rows of data in an External Content Type using Javascript

I've tried a few different ways of doing this, including querying the External Content Type and then updating the current item. However as far as I ever get is an undefined variable error. This is my ...
1
vote
0answers
42 views

BDC update operation fails with socket exception

I have set up an external content type in my BDC Service, and I am using the Secure Store Service to provide the database credentials. In the ECT I have set up Read Item, Read List, and Update Item ...
0
votes
0answers
22 views

External content source as a ContentType refiner

In SharePoint 2013, when crawling an external database, how can you include the crawled items as a content type in the ContentType refiner?
0
votes
0answers
23 views

map External Content Types

I need to be able to map External Content Types/Columns to Sharepoint Columns or Lists. Basically, I need to be able to ‘marry’ lists/columns in SharePoint with External data. Best I can tell ...
0
votes
0answers
13 views

Need Help Understanding External Content Types

I need to be able to understand how to create an External Content type based off of Stored Procedures. All example I have seen thus far show me how to create using 'Create All Operations' using a ...
0
votes
0answers
14 views

External List doesnt 'see' External Content Types

I have created a few External Content Types in which standard lists find easily as an 'External Data' column type. However, a 'External List' doesnt see any of these external content types. I dont ...
0
votes
0answers
26 views

Create external content type with sql server

I need to have an external list in SharePoint 2013, i found a lot of tutorial but. I need that my external content type has a unique authentification to my sql tablE. i don't want connection to the ...
0
votes
0answers
104 views

External content type data retrieving error in SharePoint Online

I followed this page to create an external content type in SharePoint Online and add a Business Data List Web Part to read data from this external content type. But it displays an error, it says An ...
1
vote
0answers
39 views

How to enable quick edit in an External List?

I know, it is not supported. I am in the process to customize a ECT list view with access to enable the quick edit function.
1
vote
0answers
15 views

How to tell an ECT developed in VS to use credentials from Secure Store Service?

I am trying to develop an External Content Type using Visual Studio so I can use External Data Source columns in a SharePoint list. Most of the stuff I am finding online uses Designer, but I don't ...
0
votes
1answer
87 views

Remove Infopath form from external list?

The InfoPath form has broken for the external list. How to remove all GUI InfoPath form from the external list? I want to rebuild the InfoPath again for the external list without having to recreate a ...
1
vote
0answers
26 views

Display SQL Server data in Sharepoint with the ability to Drill Down

Metadata External List Users need to see & update metadata information about user databases via sharepoint. Users open a Sharepoint site and look for metadata Information Data being pulled from ...
0
votes
0answers
58 views

External content type add connection to a rest api

Is there a way to connect an external content type to a third party rest API? If so how? I have tried to find information about this, but have only found methods to using rest to get data out from ...
0
votes
1answer
150 views

External list with hyperlinks sharepoint 2013

How do I make a column (content) a hyperlink with an external list in SharePoint 2013? I have the url in the database and need to turn it into a hyperlink.
0
votes
2answers
637 views

SharePoint Online Hosted App get List Items from within app

I have a Visual Studio 2013 solution and I have been successfully able to get list items from the host web using the following JavaScript code: var context = SP.ClientContext.get_current(); ...
0
votes
0answers
12 views

Custom Data Provider for External Content Type

I have a several data services and I want to add them to SharePoint portal. I found that I can create an external content types for that. All tutorials says that External Content Type can be created ...
1
vote
1answer
184 views

SharePoint 2013 BCS and SQL Views

I have setup my SharePoint 2013 publishing site with BCS and Secure Store so that users can access multiple external lists within the site and if they have the correct permissions setup in Secure ...
0
votes
1answer
84 views

External Content Type does not match the schema version for the form

When I try to edit or view the item within the External List view the error message is as followed: Error InfoPath cannot open the form because of an application configuration error: The schema ...
0
votes
0answers
43 views

External Content Type based on SQL View allow insert/update/delete

I have two tables in SQL, one of them is read only (it is the "master"). The other is a detail table. They are joined on column 'VNO'. It is constructed with a left join on the master table, so ...
0
votes
0answers
60 views

External Content type column causes an error in the list view

I have a siet column/field of External Data type called "ABVictName". The problem with this field is that whenever I insert it in the List View it throws an error. In the logs I found this message: ...
0
votes
2answers
81 views

External Content Type - SQL - Filters

I create a new external list via a new external content type SQL . I retreive my data and i can display it. BDC Service allows us to view 2000 items . 1st Issue: I can filtered through a ...
0
votes
1answer
40 views

How to make user edit data in business data list?

I set up a business data list to get data from SQL server through external content type. It works very well and users are able to see the data from SQL server on their SharePoint UI. But now I'm ...
0
votes
0answers
19 views

SharePont Workflow initiated automatically on item create via email not able to read from external list

I created a custom SharePoint 2010 workflow using SharePoint designer for a 2013 SharePoint environment. My workflow needs to read data from an external list, and works flawlessly when the workflow ...
0
votes
0answers
35 views

Sage 50 Accounts Integration

I want to import Sage 50 Accounts information into my SharePoint Online environment as an external content type. Can this be done? Thanks
1
vote
1answer
650 views

Could not save the list changes to the server

I have an External List in SharePoint 2013. I am trying to create a new Edit Form in SharePoint Designer but unfortunately it is throwing Could not save the list changes to the server error instead of ...
0
votes
0answers
88 views

External Content type failed to save, The name domain\username cannot be resolved via Active Directory

I get the below error when I try to edit the external content type through SharePoint Designer. The Name Domail\username, is no longer with our organization. I believe he created this External Content ...
0
votes
1answer
112 views

ReadOnly columns in External List: SharePoint 2013.

I want to make some fields ReadOnly in External List in SharePoint 2013. I have tried JavaScript and SPUtility approaches as guided in this blog, but unfortunately did not work. In SharePoint ...
0
votes
0answers
50 views

SharePoint Designer not creating NewForm or EditForm for Stored Proc

I have created an external list using an external content type which uses stored procs for create, update, and delete operations. When I try adding a new item to that list using a Web Part, I'm ...
0
votes
0answers
86 views

Picker Control Filter for External List in SharePoint 2013

I have an External List in SharePoint 2013 as shown in image below. I have a field called Department. In the Read List operation, I have added wild card filter for Department column. For Calendar ...
0
votes
0answers
20 views

Order By clause is ignored

I've created an external content type using SharePoint designer with all 5 operations. Then, I figured it orders by the element ID. I've exported the BDCM file, opened it with Notepad, and modified to ...