View Issue Details

IDProjectCategoryView StatusLast Update
597RackTablesdefaultpublic2012-10-20 11:49
ReporterToddDTaft Assigned To 
PrioritynormalSeverityfeatureReproducibilityalways
Status closedResolutionwon't fix 
Product Version0.19.14 
Summary597: Add method to do bulk updates
DescriptionPlease add a way to do bulk/mass updates via the normal web interface. e.g. I would like a way to update the hardware warranty expiration date on a large number of machines at once without having to do it one-by-one and open up each machine page or resort to a raw database (SQL) command.
TagsNo tags attached.

Activities

infrastation

infrastation

2012-10-20 11:49

administrator   ~0000923

I doubt there's a volunteer to implement this as requested (solely by means of GUI), but perhaps the following solution may fit:

1. Build a list of objects using the tag/predicate filter panel.
2. Copy the current selection criteria to the "extra" textarea of the panel (there's a button that does it in 0.20.x).
3. Use the following PHP script to update the objects as required:

<?php

$script_mode = TRUE;
include '/usr/local/racktables/wwwroot/inc/init.php';

$text = '{something} and {something else}'; # copy from the textarea

foreach (scanRealmByText ('object', $text) as $object)
    commitUpdateAttrValue
    (
        $object['id'],
        21, # support contract expiration
        strtotime ('09/01/2013')
    );

?>

Closing.

Issue History

Date Modified Username Field Change
2012-09-06 21:43 ToddDTaft New Issue
2012-10-20 11:49 infrastation Note Added: 0000923
2012-10-20 11:49 infrastation Status new => closed
2012-10-20 11:49 infrastation Resolution open => won't fix