Business Connectivity Services
0
votes
0answers
20 views
Cannot modify BCS Model Security Validation Exception
I am trying to programmatically modify a ECT/Entity based on REST data from another system. It works if I am running it from a console application but if I am trying to run it from for example a ...
0
votes
0answers
16 views
BCS: Edit button in context menu works, but edit button in display form is disabled
I created an external content type für a MS SQL Server view. I created a list from it and three different views and I changed the form with InfoPath. All of this done without VS, only SharePoint ...
1
vote
2answers
95 views
Access denied by Business Data Connectivity on Setting Metadata Store Permissions
When I try to configure Metadata Store Permissions I keep getting this error
I am the Farm Administrator and have full access on Sharepoint to start with.
Now as I drilled down further looking at ...
0
votes
0answers
24 views
Use Custom rendering Template with External List
Does anyone Know if its poossible to use a custom RenderingTemplate with an External List?
In my Schema.XML I have
<Forms>
<Form Type="DisplayForm" Url="DispForm.aspx" ...
0
votes
0answers
26 views
BCS: multiple input parameters for delete operation in ECT possible? How to pass them? SharePoint 2013
I'm currently designing an external content type that should be able to view a list, an item, insert and delete items. The first three work without problems, but I still can't get the delete operation ...
1
vote
0answers
19 views
BCS entity code update
I have a problem with the develop with BCS and the Search in SharePoint 2013... I develop an entity that connect with UCM documents and it incorporates in search service (crawling, indexing, etc)
The ...
4
votes
3answers
60 views
CAML query on external list: access denied by business connectivity services
I am trying to run a CAML query on a BCS list and getting access denied as an error when debugging the code:
SPList CMList = web.Lists[Constants.cmlist];
SPQuery query = new SPQuery();
query.Query = ...
0
votes
0answers
44 views
Get Items from External List using BdcIdentity on server
I added a ribbon Action on an external list. When the users clicks the Button in the ribbon I use SP.ListOperation.Selection.getSelectedItems() to get the ids and of thr items the user selected.
...
4
votes
2answers
99 views
Updating Active Directory User Information from Sharepoint User Profiles BCS Data
I am investigating the possibility of updating Active Directory user account information from Sharepoint 2010 User Profiles.
I am aware that there is functionality to synchronise data from the User ...
0
votes
0answers
22 views
BCS: external data from SQL Server - Image column not showing
I created an external content type based on a view in the external SQL Server database with SharePoint Designer. So far it worked fine, but when I create a list of this ECT there are two columns ...
0
votes
1answer
81 views
SharePoint 2013 Result Sources - Combining BCS Content Source with SP Content Source - Only See SP Content Source
Scenario:
Content Source 1: Standard SharePoint Local Sites
Content Source 2: BCS Application
Seek to create 1 Unified Search Result from a Common Result Source..
I have been trying to combine a ...
0
votes
1answer
15 views
Cascading External Data in Sharepoint 2010
I have a list called "Jobs" that have two columns (Type External Data) called "Company" and "Project". When the user selects a Company, I need the field "Project" filter projects in accordance with ...
0
votes
0answers
16 views
Business Connectivity Service set permission on entry level
I am not sure if it is possible or not. I Need a way to set permissions on entry Level. that means that I am retrieving data from a REST Service but every single user has different permissions on ...
0
votes
0answers
14 views
SP 2010 - BCS - Displaying SP List with additional columns autopopulated from External List
I want to know if the following is possible.
I have an SP list called 'Orders'. The Fields are 'Number', 'Quantity','Amount', etc.
I have an External List from a SQL DB called 'ExtOrders' - Fields = ...
1
vote
1answer
31 views
Sharing list data between sites
I have a list on a sub-site that I want to share via Drop Down List with a Calendar on the root site. ie. When you add or modify a Calendar entry, one of the columns will be a Drop Down List ...
0
votes
1answer
22 views
Using External Content Type Pickers with Boolean fields
I have a SQL table with three fields - a unique ID I don't care about, a description, and a Boolean indicating whether or not the record is 'current'. This table is setup as a fairly standard ...
1
vote
0answers
36 views
Item-level security possible with OData external content type?
I've created an External Content Type which uses an OData service as it source, and I created a content source in the Search Service Application in order to crawl this data.
This works fine.
However, ...
0
votes
0answers
14 views
how to use association when creating a new item using BCS Object Model and OData
I have an odata service that exposes two collections: customer and orders.
So I have this example: http://spabcd.net/customer('1')/Orders
How can I create a new customer and associate new orders to ...
1
vote
1answer
109 views
SharePoint 2010 - Create related hierarchical fields from external source
Is there a way to create two related columns as a custom field type in SharePoint? For example, can you develop a custom field type named CustomerOrder that consists of two related lookup columns ...
0
votes
0answers
25 views
Dynamically create BDC Data Model based on delivered Meta information via REST
I have the Problem that I have a REST Service which delivers the data I Need to work with in SharePoint but the System I am retrieving the data from might get additional parametes/fields over the time ...
0
votes
1answer
115 views
How to connect multiple external tables into one SharePoint list to perform CRUD operations
I am working with SharePoint 2013 and I have a requirement where I have to perform CRUD operations on multiple external tables (SQL Server) with SharePoint in one List and vice versa. I am able to ...
0
votes
0answers
30 views
BCS code - The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel
I am using a Console Application to connect to an Enternal Source (BCS) which is secure.
How can I pass my credentials to my code below so that I don't get the error above?
// Specify the SiteURL, ...
2
votes
0answers
53 views
Ribbon is disabled when I Filter an external list in SharePoint 2010
I created an external list in sharepoint 2010 (SP1) using SPD. The backend is sql server. The I added a wildcard filter on a column called Source_System (and a limit filter).
The out of the box ...
2
votes
1answer
101 views
Deleted item still showing up in search results if only doing Incremental Crawls
I'm trying to set up a Sharepoint search service using a Content Source based on an external BCS data source.
In the BDC model, I implemented the operations I needed, adding a SpecificFinder, an ...
3
votes
2answers
159 views
Does all external SharePoint data have to flow through BCS?
I was asked the question why I need access to BCS Services and have been tasked with documenting "ways to access external data in SharePoint'
I've read one article after the next regarding external ...
0
votes
0answers
26 views
Custom connector for BCS search - SP 2010
I have some doubt on when to create a custom BCS connector for searching LOB data?
By default BCs provides way to search on LOB database like Adventureworks in the given image. But when do we need ...
0
votes
0answers
18 views
Custom search option through BCS Metaman
Can any one of you help me on this?
If we implement BCS through BCS Metaman tool will we be able to search LOB oracle data through our SharePoint 2010 Enterprise search template?
Or even after using ...
0
votes
1answer
69 views
InfoPath changes the look of the form
I am following this guide to create a cross site lookup field in SharePoint. I am using SharePoint 2013. The problem is that when I open the form with InfoPath Designer 2013 the form doesn't resemble ...
0
votes
0answers
169 views
Using Business Connectivity Service to connect SharePoint 2013 to an external WCF service
Has anyone successfully connected BCS in SharePoint 2013 to an WCF service?
I did several attempts and always got
Cannot connect to Business Data Connectivity Metadata Store
in the SharePoint ...
1
vote
1answer
38 views
Search in Custom indexing connector with AttachmentAssociator property in AssociationNavigator
I have a custom indexing connector with Entities associated via AssociationNavigator method. In order for Search (of SharePoint 2013) to crawl the associated entity, we need to set either the ...
1
vote
0answers
58 views
Using InfoPath inBrowser forms, create reports from captured data, and present those reports back in SharePoint
I'm using SharePoint 2010 and I have access to InfoPath and BCS services.
I’m looking to use InfoPath forms that are accessed IN-BROWSER through SharePoint to capture data, and use that data to ...
0
votes
0answers
60 views
How to filter a paged and sorted external list
I have succesfully implented an external content type with a read list method, which can sort and page through the external data.
The external content type has 4 filters (two limit and two wildcard) ...
0
votes
0answers
75 views
External Content Type in a Site Column results in ArgumentNullException for wildcardedNamespace
I created an external content type, which seems to work fine. I created a list to browse the external content type, and I can see the elements coming from my sql server. I can also use the create and ...
3
votes
1answer
174 views
SharePoint 2013 Custom BCS/BDC Entity Search Refiner
I have a custom BCS model that I am using to index SQL data in SharePoint 2013. The localized name of the type of item is being set as the title (i.e. Answer, Question, Idea, etc.). In the search ...
0
votes
0answers
80 views
BCS DateTime Format to Date Format Conversion in Display From
Version: sharepoint Online 365
I am having Date Field in DB . While i am retrieving in BCS Its showing as Datetime Format.
How can trim Time Value. I need to display in Date Format only .
...
0
votes
0answers
14 views
2010 BCS contains metadata for an invalid Data Source for a ECT
I have been asked to look at getting search to work on an External Content Type. Taking a look at the ECT in designer I see that the previously defined datasource which is stored in BCS is invalid in ...
2
votes
1answer
116 views
Context Aware BCS Model for Search Crawling in SharePoint 2013
I have an external SQL data source that I would like to include in SharePoint search crawling with a BCS/BDC model. As it stands, SharePoint sees this data independently of the SharePoint site ...
0
votes
0answers
23 views
BCS field seen in model but not in item profile page - SP2013
I've added a column to my source SQL table, updated the model so that I CAN the new (URL - string type) field in the model (both in SP designer 2013 & BCS application), profile page for displaying ...
2
votes
2answers
129 views
Connect SAP data from SharePoint 2010
If we want to create a custom connector to connect SAP data from SharePoint 2010 ... how to do that? what steps are involved?
0
votes
0answers
120 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 ...
0
votes
0answers
83 views
BDC model to connect oracle data in SharePoint 2010
Need to connect to oracle through BDC model - we can do this by either BDC model created through Visual studio or through BCS Meta man?
performance wise which one will be better? BDC model created ...
0
votes
3answers
50 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 ...
2
votes
0answers
72 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 ...
1
vote
1answer
93 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 ...
0
votes
1answer
115 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
233 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
19 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 ...
3
votes
3answers
343 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
63 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
156 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 ...