An external list is a list published outside of the scope of SharePoint usually with the tool Business Connectivity Services (BCS).
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 ...
5
votes
3answers
752 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. ...
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 ...
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 ...
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
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 ...
2
votes
1answer
451 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 ...
2
votes
3answers
951 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
1answer
216 views
Custom forms for external lists guidance
I need guidance/suggestions developing an app which will be hosted in SharePoint using external content types. So far I have a BDC model which works fine for reading the data und displaying it in an ...
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 ...
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 ...
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
1answer
156 views
Querying an External Content Type without creating an External List
The typical scenario, on which every tutorial and walkthrough seems to advise, is to create an External Content Type with ReadList, ReadItem, Create, Update methods and then create an External List to ...
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 ...
1
vote
2answers
57 views
SharePoint 2010 - To use content database or not to use
SP newbie here. I need to build a SharePoint 2010 application to track customer support cases. This will be the first time we've used SP, and I can set it up how I please.
The built-in template for ...
1
vote
2answers
244 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?
1
vote
1answer
128 views
Customizing external list form
I need to create external list and i need customize display and edit forms.
I want add something like tabs, i.e. i want to input some fields in one tabs, and some in another. I must use ClientObject ...
1
vote
2answers
320 views
Use the same InfoPath form for inserts and updates
I am using an InfoPath form to add records to a database table. I do this by creating an External Content Type in Sharepoint Designer. Then from the content type I create an External Sharepoint List.
...
1
vote
2answers
95 views
External lists do not display data though data are available
I have external lists connected to a sql server database. Since the last day, some of the lists do not display data; the lists are empty, only headers are shown. (Some lists still display data, ...
1
vote
2answers
426 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 ...
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:
...
1
vote
0answers
17 views
Custom List Form works fine in Infopath but gets stuck when deployed
I have a custom list form for whenever I add a new item to a custom list. This form connects to an external sharepoint list that has 3000 records.
When you type a client ID it will connect to the ...
1
vote
1answer
62 views
Copy data from external List Item to New Form
I have an external list that I want to add action to copy list item to NewForm.
or any othwer way to take data from external list item to a new form. From display form, edit form any way will be ...
1
vote
0answers
22 views
External lists: Field GUIDs always empty?
I want to turn an external list into a DataTable using the ID/GUID values of external list's Fields as the DataTable column names; however, I've noticed for the external list I'm using, all of the ...
1
vote
0answers
44 views
How to set selected value of external item picker
I have developed a custom edit form with an external item picker as application page in visual studio. The picker is populated with data using the following method.
private ItemPickerExtendedData ...
1
vote
0answers
26 views
How do I change SQL connection from one server to another on an an External list
I have an external list that points to SQL Server A. Server A is being de-commission and the database is moving to SQL Server B. I need to change my connection for my lists.
I created a new ...
1
vote
1answer
69 views
Hide some fields from EditForm
I have some troubles with EditForm in Sharepoint.
In SPD 2010 i have created External Type and defined CRUD method for him. I want to show in Disp form all item fields, but in Create and Edit form ...
1
vote
0answers
133 views
user lookup field for external lists
Guys please don't beat me too much, I want to add user lookup field into my external content type to use sharepoint people picker in my external list, the price doesn't stand up. So is it ever ...
1
vote
1answer
199 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
34 views
Associated ECT only displays ID (not title) in external list
I have created two ECTs, let's call them country and city for clarity. I have also created an association with city as the child and country as the parent. When I create an external list for city, ...
1
vote
0answers
83 views
SPFieldUrl does not work
I have an external list, items in that list have a field that contains an url. I want to show this url as a link in sharepoint form.
I found this example
and defined in my Creator and Updater methods ...
1
vote
1answer
219 views
Custom form template with external list does not work
I have following .ascx file
<%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register TagPrefix="SharePoint" ...
1
vote
0answers
33 views
How add personal list for all users
I want to integrate Sharepoint with my external system. Sharepoint should load tasks from my system and show them in the list on user personal page. Integration should be done using Sharepoint ...
1
vote
0answers
50 views
How to get External List Item URl?
I want to get Item URL of External List. I tried using ListItem.URL but it is returning BLANK. Can anybody help me. Its Urgent..
1
vote
2answers
258 views
Show time only of datetime field in edit form of external list
I have an external list containing a datetime column called "Opening". I would like to show only the time portion of this column in all views (list, edit etc.). I know how to do this in the list view, ...
1
vote
2answers
379 views
How to Access External List Data via Code?
Any suggestions would be helpful...
I am attemting to access an external list using the Server OM. The external list is configured to use pass through credentials. The list functions perfectly in the ...
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 > ...
1
vote
0answers
353 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 ...
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 ...
0
votes
3answers
52 views
Caching expensive query to use in a Web Part
I have a Web Part that connects to a SQL server and pulls summary data for the current user. (Think "dashboard".) Unfortunately this query is expensive to run so I'd like to cache the results to ...
0
votes
2answers
265 views
Getting Large External Data set into SharePoint list
I have a list of "Customers" in a SQL database table with some very basic data:Id, Name, DoB, Mobile, Email, CusotmerType.
There are currently about 80,000 customers
I wanted to use an External ...
0
votes
1answer
376 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
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. ...
0
votes
1answer
42 views
Problem with performance of External List
In my company a person which are Administraiting the CRM Microsoft Dinamics give me one of External list with a Vacation of Workers in Company. I try first with list local in my project, and this list ...
0
votes
1answer
398 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
243 views
BDC external contet type SharePoint Designer
I have problem with Business Data Connectivity, when I try to create new external content type in SharePoint Designer - I "Add Connection" then I choose SQL Server I fill Database Server and Name and ...
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 ...
