An external list is a list published outside of the scope of SharePoint usually with the tool Business Connectivity Services (BCS).
0
votes
1answer
34 views
Parameterized External Content Types?
Suppose I have multiple instances of some line of business app in my environment. Is there a way to create a single External Content Type that can be parametrized and reused? If I have 5 instances, is ...
5
votes
3answers
749 views
Integrating an external database into Sharepoint
One of my current projects involves integrating a client's database into an overall CRM system design.
Part of the process was updating their legacy database and porting it over to SQL Server. ...
1
vote
1answer
386 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
441 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
1answer
84 views
External List & Picking pictures from a Picture Library
I have an external data source (BDC) based on which I created an external list. The (external) entity provides a field which can store / contain the link to an image.
Now there is an Image Library ...
0
votes
1answer
375 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 ...
0
votes
1answer
82 views
External List and External ContentTypes passing persistence errors back to the user
I have created an External Content Type in my Sharepoint 2010 installation that gets its data through a WCF Service from a remote database. I have implemented all the CRUD operations without issue.
I ...
0
votes
1answer
774 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
0answers
205 views
Code lookup of values in External List returns no records
I am using SharePoint Foundation 2010
I am designing a bulk upload of files into a Document Library. The files will all have a Content Type applied to them with the values coming from a number of ...
0
votes
0answers
48 views
External Content List BDC Permission
As I understand it, if I have the authentication mode set to BDC Identity in an External List, the username of the user that is logged on to SharePoint should be the same username to check if it has ...
0
votes
0answers
28 views
Reg BCS Entity field
I have created one entity with stored procedure. I want to create a hyperlink on one of the field in external list. Please provide me the solution how can we achieve this
2
votes
0answers
97 views
BCS and External List: Validations and Business Logic
I have been able to define an External List through a WCF Service. This works well, but I am now moving onto more advanced scenarios - I would like my Create, Update and Delete methods to implement ...
1
vote
0answers
130 views
Does BCS support creating an external list from an existing list in a different web application using List Web Services
I have sharepoint 2010 farm where there are multiple web applications. I am trying to understand BCS and its capabilities. This is the structure I have :-
Web Application A > Site Collection > ...
0
votes
0answers
113 views
“Fixing” the DataSource Guid for in a DataView Webpart
I am creating a Sandbox solution that deploys three External Lists. (Their datasource has already been configured within the Farm.) Along with the list instances, I am deploying to the 'Site Pages' ...
0
votes
1answer
50 views
ECT: Agregate view, differing update and create forms
In short, I have a complex database containing documentation for IP addresses, servers, network switches and so on. This database should be manageable in SharePoint using, I think, external content ...
0
votes
1answer
1k views
Error with External Content Type List: “Unable to display this web part”
I have deployed an external content type to my local Sharepoint 2010 Server using a Visual Studio solution. The deployment appears to work. I can view the details of the content part in the central ...
2
votes
1answer
252 views
Have External Lists And / Or Event Receivers?
I am fairly new to Sharepoint. I am in the early stages of developing a SP2010 LOB app that will finally have like 50 lists which are quite interrelated with each other. I am asking for your help ...
0
votes
0answers
51 views
Workflow lookup on external list - User Ident auth mode
Is it possible to have a Workflow lookup a value from an external list while bdc is in User Indentity mode?
0
votes
0answers
194 views
External List to DataTable error “String was not recognized as a valid DateTime”
I have created a BCS List in sharepoint 2010 server. This list contains an item of DateTime datatype. I am using the following method to convert the list into a DataTable.
dt = ...
0
votes
1answer
162 views
External list in SharePoint 2010 with unique item permissions
Is there any way to set permission for bdc items within external list?
0
votes
1answer
574 views
External Content Type and Entity Framework
I have been struggling with this project for about two weeks now. I have successfully created an External Content Type using Visual Studio and have deployed it. I was also able to use the SharePoint ...
3
votes
1answer
378 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
3answers
316 views
SpecificFinder not called on Sharepoint 2010 BCS
I have an external content type for which I created a BDC model with a LobSystem of type dot.NET assembly. I have a SpecificFinder and a Finder method defined. I also have an external list created on ...
0
votes
1answer
244 views
lookup external list
I have two tables:
Documents
Project task
What I am looking for is the following:
I have a page with project tasks in a hierarchy list (done)
Clicking on a task will open an edit screen (done)
...
0
votes
1answer
354 views
Logical AND ,OR CAML Query not working in External List
I am using ClientContext Class and CAML query to retrieve items from External List in sharepoint 2010.I have built the query with Logical AND Condition in CAML Query like this
string sDataFilter ...
0
votes
2answers
1k views
How to edit InfoPath form from SharePoint Designer when it only returns an error message
I'm trying to edit an InfoPath form for an external list from SharePoint Designer. After clicking on the "Design Forms in InfoPath" button I get the following error:
"Object 'blablabla.rem' has been ...
0
votes
1answer
96 views
Connect web part to list on separate Sharepoint Instance
As part of a migration process, I'd like to have a list view on the new environment(SP2010 standard) that's connected to a list in the previous environment(WSS 3). So different servers, site ...
1
vote
0answers
352 views
PageNumber-Fillter for Finder in .Net Assembly Connector
I'm currently trying to use an PageNumber-Filter for an Finder-Method in an .NET Assembly Connector. The relevant Part of the Method-Definition of the ReadList-Method looks the following.
<Method ...
1
vote
2answers
702 views
Filter an External List on a datetime Field
So I have an external list in SharePoint 2010 that connects to a SQL database and pulls the data successfully. I also have 2 filters defined along with a limiting (TOP) filter. The first filter is ...
6
votes
4answers
2k views
Working with large external lists using BCS
I have a database that I want to display the content in SharePoint 2010. I am not displaying the content in a list but am using a custom WebPart.
The database is not updated any more as it is ...
1
vote
1answer
202 views
Association between a custom list and an external list
I have a very basic question.
I have a Custom List and I'd like to add a lookup column from an External List based on a WCF Service. Is it possible?
E.g. I have employers in a custom list. I'd ...
2
votes
0answers
397 views
Sharepoint external list problem
I'm taking my first crack at creating an External list in Sharepoint 2010. I've taken 3 training classes in Sharepoint 2010, and am now trying to transfer my knowledge to my own development ...
1
vote
2answers
425 views
External list with bulk amount of data does not work properly
I have created and external content type to fetch data from a SQL table. The table currently contains 8000 records. So when I create an external list from that content type the list does not display ...
2
votes
2answers
2k views
How to read items in a BCS external list with PowerShell?
Is there a way that you get information from an external list (created from SPD for a specific ECT) differently than you do from a "normal" SharePoint list when using PowerShell?
I did the following:
...
2
votes
3answers
949 views
How to authenticate BDC to the external system?
I'm using the following tutorial to define a workflow on a SharePoint list to create an element in and external List.
When the workflow action tries to create the item in the external list, it fails ...
2
votes
3answers
2k views
How do I associate Workflows to SharePoint 2010 External Lists?
I've read that you can't associate workflows to SharePoint 2010 external lists but that there are workarounds for doing it.
What do those workarounds involve? Can I do all of it in the Sharepoint ...
1
vote
2answers
243 views
Additional datasource in infopath
Is there any way to add additional datasources to an infopath form when using an external list? Infopath always complains about the form not being valid, because of the addinal datasource.
1
vote
1answer
1k views
Custom NewForm for external content type?
Is it possible to create a custom NewForm for an external content type without using InfoPath?
0
votes
0answers
131 views
Enterprise - External Task List - Connect to Outlook- setting Assigned To
I've got an External List coming from an External Content Type which has Office Item Type of "Task". It comes from an external system which has its own concept of a task, and I'm pulling them into ...
1
vote
1answer
468 views
Custom View Header Rendering Twice on External List
I'm starting to work with custom view stylesheets on an external list. I am finding the header is rendering twice - once upon initial page render and again after the data is returned from the server:
...
3
votes
3answers
619 views
Is it possible to programmatically invoke a workflow on external list items?
Is it possible to invoke a workflow on an external list programmatically and pass parameters into the workflow? Is there an example using SharePoint 2010?
3
votes
1answer
367 views
How can we use multiple fields from an external list in a survey?
We are trying to build a survey, that uses data from an external list.
It works fine for a single field.
But what we would like to do is to bring about 10 fields back from the external system and ...
0
votes
2answers
355 views
How can I update an external list connected to SQL?
I am working with Project Server 2010 and SQL Server 2008. I would like to create a multiple item form that connects to SQL Server.
I tried using an external list in SharePoint that connects to SQL. ...
