Business Connectivity Services
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
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 ...
1
vote
3answers
112 views
What is BCS and what can it do for me?
I've been hearing a lot about it but even having Googled the subject I'm not sure what it is or what it can do for me. I believe BDC's could be considered a BCS component? What is BCS?
1
vote
1answer
389 views
BCS External Item picker
There are two external lists like 'Project' and 'Task'. Task referencing project by using field ProjectID. I've created external content types. For 'Project' content type I've marked field ...
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
4answers
1k 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 ...
1
vote
2answers
575 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
vote
1answer
34 views
Read/Write capability in BCS
Can someone tell me what exactly does "Read/Write Capability" means in Business Connectivity Services for SharePoint 2010?
I read it somewhere that this is a new feature in 2010 which was not present ...
1
vote
1answer
655 views
How to call Finder Method with Parameters using BCS Runtime Model
Hi i have created BCS model which use secure store service for authentication to External system.Everything works fine using out of box external list and BCS webparts but i want to create custom ...
1
vote
1answer
637 views
Connect ECT to SharePoint List in InfoPath?
I'm trying to create a list in Infopath 2010. I'd like one of the fields to be a drop down list that connects to an external content type list. It doesn't show any of the External Content Type Lists ...
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
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 ...
1
vote
1answer
45 views
Error while creating a new customer via BCS from within a web part
This is my first time that I am using BCS via a web part and in general.
this is my code and I am getting the following error:
The given dot notation 'CustomerID' refers to a node in Type Descriptor ...
1
vote
1answer
21 views
Limiting a view based on authentication by writing qualified username
This article http://www.thesharepointbar.com/?p=340 how to limit a read on a user in BCS, but we can't find the correct syntax for fba-users. (MS Quote: If the login mode for the user is claims-based, ...
1
vote
1answer
145 views
Can you use BCS External Content Types in conjunction with Product Catalogs in 2013?
Does anybody know if it is possible to use an External Content Type as the basis for a Product Catalog in SharePoint 2013? So if we store a load of Product data in a database are we then able to ...
1
vote
1answer
74 views
External List not returning values
I have an external list which isn't returning any values.
The list uses an external content type, which gets information from a SOAP service.
After creating the content type using a read item and ...
1
vote
1answer
751 views
User profile properties mapped to a BCS connection requires two syncs for new users
I have the User Profile Service Application up and running in a SharePoint 2010 farm. It is configured with two synchronization connections; one to Active Directory and a second to a backend database ...
1
vote
2answers
322 views
Deploy BCS profile page without SPD
Is it possible to deploy a BCS profile page via a WSP? Did anyone try this including settting the default action on the external content type?
All references I can find explain how to create a ...
1
vote
2answers
144 views
BCS Date Only field on Update Form
I'm tasked with finding a method for Updating a field that is defined as Date in SQL, but rendered as DateTime through BCS (as there is no Date-only type). On the Update form, I only want a Date ...
1
vote
1answer
684 views
How To Define Specific ReadItem Finder with List View in External List?
I have an external list which is using the BCS to pull data from a custom database. This database has several views which have the same column structure and several that do not. I have been adding ...
1
vote
1answer
126 views
Do not load data in design mode of webpart
I have custom webpart which gets data from external database using BCS. When I add the webpart in a webpart zone, it queries the BDC to get data so it take time to insert webpart. I only want to query ...
1
vote
1answer
480 views
External list Reading items very slow
I am trying to retrieve all the columns from External list from sharepoint 2010. Em using the below code
SPListItemCollection collection = list.GetItems(query);
foreach (SPField field in ...
1
vote
1answer
318 views
How to display a list across multiple sites?
I want to be able to create a customized list, "Test", on my main page, "Home" of SharePoint.
I want to be able to link to that custom list, "Test", onto another site in the same collection, ...
1
vote
1answer
714 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, ...
1
vote
1answer
301 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
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
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
3answers
570 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
839 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
379 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 ...
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
2answers
918 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
2answers
204 views
BCS Security Access Using Secure Store in code question
I have Secure Store and also Kerberos setup on my development and production farms. I am using Event Receivers to access BCS data. I have verified that if I simply impersonate a user that has access ...
1
vote
3answers
713 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() {
...
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.
...
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:
...
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
142 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 ...
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 ...
1
vote
1answer
736 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 ...
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
1answer
213 views
Event fire and Workflow Attach to External List?
What is the best way approach to attach workflow and Event Receiver on External List?
How to store Directly External Data to SharePoint Custom List?List
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
1answer
86 views
StreamAccessors >> Can SharePoint 2010 BCS return multiple attachments?
Can SharePoint 2010 BCS return multiple attachments? I have a database which stores multiple attachments per entity. Would like to have all of them accessible, but I've insufficient experience with ...
1
vote
1answer
358 views
SharePoint BCS with SOAP web service using custom authentication
I'm very new to using BCS in SharePoint 2010. I'm not really sure how to go about my problem or if it's even possible without coding a custom solution in Visual Studio using .NET.
I have a SOAP web ...
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
2answers
331 views
How to connect Outlook to an external list, which uses external connector in DLL
The task: connect Outlook with the external list, which was created in Visual Studio and uses SAP connector (sapnco.dll).
What I've done:
Created this external list. I can see all information in ...
1
vote
1answer
231 views
How to Set Input Filter Programmaticlly in BCS
I have a Method in Entity which takes 2 input filters. Now I want to set a value in this filter. How can I do that? I already got the collection of Filters using the GetFilters() method of the ...
