Business Connectivity Services
1
vote
1answer
583 views
External List Error : The query against the database caused an error
I got an SQL Server 2008 R2 and a SharePoint Server. I have put up a BCS between the two servers. Reading data through a External List. This worked fine yesterday. But to day I got this error:
The ...
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
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
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 ...
3
votes
1answer
271 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?
3
votes
2answers
777 views
Moving BDC models from server to server
I have created a BDC model and deploy it through a feature. The feature has to have a SiteUrl as specified in the feature xml below. However when I move the feature from say the development to test, ...
1
vote
2answers
837 views
SQL Hardening, BCS, and ECT (SharePoint 2010)
Currently running into some errors when trying to setup External Content Types with SharePoint 2010. The goal is simple which is to connect to a SQL Server and pull information into SharePoint to an ...
0
votes
1answer
385 views
BDC - User profile sync won't sync with sql server/wcf service
I created simple web service which implement 2 methods (one (no parameters) return list of object, another (one parameter - upId int) returns simple object with 3 properties (bool, string, and int ...
2
votes
0answers
196 views
Filling a External Data field (BCS) in a list trough Powershell
I have a list of which one of the columns is of the "External Data" type, linked to a BCS service.
We called this column "Organisation", and when I check the generated fields in powershell (with ...
0
votes
0answers
240 views
Sharepoint and Liferay integration [closed]
Is there any component available to pull data from liferay and show them on sharepoint?
Any links to resources would be highly appreciated.
2
votes
2answers
504 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 ...
1
vote
1answer
483 views
Best way to get external data to SP 2010
This is the scenatio:
I have an AD that i'm going to use when installing SP 2010 but it doesn't have a lot of meta data as in poperties its only got : Lastname, fistname and email etc..
So i would ...
1
vote
1answer
142 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
917 views
How to Bind Data to Traditional ASP.NET Controls in SharePoint Foundation 2010?
First off, my background is ASP.NET Web Forms. I'm sure this is very simple but I'm quite new to SharePoint. We're running SP Foundation 2010.
I'm going to build a WebPart in VS.NET 2010 and deploy ...
1
vote
3answers
712 views
Accessing External List Items Programmatically
The following bit of code throws an Unauthorized Operation exception when I try to enumerate the items in the list. Any ideas?
SPSecurity.RunWithElevatedPrivileges(delegate() {
...
5
votes
2answers
409 views
Use custom page in _layouts for display item form
I was wondering if I could acheive the following. I have a custom application page living in _layouts which displays an entity based upon an external content type item.
For external lists using this ...
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
2
votes
1answer
73 views
Good book or resource that talks about custom connectors and SharePoint search Integration?
Do you know any good books or resources that explains how to write your own custom connector for search crawling?
I have been reading Professional Business Connectivity Services in SharePoint 2010 ...
0
votes
3answers
262 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 ...
6
votes
4answers
1k 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
votes
1answer
850 views
Creating an external list from SQL query using BCS
I'm developing a visualization application on SharePoint Enterprise 2010. This involves doing some SQL queries I would love to expose as external lists in SharePoint. All interfacing with the database ...
0
votes
2answers
829 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 ...
5
votes
1answer
235 views
How to use BCS in Word for editing BLOBs
If I have an External Content type defined with a StreamAccessor that will end up referencing Word docx files stored in another system (reason for using BCS), what options do I have for updating the ...
0
votes
1answer
397 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 ...
2
votes
2answers
439 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 ...
1
vote
0answers
363 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 ...
2
votes
1answer
2k 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 ...
2
votes
1answer
1k 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 ...
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 ...
1
vote
1answer
322 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 ...
1
vote
1answer
1k 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 ...
2
votes
1answer
607 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
1answer
468 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:
...
2
votes
3answers
5k 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
0answers
282 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
0answers
252 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 ...
3
votes
1answer
144 views
Can document views/metadata be 'live'?
We have a need for end users to see documents with additional 'live' columns, i.e. I would like to show a view of documents with employee id JOINED with data from sql server (for some additional ...
1
vote
1answer
523 views
Is there a way to modify external list form with Infopath?
I would like to modify an external list form with infopath like I do with custom lists.
However, even if I select "create infopath form" when creating my external list, it doesn't seems I can do that.
...
2
votes
1answer
523 views
Using BCS and External Content Types to create Publishing Pages
I'm starting a new SharePoint 2010 web content management project where a portion of the site's content is driven by an external system (SQL Server based). Think employee bios... The external system ...
2
votes
2answers
794 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 ...
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 ...
3
votes
3answers
1k 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 ...
6
votes
4answers
6k 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 ...
1
vote
3answers
2k 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 ...
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 ...
2
votes
1answer
160 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 ...
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
270 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 ...
3
votes
3answers
1k 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 ...
