Thursday, November 09, 2006

Free Custom Cross-Site Lookup Column Add-On for WSS v3

This post has been moved to a new location.

41 comments:

Anonymous said...

This is definitely to make this alot easier for development.

Anonymous said...

I published the tool on the sharepointcommunity.de an we got some feedback, that the tool X-Site-Lookups won't work with a german MOSS version - error messages see http://weblogs.mysharepoint.de/mgreth/archive/2006/11/09/WSS-v3-Cross_2D00_Site-Lookup-Column-Add_2D00_On.aspx#comments
Any suggestions ?

Tony Bierman said...

Some of our German friends have reported that the Cross-Site Lookup Column runs into an error on German language versions of WSS V3. The error has to do with locating language specific resource keys. We're looking into this issue.

Anonymous said...

This thing is great! Do you know of any examples where people have created content type definitions in Xml using this field type. I'm looking for an example of how this can be done and included in our content types feature.

Anonymous said...

I've tried to use this Cross-Site Lookup Column, but it seems that it behaves diferently if you allow multiple values or not. In the datasheet view, a single value cross-site lookup is readonly, while a multiple value cross-site lookup can be edited. Is there a workaround?

Martin said...

I installed the "Cross-Site Lookup Column Add-On' on my sharepoint site, but when I try to use it, it display the following error: The resource object with key 'fldedit_MultiLookupWarningForDocLibSupport' was not found.

Jani said...

Is there also a version like current site lookup field type which I could use in site columns collection or with site content type definition. In site column definition I'd like to specify only list name, and field should looup into list on the same site with this name.

Jani said...

I'm looking for version of lookup field type I could use in site content types definition. It should be named something like current site lookup field type. When defining content type i would specify linked list name as string. When content type would be used in site, field would lookup information in list on current site. How could this be done?

Anonymous said...

Hi. I created a new column in an existing wihout problem and it is correctly displayed in the list. But on the create form, the column doesn't show up (ie not displayed at all).
If I use Datasheet view, I can edit the column, but only if it is multi-value, otherwise it is read-only (this was already mentioned in a previous comment).
Any clue to this ? Thanks...

Anonymous said...

This is a great solution, thank you! One comment - it doesn't seem to work when used in datasheet view. When switching to DS view, if the looked-up column is located on a different site, the column is not available :)

Any thoughts?

Guy Gordon said...

Anyone ever figure out a way around the read-only thing on single value cross-site lookups in datasheet view? I'd love to be able to fill a bunch of records but can't. Sure would be nice to get around that read-only issue.

Rahulan said...

this doesnt work for me. when i click on the Cross Site Lookup option on the 'Create COlumn' page, it goes to a HTTP 403 (Forbidden) page. would someone be able to help me?
thanks
rahulan

Anonymous said...

if i build a list template from its working fine in the target list; but if i build a site template including a list with CrossSiteLookupField(s) the fields are empty. and if i go to edit the List Settings the _layouts/FldEditEx.aspx?List=GUID&Field=Activity dont find the the list; any suggestions?

Anonymous said...

@ Rahulan, same problem here!

Waylon B. said...

I am getting the same HTTP 403 (Forbidden) page. Weird thing is I got it to work on my test bed server but not on my production. I have compared permissions and so far no difference. What permissions are required exactly?

Konstantin said...

Problem: I need to create lookup field to list on other site collection. Any ideas?

E. Tilton said...

We're loving this here at Fresno Unified School District... but one of my colleagues was disappointed the drop down list of sites wasn't alpha sorted. Prolly very easy to add that to version 1.01 :-)

koenn said...

The cross-site lookup It is a great feature. We really like it.

There is a problem however in the sense that in datasheet view apparantly a cross-site lookup column is not shown...???

Is there a solution?

many tnx.

Anonymous said...

We're also seeing the 403 issue. It works like a charm if an administrator creates the column but anyone else who tries (even site owners) gets the 403 error.

Kenth Jansson said...

Hi,

This is a great add-On !!

To make it even better, I wonder if its possible to lookup other columns other than title, id, content type and version.
I would for example like to lookup other columns that I have created in a list. Is that possible ?

Regards
Kenth Jansson, Sweden

GeniusBoyWonder said...

I'm getting the dreaded "403 Forbidden" error, and I'm not sure how to solve it.

I've tried Sharepoint Solution's site and Support forums with no luck.

Did anyone get a proper solution to this that they can share?

Thanks

GBW

Radi A. said...

Hello,

I love your cross-site lookup, however some users get the HTTP 403 Forbidden error. What is the resolution to this problem?

Thanks.

Lisa S said...

When I go to add the column, I get "This field type cannot be edited from most client programs and might block the programs from saving documents to this library."

Suggestions?

Anonymous said...

i absolutely commend you for creating this and giving it out for free. I have been nothing but frustrated to do a simple task as "share" a list. Thank you.


Microsoft (smack) wake up

Anonymous said...

fyi i had to reboot

Anonymous said...

I can't see the product on Sharepoint Solution's site - do I have to register first, before I get to see it? Or is it no longer offered?

jeremiah said...

Was there ever a resolution to the 403 permissions error that was posted previously? We have installed the add-on but can not utilize the tool.

Tom said...

This add-on doesn't seem to be able to do a cross-site lookup on a "Choice (menu to choose from)" column. Has anybody got this to work or know of a different solution?

Mark said...

When you click the "Cross-Link Lookup" radio box on the SP List Create Column page, I get...

403 Forbidden

Just like several people above.

I've noticed that -no one- is replying to this thread. Has anyone resolved this issue?

Thanks :-)

Anonymous said...

I installed the web part without any difficulty. But this webpart only gives lookup option from content withing the same site, NOT from another site. I was wondering if the right version is posted on the web.

Rui Miguel Barbosa said...

The Cross-Site Lookup Column Add-in for Wss v3 has problems and raises SPExceptions.

I like this component but its giving me performance and stability problems.

The component as far as the current version is concerned, does not dispose the Sharepoint Objects Correctly as defined in the Microsoft Recomendations for using Sharepoint Object Model.

This said, when using this component you will start to see problems in the Sharepoint LOGS such as :
Potentially excessive number of SPRequest objects (X) currently unreleased on thread Y. Ensure that this object or its parent (such as an SPWeb or SPSite) is being properly disposed.

Please check your code. Best regards.

Anonymous said...

The list of sites displayed would be great if it was alphabetically sorted!

Most of the Document Library columns I want are not displayed.

Uwe said...

Great tool! Is working ok as long as I´m logged in as a Sharepoint-Admin. But when trying to create a cross-site lookup field with Edit-rights, I get an error message: "permission denied". Is there a workaround?

Anonymous said...

Hello
I have installed the add-on and have no errors. When I go to define a new column I can see the 'CrossSite Lookup' option but just when I clic on the option button I get the following message 'The website refused to show this site' (translated from Spanish). I have installed WSS3 in Spanish, and I have read that people who have german version have had problems with the webpart. anyone knows if it works in a spanish installation?

Thanks

Ricardo Romero said...

I have installed the Cross-Site Lookup Column and I have the following error 'The web site refused to show this page' (sorry, translated from spanish) Anybody knows if this works in a Spanish installation? In some previous posts it is said that people had problems in German installations, can be the same problems? are they already solved?

Thanks

Peppe said...

Great Tool!
2 questions:
1)is it inheriting from SPFieldLookup ?
2)is it anyhow possible to get the source code for customization?
Thanks

Peppe

Anonymous said...

Hello guys,

is that add on also working without MOSS? we have only a sharepoint services installation...

nonsparker said...

are you able to use the list and not have it link in the view?

Anonymous said...

i've used the Cross-site lookup in my sharepoint portal and it is working absolutely great. But then when i tried to use it in Datasheet view, it is not working. Can anybosy help me in this

Thanks

Anonymous said...

I'm using Version 1.0 and got the following issue:

Mainpage with List "Demo_List"
Subpage with Documentlibrary and Custom Field "Demo_List_Column" of type "Cross-Site Lookup" with Items of "Demo_List" on the Mainpage.

In the DocumentLibrary I can edit and change all Documentpropertys and the Cross-Site Lookup works great. But in the Office Document Information Panel I see a String-Field "Demo_List_Column".
I can't change anything there, and the Field is filled with the following text: "Edit property on server".
So I can't use the Lookup in Office Documents and must change or set the Propertys of fields with type "Cross-Site Lookup" only in SharePoint.

I tried to edit the fldtypes_*xml like the following blogentry told me: "http://nickgrattan.wordpress.com/2008/01/06/sharepoint-2007-custom-fields-and-edit-property-on-server/" but this doesn't solved the problem.

Could you have a look? If you can get this to work, your Lookup would be perfect!

Stefan Stanev said...

check out my cross site collection lookup field here