Results 1 to 4 of 4

Thread: Case number increment automatically

  1. #1
    biplob.91 is offline Junior Member
    Join Date
    Feb 2009
    Posts
    2

    Default Case number increment automatically

    Hi,

    I am using SugarCRM 5.2 and its working well in windows server. I have made some changes in case module.I had made the case number field as textfield.Earlier it was auto incremented field.
    Earler when new cases is created case number is incremented automatically.But now I have to enter case number manually.I had made changed in admin panel -> custom module. But now I have forgotten where I had made changes.I want case number to be increment automatically.
    From where I made change again so that case number change automatically as I create new case. I have 3000 case created earlier.

    Please suggest me from where I can change the settings.I am attaching the screenshot below.


    Thanks in advance..
    Attached Images Attached Images  

  2. #2
    kuske's Avatar
    kuske is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    Germany
    Posts
    2,597

    Default Re: Case number increment automatically

    The vardef of an issue (e.g. case) is:

    $vardefs = array (
    'fields' => array (
    $_object_name . '_number' => array (
    'name' => $_object_name . '_number',
    'vname' => 'LBL_NUMBER',
    'type' => 'int',
    'len' => 11,
    'required' => true,
    'auto_increment' => true,
    'unified_search' => true,
    'comment' => 'Visual unique identifier',
    'duplicate_merge' => 'disabled',
    'disable_num_format' => true,
    ),

    from /include/SugarObject/templates/issue/vardefs.php
    Harald Kuske
    Pre-Sales Engineer Central Europe

    SUGARCRM Deutschland GmbH
    Erika-Mann-Str. 53, 80636 Munich, Germany
    Email: hkuske@sugarcrm.com
    Home: http://www.sugarcrm.com


  3. #3
    biplob is offline Senior Member
    Join Date
    Feb 2009
    Posts
    61

    Default Re: Case number increment automatically

    hi,
    Thanks for the reply ,but the code you have provided is same as I have in /include/SugarObject/templates/issue/vardefs.php .Not a single change in the code.
    Please give some advice from where I solve it.

    Thanks in advance

  4. #4
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Case number increment automatically

    You need to create an extended vardefs for Cases, override the case_number field and set the attribute

    PHP Code:
    'auto_increment' => false
    Then go to Admin -> Repair -> Quick Repair and Rebuild

    Cheers
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatically email Case Resolution Notes on Case Closed
    By Tayler in forum Feature Requests
    Replies: 7
    Last Post: 2009-10-02, 10:59 AM
  2. Auto Increment a Custome Campaign number
    By Glitch in forum Developer Help
    Replies: 3
    Last Post: 2009-05-18, 05:00 AM
  3. Replies: 3
    Last Post: 2008-01-20, 11:13 AM
  4. Case Number Auto increment
    By jeipi in forum Help
    Replies: 0
    Last Post: 2005-06-16, 05:45 AM

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
  •