How to Open Edit Form from Sharepoint BCS Profile Page

So I made a profile page that lists all of my external content types data along with all of it’s association data. Now I want to put an action on the profile page to edit the item.

Creating ECT Action

  1. Central Administration -> Manage service apps -> BDCS
  2. Right click on your ECT and click “Add Action”
  3. Make an action with the URL pointing to the list’s Edit Form: http//mysite/lists/EditForm.aspx?id={0}
  4. Add the tables primary key as a parameter.   (There is no BDC idenitity avaiable for you to use!!! So this won’t initially work.)

Once you have your action, go ahead and add it to your profile page.  When you click it, you’ll get an error.  This is because instead of going to http://mysite/list/EditForm.aspx?ID=__bgc88883333 its going to http://mysite/list/EditForm.aspx?id=444.

What we need to do to fix this is convert the SQL table id into the BDC id.

Converting SQL Id to BDC Id

  1. Edit your list’s EditForm.aspx page and add the following code:

    <%@ Register Tagprefix="SharePoint" Namespace="Microsoft.Office.Server.ApplicationRegistry.Infrastructure" Assembly="Microsoft.SharePoint.Portal, Version=, Culture=neutral, PublicKeyToken=" %>

  2. Make sure you allow SharePoint to run your inline code by adding the following to C:inetpubwwwrootwssVirtualDirectories80web.config

Now if you go back to your items profile page and click the Edit Action you made, everything should work!!

Thanks to http://tihomirignatov.blogspot.com/2012/05/open-edit-form-of-external-list-from.html for getting me started.

3 thoughts on “How to Open Edit Form from Sharepoint BCS Profile Page”

  1. Where do I put the code? When I add it to the page by pasting everything in just below the other tags, the page blows up with the message that the given code or assembly is invalid.

    1. Hi Carolee,

      Sorry for this late response, but it has something to do with copying and pasting the code directly from this blog post. I took out the Public token key when typing this:


      < %@ Register Tagprefix="SharePoint" Namespace="Microsoft.Office.Server.ApplicationRegistry.Infrastructure" Assembly="Microsoft.SharePoint.Portal, Version=, Culture=neutral, PublicKeyToken=" %>

      and got the same error as you did later on when trying to recreate from the blog entry. I fixed it by copying from an existing file I had (which I no longer have…) Sorry to be of no help!

Leave a Reply

Your email address will not be published. Required fields are marked *