.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

# string with cross site lookup field value of List in datasheet view in moss 2007

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

I am getting appended # code value with cross site lookup field value of List in datasheet view. I dont want that hash coded value, i need actual value. Please provide me the solution.



Rajanikanth Rayala

View Complete Post

More Related Resource Links

# string with cross site lookup field value of List in datasheet view in moss 2007

I am getting appended # code value with cross site lookup field value of List in datasheet view, and also i am getting this value while export to Spreadsheet. How to remove this value.....

Cross site lookup field value contains the parent list item id and the title field separated by ;# i

Actually we are using third party component for cross site lookup and facing the problem with cross site lookup field value. Its showing the correct value in default list view mode, but in "Edit in Datasheet" and "Export to Datasheet" view cross site lookup field value contains the parent list item id and the title field separated by ;#. I need the actual value in "Edit in Datasheet" and "Export to Datasheet" view as shown in default list value, i dont want that appended parent list item id and separated by ;#.

Is there any OutOfBox soluiton for this. Please suggest me for the same.


MOSS 2007: list column that lookup to multiple documents stored in doc library

Hi All, I'm trying to understand how to customise MOSS to achieve the following: I need to lookup from a list to multiple documents stored in a documetn library. Example: - List item 1 --------> Lookup to Doc 2                   --------> Lookup to Doc 5 - List item 2 --------> Lookup to Doc 3                   --------> Lookup to Doc 5                   --------> Lookup to Doc 8 - List item 3 --------> Lookup to Doc 1 How can I achieve this? is it possible that in the lookup I have a "search" option? Thanks all Vit

MOSS 2007 - This Site and This List Scopes Not Working



I am using the production version of MOSS 2007 Enterprise.  Selecting the search scope "This Site" or "This List" and specifying information that demonstrably exists in either of these scopes does not appear in the search results.  Indeed, searches in these scopes always return nothing.


"All Sites" searches appear to work nicely.


Any thoughts on how to correct this problem?





WSS 3.0 Cross Site-Collection List Lookup


Hi all

New to Sharepoint here, so apologies if the question is unclear.

We would like to store centralised reference data in a dedicated site-collection and allow it to be accessed from other site-collections using list lookups. Can anyone recommend a webpart that would allow us to do this? I've found lots of cross-site list webparts, but not for crossing SC boundaries. Is there an OOTB feature that we could extend to achieve the same thing?




If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).

If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.

cross-site list lookup using sharepoint 2010


Hi All,

Just want to ask how can I cross-site list lookup using sharepoint 2010.

 I’ve created two Sites. TestSite1 that has a list called List1 and TestSite2 that has a list called List2. The problem is when I tried to create a lookup column in List2 so I could see the List column in TestSite1 I could not find it.

How can I do this using the OOTB SharePoint 2010?


Thank you in advance.

Can WebDAV Explorer view be enabled for a MOSS 2007 Site on Port 443 (SSL)?


Issue:  When accessing the Explorer view in SharePoint 2007 libraries, the FPRPC protocol (instead of WebDAV) is used.  Users want to perform certain functions in Explorer View (like send-to compressed folder) that are not available or do not work in their FPRPC view.

Background:  The site is on port 443 (SSL), users accessing the site have Windows XP and IE 8.

I understand from the white paper http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c523ac7a-5724-48be-b973-641e805588f4 that if a site is hosted on a port other than 80, the Explorer View will be forced to use FPRPC.  The white paper also states "there is no workaround for this behavior".

However, when I access the site using Windows 7 Enterprise and IE 8, the WebDAV protocol is used and all of the functions work.


  • Is there a workaround that can force Windows XP to use WebDAV on an SSL site?
  • Or is Windows 7 Enterprise required to force WebDAV? 

I have searched the fo

[MOSS 2007] Cannot connect to SSL web application / site list


Hi all
I have a quite strange problem with MOSS 2007 and I cannot solve it..

I installed MOSS 2007 SP2 on a single server (Windows 2003 Server SP2 + local SQL Server 2005 Standard Edition) without problems

I created a web application (port 80) and a site list on it without problems; everything is running correctly, I can connect to http://servername and to http://servername/sites/sitename

Then I created a SSL web application (port 443) selecting "Use Secure Socket Layer"; web application is created without errors
I created a new site list on this web application and site list creation is correct

BUT I cannot connect (from the server) to https://servername/sites/sitename or to https://servername
I always have "Internet Explorer cannot display the webpage" error

I can connect to any other SSL website using the same Internet Explorer so I don't think it is a browser problem...

I cannot understand what is the problem; the strange thing is that some months ago I installed another server with the same configuration (web appl on port 80 and web appl on port 443 and sites created on ssl web app) and I had no problem and it is still perf

Blog Site Lookup Field Changed List Reference


We have a OOB blog site that was working fine until last week. Overnight, the Category lookup field in the Posts list began referencing the Category list from another blog on a different, unrelated sub site. I'll try to illustrate the structure below.

Top Site
	Site A
		Sub Site A-1
			Sub Site A-1-1 (Blog 1)
	Site B
		Sub Site B-1 (Blog 2)

The Posts list in Blog 1 has a lookup field for Category, which now references the Category list from Blog 2--it should reference the Category list from Blog 1.

I came up with a solution to save the site as a template, alter the reference GUID in the manifest.xml, and then re-launch the site. However, this is not a perfect solution because:

  • Upon re-launch of the blog site, all comments and posts lose the previous Created and Modified By information and instead point to my account because I loaded the site. The only way I can think to circumvent this issue would be to modify the list reference while the site is still live, but I'm not sure how to do that.
  • I still don't know how this problem happened and how to avoid it in the future.

I've been researching the problem for several days and I can't find any rhyme or reason for how it may have occurred. I was hoping the community might have some ideas for me

MOSS 2007 - Excessive items in a List Lookup


Hello Community,

I have a list that uses a lookup.  The lookup list has over 7,000 items and is throwing an error -

This is a lookup column that displays data from another list that currently exceeds the List View Threshold defined by the administrator (5000).

What are my options for correcting this issue?



Tom Molskow - SharePoint Architect - Microsoft Community Contributor 2011 Award - Linked-In - SharePoint Gypsy

How to add custom list entries to mysite's calendar in Sharepoint 2007 site?


I would like to know below things

(1) How to create MySite for one specific member with other or administrator's access?

(2) Scenario : Administrator have created one SP2007 site. now Administrator have created one calendar (Sample calendar). Administrator have added some entries in calendar. now one user entered in portal site ansd view the calendar and he click on MySite menu. so this sample calendar entries should enter in that user's mysite calendar. How this can be achieved?

Thanks in advance.
Regards, Praful Udade

How to create a single entry page for site collections in MOSS 2007



I have  7 site collections containing a few hundred team collaboration sites. Some users are internal (intranet) but most are external (extranet). Extranet users are experiencing problems with losing links to their sites and forgetting which URLs to use. So I would like to create a single entry page that all users can enter after the logon process, which shows a list of sites they have permission to access, and other user-specific information. Perhaps relevant documents, tasks, recently modified documents etc.

I know this sounds like a 'My Site' but we want to use use a general welcome page instead. We use Windows authentication.
What is the best way of doing this and is it something that can be done in SharePoing Designer or does it need to be done in Visual Studio?

Many thanks in advance.

When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open


When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open.

I am using IE7 and the path of the folder does not contains more than 100 characters.

Also it opening on few on the machines which has IE7.


Applying custom CSS to the MOSS 2007 Calendar control Month view



I have a requirement to use the MOSS 2007 Calendar Control - month view is to apply a custom css to have a look and feel as per our requirements.

We tried applying the custom css to the MOSS 2007 calendar control - month view, it does take the custom css and applies it, but when i click on any date and come back to the calendar control, it changes the CSS of the MOSS calendar control back to the default one.

Let me know if anyone has any suggestion on  how to customize the calendar control for css for our intranet application.

Your response would be highly appreciated.






Exporting MOSS 2007 List to Excel 2007

When doing the export, the columns "Item Type" and "Path" are automatically displayed in the sheet.  Is there anyway to suppress these fields from exporting automatically?  I'm sure this has already been asked before, but I couldn't find anything after much searching (perhaps I'm using the wrong keywords).  Any help would be greatly appreciated.

Datasheet view lookup column issue


When a column that has a lookup is empty in datasheet view and I attempt to update a different column I get this message: the text entered for isn't an item from the list. select an item from the list, or enter text that matches one of the listed items.

I found this hotfix, but it did not apply.


Any ideas how to get this resolved?

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.
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