Business Connectivity Services
0
votes
0answers
24 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
2answers
12 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 ...
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 ...
2
votes
1answer
45 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 ...
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
56 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
47 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 ...
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 ...
0
votes
2answers
83 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 ...
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
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 ...
0
votes
1answer
92 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
60 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
76 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 ...
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
214 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
1answer
147 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 ...
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
171 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
157 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 ...
2
votes
1answer
457 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 ...
0
votes
1answer
414 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 ...
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
3answers
113 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
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 ...
1
vote
0answers
81 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 ...
0
votes
1answer
169 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
680 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
217 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
117 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
44 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 ...
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
359 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
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 ...
1
vote
1answer
753 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 ...
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
158 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 ...
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 ...
0
votes
0answers
190 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 ...
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
1answer
390 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 ...
0
votes
2answers
453 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 ...
