Questions tagged [bcs]
Microsoft Business Connectivity Services (BCS) (formerly named the Business Data Catalog) provides the capability to allow data sources outside of SharePoint to be surfaced and potentially modifiable in SharePoint's List user interface. Use this tag for questions or problems related to configuration or using BCS.
387
questions
6
votes
4
answers
2k
views
Reusing and parameterising BCS External Content Types
I recently posted a query here that asked about the best way of connecting to an external SQL store.
I got some great responses back but need a little more info, specifically around External Content ...
- 2,130
2
votes
2
answers
1k
views
Selecting default filter
I have a ERP system which is linked to SharePoint via BCS. In a previous 2007 site, the BDC layer used the searchcode from the ERP system as primary key. That meant the user could just type in a ...
- 1,264
1
vote
1
answer
3k
views
Multiple filters in ECT External Item Picker in SharePoint 2010 BCS?
I am using SharePoint 2010 BCS to connect to a SQL Server database table and created an External Content Type (ECT).
In this ECT you can specify a filter and I have done that, and I mapped the ECT to ...
user2794
0
votes
2
answers
1k
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 activation....
- 947
3
votes
1
answer
342
views
Is it possible to filter a BCS list using a site's name?
I'm running SharePoint Foundation and copying a site template per project. I would like to filter the BCS list in my template using the site name.
Is there a possible method?
user2722
1
vote
1
answer
685
views
Custom View Header Rendering Twice on External List
I'm starting to work with custom view stylesheets on an external list. I am finding the header is rendering twice - once upon initial page render and again after the data is returned from the server:
...
- 213
1
vote
2
answers
1k
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 ...
user2600
2
votes
2
answers
779
views
Can I use a Console Application to Programmatically Create a Content Data Source and Start Crawl?
I am looking for examples where folks have programmatically defined a business data content source and setup Search Service Administration to crawl it, all within a console application. I'm aware of ...
- 249
0
votes
2
answers
763
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 ...
- 351
0
votes
2
answers
2k
views
Pros and Cons of a BCS integration versus a Custom Integration
What are the pros and cons of using the BCS to integrate an external system into SharePoint versus a custom integration.
1
vote
1
answer
488
views
Populate SharePoint Group from BCS External List
I have a BCS External List that is giving me the data that I want. Currently that data is usernames (domain\username).
Is there anyway to sync/import/connect an External List with a SharePoint Group?...
- 543
0
votes
1
answer
611
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 ...
- 101
2
votes
1
answer
247
views
BCS, field captions/title localizations
We've developed BCS appllication and now have no ideas about how to localize fields titles in BCS model. Where some xml tags in BCS model definition, but it did not work in our practise.
Does ...
- 787
0
votes
2
answers
868
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 ...
user2180
1
vote
1
answer
105
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 ...
user2057
3
votes
3
answers
2k
views
Display an SPFieldUrlValue property from a BCS Model
I have a pretty simple BCS model:
public Guid Id { get; set; }
public SPFieldUrlValue Url { get; set; }
public string Description { get; set; }
public string Owner { get; set; }
public DateTime ...
- 213
0
votes
2
answers
1k
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 ...
- 31
1
vote
1
answer
172
views
SPBuiltInFieldId structure for BCS - is there any const for "BdcIdentity"?
For SPListItem's built-in field values we have SPBuiltInFieldId class with many guids - SPBuiltInFieldId.Title and so on.
Now I am working with BCS and I can't find any built-in object for "...
- 787
2
votes
1
answer
2k
views
"Access denied" while loading the BCS list from the database
I have tried to display data from SQL Server to a SharePoint page through BCS services
using SharePoint 2010 designer.
While loading I am getting this error:
Access denied. You do not have ...
1
vote
3
answers
5k
views
Problems configuring External List on Sharepoint Foundation 2010
I have created a new database on MS SQL SERVER SHAREPOINT instace that contains two simple tables.
Then I tried to link values defined in these tables by implementing External Content Types using ...
- 435
2
votes
1
answer
905
views
Paging and sorting in sharepoint BCS
I saw this post about Paging and sorting and tried to do simiral thing in my project. But failed to do so. Everything works fine apart from instead of getting the value i get the parameter name. ...
user1523
1
vote
2
answers
2k
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 ...
1
vote
4
answers
2k
views
BDC to BCS Application Definition Upgrade
I'm trying to perform an upgrade of a SharePoint 2007 environment to 2010. Our plan is to move to entirely new hardware and do a content database migration. In such a scenario, it seems that BDC ...
0
votes
2
answers
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 ...
- 2,528
2
votes
1
answer
2k
views
Developing Visual Web Part with external list in ListView
Using VS 2010 i've created BCS model for external MS SQL source, deployed it with success, then created external list - it works perfect.
Now my task is - create visual web part in VS2010 and place ...
Mick
2
votes
1
answer
3k
views
Creating a Site Column from an External List with SharePoint 2010?
Can you create a Lookup column from an External List within SharePoint 2010. I have achieved this before but it seems incredibly fragile and I am now wondering if this is even a supported feature and ...
0
votes
1
answer
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 ...
- 330
2
votes
3
answers
8k
views
How do you enable connect to outlook on external list?
I am very new to sharepoint, its about day 3 of working with it, and I am having a problem getting Connect to outlook working on external lists. The menu item is greyed out.
In my external contact ...
1
vote
2
answers
643
views
BCS and SharePoint 2010
I'm looking to possibly upgrading to the latest version simply because the latest version has BCS integrated with the free version. A question I have to answer is "Does BCS integrate with Sage ...
- 1,676
0
votes
2
answers
2k
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 ...
4
votes
3
answers
2k
views
Validation for external lists / external content types
Where does one put validation for external content types? Let's say one field on my ECT represents an email address that must be unique in our system. Where would I put the validation that checks to ...
- 51
2
votes
1
answer
855
views
Exporting Application Model from SP Designer 2010 to Visual Studio 2010 BDC Model Project
I've created an Application Model in SP Designer 2010 and exported it (XML file). I'd like to use the definition in a Business Data Connectivity Project in Visual Studio 2010.
Is there a way to ...
2
votes
2
answers
654
views
Implementing Security on custom BCS/.net class?
I'm implementing a custom BCS Model to get data from a backend system. As the backend uses it's own user management, I'm accessing it through a service account.
All of this works well and allows me ...
- 868
3
votes
1
answer
3k
views
No Business Data Connectivity Service associated with current web context error
I am running on a new dev setup for SharePoint 2010 and trying to setup some External Content types. I think that I have setup BCS correctly (since I see it running in the central administration). ...
- 285
14
votes
3
answers
14k
views
Paging and sorting with BCS
I going to use the new exciting External Content Type feature to display a list of data from an external LOB system. The list is potentially long, so paging with filtering at the LOB system side is ...
- 578
4
votes
1
answer
230
views
Int type as Entity key into BCS Model
The BCS Model can't create a form for the "Update" operation if the key of Entity has a type of uint, int, long or ulong when I use WCF as a data source. It works fine with the string type.
Does ...
- 578
3
votes
1
answer
2k
views
BCS and Oracle: bug in connection string?
I am trying to connect from BCS directly to Oracle, but there is an error:
Keyword not supported: 'connect timeout'.
I think that the connection string formed for Oracle is in an incorrect format ...
- 578