Business Connectivity Services
0
votes
1answer
30 views
ValidateEntitySecurity failed on multitenant BSC installation
I've got a multitenant BCS service setup. It all seems to work; I've imported my model and it properly lists the entities in the model. But when I try to create an external list based on the model, ...
1
vote
2answers
2k views
BCS and Filtering/Paging - External List vs Business Data List Web Part
I am trying to learn BCS for use in an in-house application. To keep it simple at this point I am limiting myself to a single table even though the table has FK references for grouping and some ...
1
vote
1answer
2k views
CAML and External List - pass parameter to ReadList (finder) method
I have a Finder method defined on an External Content type (created with Visual Studio). Whan That method receives a parameter. So the method is something like ReadList(string partnerName). I have ...
0
votes
0answers
79 views
Cannot set BCS MethodInstance permissions through Central Administration
This is very annoying, but as far as I can tell, it is only possible to set Entity level permissions through the Central Admin BCS user interface. Is there any webpart that has been open sourced that ...
0
votes
1answer
237 views
BCSLogin failed
I got a problem when using BCS in SharePoint Foundation 2010. I'm not able to let other users see the BCS content. I tried all the possibilities I found in internet (giving permission to the users in ...
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. ...
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 ...
2
votes
1answer
348 views
Dropbox access from SharePoint
I am new to Dropbox, and I'd like to know if there is an easy way to access Dropbox content from SharePoint 2010 / Office 365.
For example, should I consider BCS? Or is there a way to work with the ...
1
vote
1answer
705 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, ...
5
votes
2answers
274 views
How to dynamically generate Business Connectivity Services
We are trying to deploy a Business Connectivity Services(BCS) Model solution where the properties in the model depend on the structure of the data exposed by a web service.
Ideally the BCS Model ...
1
vote
1answer
300 views
How to Stop ECT Action from Using ActionRedirect
If I create an Action on an External Content Type with a URL such as this . . .
...
1
vote
0answers
127 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)
{
...
3
votes
1answer
334 views
Access denied for BCS method in e-mail event receiver
I have a SPItemEventReceiver which does some stuff with an external list when a document is uploaded to a DocLib. I now wanted to have it also run when an e-mail is sent to that DocLib.
I could have ...
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 ...
2
votes
0answers
103 views
External Data Column no sorting by a string based additional field
Can anyone confirm or tell me why you can't sort by an External Data column additional field if its type descriptor is a string?
It works for int, bool and guid type descriptors. If I add a standard ...
3
votes
1answer
499 views
multiple value in external data column
We need to store multiple value from external source in the one column. Same multiple lookup.
Is there any exiting way to do it?
If no, i think about developing custom entity piecker, but it need ...
0
votes
3answers
243 views
SharePoint foundation and BCS
I am testing SharePoint 2010 foundation with bcs to access one of my sql tables.
I created a list with filters on some fields (wildcard and limit types)
But unfortunately, when I display (browser) ...
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 ...
3
votes
2answers
559 views
TFS-SharePoint integration
I am currently investigating how to push data from Team Foundation Server to SharePoint.
Are there any connections available out of the box? Any useful online references? Third party tools?
2
votes
1answer
405 views
Sharepoint Online and custom BDC models
Hello I hope somebody can help.
I need to access an external timesheet from Sharepoint Online.
The Timesheet site uses a REST api to provide the data, not a WCF or traditional ASPX webservice. So ...
6
votes
4answers
2k views
Working with large external lists using BCS
I have a database that I want to display the content in SharePoint 2010. I am not displaying the content in a list but am using a custom WebPart.
The database is not updated any more as it is ...
0
votes
2answers
814 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 ...
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
1answer
581 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
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
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 ...
0
votes
2answers
184 views
Single Library Storage for multiple Site collections
We are building portal based on SP 2010 platform which will mainly be a e-learnig site with SharePointLearning Kit. There will be ca. 100 school site collections. We will also have about 23 gigabytes ...
0
votes
1answer
740 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
3answers
871 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
1answer
416 views
synchronize data from external list and SPList
How do we synchronize data from an external list (BCS) into a custom SharePoint list? I have tried using a timer job, but it did not help. Any ideas?
2
votes
3answers
534 views
SPTimer job and BCS External list
Business requirement - synchronize a table from external my sql database into SharePoint list.
What I have done.
I have an external MySql database which as LOB data. I have created a BCS ...
2
votes
1answer
314 views
How to customize profile pages for external content type search results?
I have set up the SP 2010 enterprise search to include searches in line-of-business data. (In my concrete case that would be data from Dynamics CRM 2011 but I hope that is not relevant). I have ...
3
votes
1answer
311 views
How to use the batching and batching termination filter descriptors in BCS .NET Connectivity solutions
I know about this post on BCS paging: Paging and sorting with BCS and have implemented a similar approach in a BCS solution. However, what I'm really looking for is a complete example showing how to ...
1
vote
3answers
569 views
Error while import resource file Business Data Connectivity
I am trying to use powershell for importing a resource file in Business Data Catalog but I keep getting the following error
Import-SPBusinessDataCatalogModel : The root element of a valid
Metadata ...
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 ...
1
vote
1answer
378 views
BDC hide identifier in new item form
I'm working on a simple bdc model in visual studio.
i use the entity framework to access the data on the database.
Everything works fine (all CRUD operations) but in the "New item" form i have to ...
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
239 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.
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 ...
1
vote
2answers
306 views
merge data in a sharepoint2010 user profile property sync with sql using BCS
i have configured the user profile syncing with my custom SQL table.
i require 4 properties that are with 6 columns in the table
& the scenario is i have to concatenate the strings of the 3 ...
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
138 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
916 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 ...
0
votes
1answer
233 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 ...
10
votes
3answers
3k views
How to automate entry of external column data in BCS?
I have a document library, Resumes, that has a large number of resumes in it. There is a regular column on that library, called EmployeeID, that is already populated. I have an external content type ...
9
votes
3answers
794 views
FAST Search Security Trimming of non Windows External Content Types
We have integrated a back-end web application into SharePoint 2010 using the BCS and the OOTB Web Services connector.
The data in the backend system is protected by ACLs and we need these ACLs to be ...
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 ...
5
votes
2answers
407 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 ...
