Business Connectivity Services
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 ...
0
votes
2answers
46 views
Get Items from View of an Extrenal List(BCS List) programmatically
I have created a external content type (BCS list) in SharePoint. I am using the below code in order to get items from bcs list.
SPQuery query = new SPQuery();
query.Query = ...
0
votes
1answer
32 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
2answers
79 views
How can I view Developer Dashboard from a custom master page or PowerShell?
I need to view Developer Dashboard data to investigate a bottleneck on a SharePoint deployment, but the master page has been customized and the Developer Dashboard is not available (after enabling it ...
0
votes
0answers
23 views
Enumerate BCS Object Permissions
Hi I am looking for a method via PowerShell to enumerate the various ETC's that have been created to determine who currently has access. I realize that I can do this via the front end, however I need ...
0
votes
1answer
88 views
Getting Filtered results by Date column from a list with BCS and SharePoint 2010 JavaScript Client Object Model
I'm trying to get the filtered results by a column type DateTime from a list filled with BCS using JavaScript.
I've tried everything to get those results with query like:
"<Where>" +
...
0
votes
0answers
59 views
Show related entities in FAST search results
I've successfully created a .net assembly BCS to crawl external data in my enviorment. The BCS include an AssociationNavigator to crawl related entities based on foreign key. When i perform a crawl ...
0
votes
0answers
75 views
Filtering a business data list with date range filter
I just started working with BCS , specifically business data list. We created a sql view/query and are displaying the results via a BDL with some basic filters. However one of the bigges requirements ...
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
169 views
Sharepoint 2013 - how to connect to an external data source
I am using SP2013 and want o connect to an external data source which is an sql server source. I would like to display the some table contents from a phone list here. I am new to the software and have ...
0
votes
1answer
155 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
124 views
Best to way to populated external database?
I have a requirement where I need to populated a SQL Server database (tbl_Customer) with sharepoint List. I am not sure about the best approach.
approach 1: bcs to external database and scheduled ...
0
votes
0answers
51 views
BCS and SQL Server error messages
I'm using the BCS for reading/writing to a database. It all works well but a problem I have is that the DB uses various constraints to enforce data integrity.
If someone e.g., tries to insert some ...
0
votes
1answer
166 views
Cannot see BDC External system in SharePoint Designer Data Source Explorer
I have first created external content types in SharePoint Designer then exported the model to Visual Studio. I then deleted everything created in Designer and deployed the model through SharePoint ...
0
votes
3answers
666 views
Setting Value of External Field in Code
I cannot seem to find any examples of how to set a BCS External Field via code. I have two lists that both have a BCS field named "Industry". When an item is created in List A I need to create a new ...
0
votes
2answers
209 views
replication of document libraries in sharepoint 2010
In sharepoint 2010, Need to have a document library in a site and another document library in another site and the 2nd document library should be an exact copy of the 1st document library(with the ...
0
votes
1answer
116 views
How to connect between two document libraries in different webapplications using BCS?
In Sharepoint 2010 , How to connect between two document libraries in different webapplications using BCS?. The webapplications has sitecollections and sites in it and the sites are getting created ...
0
votes
2answers
274 views
Connect BCS / BDC to the User Profile Service?
Firstly I'm open to suggestions if people have better solutions or ideas. I would like to be able to create a list with a 'username' field that will pull additional fields from the information stored ...
0
votes
1answer
128 views
KeywordQuery to search by BCS Entity Name and Namespace
I have built a custom search connector to crawl and index external content types. That works quite well. I find the index entities in the search center as well through using the API of ...
0
votes
0answers
43 views
Generating Business Layer for External Lists
I have my custom database on backend and i have used BCS to bring in the information to SharePoint 2010. So far so good, but now i want to ideally use strongly types generated entities just like ...
0
votes
0answers
53 views
Auto-generated code for “Using”, “SQLConnection”, “ReadItem”, “ReadList” methods
I am beginner in SharePoint 2010 development. and doing following lab:
Module 6: Accessing external data with Business Connectivity Services in SharePoint 2010
...
0
votes
1answer
85 views
Sharepoint 2010, BCS and inner join
We have external content type based on a table in database. It was created using SharePoint designer.
Unfortunately one of the column is referencing another table, which is dictionary - primary table ...
0
votes
0answers
61 views
Helper DLL - Building Reusable BCS Class - Trying to build a “Create” method
I've been using a helper dll for quite some time to interact with various BCS Entities. It works rather well, no security issues, saves me a lot of time. The problem that I have is that I want to ...
0
votes
1answer
156 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
0answers
189 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
2answers
451 views
An empty pipe element is not allowed - the Powershell I copied fails
I am just trying to fix something to get my BCS external list created. All indications are that the server has too many rows for BCS so here is what I put into the Powershell IDE running as ...
0
votes
0answers
257 views
Cannot see External Content Type in SharePoint 2010 Picker After Deploying Visual Studio BDC Project
I have created BDC Model as steps provided in "SPCHOL304 – Developing a BCS External Content Type with Visual Studio 2010 – C#" the lab manual from Microsoft for BCS. I am able to see that BCS Model ...
0
votes
0answers
101 views
BCS Model with primary key consisting of multiple columns
We have a database with a table that has a primary key that consists 4 columns.
I want to show the table data in SharePoint by using BCS.
A created a new BDC Model in Visual Studio, but has no idea ...
0
votes
1answer
214 views
Using collection parameters with BCS entities results in “No constructor” error
I have a problem using collections for in-parameters with BCS entity methods and since I'm pretty sure you should be able to do this there must be some error that I haven't found.
I have created a ...
0
votes
1answer
782 views
working and filtering with large external lists using BCS
I have a large set of orders (about 7500) that I want to show in my SharePoint site. I'm using BCS because I also want to link the orders to documents.
I also have an external list with these ...
0
votes
0answers
206 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
416 views
The shim execution failed unexpectedly - Access is denied
Business Case: The user needs to access the data outside of SharePoint 2010. The database is in MS SQL. The connection to MS SQL
from SharePoint is done via configuring BDS and SSS impersonation
...
0
votes
0answers
157 views
User Profile Import PictureUrl from BCS after SP 2010 SP1
I've looked all over, and read through a few blogs on how you can map a string url into the PictureURL field in the UPS from a BCS connection. Unfortunately it looks like sp1 and on have broken these ...
0
votes
0answers
142 views
Connecting BDC/BCS Web Parts in Deployed Site Pages Module (Visual Studio)
I need to create a deployable site page that uses various BDC Web Parts to display information from a external content type. The web part must retrieve the query value from a QueryString Filter web ...
0
votes
0answers
326 views
BCS custom connector and incremental crawl with search server express not working
we are currently developing a generic connector framework to access JSON-resources from an HTTP-Server. As the connector should not depend on a data model it heavily relies on DynamicType. As there ...
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
1answer
1k views
Error with External Content Type List: “Unable to display this web part”
I have deployed an external content type to my local Sharepoint 2010 Server using a Visual Studio solution. The deployment appears to work. I can view the details of the content part in the central ...
0
votes
0answers
189 views
In Sharepoint 2010 BCS, how do I save a column of type DateTime that allows Null values?
I'm developing a Sharepoint 2010 BCS using Visual Studio 2010. One of my requirements for this particular ECT is that it have a datetime column that's not a required field. The column in the database ...
0
votes
0answers
58 views
How to use Stored Proc with no parameters with BCS
I want to use BCS to show some tables from Sql server to BCS.
The DBA has provided some stored proc with no parameters so its just s sql select that returns some data.
But when i try to configure the ...
0
votes
0answers
140 views
Sharepoint 2010 Fast Search Blobs listing from external database
I am working on a search engine to crawl documents from a Database. The blobs are stored as BytesArray into SQL server 2008 R2. The files types are PDF, Doc and Docx mainly. I have to do that with ...
0
votes
0answers
317 views
There are no addresses available for this application. Business Data Connectivity
I can't get the new Business data Connectivity Service i've just created to work.
It says that it started, and i proceed to an iisreset as said in a lot of blogs, but it still doesn't work.
Do you ...
0
votes
1answer
474 views
BCS issue: CalculatePermissionsForCurrentThread
I have a BCS model which is causing problems in the production environment. Everything works fine from within SharePoint context, but outside the context (a WCF service to be precise) I'm getting ...
0
votes
1answer
577 views
External Content Type and Entity Framework
I have been struggling with this project for about two weeks now. I have successfully created an External Content Type using Visual Studio and have deployed it. I was also able to use the SharePoint ...
0
votes
1answer
311 views
bind item id to custom webpart in dispform.aspx
I've created a custom webpart that shows me some details of a dossier. I've added a DossierID property like this:
public Guid DossierId { get; set; }
This identifies the dossier from which I want ...
0
votes
3answers
318 views
SpecificFinder not called on Sharepoint 2010 BCS
I have an external content type for which I created a BDC model with a LobSystem of type dot.NET assembly. I have a SpecificFinder and a Finder method defined. I also have an external list created on ...
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, ...
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 ...
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) ...
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 ...
