Where are the values for custom dropdown list stored?

[juanwang]

Hi All,

Thank you for providing such a great product. I'm very impressed!

I'm currently reviewing SugarCRM to replace the existing proprietary product that we're using. I've opened up the bonet and dive straight in, so hopefully I can help others in the future.

My question at the moment is :

How do I import list data from a csv file into a custom dropdown list that I have created? I have explored the database and was unable to find a table where this information was being stored. Has anyone done this before?

Cheers,

JuanWang

[billsandusky]

Juan,
The values are stored in the php file for your default language (mine is English as the example below)

%SUGAR-INSTALL%/custom/include/language/en_us.lang.php



The structure is easy to see, it is just building a php list

IE

$app_list_strings['YOUR-DROP-DOWN-NAME-HERE'] = array ( '' => '',
'' => '',
'LABEL' =>'VALUE',
'LABEL' =>'VALUE',
'LABEL' =>'VALUE',
'LABEL' =>'VALUE',
'LABEL' =>'VALUE',
);


Best of luck to you

Bill

[juanwang]

Thanks Bill. Perfect!

[agnoses]

Hello,

I have a lot of custom drop downs and customs fields created in a new install.
I am having a problem with the leads being displayed.

Can I copy the %SUGAR-INSTALL%/custom/include/language/en_us.lang.php file
and backup the custom fields related tables for use to restore the custom drop downs and custom fileds into a new instance of SugarCRM CE ?

Or am I missing files / DBs ?

Lisa

[labanjohnson]

I found several custom drop down lists there, but one dropdown list in particular is not there, but must be someplace else because the drop down appears in the layouts. This custom drop down list is one that I created in Module Builder and is shared between several modules, custom modules and original modules. Any ideas where the list is hiding out?

Juan,
The values are stored in the php file for your default language (mine is English as the example below)

%SUGAR-INSTALL%/custom/include/language/en_us.lang.php



The structure is easy to see, it is just building a php list

IE

$app_list_strings['YOUR-DROP-DOWN-NAME-HERE'] = array ( '' => '',
'' => '',
'LABEL' =>'VALUE',
'LABEL' =>'VALUE',
'LABEL' =>'VALUE',
'LABEL' =>'VALUE',
'LABEL' =>'VALUE',
);


Best of luck to you

Bill