A variation of a content type that stores content outside of SharePoint.
0
votes
2answers
27 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 ...
0
votes
0answers
3 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. ...
2
votes
2answers
633 views
DropDownList to display External Content Type?
I am creating a visual web part in Visual Studio 2010 for SharePoint 2010 Server. I would like to use a DropDownList that shows data from an external content type (that is tied to a SQL Database ...
0
votes
1answer
430 views
Declarative (CAML) BusinessData field
I am trying to create a List template definition declaratively (using CAML) which includes a External Data column and several secondary columns.
I created a custom list via the UI and exported the ...
3
votes
1answer
381 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
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 ...
0
votes
1answer
319 views
How to create new External Content Type on SharePoint Designer
I'm trying to create a new External Content Type on Sharepint Designer , but where I try to insert the web services wisdom into the "New Connection -> WCF Connection " I get the following error:
...
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 ...
1
vote
2answers
397 views
BDC external type with dropdown data entry
I would like to be able to have a BDC entity setup such that when you create a list from the external content type the new item form automatically comes setup with a lookup field for one of the ...
3
votes
1answer
399 views
How do I access an SQL image column using an External Content Type list?
I have a External Content Type (list) which pulls the data from an SQL Server. The image field in SQL can be stored in binary format or just the image path is stored (currently I am storing the path ...
0
votes
1answer
38 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
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?
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 ...
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 ...
1
vote
2answers
1k views
How to create an external List on SharePoint 2010 using MySQL table
I have a MYSQL database that contains customer related data from sugarcrm while a few order related data is stored in the MSSQL server.
So far, I have been able to create an external list for the ...
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
496 views
drop down list for an external list
If a guy were to want to allow a user to change data in an external list (based on an ECT of a SQL Server Table), and he had a particular field in that list (say a status field) that only needs to be ...
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
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 ...
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 ...
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
92 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
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 ...
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 ...
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
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
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 ...
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 ...
1
vote
1answer
775 views
External wcf (Soap/rest) datasource to external content type
I'm looking for a way to use an external datasource (WCF SOAP or REST) and include the results in a list. Using the External Content Type directly for a WCF service does not work, as I get a XML error ...
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
99 views
Could not find IEntity
I have a SharePoint 2010 site collection, which is mainly used to create projects. These projects can contain different phases, which becomes a new subsite when a new project is created. The phases ...
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
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
5k views
[SharePoint Designer 2010] Connecting to an external data source
I'm using SPD 2010 to connect to an external SQL database hosted on a different server. External data source type selection is SQL Server. I then filled up the connection properties , choose "Connect ...
1
vote
1answer
2k views
Why won't the “New Item Form” create for an external list?
I'm using SharePoint Foundation 2010 and I have an external list created from an external content type. The external content type uses a WCF service as datasource.
The WCF service has only three ...
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 ...
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.
1
vote
2answers
324 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.
...
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 ...
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
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 ...
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
402 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
123 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 ...
2
votes
0answers
399 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 ...
