Update multiple records

3 posts by 2 authors in: Forums > CMS Builder
Last Post: December 19, 2013   (RSS)

By aev - December 18, 2013

Hi,

we need to update 500 records with new numbers (prices), does anyone have great tip for speeding up this task?

It would be great to edit the records directly in the CMSB admin/list-view with a ajaxified-apply button for each record. Or a save button for a big editable admin page, but I guess that would be a bit complicated. Can IT make any of these features through consulting?

Another approach that could work would be a variant of the "Save & Copy" plugin called "Save & Edit next". Can that be done?

-aev-

By Damon - December 18, 2013

Hi aev,

How often will you need to update these prices?

It's a fairly large number of updates so I here is one approach that would save a whole lot of time over editing each record:

  1. Export the records with CSV Export.
  2. Open in Excel and edit the prices.
  3. Upload the updated csv file back into CMS Builder with CSV Import

Here are the links to each Add On to check out:

CSV Export: http://www.interactivetools.com/add-ons/detail.php?CSV-Export-1005
CSV Import: http://www.interactivetools.com/add-ons/detail.php?CSV-Import-1041

Would this method work for you?

If not, let me know so we can explore other options.

Thanks!

Cheers,
Damon Edis - interactivetools.com

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