Doorgaan naar de website
OCLC Support

Mass change item barcodes

Learn how to mass change item barcodes in Amlib.


Before changing the Barcodes on the Items ensure that there is no likelihood of any Item Barcodes becoming identical to any Borrower barcodes. If there is a chance of this contact Customer Support prior to running the changes

Create a CSV file

  1. Export/create a CSV file with the OLD barcode in column A, and the NEW barcode in column B
  2. Right-click on the saved CSV file and open with Notepad
  3. Insert a line at the top of the file
  4. Type in: ItemOldBarcode,itemNewBarcode
  5. Save the file as ItemChange.csv

Back-up and log off

  1. Ensure that all users are logged off
  2. Ensure that NetOpacs and ZOpacs are stopped
  3. Make a backup all the Amlib databases

Run Rasissue

  1. On the Amlib server, go to into the Amlib folder
  2. Open Rasissue.exe
  3. From the main menu, select File > Login… - the Login dialogue box will open
  4. Type in the Login name: and Password: – the default is SYSADM/SYSADM (be sure you type it in UPPERCASE)
  5. Connect To: select your Test database (test it first in the Test database and then repeat it for LIVE if successful)
  6. Click the OK button – if connected the Main DB, Cat DB and Param DB headings will update with the names of the Amlib SQL databases

    From the main menu, select Conversions > Amlib Import > Change Barcodes > Items– the Amlib Barcode Change Import File – Open screen will open
  7. Choose the BarcodeChange.csv file and click on the Open button
  8. File Position = 0 / Max Records: 1000000
  9. Click the OK button – the file will be imported
  10. The following message will appear:z
  11. If there is a problem ,you can roll-back by restoring the databases from the backups made earlier
  12. Restart NetOpacs and ZOpacs and resume operations​​​​​​​