An external list is a list published outside of the scope of SharePoint usually with the tool Business Connectivity Services (BCS).
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 ...
1
vote
0answers
16 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 ...
0
votes
1answer
297 views
How to have integer fields in an external list display without thousands separators on the display form?
I am using the Business Connectivity Services in SharePoint 2010 to display the content of a database table in an External List on my site.
One of the fields in the database table is of int type and ...
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 ...
1
vote
2answers
376 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 ...
0
votes
1answer
35 views
Lookup Data from External List
I have a list - Companies - that is an External List based on an External Content Type from SQL Server. I have another list - Purchase Orders - that has a lookup column to the Companies table.
I am ...
0
votes
2answers
43 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
2answers
94 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
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 ...
0
votes
0answers
43 views
Custom InfoPath edit form for external list with two fields referencing same foreign identifier
I have a scenario simmilar to this:
SQL Server tables
Partner
- ID (primary key)
- Name
Project
- ID (primary key)
- Name
- TechnicalPartnerID (foreign key to Partner)
- BusinessPartnerID (foreign ...
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
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
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 ...
0
votes
1answer
48 views
External Content Type not found in Business Data List picker
I have just created several ECTs along with lists to go with them and they work fine. Just my luck im on the final one and im stuck.
Here's what I've done...
1. Created ECT and List
2. Given the ...
0
votes
3answers
51 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 ...
1
vote
0answers
43 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 ...
0
votes
0answers
85 views
Forcing filter value of an external item picker on an InfoPath form
Question:
Is there a way to force the filter value on an InfoPath form's external item picker?
I don't want to modify the underlying ECTs to do this, because I hope to reuse the ECTs for different ...
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 ...
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
33 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, ...
0
votes
2answers
53 views
Filters get removed from external list when document is deleted from XsltListViewWebPart on same webpage
I have a webpage on Sharepoint 2010 that has:
1) An external list
2) A webpart that has XsltListViewWebPart referring to a document library
When a filter is applied to External list, it filters out ...
0
votes
0answers
25 views
Bulk-Edit in external lists (Sharepoint 2010)
I try to provide bulk editing for external lists.
I heard that the datasheet view is a convenient tool, but it is not enabled for external lists. Is there any way to get an easy, user-friendly bulk ...
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
197 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
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
145 views
Display an External List in a DataView webpart
My scenario is as follows:
I have a dataview wp which currently displays list items (from ECT).
In the DataView wp I filter the data according to a parameter passed in from another wp.
The current ...
0
votes
2answers
142 views
update external list data using infopath codebehind
I know that I can update my ECT record (using InfoPath forms I created for the external lists), by passing the BdcIdentity (ID) to the form and it will find that record and enable me to edit.
How do ...
0
votes
1answer
21 views
need support/materials for developing external lists with visual studio 2010
Up to now, I have mostly used Sharepoint designer to develop external content types and lists.
Due to the lack of source control and for other reasons, we would like to move the development process ...
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" ...
2
votes
1answer
215 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 ...
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
2answers
71 views
How do I retrieve associations items for list field using JavaScript
I have any ExternalContentTypes(ECT) with associations between them. One ECT is shown in an external list. I want to add a custom button on that external list ribbon. And it must change value ...
0
votes
1answer
128 views
How i can get “item ID” column through “BDC Identity” column
I create external list for display external items from my wcf service and add custom action on that list EditForm through ClientObjectModel with this url:
...
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 ...
0
votes
0answers
54 views
Run custom javascript when external list table loaded
Is there any way to run custom javascript after table with external custom list is loaded on page? The external list table is loaded on page with some delay and I would like to modify its content ...
1
vote
2answers
257 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, ...
0
votes
0answers
32 views
Delete selected item (which may be null) in external item picker
I have an external list with an edit form that uses an external item picker for foreign key values. The value may be null in the data source, which is also represented in the list. But if I select an ...
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
0answers
34 views
Can't read by loop foreach Externall List
If I tried to view in Element one of three External List I geting this error:
Unable to display this Web part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint ...
0
votes
0answers
70 views
Reading a data from External Lists
I have got a problem to read data from External List. I getting this error while I reading a External Lists:
Exception Details: System.Xml.XmlException: Name cannot begin with the '-' character, ...
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
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..
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
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 ...
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 ...
0
votes
1answer
397 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
121 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 ...
