Aug 16, 2008

Back and Forth - Lookup Field with Picker and Lookup

I've added two PowerShell Scripts (ConvertLookupFieldWithPickerToLookup.ps1,ConvertLookupToLookupFieldWithPicker.ps1) to my Lookup Field with Picker Release. With this scripts you can convert an built-in SharePoint Lookup to my Lookup Field with Picker and the reverse way my Lookup Field with Picker to an built-in Lookup. Means you can extend an already existing solution with my lookup with picker. On the other hand, if you don't like my lookup with picker (hard to believe;-), just convert back to the boring built-in lookup. Maybe useful for an upgrade to Office 14 - who knows?

  • Convert Lookup to Lookup Field with Picker:

PS>& .\ConvertLookupFieldWithPickerToLookup.ps1 http://[server:port]/site/subsite [ListName] [FieldTitle]

  • Convert Lookup Field with Picker to Lookup

PS>& .\ConvertLookupFieldWithPickerToLookup.ps1 http://[server:port]/site/subsite [ListName] [FieldTitle]

At the moment the script supports only list fields, no contet type fields. Do you need it? Let me know...

Bye,

Christian

18 comments:

Anonymous said...

I am trying to use your ConvertLookupFieldWithPickerToLookup.ps1 script. I can't seem to get the syntax correct to make this work. The error I get is:

Unable to index into an object of type Microsoft.SharePoint.SPListCollection.
At D:\ILoveSP\iLoveSharePoint.Fields.LookupFieldWithPicker_2.56\ConvertLookupFieldWithPickerToLookup.ps1:15 char:20 + $list = $web.Lists[$ <<<< listName];

Do you have an example of the syntax?

Christian said...

Hi, the syntax should be & .\ConvertLookupFieldWithPickerToLookup.ps1 -webUrl "http://localhost/site" -listName "Title of the List" -fieldTitle "Title of the column"

Bye, Christian

Anonymous said...

Hi,
I am trying to run the script and I am getting the same error message as above (Unable to index into an object of type Microsoft.SharePoint.SPListCollection...".
I am entering the syntax exactly as you have displayed it but I am not sure what the PowerShell line prefix should be; by default: "PS C:\Windows\System32>" before adding & .\Convert....

There is a copy of the PS1 file in System 32 but it gives the indexing error.

Could you let me know where I am going wrong?

Christian said...

Include the listname in quotes and keep care on casing, it's case sensitive.
Bye, Christian

Anonymous said...

Does this support the datasheet mode for bulk edits?

Christian said...

Unfortunately it doesn't support the datasheet view.

AboutDev said...

I keep seeing this error come up

1d22ea11-1e32-424e-89ab-9fedbadb6ce1
Exception setting "SchemaXml": "Non-supported field type change.
The field cannot be changed to the new type. Please check the new type and try again."
At C:\Documents and Settings\xgrmmart\Desktop\icgpm\deploy\ConvertLookupToLookupFieldWithPicker.ps1:29 char:8
+ $field.S <<<< chemaXml = $schema.PSBase.OuterXml;


No idea why its not working....ran perfectly in the test environment.

Any help is much appreciated. Thanks.

law dissertation methodology said...

I was very fulfilled to look for this website, wanted to thank you for your time for this wonderful post!! I absolutely enjoy reading it and I have you bookmarked to check out fresh things you blog post.

digital signature PDF said...

Congratulations, your blog is appealing and informative. Going through your Information, I found quite a few new ideas to implement ... Thanks

Fake Chanel said...

I think this bag is also neutral enough a shade that will allow you to carry it quite often. The other “Tony the Tiger” Ebury tote is really cool to have as well, but I think that’s far too casual a bag to carry for work.

سما احمد said...

شركة تنظيف كنب بخميس مشيط
شركة تنظيف مساجد بخميس مشيط
شركة تنظيف سجاد بخميس مشيط
شركة كشف تسربات المياه بخميس مشيط
شركة تخزين عفش بخميس مشيط
شركة عزل خزانات بخميس مشيط


شركة تعقيم خزانات بخميس مشيط
شركة صيانة خزانات بخميس مشيط
شركة غسيل خزانات بخميس مشيط
شركة صيانة مسابح بخميس مشيط

سما احمد said...

شركة تنظيف الاثاث بخميس مشيط
شركة جلي بلاط بخميس مشيط
شركة تنظيف شقق بخميس مشيط
شركة نقل عفش بخميس مشيط
شركة تنظيف موكيت بخميس مشيط
شركة تنظيف مجالس بخميس مشيط
شركة تنظيف مسابح بخميس مشيط
شركة تنظيف منازل بخميس مشيط
شركة تنظيف ستائر بخميس مشيط

شركة مكافحة الفئران بخميس مشيط
شركة مكافحة حشرات بخميس مشيط

سما احمد said...

شركة رش مبيدات بخميس مشيط

شركة عزل اسطح بخميس مشيط

شركة تنظيف فلل بخميس مشيط
شركة تنظيف كنب بخميس مشيط
شركة رش الدفان بخميس مشيط
شركة مكافحة النمل الابيض بخميس مشيط
شركة مكافحة بق الفراش بخميس مشيط
شركة مكافحة الصراصير بخميس مشيط
شركة مكافحة الناموس بخميس مشيط
شركة مكافحة الباعوض بخميس مشيط
شركة تسليك مجارى بخميس مشيط
شركة تنظيف خزانات بخميس مشيط

Raj Joshi said...

Happy Hug Day Images Pics,
Happy Hug Day 2016 Quotes SMS,
Hug Day Images SMS Messages
When is Hug Day 2016 Date
Hug Day 2016 Gift Ideas
Things to do on Hug Day 2016

Hug Day said...

happy hug day 2016 SMS
hug day 2016 Wishes cards greetings
Hug day Date 2016
hug day sms

Fangyaya said...

michael kors purses
christian louboutin outlet
burberry handbags
coach outlet online
fitflop clearance
jordan 3s
michael kors
michael kors outlet
air jordan 8
replica rolex watches
adidas outlet store
michael kors outlet clearance
retro 11
cheap true religion jeans
cheap true religion
nike air max uk
replica rolex watches
christian louboutin shoes
supra footwear
louis vuitton bags
designer handbags
polo ralph lauren
cheap basketball shoes
adidas originals
coach outlet store online
coach outlet
cheap jordan shoes
oakley vault
jordan retro 4
coach factory outlet online
louis vuitton outlet
air jordan shoes
ed hardy outlet
gucci handbags
adidas yeezy
kobe shoes
discount jordans
cheap jordans
oakley sunglasses
coach factory outlet online
20168.8chenjinyan

dada24 Xu said...

canada goose jackets
birkenstocks
ugg outlet
cheap uggs
canada gooses outlet
louis vuitton
rolex replica watches
fitflops sale clearance
gucci outlet
cheap jordans
2016921caiyan

dong dong23 said...

calvin klein jeans
vans outlet
coach bags
christian louboutin shoes
ralph lauren outlet
michael kors outlet clearance
michael kors handbags
yeezy boost 350 v2
louis vuitton outlet online
birkenstock shoes
2017.5.11chenlixiang