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

learn more… | top users | synonyms

0
votes
1answer
11 views

ECT and adding created by and updated by

I'm using BCS and ECT's to connect to external DB. Is it possible to record the user who has updated or created the record in the DB? I'm not using SSS at the moment. Thanks
0
votes
2answers
24 views

BCS connecting to Oracle Database with BDC Model

Firstly I'm open to suggestions if people have better solutions or ideas. I want to create a Dashboard with CRUD operations from the Oracle data and planning on using SPD External Content Types. I'...
0
votes
0answers
14 views

Create ECT using Nested SQL Store Procedure

I'm creating ECT in SharePoint O365 using SP Designer. I'm defining the operations using Store Procedure. My Read List Store Procedure some thing like below: CREATE PROCEDURE [dbo].[...
0
votes
0answers
11 views

MYSQL External Content Types in SharePoint Online

Is there a way to create an external content type using MySQL in SharePoint 2013 online?
2
votes
0answers
30 views

Reading data from a external list using a 2010 workflow

I work with SharePoint 2013, and need to read information from a external list that I have created. The list can display information correctly when using it through the browser. I need to create a ...
2
votes
0answers
32 views

Display additional fields on forms (External lists)

I have a external list where I have employee information. I am trying to do a lookup where I can select the employee and display it's corresponding department with the additional columns possibility. ...
0
votes
0answers
13 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
23 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
79 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
45 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 list(...
1
vote
0answers
111 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 ...
1
vote
2answers
49 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
47 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
24 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
347 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
30 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
86 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 xmlns="http://schemas....
2
votes
1answer
39 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
24 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
42 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
39 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
291 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
52 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
33 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
26 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
118 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
41 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
51 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
26 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
24 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
14 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
27 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
131 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
53 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
17 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
115 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
28 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
74 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
175 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
907 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
15 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
234 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
100 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
51 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
66 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
105 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
50 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
21 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
40 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