These are the basic steps:
- Identify the items you want to change
- Identify the database column you want to update
- Enter the new data
- Run Readerware replace
- Check the results
On this panel you can select on of the following choices:
If you are typing in CD and DVD barcodes, you must ensure that you type in all digits. A US barcode currently contains 12 digits, a European barcode contains 13.
In the above example, you would enter 731458917724, you must include the digits to the left and right of the barcode.
Using a bar code scanner is often the fastest way to enter the list of items to update. Each day more and more companies make low cost bar code readers available to consumers. Check the bar code reader section on the Readerware web site for more information.
To enter the ISBN or UPC manually, simply type it in and press the enter key. Readerware will then validate the data and if valid, move it to the list below. If invalid, Readerware will display an error message. Readerware also uses audible queues to indicate a valid or invalid item number, so you don't have to keep looking at your screen each time you enter an item.
Normally when Readerware indicates that an ISBN is invalid, it means that you typed in the number incorrectly. Simply correct the mistake and try again. Very rarely Readerware will display the error, even when you entered the ISBN exactly as printed on a book. This is because the publisher included an invalid ISBN on the book. This does occasionally happen, especially on older books when the ISBN was new. You can tell Readerware to accept this ISBN anyway and try and find it by clicking on the Accept button in the dialog.
To scan in a barcode, refer to the instructions that came with your scanner. Simply ensure that the input field has the focus and scan. Readerware then receives the data, converts it if necessary and adds it to the list.
To delete an item from the list, select it and hit the Delete key.
If the Allow Duplicates
option is on, all books with the same ISBN/UPC will be updated. For
if you use the replace wizard to edit the title format for a movie, the
title will be updated on all items with this UPC.
You will see a drop down list of all database columns. Select the one you want to update. An editable field is then displayed and you can enter or select the new value. If you don't enter a value, the replace will erase the current contents.
When you select the column you want to change,
an appropriate editor is displayed where you can enter the new data.
most fields, this is an entry field or a list. But Readerware also
you to perform some very powerful operations on some columns,
Enter a new title
Reformat titles from "The Title" to "Title, The".
Reformat titles from "A Title" to "Title, A".
Enter a new value
Adjust existing values by a set percentage. For example, suppose you want to value your collection at 25% less that the Amazon retail price. You could use Readerware auto-catalog or auto-update to extract the price from Amazon. Then you would use the replace function to set the value to 75% of the current value. Readerware will update the value on each selected item.
Enter a new value
Increment copies by the specified amount.
Decrement copies by the specified amount.
Enter a new user number.
Automatically generate user numbers based on a pattern. You specify the pattern, the starting value and the increment. You use question marks in the pattern to identify where Readerware should insert the number.
To start with a simple example. If you specify a pattern of ?, starting value of 10000 and an increment of 100, Readerware will generate user numbers of 10100, 10200, 10300 etc.
You can specify other text in the pattern which is used as is. You can specify multiple consecutive question marks to control the width of the generated number. If you specify a pattern of ?????? each number will have at least 6 digits, Readerware adds leading zeros if necessary.
The following table lists some examples:
Pattern Starting Value Increment Numbers
? 10000 10 10010, 10020, 10030 ????? 100 10 00100, 00110, 00120 TOM-?????-BK 100 100 TOM-00100-BK, TOM-00200-BK, TOM-00300-BK BN-? 100 1 BN-100, BN-101, BN-102
Initially each item in the list will have a question mark icon displayed next to it. This indicates that Readerware has not yet processed this item. As it processes each item, Readerware changes the icon to indicate the results. The icons are:
- This indicates that the item has been changedIn addition to the icons, Readerware adds the title to each item. This is a very handy way to identify the items, it effectively gives you their location on your shelves.
- The item was not changed
- The item could not be found in your database. This can only happen when you input an item list
You can save the item list by clicking on the Save List button.
When you have reviewed the status of each item, click on the
button to proceed to the final page of this wizard.
Note that you can use the Back and Next buttons to toggle between the results and the auto-catalog summary page. When you are done, click the Finish button. Readerware will then display all the updated items in the main window. You can optionally review and edit these updated items. Click on the toolbar browse button to return to the full database display.
- Items Input Count - The number of items processed
- Items Updated Count - The number of items actually updated
- Errors - The number of errors
This statistics information and a complete item by item listing is also written to a log file, if user logging is enabled. You will find this file in your Documents->Readerware->Logs folder. You can view this file in any text editor