.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

BCS external item picker - automatically fill up

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :SharePoint


We use CRM and Sharepoint and would like to export all the documents from CRM and file shares to Sharepoint. 
This already works and I can add documents in to the library with custom properties.

In my sharepoint library I'm using an external data field to look for my contact ID's in CRM to link with the corresponding document.

Question now is: how can I programmatically fill up this external item picker with the correct contactID when I'm moving my documents all at once?

SPDocumentLibrary doclib = (SPDocumentLibrary

View Complete Post

More Related Resource Links

Using Additional Fields from External Content Type in InfoPath 2010 External Item Picker


Hello, we've created an external content type for our store locations. Each location in the content type has a name, id, manager, region and so on. When we use this BCS content type as a field in a list, we are given the option to "Add a column to show each of these additional fields"

What would the equivalent be in an InfoPath form? When we add an External Item Picker to a form a number of fields are included in the form's data source, including a repeating group called BDCEntity with the following fields:

  • EntityDisplayName
  • EntityInstanceReference
  • EntityId1
  • EntityId2
  • EntityId3
  • EntityId4
  • EntityId5

Entity display name appears to be what we configure as the Display Field Name in the picker properties, and the EntityId1 is the location ID, which is the identifier on the external content type. EntityId2-5 are all blank.

We use region and other location attributes in workflows so how can we access all these other fields?

Thanks for your time.

Peter Newhook SharePoint posts on my blog

How to authenticate automatically to the external portal from Page viewer?

Page viewer web part gives iView to the website eg. http://www.test.com. This works fine! Our customer would like login to the external portal with attaching user name in the ur like http://www.test.com/abc?name=John. Or user single sign on to login to the external portal. Authentication to the external system should be automatical to the end-user so that they don't have to login manually to the www.test.com portal. How to do it?Kenny_I

Show all in BDC data item picker by default

I have one ADF where it actually, by default when opening, show all 5 items without having to enter any filter criteria, which is great!  I'm trying to reproduce it for another project and cannot for the life of me do it again and it's driving me crazy.  I'm sure I'm missing something, but not sure what it might be and have spent hours comparing the two files for any elements, attributes that I might be missing without success.  Any ideas would be appreciated.

Workflow - automatically create discussion item using title field of of custom list item as its subj

Anyone any ideas as to how I can configure SharePoint to create a discussion item using the title of a list item. e.g. user creates list item on a custom list - SP automatically creates a Discussion thread for this list item in the discussions list. I'm guessing this can't be down OOTB . would I be looking at SPD or a coded solution ? regards, Counie

Automatically select item with keyboard navigation in a combobox


Hi there,

in a WinForms ComboBox the selected item automatically changes, when I navigate through the combobox items with keyboard.

However, in the WPF ComboBox (IsEditable = false), the item in the list is highlighted but not automatically selected. Is there a way to change this behaviour?




External List Infopath Form - people picker and dropdown


I am editing external list form in InfoPath. I have two questions

1)      My requirements are to put people picker for say employee name field.

When I try to add this control it ask me to bound it to some field as there is no people field I can’t add this control. How can I achieve this?


How to automatically Authenticate User on External Site once Authenticated on SharePoint Site


We analyzing the implementations approach, for a scenario.

  1. External Site: To log-in to external site which has its own user store and is hosted on different domain. So user has to provide his user id and password for logging in to external site like e.g.  DOMAIN1\UserName & Password

  1. SharePoint Site: This site is hosted on different domain other than DOMAIN1 and has got windows/forms authentication. So the user to login to SharePoint site has to provide SharePoint site Credentials DOMAIN2\UserName & Password.
  2. SharePoint Web Part which shows external site in IFrame and allows user to perform CURD operation once the user is authenticated in external site.

What we want is once user login to SharePoint site using (Forms/Windows) authentication, he should be automatically authenticated in External Site (using some mechanism) the logged in user credentials are picked up from some store based on his sharepoint username and system authenticates the user on external site.

Any pointers to code/blogs/articles would be really helpful.

Akhilesh Nirapure

Add item to external list from profile page


I have three external lists that are related. The list is searchable, and the results send you to a profile page that has the first list, which is the user information, and then two other related lists below that. On one of the related lists, I would like to add an "add item" link.

For example: You have a customer profile, with a list of that customer's orders, and you click add order under the order section, and it fills in the customer id number automatically, then you can fill out the rest, which populates the list.

I am guessing I need to do this with a custom action. Could someone point me in the right direction?

CollectionViewSource sort not reflecting automatically after ObservableCollection item property chan


I use a CollectionViewSource to feed the Items of a ListView.  My CollectionViewSource is bound to an ObservableCollection that contains items that implement INotifyPropertyChanged.  Item property changes are being appropriately reflected in the ListView, but I'm surprised to find that the item does not automatically get resorted when its property that the sort is keying off of changes.  It would seem that all the information should be there for the ListView to recognize the need to resort the changed item.  Is there a way to make this happen or another 'lighter' alternative to calling Refresh() on the view?





Add Related/Child List Item? - How to automatically set the relationship?




I've got a parent/child relationship between two lists.  I have the parent form set to automatically include child records.

The problem I'm having is that when I "Add new item," it is not associating the new record with the parent record automatically.

How do I have it automatically set the key field?

Thanks in advance for any suggestions,




Item Event Receivers or way to validate data entered for External List in SharePoint 2010?

Hi everyone,

Are there Item Event Receivers for External List in SharePoint 2010? If not, is there a way to validate the item data entered from External List UI in SharePoint site?


calendar item automatically delete upon request rejected.



i got an issue where i've created a workflow and attached it to a calendar so the workflow will starts when new item is created. if the PIC reject the item can MOSS delete the item from calendar once the PIC reject it?



How to automatically resolve external business data in a MOSS 2007 document list


Here's what I have so far...

1.      I have a document list in MOSS 2007.

2.     Each document in the list may be sent to an external system for further processing.  This was done by adding a custom feature to the document libraries actions menu in SharePoint.

3.     The external system uses it's own SQL Server database.  A table in this database references the SharePoint document’s GUID.  Additional columns in the table are updated during external processing data such as status.

The problem I'm trying to solve is this:

1. I would like the see the external processing status for a document in the original SharePoint document list.  This status will change and needs to be updated for each document automatically.

I tried setting up a business data column in the document list.  I created the XML definition of the external SQL Server table using the MOSS 2007 SDK and imported the definition.  I added the business data column to the list

workflow runs when item changed even though only 'Automatically start ... is changed' is unselecte


We have an SPDesigner workflow on a form library in SP2007 SP2 (& some CU updates).

Its 'Automatically start this workflow whenever an item is changed' is unchecked.  The other 2 options '...new item is created.' and '... manually started...' are checked.

We add an item into the list.  The workflow starts.  We see the 'Approval Workflow Started' in the workflow history.  And approver then approves the item, and in the workflow history, we then see the 'Approval Workflow Started' again.  It's as if the workflow has restarted. 

This errant behavior seems to have started when we added an if condition in second step of our workflow:

If Checked Out to is not empty

 Log xxxyyy to workflow history

 then Wait for Checked Out To to be empty 

Is it a known bug in SP2007?


A little more info on this:

We have a workflow step that :

Store https://url/blah in Variable:Blah URL

  then Check out item in OurFormLibraryName

  then Set Approval Status to Awaiting Approvers Approval

  then Set ... another field value ...

  then Check in item OurFor

jQuery Date picker Implementation in ASP.NET

I've posted a wrapper ASP.NET around the jQuery.UI Datepickercontrol. This small client side calendar control is compact, looks nice and is very easy to use and I've added it some time back to my control library.

This is primarily an update for the jQuery.ui version, and so I spend a few hours or so cleaning it up which wasn't as easy as it could have been since the API has changed quite drastically from Marc's original implementation. The biggest changes have to do with the theming integration and the resulting explosion of related resources.

If you want to use this component you can check it out a sample and the code here:

Missing 'new item templates'


 Hi all,

          I am a 'newbie' to VWD and I am slowly working through the Basic Walkthrough Help files, and learning plenty along the way.

However, when I tried to create a new database in the LINQ control walkthrough I found that the option to create a new database is missing, and further investigation has found that many other new item templates are missing.

I am using a brand new machine with Windows 7 Ultimate and have enabled IIS and .NET from Control Panel-Programs-Turn Windows Features On-Off. I used the WPI to install all basic elements eg. IIS Components, SQL Server Express.

The only 'new item templates' I have when I right-click the App_Data Folder and choose 'new item' are:-

ADO.NET Data Service

AJAX Enabled WCF Service

Dynamic Data Field

SQL Server Database

Text File

XML File

Does anyone know where I have gone wrong.


Michael J. Hill

Automatically redirect to HTTPS and check if SSL is active



I've set in the web.config:

    <!-- User Authentication -->
    <authentication mode="Forms">
      <forms loginUrl="~/Page/View/Content/Login.aspx" timeout="2880" requireSSL="true" />

This works fine. If there is no ssl connection, the login form doesn't continue. But I would like to check if ssl is active (in codebehind) and, if it's possible, to automatically the user to the https page if he's currently on http. (I could do this job by manually redirect with page.response("https://url.../login.aspx"); but this is not really generic. For example if the webapp is moved to another domain it doesn't work anymore... I'm looking for something like: FormsAuthentication.RedirectWithSSL(); or so... :D)


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend