Results 1 to 4 of 4

Thread: Error on adding row to dropdown editor - not alphanumeric

  1. #1
    stevec is offline Sugar Community Member
    Join Date
    Oct 2005
    Location
    London
    Posts
    1,100

    Default Error on adding row to dropdown editor - not alphanumeric

    Hi,

    Up until a recent upgrade to 6.2 from 5.1, we have a large number of entries in a dropdown list that contain '-' characters in the item name (not the value). In fact, it's a guid like the sugar record ids.

    Now, when trying to add such a new row, we get the error message:

    "Key - Must be alphanumeric, begin with a letter and contain no spaces."

    To get around this, I'm having to modify the custom language file directly on the server to add new rows.

    I've looked at the codebase to see where this error is generated (the text is represented by the 'LBL_JS_VALIDATE_KEY' label - but being javascript it's very difficult (for me) to see what I need to change.

    Can anyone point me in the right direction?

    Thanks

  2. #2
    Angel's Avatar
    Angel is offline Sugar Community Member
    Join Date
    Jul 2005
    Location
    Los Angeles
    Posts
    4,813

    Default Re: Error on adding row to dropdown editor - not alphanumeric

    You really shouldn't modify the language file to circumvent this matter. The reason why the interface does not allow you to use spaces and the like is because its been known to cause problems when editing the list, more specifically, saving values.

    This was a major pain if it happened to you after having entered 20, 30 values, as none of the values would be saved.

    I am not sure what other problems it can cause, but I would assume that if they don't allow certain characters, there are likely other problems they intend to prevent.
    Regards,

    Angel Magaņa
    Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
    Blog: http://cheleguanaco.blogspot.com.
    Twitter: @cheleguanaco.

    ________
    | Projects: |_____________________________________
    |
    | CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
    | GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
    | CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
    | Round Robin Leads Assignment
    | Phone Number Formatter
    | CaseTwit (Twitter Integration)
    ______________________________________________

  3. #3
    stevec is offline Sugar Community Member
    Join Date
    Oct 2005
    Location
    London
    Posts
    1,100

    Default Re: Error on adding row to dropdown editor - not alphanumeric

    Thanks - but it's something we cannot avoid at the present. Do to the legacy integrations, we need the guids values in the dropdown items.

    The editing works in this circumstance - and once in there, the dropdowns can be edited and moved.

  4. #4
    martyp is offline Sugar Community Member
    Join Date
    Jun 2011
    Location
    Australia
    Posts
    29

    Default Re: Error on adding row to dropdown editor - not alphanumeric

    Quote Originally Posted by stevec View Post
    Thanks - but it's something we cannot avoid at the present. Do to the legacy integrations, we need the guids values in the dropdown items.

    The editing works in this circumstance - and once in there, the dropdowns can be edited and moved.
    Did you ever find a way to over ride the error? I've noticed that a number of the DEFAULT entries within Sugar 6.4.4 have spaces in the item name, have a look at the lead_source_dom drop down list (Studio > Contacts > Fields > lead_source) You'll see a number of entries have item name listings that have spaces in them, however, when you try to create one with a space, you get the following error:

    Key - Must be alphanumeric, begin with a letter and contain no spaces.

    Surely this is a bug? An edit to the JS that is doing the checking should fix it, does anyone have any ideas on where/what JS is used to check the drop down item name entry?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 2011-10-14, 12:19 PM
  2. error in while accessing the dropdown editor
    By malayappa in forum Installation and Upgrade Help
    Replies: 1
    Last Post: 2010-04-05, 11:36 AM
  3. Dropdown Editor Error
    By bumrush in forum Installation and Upgrade Help
    Replies: 8
    Last Post: 2008-12-17, 11:48 PM
  4. Error dropdown editor
    By sk1983 in forum Help
    Replies: 2
    Last Post: 2008-04-04, 12:55 AM
  5. Error When Adding To Dropdown Menus
    By jnovak in forum Help
    Replies: 1
    Last Post: 2006-03-23, 07:58 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
  •