Business Connectivity Services
0
votes
0answers
20 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 ...
1
vote
1answer
380 views
custom paging and sorting in BCS
I'm creating a custom .Net Assembly connector. I have to show a lot of data, so I want to page and sort that.
I've already created parameters in my model for that:
StartRow
PageSize
SortField
In ...
3
votes
1answer
311 views
How to use the batching and batching termination filter descriptors in BCS .NET Connectivity solutions
I know about this post on BCS paging: Paging and sorting with BCS and have implemented a similar approach in a BCS solution. However, what I'm really looking for is a complete example showing how to ...
2
votes
3answers
539 views
SPTimer job and BCS External list
Business requirement - synchronize a table from external my sql database into SharePoint list.
What I have done.
I have an external MySql database which as LOB data. I have created a BCS ...
3
votes
1answer
381 views
Paging and sorting with BCS - Is it really possible?
I'm trying to add paging on an external list and so far it does not work 100%. The best references I could find (that actually... kinda... work) are these:
Paging and sorting with BCS
Paging and ...
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
1answer
416 views
synchronize data from external list and SPList
How do we synchronize data from an external list (BCS) into a custom SharePoint list? I have tried using a timer job, but it did not help. Any ideas?
2
votes
1answer
44 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
1answer
785 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 ...
7
votes
1answer
362 views
SharePoint 2010 User Profile Synchronization: BCS + WCF
I'm here because I'm trying to implement a scenario of user profile synchro with bcs connecting to wcf service.
Here is the context:
A remote web service is returning a full list of employee infos. ...
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
2answers
400 views
BDC external type with dropdown data entry
I would like to be able to have a BDC entity setup such that when you create a list from the external content type the new item form automatically comes setup with a lookup field for one of the ...
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
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 = ...
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
2answers
1k views
How to create an external List on SharePoint 2010 using MySQL table
I have a MYSQL database that contains customer related data from sugarcrm while a few order related data is stored in the MSSQL server.
So far, I have been able to create an external list for the ...
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 ...
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 ...
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 ...
0
votes
2answers
81 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 ...
0
votes
1answer
89 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>" +
...
1
vote
1answer
20 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, ...
0
votes
3answers
243 views
SharePoint foundation and BCS
I am testing SharePoint 2010 foundation with bcs to access one of my sql tables.
I created a list with filters on some fields (wildcard and limit types)
But unfortunately, when I display (browser) ...
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
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 ...
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
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
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 ...
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
1answer
237 views
BCSLogin failed
I got a problem when using BCS in SharePoint Foundation 2010. I'm not able to let other users see the BCS content. I tried all the possibilities I found in internet (giving permission to the users in ...
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 ...
5
votes
2answers
274 views
How to dynamically generate Business Connectivity Services
We are trying to deploy a Business Connectivity Services(BCS) Model solution where the properties in the model depend on the structure of the data exposed by a web service.
Ideally the BCS Model ...
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
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
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 ...
2
votes
1answer
456 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
411 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 ...
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 ...
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?
3
votes
2answers
2k views
Date Only format with BCS
I have created an External Content Type through SharePoint Designer. One of the fields that I'm getting from my database is a DateTime column. In SharePoint, however, I want to format this as a Date ...
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
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 ...
0
votes
3answers
670 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 ...
2
votes
2answers
592 views
Supplementing User Profile with information from BCS
I've got my external content type and BCS all sorted and working - the list view of the external list shows 100% in the site and the external content type shows under my BCS service application.
Now ...
