An external list is a list published outside of the scope of SharePoint usually with the tool Business Connectivity Services (BCS).
0
votes
1answer
8 views
Add Column to External List from Updated External Content Type
We are currently trying to understand the relationship between External Content Types and External Lists within SharePoint 2013. We have a read-only ECT which we defined based on a SQL Server View. ...
0
votes
2answers
30 views
Problem showing External List in a page
I have a external content type that is showed in section of lists (Insert in Ribbon). I want to add it to a page but when is added, It shows list of BDC Identity, and when I click on them, main data ...
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 ...
0
votes
1answer
39 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
46 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
64 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
48 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
23 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
59 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 ...
0
votes
1answer
50 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
53 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
46 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
94 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
2answers
58 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
28 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
162 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
72 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
134 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
211 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
36 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
1answer
130 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
0answers
84 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
220 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" ...
0
votes
1answer
22 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 ...
2
votes
1answer
224 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 ...
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
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:
...
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 ...
0
votes
2answers
144 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
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 ...
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, ...
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 ...
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
327 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
97 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, ...
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 ...
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
404 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 ...
1
vote
2answers
262 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
1answer
101 views
Customize the InfoPath form of an External Content List
I generated an InfoPath form which OOTB gives me the ability to edit items in an External List, which in turn, updates a database table.
This form however uses the Sharepoint ribbon control to show ...
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 ...
0
votes
2answers
68 views
External list not implementing TimeSpan field
I am developing an external content type with sharepoint designer, based on a microsoft sql server table. One of the columns has the time(0) format. This is interpreted by sharepoint designer as ...
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
156 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 ...
1
vote
2answers
384 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
0answers
272 views
External Content Type using Entity Framework “'The specified named connection is either not found in the configuration etc..”
I suspect this error is because I am using the EF and the connection string is not being found. Here is the error I am seeing:
MethodInstance with Name 'ReadList' on Entity (External Content Type)
...
