A variation of a content type that stores content outside of SharePoint.
0
votes
2answers
451 views
An empty pipe element is not allowed - the Powershell I copied fails
I am just trying to fix something to get my BCS external list created. All indications are that the server has too many rows for BCS so here is what I put into the Powershell IDE running as ...
0
votes
1answer
84 views
External List & Picking pictures from a Picture Library
I have an external data source (BDC) based on which I created an external list. The (external) entity provides a field which can store / contain the link to an image.
Now there is an Image Library ...
0
votes
0answers
92 views
Multiple values from ECT field in Word 2007/2010 document
I have the following issue. I have a word 2010 document template where I would be able to add multiple values (not neccessary all at the same time - one by one is also ok) to a field from ECT field.
...
0
votes
0answers
206 views
Code lookup of values in External List returns no records
I am using SharePoint Foundation 2010
I am designing a bulk upload of files into a Document Library. The files will all have a Content Type applied to them with the values coming from a number of ...
1
vote
2answers
407 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 ...
0
votes
0answers
49 views
External Content List BDC Permission
As I understand it, if I have the authentication mode set to BDC Identity in an External List, the username of the user that is logged on to SharePoint should be the same username to check if it has ...
0
votes
1answer
152 views
Error when adding new external content type from azure hosted service
trying to set-up and consume a web service within SP using azure hosted services. I have written really simple code which compiles and deploys as a package. Followed this excellent walkthough... ...
0
votes
0answers
104 views
How to use boolean value for FilterDescriptor
I have an external content type with a few filter descriptors for name and type and such. These take a text string to search for objects where the appropriate property contains that text string.
I ...
0
votes
0answers
29 views
Reg BCS Entity field
I have created one entity with stored procedure. I want to create a hyperlink on one of the field in external list. Please provide me the solution how can we achieve this
1
vote
0answers
114 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
0answers
123 views
Use Secure Store Credentials to connect to database with Windows Authentication in Visual Studio solution?
Background: I have an external content type that has been developed in a Visual Studio 2010 solution. This content type is based mostly off elements in a database that are accessed via stored ...
1
vote
0answers
130 views
Does BCS support creating an external list from an existing list in a different web application using List Web Services
I have sharepoint 2010 farm where there are multiple web applications. I am trying to understand BCS and its capabilities. This is the structure I have :-
Web Application A > Site Collection > ...
0
votes
1answer
135 views
Set permissions for external content type from C#
When adding a new external content type you have to go into the CA and the Business Data Connectivity Service and then "Set Object Permissions" for each external contant type.
Is it possible to do ...
1
vote
2answers
1k 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 ...
0
votes
0answers
182 views
External Content Type custom action with parameters not showing up in actions menu
So I looked around for solution and could not find anything. Here's the problem:
I am using SharePoint 2010.
I want to add a custom action to an external content type.
If I add a custom action ...
1
vote
0answers
200 views
Create a survey in sharepoint 2010 where question text is from external content type
I have a small issue. I need to create a survey page in SharePoint 2010. This page needs to have dynamic number of questions where text values for this questions are retrieved from SQL Server database ...
0
votes
1answer
50 views
ECT: Agregate view, differing update and create forms
In short, I have a complex database containing documentation for IP addresses, servers, network switches and so on. This database should be manageable in SharePoint using, I think, external content ...
0
votes
1answer
1k views
Error with External Content Type List: “Unable to display this web part”
I have deployed an external content type to my local Sharepoint 2010 Server using a Visual Studio solution. The deployment appears to work. I can view the details of the content part in the central ...
1
vote
0answers
52 views
Getting error while creating ECT using WCF that is hosted in SharePoint through SharePoint Designer [closed]
I am getting error while creating ECT using WCF that is hosted in SharePoint through SharePoint Designer. The error message is Object Reference.
When I Host this WCF then I am able to create ECT ...
2
votes
1answer
108 views
Search terms containing period, “.”, does not yield any results.
Using external content types, I am trying to create an asset management system for administering, among other things, IP addresses. Using an enterprise search center, the crawler indexes the external ...
1
vote
1answer
635 views
Connect ECT to SharePoint List in InfoPath?
I'm trying to create a list in Infopath 2010. I'd like one of the fields to be a drop down list that connects to an external content type list. It doesn't show any of the External Content Type Lists ...
1
vote
3answers
3k 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
0answers
87 views
Populate Drop-Down Box with data from an ECT Column
I want to be able to create a drop-down list web part that takes its data from a specific column in an External Content Type.
If you need further clarification, please let me know.
0
votes
1answer
431 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 ...
2
votes
2answers
637 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
1answer
21 views
Which logs are SQL Error Messages returned by an External Content Type (retrieving data from an MSSQL db) stored in?
I'm a SQL DBA, a customer's external content type had its database schema changed from underneath it. Using SQL Profiler we could easily determine that the query included a column that no longer ...
0
votes
2answers
616 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
94 views
Trying to create list with ECT
I'm trying to create list from External content types with powershell. I'm trying to get the model, through this line :
$Model = Get-SPBusinessDataCatalogMetadataObject -BdcObjectType Model -Name ...
0
votes
1answer
320 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
241 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, ...
1
vote
2answers
365 views
ReadList with Association for External Content Type via Visual Studio
I would have thought this is a common requirement but I just cannot seem to find any resources addressing this. I have several Entities defined along with Associations between them. They deploy ...
1
vote
0answers
251 views
Business Connectivity Services over OData : caching and paging?
I'm planing a new application for a customer that requires to read data from an external system.
Basically, the external system will expose a read-only OData service (to be defined actually). The ...
1
vote
0answers
295 views
Association created by VS does not work
I am trying to create several ECT with Associations between them. Been playing around with several tools and reading/watching a handful of tutorials. I have gotten my pieces to work when playing ...
1
vote
1answer
927 views
External Content Type Search not returning results
I have configured my 2010 External Content Type for search by adding the RootFinder property to the ReadList method. I have also added the ShowInSearchUI property to the LOB entry. I then set up my ...
0
votes
1answer
577 views
External Content Type and Entity Framework
I have been struggling with this project for about two weeks now. I have successfully created an External Content Type using Visual Studio and have deployed it. I was also able to use the SharePoint ...
3
votes
1answer
381 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
3answers
318 views
SpecificFinder not called on Sharepoint 2010 BCS
I have an external content type for which I created a BDC model with a LobSystem of type dot.NET assembly. I have a SpecificFinder and a Finder method defined. I also have an external list created on ...
1
vote
1answer
776 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 ...
0
votes
1answer
356 views
Logical AND ,OR CAML Query not working in External List
I am using ClientContext Class and CAML query to retrieve items from External List in sharepoint 2010.I have built the query with Logical AND Condition in CAML Query like this
string sDataFilter ...
0
votes
1answer
497 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
1answer
708 views
External list with friendly display names for columns
I have an external content type that I'm accessing through a .NET assembly. So I created a BDC model with Type="DotNetAssembly" (for now with just finder and specific finder operations).
It works, ...
3
votes
2answers
537 views
Search in External content type
I am new to SharePoint. I am trying to add a search box to a list but I can't figure uot how to do it. I have added a external content type and want to be able to search in it.
So what I did was ...
1
vote
0answers
353 views
PageNumber-Fillter for Finder in .Net Assembly Connector
I'm currently trying to use an PageNumber-Filter for an Finder-Method in an .NET Assembly Connector. The relevant Part of the Method-Definition of the ReadList-Method looks the following.
<Method ...
2
votes
1answer
229 views
BCS Model not deploying in Farm environment
Has anyone else seen an issue with deploying a BCS Model WSP to a farm and the External Content Type is not being deployed? The Farm feature is activated.
It is working fine for a single server ...
1
vote
0answers
372 views
Problem with Refresh button on External data column
I'm struggling with refreshing items on list with external data. So far I have been able to make the refresh button work, but only when I add items to list in a standard way (via browser). When I add ...
2
votes
0answers
557 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
399 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
2answers
428 views
External list with bulk amount of data does not work properly
I have created and external content type to fetch data from a SQL table. The table currently contains 8000 records. So when I create an external list from that content type the list does not display ...
1
vote
1answer
483 views
Custom BDC External Data column errors “No exact match was found”
I've created a custom BCD for SharePoint 2010. It works well, i can create a list, view all the items, click on an item and view it.
I am now adding this to a list as an External Data column. The ...
0
votes
1answer
285 views
Is it possible to create an external content type from WCF service with message security?
I have an external content type that consumes a WCF service. So far it's something simple, over HTTP, no security, just for tests. Here is a sample to get an idea.
Now I'm stepping up a gear and want ...
