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

Delete Dropdown List

Neil Conacher

I need to do some housekeeping on a Sugar instance and this includes removing some redundant customised dropdown lists.

In Studio you are unable to delete DD lists directly.

I am familiar with the language files in custom and also that DD lists are referenced by field definitions in various places (including in the database in fields_meta_data)

Is there a way to manage unwanted dd lists out of the system in a way that maintains integrity.

Otherwise you can end up with a library of DD lists which becomes increasingly difficult to manage over time.

Thanks

Neil

Parents
  • 0

    If you instance is OnSite so you are able to:

    • delete the respective dd files from custom/Extension/application/Ext/Language/
    • update the table fields_meta_data in order to replace redundant dd list by some other

    Remember to run Quick Repair and Rebuild.

    Regards

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 in reply to André Lopes

    Hi André

    Thanks for your quick response

    I followed those steps on a couple of fields and the result was as follows:

    1. Newly named DD list appears in the Dropdown Editor - from the new/renamed language file in custom/Extension/application/Ext/Language/

    2. Correct DD list appears on the field in Studio - following change to Ext1 in fields_meta_data

    3. Old DD list is no longer mentioned in re-merged main language file

    However... the old DD List is still appearing in the Dropdown Editor list in Studio

    QRR was done, otherwise wouldn't have updated re-merged main language file.

    Neil

  • 0 in reply to Neil Conacher

    Eventually the same dd list is definied in two or more files. Double check how many language files define the same dd list using the linux command:

    find custom/Extension/application/Ext/Language -name "*.php" | xargs grep -n "<dd_list>"

    Replace the <dd_list> by the exact name of the dd list.

    Regards

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 in reply to André Lopes

    Hi André

    We indeed had another reference in that folder as we were maintaining multiple languages (only 2 languages in our case)

    So I suppose that implies the list of drop downs in Dropdown Editor is an aggregate of dropdowns across languages ?

    I aligned the dropdown lists across the 2 languages and the original reference disappeared - which was my intention.

    So I suppose that makes sense in that even though you have multiple languages, you want to be using consistent DD List names in the application.

    Thanks for your help on this Andre

    Neil

Reply
  • 0 in reply to André Lopes

    Hi André

    We indeed had another reference in that folder as we were maintaining multiple languages (only 2 languages in our case)

    So I suppose that implies the list of drop downs in Dropdown Editor is an aggregate of dropdowns across languages ?

    I aligned the dropdown lists across the 2 languages and the original reference disappeared - which was my intention.

    So I suppose that makes sense in that even though you have multiple languages, you want to be using consistent DD List names in the application.

    Thanks for your help on this Andre

    Neil

Children