Business Connectivity Services
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 ...
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
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 ...
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
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
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
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 ...
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. ...
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 ...
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
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 ...
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
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 ...
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 ...
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
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
1answer
168 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
1answer
157 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 ...
0
votes
1answer
216 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 ...
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 ...
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
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?
