Details about this thread
  • State Not Answered
  • Replies 7 replies
  • Subscribers 300 subscribers
  • Views 1313 views
  • Users 0 members are here
Related content from around SugarClub

Bulk update values in drop down editor

Sam Hennessy

Hi Everyone,

I am looking for a solution where we have a drop down in opportunities for the amount of users.

We want to import around 250+ different values into this drop down but I am not seeing any import options only manually adding each value one at a time.

We are currently using a drop down field which is sub-optimal but we are wanting to change to a lookup field.

Does anyone know a better solution to doing this or any recommendations in to how I would proceed?

Thanks in advance,

Sam

Parents
  • 0

    Dropdown values are stored in the file system in: 

    custom/Extension/application/Ext/Language/

    The file format is <language prefix>.sugar_<dropdown_list_name>.php

    For example: 

    custom/Extension/application/Ext/Language/en_us.sugar_call_status_dom.php

    the file then contains the list as "key=>label" pairs

    for example:

    <?php
 // created: 2015-12-31 08:49:15

$app_list_strings['call_status_dom']=array (
  'Planned' => 'Planned',
  'Held' => 'Completed',
  'Not Held' => 'Canceled',
);

    So you could easily generate the file and upload it to your system (I do that on my  OnSite instance when copying modifications from TST to PRD). I would think you should be able to include the file in a manifest to deploy to a cloud instance.

    If you are in Cloud you should be able to get a backup of your instance, get the original list, edit it, and re-upload it with the right manifest.

    Having said that, I would question the business logic behind this choice.

    A 250+ value dropdown is very hard to scroll through and not very user-friendly.

    FrancescaS

Reply
  • 0

    Dropdown values are stored in the file system in: 

    custom/Extension/application/Ext/Language/

    The file format is <language prefix>.sugar_<dropdown_list_name>.php

    For example: 

    custom/Extension/application/Ext/Language/en_us.sugar_call_status_dom.php

    the file then contains the list as "key=>label" pairs

    for example:

    <?php
 // created: 2015-12-31 08:49:15

$app_list_strings['call_status_dom']=array (
  'Planned' => 'Planned',
  'Held' => 'Completed',
  'Not Held' => 'Canceled',
);

    So you could easily generate the file and upload it to your system (I do that on my  OnSite instance when copying modifications from TST to PRD). I would think you should be able to include the file in a manifest to deploy to a cloud instance.

    If you are in Cloud you should be able to get a backup of your instance, get the original list, edit it, and re-upload it with the right manifest.

    Having said that, I would question the business logic behind this choice.

    A 250+ value dropdown is very hard to scroll through and not very user-friendly.

    FrancescaS

Children
No Data