A variation of a content type that stores content outside of SharePoint.
0
votes
1answer
24 views
Insert External List to 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 ...
0
votes
0answers
9 views
ECT always disappear in ECT Picker
Sometimes ECT lists disappear. It says
External Content Types are not available. Contact your system
administrator.
I have to change the App Pool for BDC and then return the previous App Pool ...
1
vote
2answers
19 views
External “Asset Library”
Any idea if SharePoint has an extensibility point to add an external DAM store as a normal Asset source for images or other media files?
0
votes
1answer
25 views
Sharepoint Designer crashing when trying to add new External Content Type
Sharepoint Designer is crashing when trying to add new External Content Type with below error message:
Description:
Stopped working
Problem signature:
Problem Event Name: CLR20r3
Problem ...
0
votes
1answer
36 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
75 views
SharePoint 2010 - Business Data List - Apply Multiple Values to a Single Column Filter
I am working in SharePoint 2010. I have a stored procedure that I've attached to through an External Content Type. I've created a Web Part page with a Business Data List web part and have ...
0
votes
1answer
32 views
Search External Content type not returning all records
I have a sql view that returns 449 records.
I have setup my external content type to point to this view and have implemented via SPD the read item and read list operations.
I have created the ...
0
votes
0answers
45 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
0answers
34 views
Add Connection is empty-External Content Type
When I click on Add Connection the drop down list comes empty. What should I do? Why can't I see the drop down list?
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
0answers
91 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
160 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
71 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
35 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, ...
2
votes
2answers
83 views
Game On - DVWP in the Ribbon
I have a 2010 Enterprise Farm, and I am attempting to place a Data View Web Part in the Ribbon to display content from an external SQL database as part of a gamification initiative. Basically, I need ...
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
143 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
49 views
Filtering datas
I want to filter datas.
I have a data view with 3 column (name,department,foreign languages)by a SOAP Connection but I can't make any filtering for foreign languages.
I have a html form web part ...
0
votes
1answer
45 views
Data source element is of data type x, the mapped item is of data type y (Sharepoint designer)
I have built an external content type based on a database table. Originally, a certain column was of type int, but recently it has been changed to decimal. Now I get an error in the ReadList and ...
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
1answer
181 views
Changelog-based Incremental Crawl of an External Content Type (ECT)
I'm trying to add incremental crawling to an External Content Type that we have defined, but I don't want to use the item time-stamp option, which seems to be so prevalent(see: link). I have a .Net ...
3
votes
0answers
62 views
Problems with External List and Creating New Item with Webservice
can anybody verify that inserting new Items through SharePoint Webservice Method Lists.UpdateListItems is errornous?
I always get the Error:
0x80070057Bad parameter passed to Web Server ...
1
vote
2answers
323 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.
...
0
votes
1answer
154 views
403 Error connecting to ODATA via External Content Type with SharePoint
I have a tenant on SharePoint Online (the new 2013 version). In that tenant, I have a Project Online site collection. Project Online hosts a very nice OData endpoint at ...
2
votes
1answer
455 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 ...
1
vote
1answer
138 views
BDC Model for ActiveDirectory
I am trying to build a BDC Model and a custom .net connector for ActiveDirectory so that users can search for data in AD from Sharepoint as well as create lists (ie: Users list that will show users ...
0
votes
1answer
400 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
1answer
74 views
External List not returning values
I have an external list which isn't returning any values.
The list uses an external content type, which gets information from a SOAP service.
After creating the content type using a read item and ...
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
122 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 ...
1
vote
1answer
135 views
Is it possible to map External Content Type to Office Item Type without using SharePoint Designer?
I need to connect Outlook to the External list and have to map its content type to the Office Item Type for that, but unfortunately I can't see it in SPD2013. Possibly it is because BDC model uses ...
0
votes
1answer
254 views
External content type based on OData is invisible in SPD2013 (but visible in a web browser)
I am trying to connect external list based on OData to Outlook, I could create it, but can't map its fields to Office Item type because it is invisible in SPD2013.
I made screenshots of all the steps ...
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 ...
1
vote
0answers
26 views
What CMIS services are required if Fast Search is used to query an external CMIS repository
For a repository to be CMIS compliant, it must implement a number of services. Query services are not mandatory. I want to incorporate a CMIS repository in SharePoint 2010 as an External Content Type. ...
1
vote
2answers
71 views
How can i retreive data from Web Server to my Intranet SP site
Would you please let us know the steps to connect a external Web Service that has specific attribute (GetAttributeProductsByID , GetAttributeProductsByName ... etc ) with an Intranet Sharepoint site
...
0
votes
0answers
38 views
Unable to select External Content Type for new Synchronization
I have created a new ECT in SPD, but when i try to add a new synchronization connection in Central Admin, the ECT picker does not display my new type. It shows several others, but not the one i need. ...
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
155 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
189 views
Business Data Connectivity Service: There are currently no external content types
I have created an external content type in VS2010 and successfully deployed it on my site Collection. Now, in my SP site, i created external list and configure it with my external content type (the ...
0
votes
1answer
203 views
How to create a dynamic external content type (the DB tables can change)
I want to create an external content type based on SQL Server tables. My external content is a list of Cats and its source is a database table also named Cats.
However, I have a different Cats table ...
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 ...
1
vote
1answer
168 views
Send current user's parameter to External Content Type
Is it possible to send the current user's username as a parameter for my External Content Type query? I am on SharePoint 2010 Standard.
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
757 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
389 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
446 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 ...
