Tagged Questions

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
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 ...
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
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 ...
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
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
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
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 ...
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
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
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
2answers
317 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. ...
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
99 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
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 ...
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
264 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
154 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
0answers
271 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) ...
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
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
439 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
0answers
204 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
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
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 ...
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
377 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
314 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
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 ...
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 ...
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 ...
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 ...