Email: Change from comma to semicolon?

Anyone? 

thanks

No takers?

Hi Kristjan,

As i seen this parameter(email_address_separator) in config.php.It is set to comma(,)

I think we can override this parameter in config_override.php like below

$sugar_config['email_address_separator']=";";

I do this all the time. Copy the column of email addresses into a Word document. Click in the column, then go to 'Table in Excel. Click on 'convert', then 'table to text' (this is all Office 2003 - it may be different in other versions, but the principle probably still applies). Now, you'll be given a choice of how you want he field separated. In theory, you ought to be able to choose 'other' and use a semi-colon. I've never been able to get this to work, so I leave it as the default - paragraph mark. Then, when it's done, I use Word's search/replace to replace paragraph marks with semicolons. It sounds laborious, but it's actually very quick - and a whole lot quicker than the alternatives.  We are Provide a more than ideas from u Visit us @   Hadoop Training in Chennai  |   Salesforce Training in Chennai |   Android Training in Chennai |   SAS Training in Chennai | Softwaretesting Training in Chennai

I do this all the time. Copy the column of email addresses into a Word document. Click in the column, then go to 'Table in Excel. Click on 'convert', then 'table to text' (this is all Office 2003 - it may be different in other versions, but the principle probably still applies). Now, you'll be given a choice of how you want he field separated. In theory, you ought to be able to choose 'other' and use a semi-colon. I've never been able to get this to work, so I leave it as the default - paragraph mark. Then, when it's done, I use Word's search/replace to replace paragraph marks with semicolons. It sounds laborious, but it's actually very quick - and a whole lot quicker than the alternatives.  We are Provide a more than ideas from u Visit us @   Hadoop Training in Chennai  |   Salesforce Training in Chennai |   Android Training in Chennai |   SAS Training in Chennai | Softwaretesting Training in Chennai

Hi Ajay Kumar 

Thanks for this insight and idea. I´ve tried it - both with single and double quotes but have not managed to get it to work. I´ve tried clearing the cache on the server and Quick Repair & Rebuild. Is there anything special that needs to be done to "activate" this change?

Thanks again

KGM

1st of all there is an option in Outlook which allows comma as address separator, so if you set that option all commas will be replaced by semicolons.

If you really want to change the comma in Sugar to semicolon you must patch a core file which is not upgradesafe.

This file is \include\javascript\sugar7\plugins\EmailClientLaunch.js

I function _formatRecipientsToString you find the definition of the delim_char which is ',' by default.

If you change the defintion to:

   _formatRecipientsToString: function(recipients) {
      var emailDelim = ';',
      emails = [],
      email;

the email addresses will be separated by ";" globally.

Thanks kuske for this. So it´s not upgradesafe - that´s good to know.

I was aware of the Outlook option but to change each and every Outlook for over 75 users is not as practical as changing a Sugar setting in one place  That was the use case/thought. I´ll have to think some more about this. Too bad this isn´t an option somewhere in Admin (along with default mail client).

Have a great night!

KGM

In Version 10.2 the function looks like this:

            _formatRecipientsToString: function(recipients) {
                var emails = [];

                recipients = recipients || [];

                if (!_.isArray(recipients)) {
                    recipients = [recipients];
                }

                _.each(recipients, function(recipient) {
                    var email = getEmailAddress(recipient);

                    if (email.get('email_address')) {
                        emails.push(email.get('email_address'));
                    }
                }, this);

                return emails.join(',');
            },

The last statement (return) uses the hardcoded comma.

Actually you can override EmailClientLaunch from plugin list by some other custom plugin having the code fixed accordingly.