How to mass update the text fields?

Hi,

How to mass update the text fields in sugar 7.2.x?
There is no option from to studio of Mass update for text fields.
Can somebody advise?

Thank you,
Usman

0 Chris Hall over 11 years ago

Hi Usman, I have a similar requirement and am thinking that I would do this by connecting to the MYSQL database and updating with a SQL script. I know it's possibly better practise to do it through the application but I don't know of a way. I am not sure how to connect to the MYSQL db. If you can find that out then I can help you. Thanks Chris
0 Frozen Frozen over 11 years ago

Hi Usman,
You go to root/custom/extention/modules/module/Ext/Vardefs/fileds.php
you edit: massupdate = 1;
it can help you.
Thanks
0 Usman Saeed over 11 years ago

Thank you Frozen for the help.
My business logic was like that.
Client want to see the contact-name,email and Mobile on the Opportunities list view so that he can export the opportunity with the contact details.

I created the text fields and put formula of related contact field.
So, I need to mass update the fields.
In the list view I selected all the records and than recalculate the values instead of mass update and it did the trick.

@chris for querying to database. You can use logic hooks, esp before_save or after_save.
http://support.sugarcrm.com/02_Documentation/04_Sugar_Developer/Sugar_Developer_Guide_6.5/03_Module_...
check this and in the hook function you can use the global db variable to do custom queries eg.
global $db;
$db->query("SELECT /update/ insert query");
for fetching $db->fetchByAssoc($query);

Thank you, for helping.
Usman