Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open the ADM table and use the filter to show all rows that have to be updated

    Image Modified

  2. highlight the rows you want to update (same as with Excel, use the shift key)

    Image Modified

  3. hit the button. It opens a dialog window

    Image Modified


    1. fields with value: all selected rows have the same value for that field


      Image Modified
    2. blank fields: at least one row shows another value for that field 

      Image Modified

  4. You want to update MatField 1 → enter the target value in that field. Once you do, the checkbox is activated.

    Image Modified

  5. hit
  6. MatField1 is updated.

    Image Modified


Info

The above works well when updating massive number of records with one value. E.g. setting all selected record to MTO stock policy.

For more complex mass changes, you want to touch base with Ion and give them a file to upload. Find a list of ADM tables that have been made MASS-change ready:

  • Production Standard
  • Production Standard Effectivity

Open the tables, filter on the data you want to update, and hit Image Added. It export the selected data into an Excel spreadsheet you can update and send over to Ion.

Content by Label
showLabelsfalse
max5
spacesMP
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "kb-how-to-article" and type = "page" and space = "MP"
labelskb-how-to-article

...