.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

SharePoint lookup site columns and Word Content Controls

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#
I discovered that when you bind lookup columns in SharePoint to a Content Type that in turn pushed these properties to the document, the value actually stored is the ID and not the text that is displayed. What is the correct way to use such site columns to enable users to select the data they want to be associated with a document and then to have the display values be populated in the Content Controls?

View Complete Post

More Related Resource Links

Easy way to migrate site columns and content types from moss 2007 to sharepoint 2010?

Easy way to migrate site columns and content types from moss 2007 to sharepoint 2010?

sharepoint Duplicate Site columns and updating content type failed when publishing to sharepoint


1many duplicate columns in my library

we can see image here:

2run  sql :

select * from AllUserData 
where  tp_LeafName = 'xxxx.xml' and tpid='1123' 
and tp_DeleteTransactionid = 0x 

should find only one row,but then can find 7 rows:

row1                    0
row2                    1
row3                    3
row4                    4
row5                    6
row6               &

SharePoint and Open XML: Generating Documents from SharePoint Using Open XML Content Controls


This article describes how to generate documents that contain data stored in SharePoint lists. The example demonstrates how OpenXML content controls can be defined to capture list data in a Word document and how LINQ to XML can be used to query the lists. The documents are generated from a SharePoint Web Part.

Eric White

MSDN Magazine October 2009

Assembling Documents on SharePoint 2010 Sites by Merging Content from Excel, PowerPoint, and Word

This article describes a rich document assembly solution that takes Word 2010 documents, Excel 2010 documents, and PowerPoint 2010 documents and merges them together to form a final report in Word. It does all of this from a SharePoint 2010 Web Part.

SharePoint read/recognize a Digital Signature in Word (XML Content Control Mapping)?

I am using Content Control Mapping to pull certain fields from a Word Document and include it as columns when a document is uploaded into a Document Library. We're using MOSS 2007 and Word 2007. It is required that the user digitally signs the document before uploading.  Is there a way to get the signature to appear as a column in a similar fashion?  I'm new to this mapping business, and Google hasn't been much help. I realize I could use the Collect Signatures workflow, but that seems cumbersome to 1) have the user submit it, 2) have an admin open each document and start the workflow and 3) have the user THEN sign the document.  That's more steps than simply manually opening and verifying digital signatures. I figure I'm missing something obvious here.  Any help or ideas would be appreciated.

Remove Word Style once copy and paste content to Rich text Editor in sharepoint 2010

Hi Guys, I have page layout for Users to add content for Page.I have site column for page content on field type HTML with Richtextmode="FUll Html". Now when user cut and paste content from Word document in this Field it carry word document style. how can i control this content on Page layout with CSS. Please adviseThanks Ron

Lookup columns in a SharePoint Custom list

Hi, I would like to know the maximum lookup columns we can create in a SharePoint Custom list. Thanks and regards, Usha   

How to migrate sharepoint site in 2007 with custom solution package and its content to sharepoint 20

Hi Experts, Recently, my organization is planning for SharePoint 2010 upgrade. We decide to go with Database content migration as it is less impact with down time due to hardware and software requirement (64 bit) in SharePoint 2010. We have a sub-site which contains a lot of customization such as master page, custom list, web parts and a lot of content. There is also a solution was built for that sub-site as well. However, as the time past by there quite a few update and manual creating from power users which concern to me that the solution package that we have does not up to date that can be use for SharePoint 2010 upgrade. I am planning to re-package the solution for the upgrade with all the changes users made for SharePoint 2010. But the question is how do I migrate the content of existing site when we upgrade to 2010? It is also possible that they want to change the sturction of the site when migrate eg: make this new upgrade site as top site collection instead of sub-site. Another concern is what happen after I finish making re-package the solution but during the re-package period users might make more change to the existing site? I would greatly appreciate for any ideas, suggestions as well as best methodology I should take.   Thanks praneth

Traversing Lookup Columns in a SharePoint View

I have a list with a lookup columns that references another list. This list, in turn, has a lookup column that references a third list. This represents a Child->Parent->Grandparent relationship.  I have a view of the child list and I want to filter the items based on a column in the grandparent list.  I know I can do this in code using LINQ to SharePoint, but is there a no-code solution? The Content Query web part infers that it can do this but I didn't see a way to implement this. Does anyone know of a way to accomplish this in SharePoint Designer or the SharePoint UI?

Create Lookup Site Column based on External List (SharePoint 2010)


I've got an External List and I want to create a Site Column, which is Lookup to a column in my external list. If I tick any of the columns in 'Add a column to show each of these additional fields' and click OK i get the following error message:

[NullReferenceException: Object reference not set to an instance of an object.]
  Microsoft.SharePoint.SPBusinessDataField.IsInDefaultView() +58
  Microsoft.SharePoint.SPBusinessDataField.CreateSpFieldForBdcType(String bdcName, Boolean hidden, Boolean readOnly, Boolean idField, SPAddFieldOptions op) +809
  Microsoft.SharePoint.SPBusinessDataField.AddNeededSecondaryFields(String wssNames, String[] oldNames, String[] newNames, SPAddFieldOptions op) +315
  Microsoft.SharePoint.SPBusinessDataField.OnAdded(SPAddFieldOptions op) +240
  Microsoft.SharePoint.SPFieldCollection.AddFieldAsXmlInternal(String schemaXml, Boolean addToDefaultView, SPAddFieldOptions op, Boolean isMigration, Boolean fResetCTCol) +759
  Microsoft.SharePoint.SPFieldCollection.Add(SPField field) +61
  Microsoft.SharePoint.ApplicationPages.FieldNewPage.Save() +513
  Microsoft.SharePoint.ApplicationPages.FieldNewPage.BtnOk_Click(Object sender, EventArgs e) +46
  System.Web.UI.WebControls.Button.OnClick(EventArgs e) +114
  System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +139

Word 2007 documents won't open from Sharepoint Services site

I have a Sharepoint Services 3.0 site that contains shared documents, Word, Excel, PDF, etc.  I cannot open Word documents directly from the shared documents portal.  Other file types like Excel adn PDF open fine.  It's only Word that has the issue.  I'm using Word 2007 and it doesn't matter if it is a .docx or a .doc, both act the same.  Word tries tro open, then just sits there....no error message or anything.  Any help would be greatly appreciated!

Host-named site collections and content deployment jobs (SharePoint 2007 Internet facing Web Sites)



I have an editing web application with multiple site collections (only accessible internally on a dedicated port), and I've one public facing web application (on port 80). Now I want to create several host-named site collections in the public facing web application (to limit the number of web apps in the farm), and then use content deployment jobs to push the content from the site collections on the editing web app into these host-named site collections.

Does anyone have any experience with this?
Do you see any issues?


SharePoint 2007 Content Deployment Word Document URLs being changed


We created an application that leverages on SPExport and SPImport.

We noticed that when we export/import site, the links on the word documents pointing to same application on the target site seems to get truncated url, the url parameters (ie ?param1=a&param2=b) are truncated.

also the host header seems to get updated ie(http://my.shop.com/path1/path2 turns to like (http://hostheader/path1/path2) which is causing broken links.

need some help/advice/ suggestion.


Thanks a lot


Duplicate Fields during list creation from content types and site columns


I am trying to create a List in Sharepoint 2010 using Site Columns and Content Types. It results in creating duplicate fields in the list for the Site Columns used. Here is the details description of what I was doing.

I have created two site columns 


<Field Type="Number" DisplayName="Start Coordinate" Required="TRUE" EnforceUniqueValues="FALSE" Indexed="FALSE"
Group="QMS" ID="{A3F2D108-11B5-4B49-9633-338D27227E12}"
Name="StartCoordinate" Overwrite="TRUE" />

<Field Type="Number" DisplayName="End Coordinate" Required="TRUE" EnforceUniqueValues="FALSE" Indexed="FALSE"
Group="QMS" ID="{06B927BB-C354-4A0A-AE88-9C14E55EAB27}"
Name="EndCoordinate" Overwrite="TRUE" />

Then added these to a new content type I

Can we add a video or flash content to sharepoint site

    Is there any possibility to add a video or a flash content  to a sharepoint page. Suppose when a page is loaded, the video or the flash file shoul automatically start to play.

I´m aware that video can be added through content editor webpart, but it does not plays the video file automatically. Only if the play button is pressed, the video starts playing. I want it to be automated. Is there any possible ways?

Thanks in advance..

Opening Word 2003 document from sharepoint site in word 2010.


When using sharepoint services with word 2003 on an XP machine, everything works fine. We bought some new computers where we now have windows 7 and office 2007/2010. These work perfect too. Even the 64-bit computers.

We are very happy with the new office version, so we decided to upgrade the entire company. As a test, we upgraded 1 PC. But this is not working. So we upgraded office, later we reinstalled it. But nothing helps. This is the problem: I surf to the document click it to open it, and then Word hangs. "contacting server". This is not always the case, sometimes it works, sometimes it doesn't. This even with the same document.

We would really like to upgrade to office 2010 entirely. But we're not going to buy licences we cannot use. Anybody got a solution?

Block offencive word in sharepoint blog site



How can i stop the uesr to enter the offencive and restricted words in the sharepoint blog site ?




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