Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I'm migrating a list up a level from the site to the site collection. After migrating the list via list template, I need to move the data from the Lookup to the new Filtered lookup field on the same list. (so I can delete the original list).

When trying to copy/paste the date in datasheet view, I found that it's a read only field. Is there a way to do this with just COTS abilities?

Thanks,

share|improve this question
    
What do you mean by "filtered" lookup? –  Christophe Mar 21 '12 at 20:28
    
a filtered lookup as in a lookup column that is able to search the entire site collection for information, and not only the current site –  hrezs Mar 21 '12 at 21:02
    
Maybe you'll need to be more specific in your question. It seems that you are using a third party tool, not an out of the box feature. –  Christophe Mar 21 '12 at 21:10
    
Copy/Paste from when creating a new column for a List Lookup (information already on this site) Filtered Lookup (Information from all sites in site collection –  hrezs Mar 21 '12 at 21:11
    
I'm sure copying the information between two standard lookup columns would also work for coping from a lookup to a filtered lookup. I am using SharePoint 2010, I don't have experience with older versions, so a filtered lookup could be a new feature? –  hrezs Mar 21 '12 at 21:15
show 2 more comments

1 Answer 1

up vote 0 down vote accepted

I am not sure what you mean by filtered lookup. But keep in mind that a regular lookup field is actually a combination of an id and text. For example: 35;#LookupText#

The id is the most important part, this is what will allow your lookup to stay connected if you later edit the text.

The association of id (35) and value (LookupText) is specific to the source list, and probably doesn't match what your site collection filtered lookup expects.

share|improve this answer
    
Thanks, thankfully there isn't tooooo much data to just do the migration manually –  hrezs Mar 30 '12 at 17:54
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.