Mass change item barcodes
Learn how to mass change item barcodes in Amlib.
Warning
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
- Export/create a CSV file with the OLD barcode in column A, and the NEW barcode in column B
- Right-click on the saved CSV file and open with Notepad
- Insert a line at the top of the file
- Type in: ItemOldBarcode,itemNewBarcode
- Save the file as ItemChange.csv
Back-up and log off
- Ensure that all users are logged off
- Ensure that NetOpacs and ZOpacs are stopped
- Make a backup all the Amlib databases
Run Rasissue
- On the Amlib server, go to into the Amlib folder
- Open Rasissue.exe
- From the main menu, select File > Login… - the Login dialogue box will open
- Type in the Login name: and Password: – the default is SYSADM/SYSADM (be sure you type it in UPPERCASE)
- Connect To: select your Test database (test it first in the Test database and then repeat it for LIVE if successful)
d - 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
- Choose the BarcodeChange.csv file and click on the Open button
- File Position = 0 / Max Records: 1000000
- Click the OK button – the file will be imported
- The following message will appear:z
- If there is a problem ,you can roll-back by restoring the databases from the backups made earlier
- Restart NetOpacs and ZOpacs and resume operations