Questions tagged [bcs]
Microsoft Business Connectivity Services (BCS) (formerly named the Business Data Catalog) provides the capability to allow data sources outside of SharePoint to be surfaced and potentially modifiable in SharePoint's List user interface. Use this tag for questions or problems related to configuration or using BCS.
387
questions
2
votes
0
answers
344
views
Using code, how to sync data from CRM online 2011 to sharepoint online 2011 (or 2013) & vice-versa
I am trying for a proof-of-concept on this one.
I have a sample crm-online plugin and I would like to know if through the code I can open my sharepoint online site and thereby get access to the lists/...
- 247
2
votes
3
answers
3k
views
How to sync a Sharepoint 2010 list with data from a table in SQL server
I have a table in SQL server 2008 and a list in sharepoint 2010 that has a few columns from this table and a few other unrelated columns as well.
This SQL server table keeps changing and I want to ...
- 91
2
votes
0
answers
407
views
Custom BCS indexing connector with changelog inremental crawl is not working properly
Custom BCS indexing connector with changelog inremental crawl is not working properly
I am writing a custom indexing connector using changelog incremental crawl approach.
I'm using sample from http://...
- 86
1
vote
1
answer
524
views
How can I create a multi-valued refiner for a Business Data Catalog external content type?
This question regards a SharePoint 2010 instance using vanilla search.
I'm currently using a Business Data Catalog to pull records from a database table with an end-goal of displaying the records in ...
- 63
0
votes
1
answer
171
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 ...
- 771
0
votes
2
answers
1k
views
oracle data in InfoPath form
We have a InfoPath form on which wants to show real time data from Oracle database. E.g. Employee name in a drop down list in InfoPath form from employee table in oracle.
Don't want to populate ...
- 455
0
votes
0
answers
36
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 ...
- 155
4
votes
3
answers
2k
views
Custom BCS indexing connector and changelog inremental crawl: ChangedIdEnumerator method is not working
I am writing a custom indexing connector using changelog incremental crawl approach.
The full crawl is working perfectly. All atems are indexed and queryable.
The problem is that incremental crawl ...
- 86
0
votes
0
answers
744
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 ...
- 13
0
votes
2
answers
496
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 = "<Where><...
- 593
0
votes
1
answer
455
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 ...
- 1
1
vote
1
answer
739
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,905
0
votes
3
answers
2k
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 ...
- 175
1
vote
1
answer
56
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, ...
- 11
1
vote
1
answer
110
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 ...
- 3,636
0
votes
1
answer
678
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>" +
"<...
- 43
0
votes
0
answers
137
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 ...
- 766
1
vote
0
answers
129
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 ...
- 11
1
vote
1
answer
3k
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,020
1
vote
1
answer
2k
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 ...
- 831
1
vote
2
answers
3k
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 http://sampletenant....
- 1,532
2
votes
1
answer
3k
views
External List from External Content Type: missing and/or error
I've created an ECT w/ Read List and Read Item operations using SharePoint Designer, saved it, and given myself permissions. The ECT's external data source is a WCF service.
When I try to create an ...
- 487
1
vote
1
answer
2k
views
Synchronization of SharePoint 2010 List with SQL Server Table
I need to create a list such that the values on the list can be stored in SQL table as well.
I need to attach workflows to the list item as well. Its a simple workflow with two approval process ...
- 131
1
vote
1
answer
242
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
3
answers
733
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?
0
votes
1
answer
191
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 ...
1
vote
0
answers
158
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 ...
- 87
0
votes
1
answer
1k
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 ...
- 410
1
vote
3
answers
6k
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 ...
- 6,469
0
votes
2
answers
1k
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 ...
- 87
1
vote
1
answer
238
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 ...
- 87
0
votes
2
answers
1k
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 ...
- 91
0
votes
2
answers
529
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 ...
- 133
1
vote
2
answers
666
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 ...
- 2,432
1
vote
1
answer
1k
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 ...
0
votes
0
answers
91
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
http://msdn.microsoft.com/en-US/...
- 2,537
0
votes
1
answer
262
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 ...
- 1,537
3
votes
1
answer
3k
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 ...
- 3,151
1
vote
1
answer
1k
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 List"...
- 11
1
vote
0
answers
224
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 ...
- 4,665
2
votes
0
answers
689
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 ...
- 449
2
votes
0
answers
127
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 ...
- 45
1
vote
1
answer
4k
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 '...
- 379
0
votes
2
answers
2k
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 ...
- 211
1
vote
2
answers
654
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 SP.
...
- 1,449
1
vote
2
answers
848
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,978
0
votes
1
answer
2k
views
What are the BCS/External List Limitations for ECMA CSOM?
I cannot seem to find any documentation on this topic. Are there any limitations for what I can or cannot do with the JavaScript CSOM in SharePoint Server Standard 2010 External Lists as compared to ...
- 6,469
1
vote
1
answer
659
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 ...
- 199
2
votes
2
answers
327
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
2
answers
3k
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 orders,...
- 1,130