Results 1 to 6 of 6

Thread: Error: Salutation length

  1. #1
    BastianL is offline Junior Member
    Join Date
    Sep 2009
    Posts
    4

    Post Error: Salutation length

    Hallo,
    I have a problem with the Salutation_dom Field.

    We need in our Company longer salutation (e.g. 'Mr. Dr.' or 'Mrs. Prof.' ) next to the standards.

    I changed the salutation_dom the way I need it, but when I use a salutation longer when 5 chars in Sugar, it only uses the first 5 chars (e.g. 'Mrs. Prof.' will be shown as 'Mrs. ' or 'Mr. Dr.' is shown as 'Mr. D'), this shorten forms will be also written into the database :-(

    I increased the length of the data field in the database, but I can't use longer salutations when 5 chars.

    Is where a regulation in sugar for the length of the salutation_dom DDM? And where can I change it?

    Greetings
    Bastian

    Oh I totally forgot our Version is:
    SugarCRM Community Edition Version 5.1.0 (Build 4732)

  2. #2
    roblaus's Avatar
    roblaus is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Vienna / Austria
    Posts
    2,850

    Default Re: Error: Salutation length

    Create a file e.g. 'custom.php' (the name doesn't matter) into /custom/Extension/modules/Leads/Ext/Vardefs

    Put that in:
    <?php
    $dictionary['Lead']['fields']['salutation'] =
    array (
    'name' => 'salutation',
    'vname' => 'LBL_SALUTATION',
    'type' => 'enum',
    'options' => 'salutation_dom',
    'massupdate' => false,
    'len' => '25',
    'comment' => 'Contact salutation (e.g., Mr, Ms)',
    );
    ?>

    Run a quick repair (probably twice...)

    Same for contacts accordingly

    Result looks like this (hopefully):
    Attached Images Attached Images  
    __________________________
    Robert Laussegger
    http://www.iscongroup.net

    Bei Fragen: support@iscon.at
    Die deutschen Sprachdateien für SugarCRM und das deutsche Handbuch gibt es hier: http://goo.gl/kPsAz
    Ab sofort auch mit 6.4.2

  3. #3
    BastianL is offline Junior Member
    Join Date
    Sep 2009
    Posts
    4

    Default Re: Error: Salutation length

    Hallo roblaus,
    many thanks for your advise.

    Also I did it a little bit different, you helped me a lot.

    I only changed the 'vardefs.php' in '/include/SugarObjects/templates/person' like you said.

    And after that, a short Quick Repair an everything is like I needed.

    Thanks a lot.

    Greetings
    Bastian

  4. #4
    roblaus's Avatar
    roblaus is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Vienna / Austria
    Posts
    2,850

    Default Re: Error: Salutation length

    This basically ok and achieves the same result. But it's not upgrade safe. So with the next upgrade your changes are gone. Changes in custom are excluded from upgrades and are (at least in theory) upgrade safe...
    __________________________
    Robert Laussegger
    http://www.iscongroup.net

    Bei Fragen: support@iscon.at
    Die deutschen Sprachdateien für SugarCRM und das deutsche Handbuch gibt es hier: http://goo.gl/kPsAz
    Ab sofort auch mit 6.4.2

  5. #5
    samisgr is offline Junior Member
    Join Date
    Nov 2009
    Posts
    1

    Default Re: Error: Salutation length

    Quote Originally Posted by BastianL View Post
    Hallo,
    I have a problem with the Salutation_dom Field.

    We need in our Company longer salutation (e.g. 'Mr. Dr.' or 'Mrs. Prof.' ) next to the standards.

    I changed the salutation_dom the way I need it, but when I use a salutation longer when 5 chars in Sugar, it only uses the first 5 chars (e.g. 'Mrs. Prof.' will be shown as 'Mrs. ' or 'Mr. Dr.' is shown as 'Mr. D'), this shorten forms will be also written into the database :-(

    I increased the length of the data field in the database, but I can't use longer salutations when 5 chars.

    Is where a regulation in sugar for the length of the salutation_dom DDM? And where can I change it?

    Greetings
    Bastian

    Oh I totally forgot our Version is:
    SugarCRM Community Edition Version 5.1.0 (Build 4732)
    On
    SugarCRM Community Edition
    Version 5.2.0a (Build 5447):

    I overcame the problem without additing any .php file:

    The 5 characters limitation seems to be for the "Item Name:" not the "Display Label:".
    So while adding salutation labels to the salutation_dom at the Dropdown Editor, keep "Item Name" variable name short e.g. "difh" and the Diplay Name, as you like it: e.g. "Dipl.-Ing. (FH)", or even much longer.

    Seems to work without any problems until now ...

  6. #6
    roblaus's Avatar
    roblaus is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Vienna / Austria
    Posts
    2,850

    Default Re: Error: Salutation length

    Yep, of course. But you run into troubles if you want to import anything, Because then you have to change all instances of your Dipl.Ing (FH) in your import file to "difh". For most people this causes much more of a problem.
    __________________________
    Robert Laussegger
    http://www.iscongroup.net

    Bei Fragen: support@iscon.at
    Die deutschen Sprachdateien für SugarCRM und das deutsche Handbuch gibt es hier: http://goo.gl/kPsAz
    Ab sofort auch mit 6.4.2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 2010-04-08, 08:39 PM
  2. can we expan last name length
    By vacharaphol in forum Help
    Replies: 3
    Last Post: 2008-10-15, 10:48 AM
  3. Changing length of day?
    By greenleaf in forum Installation and Upgrade Help
    Replies: 2
    Last Post: 2007-01-17, 06:02 PM
  4. Changing Varchar length
    By eaho in forum Help
    Replies: 4
    Last Post: 2006-09-05, 07:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •