Mass change refresh from catalogue
Learn how to mass change the stockitem data due to changes in the catalogue records in Amlib.
It is sometimes necessary to refresh the stockitem data due to changes in the catalogue record – this process is not automatic due to the fact that stockitem entries often deliberately differ from the catalogue and it is important that this information not be overwritten. This update can be done on a record-by-record basis, but it is also possible to update an entire group of records.
Note: In the following example we are only updating the Title data. If you already have a saved Where search containing a list of stockitems to be updated, skip ahead to step 10.
Create a saved file
First, you need to create a Saved file with a list of the stockitems to be updated.
- Launch the Amlib client
- Go to Stockitem module and select Application > Where... – the Stockitem Where Search screen will display
- Create a search that enables you to locate the items in question – for example: Stats Code = Adult Fiction
- Choose Search Column: Sts Code
- Choose Operator: =
- Type the Where condition: AF
- Click F7 QtoFile – the Stockitem Saved Query Results screen will display:
- Click the F1 New button
- In the Details column type in a name/description for your file – for example: MassCatUpdate
- Click the F3 Save button
- Highlight the Saved File and click the F9 Select button
- This will copy the results of the Where search into the Saved file – the following prompt will display: The ‘XXX’ file contains XXX stockitems.
- Click on OK to continue
Refresh from catalogue
The Saved File stockitems must now be refreshed from the catalogue.
- From the Stockitem module, select Application > StockitemAutoLink – the Stockitem Miscellaneous screen will display:
- Select * Refresh ALL items from the catalogue (excludes Periodicals and Orders)
- Click on the GetFile button and select your previously saved search from the Stockitem Saved Query Results screen
- Click the F9 Select button
- Click on the Start button – the Refresh prompt will display:
- Deselect all options – except Title
- Click on OK button – this will execute the Refresh and update the Titles on all the items in the file selected
- The following Item Rebuild prompt will then display: XXX Items Rebuilt.