Resetting the value of a check box field for all records
10 posts by 3 authors in: Forums > CMS Builder
Last Post: June 17, 2010 (RSS)
By gkornbluth - November 16, 2009 - edited: November 16, 2009
On January 1 (or another date of their choosing) my client would like to have the value of that field in all records automatically revert to “0"
Short of having them delete the field and then recreate it (which sends shivers up my spine), is there any way to automatically reset the value of a field for all records in the table?
Thanks,
Jerry Kornbluth
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
Re: [gkornbluth] Resetting the value of a check box field for all records
By Dave - November 16, 2009
I can't think of anything built in that could reset a field value like that.
If you are comfortable with MySQL and you have something like phpMyAdmin you can reset the value of a field with this query:
UPDATE cms_tablename SET fieldname = 0
Other ways to do it (especially if you wanted it to happen automatically) would be to make a plugin to do it.
Also, we're working on a "MySQL Console" plugin which will let you run custom MySQL queries from within CMS Builder (for advanced users).
interactivetools.com
Re: [Dave] Resetting the value of a check box field for all records
I was hoping to implement this in a way that the client could not break.
I guess that I'll reset the fields until a better solution appears.
Jerry
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
Re: [Dave] Resetting the value of a check box field for all records
By gkornbluth - June 12, 2010
Now that you've all been working with plugins for a while, I thought I'd revisit this one again.
Thanks,
Jerry Kornbluth
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
Re: [gkornbluth] Resetting the value of a check box field for all records
By carl2 - June 15, 2010
I've had a look into this and I could make a plugin that adds something to the 'Advanced Command' dropdown on the table list page. That way you or your client could manually reset the field. Would that be okay for you?
Carl
Re: [carl] Resetting the value of a check box field for all records
By gkornbluth - June 15, 2010
That would be great as long as it was available to admins only, not editors. Possibly by a "Super Admin" only or a special 2 step process?
It's a pretty powerful command and shouldn't be able to be accessed easily or casually.
Just my paranoia about the "oops" factor.
Best,
Jerry
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
Re: [gkornbluth] Resetting the value of a check box field for all records
By carl2 - June 16, 2010
A 'super-admin' user would be more convoluted and would require changes to your database and so on, though. However I can certainly make it only accessible to admin users.
Alternatively if you really don't want anyone but one user to have access, it could just be a standalone script with some obscure URL. So you or your client would visit /some_script_name.php to perform the update. You could also automate that with a cronjob.
Carl
Re: [carl] Resetting the value of a check box field for all records
By gkornbluth - June 16, 2010
I guess I could create a "Super Admin' with the membership module, the same way I've restricted page access based on membership levels.
I'm a little gun shy when it comes to globally changing anything in the database. So I really appreciate your help and look forward to seeing what you come up with.
Best,
Jerry
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
Re: [gkornbluth] Resetting the value of a check box field for all records
By carl2 - June 17, 2010
I've attached a plugin you can use that will add this functionality. You will need to add some information at the top: the table and field name that you want to reset, and the value to reset it to. For example, if you want to set the value of 'paid' to '0' on all records in the 'accounts' table, add this near the top where the comments tell you to:
array( 'tableName' => 'accounts', 'fieldName' => 'paid', 'resetValue' => 0 )Once you have enabled the plugin, in the 'Advanced Commands' section, there will be the option to set the fields on all records.
Right now it will only make the option available to admins. If you wanted to have a 'super admin', then you could add a checkbox field to your Accounts section called 'super_admin' and change the check on line 27 to
if ( !$CURRENT_USER['super_admin'] ) return;Let me know if this works for you or if you have any problems getting it to work!
Carl
Re: [gkornbluth] Resetting the value of a check box field for all records
By carl2 - June 17, 2010