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

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

Publishing HTML Field with External List

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :SharePoint
I have an external content type I created and an external list that I provisioned off of the content type.  I want to customize how the user edits some of these columns.  I need one of my list columns to be a field type "image" and one to be a field type of "HTML".  I tried exporting the list as an wsp and importing into an empty sharepoint project.  When I review the custom schema.xml for the list I can see the fields referenced from the externa content type.  I altered these fields so that they conform to the types I need.  For some reason when I deploy the list definition and instance those fields are still textboxes.  I have googled this topic and there doesn't seem to be much out there.  Does anyone have any idea as to how I can accomplish this.  I originally wanted to build my list structures out in sharepoint but there are many parent child relationships and after realizing I cannot create a lookup type field that references a sharepoint list declaritively in CAML due to the fact that the listid has not been created because it hasn't been provisioned I abandoned that concept and put my tables in a SQL database.  I need the user to be able to associate a sharepoint image and some HTML in a couple of columns in this table.

View Complete Post

More Related Resource Links

Changing the field type in an External List

I have created an External Content Type to a database containing document titles and the URLs to those documents.  I created the External content type operations for read item and read list with the title and url fields (there's a number identifier too). I next created an external list using my external content type. It's great - I can see the information I need from the external Database. BUT... The URL field appears as text and I'd like a clickable Hyperlink.  I'm not sure how I can do this.  Any ideas? Cheers,

Create View in an External List that Gets a Field from Another External Content Type via Foreign Key


I currently have two tables in a SQL Server 2k8 database: Locations and Customers

The fields in the Locations table are:

  • LocationName
  • StreetAddress
  • City
  • State
  • ZIP
  • CusotmerID (foreign key joined to Customers table)

The fields in the Customers table are:

  • ID (primary key)
  • CustomerName
  • CurrentBalance

Through SharePoint Designer, I have both tables set up as External Content Types of the same names as the tables and have created External Lists for each External Content Type. All CRUD operations are working perfectly. I added the proper Assocaiation and I've set CustomerName to be the Title of the Customers External Content Type. I can currently use a picker for CustomerID in the Locations List and CustomerName is displayed properly. Also, the default DispForm also correctly displays the CustomerName for any single Location record.

However, I would like to modify the default ReadList so the foreign key (CustomerID) will show the Title field of Customers (CustomerName). However, I am running into trouble finding out how to do this.

Any help with this issue would be greatly appreciated!!


Adding HTML Publishing Field to Content Type via the API


I have a site feature receiver that sets up all my custom columns and content types. This appears to have a persistent issue with adding field references to publishing controls, in example below it is an HTML Publishing Field but this also happens on a Publishing Image Field. In summary: - Publishing HTML Field creates successfully and is added to the Site Columns (see method CreateHtmlField below) - Content Type creates successfully and updates ok with an SPFieldLink to my custom field of type SPFieldText (non publishing) - When trying to add a SPFieldLink to an HtmlField, however I get an ArgumentNullException

Detailed exception from 14/LOGS: System.ArgumentNullException: Key cannot be null. Parameter name: key at System.Collections.Hashtable.get_Item(Object key) at Microsoft.SharePoint.SPFieldLinkCollection.Exists(String name, SPFieldLink& fldFound)

Tracing this down the hierarchy of calls into SP SPFieldCollection.Add() calls SPFieldCollection.Exists() with the SPFieldLink.Name property, however this is a read only value which is derived from SPField.InternalName

SPField.InternalName is set in 2 of the 3 constructors of SPField, however, I'm using the 3rd one with signature: public SPField(SPFieldCollection fields, string typeName, string displayName)

SPField doens't seem to set that anywhere else and neighter does the HtmlControl.

FormView Text Field Being Set by A Drop Down List


Hello, I have a FormView which is used to insert a record into a database.  Outside of this formview i have a drop down list, I want to grab the value from that drop down list and set one of the text fields within the formview to it's currently selected value.  I've tried the following code, but the dynamic categorytextbox line is what seems to not be working.

                    <asp:DropDownList ID="ddlCategory" runat="server" AutoPostBack="True" 
DataSourceID="SqlDataSourceCategory" DataTextField="CategoryName"
DataValueField="CategoryID" Width="200px">

                            <asp:TextBox ID="CategoryIDTextBox" runat="server" 
Text='<%# Bind("CategoryID") %>' Visible="False" />

        protected void FormView1_DataBound(object sender, EventArgs e)
dynamic varCategory = ddlCategory.SelectedValue;
dynamic categoryTextBox = FormView1.FindControl("CategoryIDText

Workflow field not being added to list or views when adding a workflow


This problem just started happening in my entire site collection.  Anytime I associate a workflow to any list or doc lib the Workflow column that shows the status and links to the history is not beind added to the list or any views and is nowhere to be found.   Here's exactly what I'm doing:

1.  Go the List settings -> workflow settings -> add a workflow (for this example the OOB approval workflow)

2.  After adding I go to the List, the workflow column doesn't exist.

3.  I go to "modify view", and the workflow column is not listed in the available columns.

Any help is greatly appreciated.

Video: Field and List Item Validation in SharePoint 2010

SharePoint supports the ability to create Excel-like field validation formulas to validate field data in a list, which greatly reduces the amount of custom code that a developer must create and deploy. (Length: 1:44)

How to Set a list item's createdby or modifiedby field as a User(deleted from AD)



I have to migrate data from SQL DB to SP list. But its old data and some users who created/modified the record has been deleted from the AD. Now I need to set the CreatedBy / ModifiedBy Field of the item accordingly. How to achieve this?

And when I tried to modify the "Editor" and "Author" field through Object Model, it works. But its not working through Webservice. What is the reason behind this?

Please help me find an optimal solution for this...


Thanks and Regards,

/* John JB */

How to read a column of a sharepoint list to a text string field of infopath form?

My infopath form used to read these email addresses from a web service and web.config file. Now i would like to get these user email addresses from a contact list in a sharepoint server. I am trying to do this without writing any codes. Here is what i have done so far: 1. Adding a new "data connection to receive data from SharePoint library or List" where i selected Email Address column of the contact list. 2. I added a new Text Field and define a new rule with "Query using a data connection" defined above. When i try to access the newly created Text field above it always return empty as if the Query attached to it did not executed at all. What did i do wrong? Is there a better way? Thank you in advance for your help.

Custom Field in List

Hi All, I have developed a Custom field and deployed on the server but it is available when we add list in site, that is fine But I want this field as default like "Title". Is there any way to do it. Thanks Saumil Thakkar

Updating a List item field value in a SPD Workflow is setting Date fields to null

Hello everybody,I faced a very weird behavior while creating a workflow in SPD against a Document Library.Here is the case:1- Create a document library in sharepoint site.2- Add a custom column of type DATE.3- Upload any document to the library4- Edit the item metadata and set the custom date field to any date you want.5- Now using sharepoint designer, create a very simple Workflow with only one action that updates the current item "Title" field to any value. (Note: In my case I set the workflow to start manually and not automatically)6- Save the workflow and then start it on the uploaded item.7- Now check the value of the date column after the workflow is finished.8- You will see that the Date field is Empty... (very weird)Notes:   1-This behavior will not appear on a standard list. it is only appearing in a Document library.  2- I am using WSS 3.0 SP2 + MOSS 2007 SP2. Also SharePoint designer 2007 SP2Did anyone face this situation and does it have a fix, or am I doing something wrong here... Please help.Regards,Maheed

Read data from BLOB field and write to sharepoint list

Hi, I want to read the data from BLOB field and write it into sharepoint list item. Please provide some pointer to archive above objective.   Thanks in Advance.

Calculated date field displays differently in List View and Data View web parts

In SharePoint GUI I created a simple custom list with a calculated Date/Time field (Due).  The calculation is =[Created]+7.  I'm trying to display this data on a page using a DVWP.  But first, for testing purposes, I also created a second calculated Date/Time (TestCreate) field in my custom list that is simply =[Created]. In the List View from within SharePoint, the dates show as expected (for example): Created = 8/12/2010 3:45 PM Due = 8/19/2010 3:45 PM TestCreate = 8/12/2010 3:45 PM In SharePoint Designer, I added a Data View web part and the above three data elements (each configured to display mm/dd/yyyy hh:mm:ss tt).  I see the time displayed for the example list item as: Created = 8/12/2010 3:45:30 PM Due = 8/19/2010 10:45:00 AM TestCreate = 8/12/2010 10:45:00 AM I've tested a couple scenarios and the calculated fields always display five hours in the past (along with dropping the seconds).  It seems like the DVWP is returning the date in a different time zone (with no seconds).  The lcid is set right (1033).  I didn't see any time zone settings for the DVWP specifically.  I'm basically stuck.  Could someone help me figure this one out. Thanks.

External List Profile Pages

I have some external data sources that are related to each other. I created the associations in sharepoint designer, and they all work.  I have a page that has a list of people, that you can search, and when you search for them, it takes you to the profile page that shows the two related lists for that person. This works how I want it. What I want to do has four parts. First, on the initial page that displays my list, I want the primary field (case number) to link to the profile page for that person, instead of the display form. I have tried this with a custom action, but I don't think I did it correctly. Second, on the profile page itself, I have those two related tables that show up. One table is a questionnaire the person filled out, and one is information about interviews they were given.  In the interviews section, I would like the viewer to have an "add interview" button at the bottom, just like any list web part would have. I don't have the option in the web part properties. Finally, on the questionnaire section, I need to alter the view. Right now, there are headings across the top, with the information going left to right. I would like to set it up with a box style, like you can normally do in a list. I would also like to change the field labels from generic field names to more descriptive ones. In addition to that, the questionnaire is entere

External List - Access Selected Items

Hello, The situation;- An external list in SP 2010 from SQL A custom ribbon/button that calls via JS a Dialog box(Application page) and passes the selected items IDs Some code behind to process items after confirmation from user. Question is how to access the selected items in the code behind. As far as I can tell the JS 'getselecteditems' only returns the list ID, which in the case of a standard list is fine, but with an External list returns something like '_B00234' - how do I use this or how to return a more meaningfull ID? (I would rather work in my confort zone VB/C# than JS to process items) casey

Connecting a Sharepoint Custom list with an external Data-source

Hi I am planning to connect a Sharepoint Custom list with an external Data-source. External DB will be in Access 2007 format. More Information: I need a solution that we can connect our sharepoint list (one-way) to online db in a way that new  information is directly updated in the sharepoint list, whilst other info changed in sharepoint list  is not synced back to original value. Is there a way to solve this? -saumil

How to add List item in search results for anonymous in a publishing site?

Hi all,   For now, results in Library (document set or not) are shown and the link is the binary file. This is ok. But for list, anonymous users can't view results. As logged in I see the items in the AllItems.aspx page. How could I allow this result to be viewed by anonymous users too?      Thank you,   Benoit Pironet
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