changing/deleting names of salestages (and in other dropdowns)

[ahab]

Hi,
Is there a way to remove the existing entries in a dropdown-list (without hacking in to the database)?
I want to change the names of the salestages to my own.

/Andreas

[JVWay]

In Sugar 5.x you go to the dropdown editor.

In the future it would be helpful to list system specifics.

[DragonflyMaster]

Hi,
Is there a way to remove the existing entries in a dropdown-list (without hacking in to the database)?
I want to change the names of the salestages to my own.

/Andreas

You can do that hand-coding too.
Take a look at <sugar-root>\include\language\en_us.lang.php
there you'll find dropdown-lists and you'll easily change labels as you wish.

[ahab]

Thank you for the replies! I have sugarCRM community edition 5.0b installed and I can only add values with the dropdown-editor, not remove nor change. Should it be possible to remove/change values with the dropdown editor?

If not I will try changing the language file.

[ahab]

Hi again,

I've tried changing the values in the language file according to the advice above, but the changed values doesn't show up in the dropdown. Do I need to refresh the dropdown somehow?

I've tried with F5 and ctrl+F5 and shift + F5.

[kuske]

1.) You should not use MS Internet Explorer to edit dropdown fields, there are some JavaScript errors in the studio.Firefox does not have these JavaScript errors.

2.) You should not change the database values of the sales_stage_dom dropdown, as they are HARDCODED in some modules, e.g. Dashlets and Opportunity lists. Look to following findings:
modules\Charts\code\Chart_lead_source_by_outcome.p hp(270): $salesStages = array("Closed Lost"=>$app_list_strings['sales_stage_dom']["Closed Lost"],"Closed Won"=>$app_list_strings['sales_stage_dom']["Closed Won"],"Other"=>$other);
modules\Charts\code\Chart_lead_source_by_outcome.p hp(290): if($row['sales_stage'] == 'Closed Won' || $row['sales_stage'] == 'Closed Lost'){
modules\Charts\code\Chart_outcome_by_month.php(278 ): $salesStages = array("Closed Lost"=>$app_list_strings['sales_stage_dom']["Closed Lost"],"Closed Won"=>$app_list_strings['sales_stage_dom']["Closed Won"],"Other"=>$other);
modules\Charts\code\Chart_outcome_by_month.php(295 ): if($row['sales_stage'] == 'Closed Won' || $row['sales_stage'] == 'Closed Lost'){
modules\Opportunities\ListViewTop.php(53): $where = "opportunities.sales_stage <> 'Closed Won' AND opportunities.sales_stage <> 'Closed Lost' AND opportunities.assigned_user_id='".$current_user->id."'";
modules\Opportunities\Opportunity.php(323): $query = "select amount, id from opportunities where (". $idequals. ") and deleted=0 and opportunities.sales_stage <> 'Closed Won' AND opportunities.sales_stage <> 'Closed Lost';";

3.) The dropdowns sales_probability_dom and quote_stage_dom depend directly from sales_stage_dom, look to
include\language\en_us.lang.php

4.) After changing dropdowns you should call "admin" "repair" " Rebuild Javascript Languages" to rebuild the JavaScript versions of the language files.

[ahab]

Thank you, thank you, thank you!

[MadSugar]

Currently it is not possible to remove values from standard sugar domains using a manifest file. In file include/utils.php all app_list_strings are merged with the standard values. Adding and removing of domain values is possible using custom language files.
Comment out the line below (around line 760) to disable the app_list_string merging.

	// cn: bug 6048 - merge en_us with requested language
	$app_list_strings = sugarArrayMerge($en_app_list_strings, $app_list_strings);

I've reported this as bug 20636 .

[MadSugar]

I have found a simple work around to solve the problem above.

When you wan't to remove an existing domain or domainvalue from a standard language file, you 'll have to add the next line to a custom language file, For example, the lines below replace the standard sales_stage_domain with a customized domain:

unset($en_app_list_strings['sales_stage_dom']); // Remove the standard sales_stage_dom to prevent merging of standard and customized domain.
$app_list_strings['sales_stage_dom'] = array(   // New domain. 
	'Prospecting' => "Prospecting",
	'Proposal/Price Quote' => "Proposal/Price Quote",
	'Negotiation/Review' => "Negotiation/Review",
	'Closed Won' => "Closed Won",
	'Closed Lost' => "Closed Lost",
);

Explanation: $en_app_list_strings['domain'] contains all standard values for 'domain' as specified in "include/language/en_us.lang.php". In file "include/utils.php" this variable is merged with your customized $app_list_strings. By removing $en_app_list_strings['domain'] this merge will not occur for this domain, Problem solved