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