Dienstag, 27. März 2007

Save time and energy creating large picklists

Some time ago I created an online tool which makes life easier if you have to generate large picklists. Creating every item one-by-one can be very tideous. Caution: only use it, if you are comfortable with editing XML-Files and know exactly what you are doing ;-)


Here's how to use it (at your own risk):
  1. Create the attribute/picklist in the Microsoft CRM entity customization

  2. Add at least one option

  3. Export the entity as XML

  4. go here: http://www.beatnik.at/picklist_for_mscrm.php
  5. Choose the appropriate language setting (if missing, contact me)

  6. Enter the desired picklist values into the textbox

  7. Click "Generate XML"

  8. Open the XML-File that you exported in step (3) with WordPad or your favourite TextEditor (Notepad tends to have problems with encoding)

  9. Search for the displayname or the schemaname of the attribute

  10. Replace the options tag with the XML-String generated in (7).
    It might look like that:

  11. <options nextvalue="3">
    ...
    </options>

  12. Save the XML-Customizations File

  13. Import the File into MS CRM and publish

Kommentare:

  1. This is great--saved me a bunch of time--thanks

    AntwortenLöschen
  2. CRM Picklist Generator has been updated and is now 4.0 compatible.

    AntwortenLöschen
  3. This tool will save me a lot of time!!! Can you add also the italian language?

    AntwortenLöschen
  4. This is wonderful it saved me a lot of time. One problem though, I was not able to set a default value to the picklist. Any ideas? I get something like 'Invalid Input' error message when I try to set the default.

    I appreciate your help!

    AntwortenLöschen
  5. Hi Bewnet,

    there is a Tag <AppDefaultValue>. Did you change that in the XML?

    AntwortenLöschen
  6. anyway of resorting the list after importing it? When I try and apply a sort to the picklist within the CRM i get an invalid argument...

    AntwortenLöschen
  7. @jeff: sorry, i can't reproduce that error.... did you maybe use the 3.0 version in 4.0 or vice versa?

    AntwortenLöschen
  8. Hi there,

    just to check, do you also provide the generator for list of nationality?

    AntwortenLöschen
  9. hi angela,
    the tool was meant to assist getting your values into picklists because the needs might vary greatly. but i'm considering putting some more pre-made lists (languages, countries, currency) in.

    AntwortenLöschen
  10. Picklist generator has been updated. It now supports values and I have included some premade lists as Angela suggested.

    AntwortenLöschen
  11. I just discovered the website who writes about
    many
    home business reviews

    If you want to know more here it is
    home business ideas

    AntwortenLöschen
  12. [url=http://www.blingforfun.com]hip hop jewelry[/url],[url=http://www.blingforfun.com/pendants/cat_9.html]hip hop pendants[/url],hip hop watches,[url=http://blingforfun.com/belts/cat_18.html]bling bling[/url] ,hip hop,[url=http://blingforfun.com/chains/cat_7.html]hip hop chains[/url],hip hop bling,[url=http://blingforfun.com/chains/cat_7.html]iced out chains[/url],[url=http://www.blingforfun.com/chains/cat_7.html]wholesale chains[/url]
    hip hop jewelry
    wholesale hip hop watches
    hip hop rings

    AntwortenLöschen
  13. I have found it on this website called [url=http://tipswift.com]tip swift[/url]. You can find it there.
    cheers
    edit: wrong thread,

    AntwortenLöschen
  14. Good brief and this fill someone in on helped me alot in my college assignement. Thank you as your information.

    AntwortenLöschen
  15. Amiable post and this fill someone in on helped me alot in my college assignement. Gratefulness you as your information.

    AntwortenLöschen
  16. Inquire on every side Our Notice in the party Prices at www.Pharmashack.com, The Unrivalled [b][url=http://www.pharmashack.com]Online Chemist's rat on [/url][/b] To [url=http://www.pharmashack.com]Buy Viagra[/url] Online ! You Can also Learn up Comfortably postponed Deals When You [url=http://www.pharmashack.com/en/item/cialis.html]Buy Cialis[/url] and When You You [url=http://www.pharmashack.com/en/item/levitra.html]Buy Levitra[/url] Online. We Also Shore up a Ill-fated Generic [url=http://www.pharmashack.com/en/item/phentermine.html]Phentermine[/url] In shore up of Your Nutriment ! We At this place in space the for the nonce at once being away Trade consequence designation [url=http://www.pharmashack.com/en/item/viagra.html]Viagra[/url] and Also [url=http://www.pharmashack.com/en/item/generic_viagra.html]Generic Viagra[/url] !

    AntwortenLöschen
  17. http://www.smartbargainsus.com/main/index.php

    http://www.smartbargainsus.com/main/index.php?act=viewCat&catId=1

    http://www.smartbargainsus.com/main/index.php?act=viewCat&catId=22

    http://www.smartbargainsus.com/main/index.php?act=viewCat&catId=4

    http://www.smartbargainsus.com/main/index.php?act=viewCat&catId=7

    http://www.smartbargainsus.com/main/index.php?act=viewCat&catId=8

    http://www.smartbargainsus.com/main/index.php?act=viewCat&catId=9

    http://www.smartbargainsus.com/main/index.php?act=viewCat&catId=15

    http://www.smartbargainsus.com/main/index.php?act=viewCat&catId=16

    http://www.smartbargainsus.com/main/index.php?act=viewCat&catId=17

    http://www.smartbargainsus.com/main/index.php?act=viewCat&catId=19

    http://www.smartbargainsus.com/main/index.php?act=viewCat&catId=20

    http://www.smartbargainsus.com/main/index.php?act=viewCat&catId=saleItems

    http://www.smartbargainsus.com/main/index.php?act=viewProd&productId=2

    http://www.smartbargainsus.com/main/index.php?act=viewCat&catId=21

    http://www.smartbargainsus.com/main/index.php?act=viewProd&productId=18

    http://www.smartbargainsus.com/main/index.php?act=viewProd&productId=20

    http://www.smartbargainsus.com/main/index.php?act=viewProd&productId=16

    http://www.smartbargainsus.com/main/index.php?act=viewProd&productId=24

    http://www.smartbargainsus.com/main/index.php?act=viewProd&productId=78

    http://www.smartbargainsus.com/main/index.php?act=viewProd&productId=63

    http://www.smartbargainsus.com/main/index.php?act=viewProd&productId=65

    AntwortenLöschen
  18. Just one hint when adding Countries in a dropdown list.

    Since dynamics CRM (at least v3 and v4) only allow numeric values in for dropdowns, the idea of adding countries in a sequential integer order, such as:

    Afghanistan = 1
    Åland Islands = 2
    Albania = 3
    [...]

    However this is a bad idea, since if a country is added or removed from the list, it might be difficult to keep track, or even result in mismatches. I strongly recommend fellow CRM users to use the ISSO 3116-1 unique numeric value for each country instead (source: http://en.wikipedia.org/wiki/ISO_3166-1). So in case a new country is added or removed, you will never have mismatch issues in the future.

    following this idea, a country list would look something like this when following the ISO 3116-1 numerical values:

    Afghanistan = 4
    Åland Islands = 248
    Albania = 8
    [...]

    Just my two cents :)

    AntwortenLöschen
  19. Hello,

    is there a way to import data into Option-Set in Microsoft CRM 2011 ?

    AntwortenLöschen
  20. great tools saved me a lot of time and effort potenzmittel

    AntwortenLöschen