Editing Multiple Text Fields at once

10 posts by 3 authors in: Forums > CMS Builder
Last Post: February 9, 2016   (RSS)

By wevolutions - November 10, 2015

I need to edit about 10,000 text fields by adding in a number zero in front of all of them.

Example: My text field is now saying 12345 and i need them to say 012345 instead.

Can this be done on the CMS itself or can anyone suggest a simple solution.

Thank you.

By Damon - November 10, 2015

Hi,

If you have experience with mySQL you could run a mySQL command to prepend the field to add 0.

This could be done via phpMyAdmin or using the MySQL Console Add-On here:

http://www.interactivetools.com/add-ons/mysql-console/

Be sure to make a complete backup of your database first. And if you have a staging environment,  that would be preferred.

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By wevolutions - November 11, 2015

I have ZERO experience with mySQL. Any step-by-step assistance with this will be greatly appreciated. Thank you.

By Damon - November 11, 2015 - edited: November 11, 2015

Hi,

Step-by-step mySQL instructions isn't something we can provide via support. And with no mySQL experience I would strongly recommend against running any mySQL updates on a live site. 

We can help make the update through our consulting department.  Email the site details to consulting@interactivetools.com and we can provide you a quote.

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By wevolutions - February 9, 2016

I just sent an email to consulting@interactivetools.com concerning this. Please let me know if it was received and the next step in getting this sorted out. Thank you.

By wevolutions - February 9, 2016

Resent from another email address. khayam.trinicarsforsale@gmail.com

By ross - February 9, 2016

Hi Arif

Thanks for sending the email again. I got this one and replied to it already.

We can continue the conversation via that email thread.

Thanks!

-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/

By wevolutions - February 9, 2016

Apparently some of my emails are not going through. I sent a response. Let me know if you got it. Thank you.

By ross - February 9, 2016

Thanks for the heads up.  Looks like our emails are coming through fine.  We can continue the conversation via email moving forward.

-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/