Business Connectivity Services
1
vote
0answers
122 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 > ...
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 ...
1
vote
0answers
216 views
Specify external content type lookup for deployable list?
I have a ListTemplate which is being deployed with Visual Studio.
Is it possible to make a reference from this template to an external content type that runs on the farm? Or must I manually add these ...
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 ...
1
vote
1answer
378 views
custom paging and sorting in BCS
I'm creating a custom .Net Assembly connector. I have to show a lot of data, so I want to page and sort that.
I've already created parameters in my model for that:
StartRow
PageSize
SortField
In ...
1
vote
2answers
363 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
292 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
925 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 ...
1
vote
0answers
134 views
Read sharepoint external-list items
I am working with sharepoint 2010. I have an external list. I need to retrieve the list items from the external list for which i am using the following code below.
SPQuery query=new SPQuery();
...
1
vote
0answers
453 views
Navision + sharepoint.
For the last couple of weeks we have been struggling with an issue that we could not solve. This issue are concerning Sharepoint and Navision 2009. So we really hope that you would find a solution. ...
1
vote
0answers
126 views
updating item from an external list
I'm trying to update an item in my external list i'm using BCS and LINQ to query. That's my
Update method :
public static void Update(Customer customer, int parameter)
{
...
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 ...
1
vote
1answer
202 views
Association between a custom list and an external list
I have a very basic question.
I have a Custom List and I'd like to add a lookup column from an External List based on a WCF Service. Is it possible?
E.g. I have employers in a custom list. I'd ...
1
vote
0answers
92 views
Edit the BCS search item
I have created an external list and external content type using SharePoint Designer. I need to search an item in the external list. So I configured search in central admin. I am able to search an item ...
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 ...
1
vote
1answer
135 views
The operation(s) generations creates an SQL query which exceeds the length limit in Business Data Connectivity Metadata Store
I am trying to add a table from a SQL database as an external content type. When I do so I am getting the following error:
The database table has 188 columns (I did not design this legacy system. I ...
1
vote
2answers
1k views
External Data field - problem with refreshing (SP 2010)
I have created a custom list with a field (column) of 'External Data' type, connected to my external content type. External Content Type's source is an SQL view. My problem is, when I make changes on ...
1
vote
0answers
131 views
BCS External List selected items using ECMA script
I am getting the BdcIdentity values using ECMA script for external list, is there any way to get the list column values using ECMA script
1
vote
0answers
362 views
Populating User Profile properties with multiple values via BCS/BDC in SP2010
In SharePoint 2010, I have user profile data synchronized from active directory. Additionally, I've created a BdcModelProject in Visual Studio 2010 and done the necessary work to add some additional ...
1
vote
0answers
250 views
Changing the field order after BCS Association? [closed]
I’ve created and deployed an External Content Type with Associations. All of the CRUD methods I’ve implemented are working correctly. Here’s my problem – in the View Item, Edit Item and New Item ...
1
vote
0answers
280 views
Deploying BCS Model To Multi-Tenant Administration Site [closed]
I've got a simple BCS model with a single entity for a test. The entity pulls from a Entity Data Model in a separate assembly. I'm using SharePoint Foundation so I used the feature receiver here to ...
1
vote
2answers
394 views
BDC external type with dropdown data entry
I would like to be able to have a BDC entity setup such that when you create a list from the external content type the new item form automatically comes setup with a lookup field for one of the ...
0
votes
2answers
634 views
Where the SharePoint External List data is stored?
Last week I had a discussion with one of my colleagues about "Where the SharePoint external List data is stored?", Is it stored in a SharePoint list and the SharePoint is synchronizing the changes ...
0
votes
2answers
611 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
376 views
What are the BCS/External List Limitations for ECMA CSOM?
I cannot seem to find any documentation on this topic. Are there any limitations for what I can or cannot do with the JavaScript CSOM in SharePoint Server Standard 2010 External Lists as compared to ...
0
votes
2answers
236 views
How can i use External Content Types - SQL Authentication with NO Kerberos
I'm in the process of using ECT and the data is in a sql sever.
Before i get started is this possible with no kerberos existing in this current environment.
So the service where SP resides is ...
0
votes
3answers
171 views
BCS in a multi tenant scenario
I'm planning on creating a BCS layer which will be used in a multi tenant scenario. The plan is as follows: multiple clients will all get a SharePoint site. They will sync data from their ERP into a ...
0
votes
2answers
813 views
Using LINQ on an external list
When I create a list in SharePoint and want to run LINQ agaisnt it I use SPMetal to auto generate the mapping.
SPMetal.exe /web:http://mysite /code:C:\MyFile.cs
This does not seem to generate the ...
0
votes
3answers
869 views
Importing data from Excel/Word into a SharePoint List
Is it possible to import data from an Office Excel or Word file into a list in SharePoint (specifically SharePoint Online)?
I have imported data from SharePoint lists to Word files.
0
votes
2answers
1k views
External Data Source vs. External Content Type
I was able to create an external data source (connected to an external SQL) database. However, when I try to create a column that is a lookup field, this data source and it isn't available to me
So ...
0
votes
2answers
2k views
Manage User Profile Custom Properties using BCS
We want to write a Custom Webservice to pull the User Profile Properties from SharePoint 2007 and should be able to consume the same Webservice in BCS (SharePoint 2010).
AIM:
1. Read a User Profile ...
0
votes
1answer
399 views
Synchronization of SharePoint 2010 List with SQL Server Table
I need to create a list such that the values on the list can be stored in SQL table as well.
I need to attach workflows to the list item as well. Its a simple workflow with two approval process ...
0
votes
2answers
280 views
External List and jQuery
I have an external list that I want to hackup with jQuery. If i put a simple alert in document .ready, it fires, and THEN the SharePoint progress spinner shows up, and then the data is returned - long ...
0
votes
1answer
163 views
External list in SharePoint 2010 with unique item permissions
Is there any way to set permission for bdc items within external list?
0
votes
1answer
1k views
Unable to display this Web Part. BCS SP2010
I am trying to get data form SqlServer2008 in SP2010 with the hep of BCS.
I have created External List Successfully,but when I go to my Site I get following error:
Unable to display this Web Part. To ...
0
votes
1answer
737 views
Search results: URL of BCS search results start with bdc3://
I am using sharepoint 2010 Business connectivity service. I need to search an item in the database. So I configured search service. I am able to find the search results but when I clicked on the ...
0
votes
1answer
232 views
BCS StreamAccessor method
I've implemented a StreamAccessor method for my BCS indexing connector.
My source is an SQL database which has a table that contains records.
Some of the records have links to files. My problem is ...
0
votes
3answers
261 views
Pass user UPN claim to WCF service via BDC
I've finally managed to get my SharePoint system up and running so that it authenticates users with Kerberos and successfully passes that authentication along to a back-end WCF service. All end-users ...
0
votes
2answers
409 views
SiteUrl BCS deployment error through Visual Studio
Error occurred in deployment step 'Add Solution': The default web application could not be determined. Set the SiteUrl property in feature xxx to the URL of the desired site and retry ...
0
votes
1answer
396 views
SharePoint 2010 BCS stops working after a while
A little background: we are using the BCS with an external content type to expose external content we provide using a WCF service. We have a webpart that uses the external content type to display a ...
0
votes
1answer
81 views
Displaying error in External List
I've an external list. I've to add a new item to the list (insert a record in the db) based on some conditions. Failing to meet those condition I must not allow the creation of object.
I've thrown an ...
0
votes
2answers
827 views
SharePoint 2010 using web service to insert a data that has a lookup into external BCS list
I've got a 2 SharePoint lists:
List A: This is an external list that's using Business Connectivity Services to connect to CRM. List B: This list contains a lookup field that linked into List A.
I am ...
0
votes
1answer
1k views
ECMAScript Client OM with External List
In SharePoint 2010, for a regular "custom" list calling SP.ListOperation.Selection.getSelectedItems() using the ECMAScript client object model returns an array of item IDs. These IDs correspond to the ...
0
votes
2answers
1k views
SharePoint 2010 Foundation BCS Errors
We have an BCS issue on a Sharepoint Foundation multi-tenant farm.
Users are able to create external content types using SharePoint Designer 2010, but when they browse to the list of external data we ...
0
votes
2answers
12 views
oracle data in InfoPath form
We have a InfoPath form on which wants to show real time data from Oracle database. E.g. Employee name in a drop down list in InfoPath form from employee table in oracle.
Don't want to populate ...
0
votes
0answers
11 views
Is there a way to make data linked to by BCS look like a document library?
Is there a way to make the data linked to by BCS look like a document library?
Basically, I'm storing some archival type documents in cheaper storage than a SharePoint document library, but I would ...
0
votes
0answers
36 views
External item picker Default Value
How to set default value to external item picker (the textbox that related to it.)
Thanks,
Omri
0
votes
0answers
55 views
The created external list does not support creating new items
i have BCS with external list that read list and read item is from a table.
and create new item is from Stored Procedure.
i'm using applicative user who has full permissions (work directly from ...
