Mass update accounts, help please

[aaaa1es2000]

hi,
i´m using Bitrock sugarcrm 4.5.1 in windows xp pro,

in ACOUNTS, i have create a new "custom field" with this name "xxx" and i want to update all my accounts xxx whith a value yyy.

how can i do that.

tks a lot

[kenlyle]

If your database is MySQL running locally under Windows, one really simple way is to install the ODBC driver, and use Access to do your updates, custom reporting, exports, etc.

Once you have the queries, you can also paste them into PHPMyAdmin to run them, with minor modifications.

[Angel]

hi,
i´m using Bitrock sugarcrm 4.5.1 in windows xp pro,

in ACOUNTS, i have create a new "custom field" with this name "xxx" and i want to update all my accounts xxx whith a value yyy.

how can i do that.

tks a lot

Use a MySQL admin utility such as phpMyAdmin or SQLYog and connect to the Sugar database.

Once connected, execute the following query, replacing "yourfield" with the actual name of your custom field:

UPDATE accounts_cstm SET youfield_c = 'yyy';