A variation of a content type that stores content outside of SharePoint.
3
votes
1answer
69 views
Problems with External List and Creating New Item with Webservice
can anybody verify that inserting new Items through SharePoint Webservice Method Lists.UpdateListItems is errornous?
I always get the Error:
0x80070057Bad parameter passed to Web Server ...
3
votes
1answer
394 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 ...
3
votes
1answer
410 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 ...
1
vote
1answer
40 views
Associated ECT only displays ID (not title) in external list
I have created two ECTs, let's call them country and city for clarity. I have also created an association with city as the child and country as the parent. When I create an external list for city, ...
1
vote
1answer
143 views
BDC Model for ActiveDirectory
I am trying to build a BDC Model and a custom .net connector for ActiveDirectory so that users can search for data in AD from Sharepoint as well as create lists (ie: Users list that will show users ...
1
vote
1answer
182 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.
0
votes
1answer
33 views
Add Column to External List from Updated External Content Type
We are currently trying to understand the relationship between External Content Types and External Lists within SharePoint 2013. We have a read-only ECT which we defined based on a SQL Server View. ...
0
votes
1answer
53 views
Lookup Data from External List
I have a list - Companies - that is an External List based on an External Content Type from SQL Server. I have another list - Purchase Orders - that has a lookup column to the Companies table.
I am ...
0
votes
1answer
41 views
Search External Content type not returning all records
I have a sql view that returns 449 records.
I have setup my external content type to point to this view and have implemented via SPD the read item and read list operations.
I have created the ...
0
votes
1answer
55 views
Filtering datas
I want to filter datas.
I have a data view with 3 column (name,department,foreign languages)by a SOAP Connection but I can't make any filtering for foreign languages.
I have a html form web part ...
0
votes
1answer
181 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 ...
0
votes
1answer
174 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 ...
0
votes
1answer
36 views
Parameterized External Content Types?
Suppose I have multiple instances of some line of business app in my environment. Is there a way to create a single External Content Type that can be parametrized and reused? If I have 5 instances, is ...
0
votes
1answer
153 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
1answer
439 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 ...
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
1answer
325 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:
...
0
votes
1answer
534 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 ...
2
votes
0answers
574 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
401 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
0answers
17 views
Crawled Properties from Business Data not getting created
I have created a content source crawling exteranl data using business data connectivity service. I can sucessfully crawl the business data content source without any errors. In crawl logs also I ...
1
vote
0answers
137 views
user lookup field for external lists
Guys please don't beat me too much, I want to add user lookup field into my external content type to use sharepoint people picker in my external list, the price doesn't stand up. So is it ever ...
1
vote
0answers
28 views
What CMIS services are required if Fast Search is used to query an external CMIS repository
For a repository to be CMIS compliant, it must implement a number of services. Query services are not mandatory. I want to incorporate a CMIS repository in SharePoint 2010 as an External Content Type. ...
1
vote
0answers
118 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
134 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 > ...
1
vote
0answers
203 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 ...
1
vote
0answers
260 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
318 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
0answers
369 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 ...
1
vote
0answers
383 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 ...
1
vote
0answers
101 views
Could not find IEntity
I have a SharePoint 2010 site collection, which is mainly used to create projects. These projects can contain different phases, which becomes a new subsite when a new project is created. The phases ...
0
votes
0answers
7 views
2010 BCS contains metadata for an invalid Data Source for a ECT
I have been asked to look at getting search to work on an External Content Type. Taking a look at the ECT in designer I see that the previously defined datasource which is stored in BCS is invalid in ...
0
votes
0answers
21 views
WCF External Content Type: Unable to find the default edit form for list LISTNAME
I using Sharepoint 2010 Online and SharePoint Designer, and I create an External Content Type from WCF Service. It have a CRUD operations. Next, I create List based on external content type. Read ...
0
votes
0answers
9 views
ECT always disappear in ECT Picker
Sometimes ECT lists disappear. It says
External Content Types are not available. Contact your system
administrator.
I have to change the App Pool for BDC and then return the previous App Pool ...
0
votes
0answers
84 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 ...
0
votes
0answers
56 views
Custom InfoPath edit form for external list with two fields referencing same foreign identifier
I have a scenario simmilar to this:
SQL Server tables
Partner
- ID (primary key)
- Name
Project
- ID (primary key)
- Name
- TechnicalPartnerID (foreign key to Partner)
- BusinessPartnerID (foreign ...
0
votes
0answers
37 views
Add Connection is empty-External Content Type
When I click on Add Connection the drop down list comes empty. What should I do? Why can't I see the drop down list?
0
votes
0answers
107 views
Forcing filter value of an external item picker on an InfoPath form
Question:
Is there a way to force the filter value on an InfoPath form's external item picker?
I don't want to modify the underlying ECTs to do this, because I hope to reuse the ECTs for different ...
0
votes
0answers
108 views
Programmatically access external list associated column
Hi I have 2 external lists 'A' and 'B'. with an associated column in A, that looks up for B. When i view/edit item in browser, it shows correct values as shown in picture below.
But when i try to ...
0
votes
0answers
39 views
Unable to select External Content Type for new Synchronization
I have created a new ECT in SPD, but when i try to add a new synchronization connection in Central Admin, the ECT picker does not display my new type. It shows several others, but not the one i need. ...
0
votes
0answers
199 views
Business Data Connectivity Service: There are currently no external content types
I have created an external content type in VS2010 and successfully deployed it on my site Collection. Now, in my SP site, i created external list and configure it with my external content type (the ...
0
votes
0answers
277 views
External Content Type using Entity Framework “'The specified named connection is either not found in the configuration etc..”
I suspect this error is because I am using the EF and the connection string is not being found. Here is the error I am seeing:
MethodInstance with Name 'ReadList' on Entity (External Content Type)
...
0
votes
0answers
95 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
212 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 ...
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
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
0
votes
0answers
183 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 ...
0
votes
0answers
133 views
Enterprise - External Task List - Connect to Outlook- setting Assigned To
I've got an External List coming from an External Content Type which has Office Item Type of "Task". It comes from an external system which has its own concept of a task, and I'm pulling them into ...
