Results 1 to 10 of 10

Thread: need help: removing standart fields from massupdate

  1. #1
    smoothumut is offline Senior Member
    Join Date
    Apr 2010
    Location
    Turkey
    Posts
    25

    Default need help: removing standart fields from massupdate

    Hi all,
    can anybody help me on how to remove uncustomizable fields from massupdate layout please in sugar 5.5?
    thanks for now
    regards

  2. #2
    salesagility's Avatar
    salesagility is offline Sugar Community Member
    Join Date
    Aug 2006
    Location
    UK
    Posts
    2,379

    Default Re: need help: removing standart fields from massupdate

    You cannot achieve this for standard sugar fields using studio. you would have to amend the vardef file for the modules that you wish to change the mass update panel for.

  3. #3
    smoothumut is offline Senior Member
    Join Date
    Apr 2010
    Location
    Turkey
    Posts
    25

    Default Re: need help: removing standart fields from massupdate

    thanks for the reply SalesAgility,
    but can you please explain it simply more regarding which php i should edit and what i should do.
    as an example i want to remove 'converted' field from massupdate layout.
    appreciate for any help,
    regards
    Last edited by smoothumut; 2010-04-30 at 12:23 PM.

  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: need help: removing standart fields from massupdate

    Create the folders and file, if don´t exist:
    custom/Extension/modules/<ModuleName>/Ext/Vardefs/somescript.php

    PHP Code:
    <?PHP
    $dictionary
    ['<BeanName>']['fields']['<FieldName>']['massupdate'] = false;
    ?>
    Obviously go to Admin -> Repair -> Rebuild Extensions

    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.

  5. #5
    smoothumut is offline Senior Member
    Join Date
    Apr 2010
    Location
    Turkey
    Posts
    25

    Default Re: need help: removing standart fields from massupdate

    Thanks for the very clear answer Andopes,
    but i have one more very very basic question that might make you laugh or get you crazy.

    what is Beanname?? what should i put instead of it in the php file i have created? do you mean module name like 'cases' or something different??

    thanks for your understandings
    Regards

  6. #6
    LucioFiamingo is offline Sugar Community Member
    Join Date
    Jul 2009
    Posts
    29

    Default Re: need help: removing standart fields from massupdate

    I have the same problem and try the code:

    <?PHP
    $dictionary['Contacts']['fields']['lead_source']['massupdate'] = false;
    $dictionary['Contacts']['fields']['reports_to']['massupdate'] = false;
    $dictionary['Contacts']['fields']['sync_contact']['massupdate'] = false;
    ?>

    Hovewer, after try repair the follows errors appear:

    Executing repair query: Query Failed:ALTER TABLE contacts add column NULL ,
    add column NULL::MySQL error 1064: You have an error in your SQL syntax;
    check the manual that corresponds to your MySQL server version for the right
    syntax to use near 'NULL ,add column NULL' at line 1

    Any help?

  7. #7
    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: need help: removing standart fields from massupdate

    Quote Originally Posted by smoothumut View Post
    Thanks for the very clear answer Andopes,
    but i have one more very very basic question that might make you laugh or get you crazy.

    what is Beanname?? what should i put instead of it in the php file i have created? do you mean module name like 'cases' or something different??

    thanks for your understandings
    Regards
    Bean name is the class of the module. For example the LucioFiamingo code.
    He tried to setup $dictionary['Contacts'].
    Actually Contacts is the name of the module, Contact is the name of the bean (BeanName).

    To make sure what is the bean name take a look at default vardefs of the module you are going to customize.

    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.

  8. #8
    smoothumut is offline Senior Member
    Join Date
    Apr 2010
    Location
    Turkey
    Posts
    25

    Default Re: need help: removing standart fields from massupdate

    Thanks a lot Andopes,

    You are a REAL Hero...

    My Best Regards

  9. #9
    LucioFiamingo is offline Sugar Community Member
    Join Date
    Jul 2009
    Posts
    29

    Default Re: need help: removing standart fields from massupdate

    Dear Andopes,

    I change the code as you suggest:
    <?PHP
    $dictionary['Contact']['fields']['lead_source']['massupdate'] = false;
    $dictionary['Contact']['fields']['reports_to']['massupdate'] = false;
    $dictionary['Contact']['fields']['sync_contact']['massupdate'] = false;
    ?>


    but still have problems with DB update:

    Executing repair query: Query Failed:ALTER TABLE contacts add column NULL ,add column NULL::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL ,add column NULL' at line 1

    What do you suggest to do?

    Thanks

  10. #10
    LucioFiamingo is offline Sugar Community Member
    Join Date
    Jul 2009
    Posts
    29

    Default Re: need help: removing standart fields from massupdate

    I fix the problem : report_to doesn't exist, I set report_to_link instead. Now no errors are swown, however the code has no action...
    Any help?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. change fields in massupdate
    By user1000 in forum Developer Help
    Replies: 9
    Last Post: 2009-03-26, 05:49 PM
  2. non-db fields are considered for massupdate
    By SugarDev.net in forum Developer Help
    Replies: 0
    Last Post: 2009-01-15, 04:02 PM
  3. You CAN massupdate non-dropdown fields
    By tj@estreet.com in forum Help
    Replies: 0
    Last Post: 2006-10-03, 05:01 PM
  4. Customize MassUpdate fields
    By viking in forum Developer Help
    Replies: 6
    Last Post: 2005-12-21, 09:17 AM
  5. Replies: 0
    Last Post: 2005-12-19, 08:31 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
  •