Versions Compared

Key

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

I need to update data in ADM (Web DP or Master Data). How do I do it in an efficient mattermanner?

Step-by-step guide

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

    Image Added

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

    Image Added

  3. hit the Image Addedbutton. It opens a dialog window

    Image Added


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


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

      Image Added

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

    Image Added

  5. hit Image Added
  6. MatField1 is updated.

    Image Added


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

...