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: ...
1
vote
0answers
30 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
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 - ...
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 ...
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
0answers
124 views

Copy SharePoint 2013 External List Data to Custom List

I am currently developing a solution where I have en external content type/list which pulls filtered data back from a SQL source. What I am trying to do is get this data into a SharePoint list so ...
0
votes
1answer
309 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
188 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 ...
0
votes
1answer
154 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
0answers
113 views

SharePoint 2010 - Business Data List - Apply Multiple Values to a Single Column Filter

I am working in SharePoint 2010. I have a stored procedure that I've attached to through an External Content Type. I've created a Web Part page with a Business Data List web part and have ...
1
vote
1answer
350 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
1answer
115 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
512 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 ...
1
vote
2answers
88 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
487 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 ...
0
votes
1answer
335 views

BDC external contet type SharePoint Designer

I have problem with Business Data Connectivity, when I try to create new external content type in SharePoint Designer - I "Add Connection" then I choose SQL Server I fill Database Server and Name and ...
2
votes
1answer
558 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
2answers
578 views

How to create an external data source based on a Web Service?

Can you please advise me "How to create an external data source based on a Web Service"? Usually WCF can be a data source, but I am not strong on WCF. Could I use the existing web service as an ...
1
vote
0answers
161 views

SPQuery on ECT very slow

I am creating a custom web part which is supposed to return results from an External Content Type(ECT) List which contains almost 40,000 records. There are multiple ways the items can be searched and ...
1
vote
3answers
4k views

How to Connect to SQL database using Sharepoint 2010/Office 365

How do you get into the Central administration page and create a secure store application ID? I am trying to connect to an external database and cannot do so with my current credentials. I have a ...
0
votes
2answers
976 views

Update and Create Problem with Adding Columns to an Existing External Content Type in SharePoint 2010

I used SharePoint Designer 2010 to create an external content type (ECT) that consumes and writes data to SQL Server. [Went through the process of connecting to a database table, then right-clicking ...
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
269 views

Make list item “editable”

I have created a sharepoint list from an external content type (using Sharepoint Designer) with columns Id, Name etc. The fields in the Id column are links and contain a dropdown menu (view, edit, ...
2
votes
1answer
1k views

External wcf (Soap/rest) datasource to external content type

I'm looking for a way to use an external datasource (WCF SOAP or REST) and include the results in a list. Using the External Content Type directly for a WCF service does not work, as I get a XML error ...
2
votes
1answer
837 views

External Item Picker problems in InfoPath 2010 with ECT

I have used SPD to create and ECT to a standard SQL Database, and then a view. In the view there is an ID field, and then another field of a string type that stores codes (consisting mainly of ...
2
votes
0answers
546 views

Sharepoint external list problem

I'm taking my first crack at creating an External list in Sharepoint 2010. I've taken 3 training classes in Sharepoint 2010, and am now trying to transfer my knowledge to my own development ...
1
vote
1answer
3k views

Why won't the “New Item Form” create for an external list?

I'm using SharePoint Foundation 2010 and I have an external list created from an external content type. The external content type uses a WCF service as datasource. The WCF service has only three ...
0
votes
1answer
799 views

Is it possible to create external content types without secure store?

Our organization is going to be using Office 365 - D (BPOS-D) as our SharePoint environment. I'm told we can't use secure store in this environment. So how do we use SharePoint to connect to an ...
0
votes
1answer
6k views

[SharePoint Designer 2010] Connecting to an external data source

I'm using SPD 2010 to connect to an external SQL database hosted on a different server. External data source type selection is SQL Server. I then filled up the connection properties , choose "Connect ...
0
votes
2answers
407 views

Adding Content to External Content Types

I was able to create an ECT and the first three columns of data that I used to create the ECT display on the portal. The only issue I am running into is that I want to add more columns to the ...