Business Connectivity Services
2
votes
0answers
98 views
BCS and External List: Validations and Business Logic
I have been able to define an External List through a WCF Service. This works well, but I am now moving onto more advanced scenarios - I would like my Create, Update and Delete methods to implement ...
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 ...
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 ...
1
vote
0answers
50 views
COM BCS model programmatic creation methods
Following the source code found here: http://code.msdn.microsoft.com/office/Creating-SharePoint-2010-ad694d17
I've managed to create the Create, Update and Delete method, but only the Delete ...
1
vote
0answers
78 views
BCS connection with SQL DB and Sharepoint list passing parameters
Is there way to pass parameters to BCS connection between sharepoint list and sql table and populate the list with the sql table data which agrees to a certain scenario(according to the passed ...
1
vote
0answers
125 views
Can't get Custom BCS Connector with filters to work
I am trying to create a BCS connector in Visual Studio that connects to a WCF service.
I first used an parameterless GetAccounts method as the source for the ReadList method, and the wanted to add ...
1
vote
0answers
252 views
LastModifiedTimeStampField not working in incremental crawl (SharePoint 2010 + BCS + FS4SP)
I'm using a custom BCS .Net Assembly connector with my BDC model but can't seem to get the Incremental Crawl working correctly. It keeps doing a Full crawl, or at least it seems that way because the ...
1
vote
0answers
85 views
Searching CRM 2011 records in Sharepoint 2010
I need to search Microsoft Dynamics CRM 2011 (onpremise or online) records in SharePoint 2010 (onpremise and preferably foundation but can go to enterprise if it is a must).
I want to know from ...
1
vote
0answers
123 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
0answers
217 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
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
295 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
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
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)
{
...
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
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
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
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 ...
0
votes
0answers
16 views
Which approach I should follow; SharePoint business connectivity services OR developing SharePoint App
I have developed a document management system and an enterprise wiki library for our company using SP2013. The second project I am going to start is to develop an asset management system for our ...
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 ...
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
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
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
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
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
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
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
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
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
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
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
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
0answers
301 views
Why isn't BCS populating a multi-value field?
Anyone know why BCS won't populate a multi-value field? I tried everything and still can't get it to work in the user profile.
I went through the log(s) and did not see anything unusual. I opened the ...
0
votes
0answers
131 views
Enterprise - External Task List - Connect to Outlook- setting Assigned To
I've got an External List coming from an External Content Type which has Office Item Type of "Task". It comes from an external system which has its own concept of a task, and I'm pulling them into ...
