Setting Up Horizon to Use 13-Digit ISBNs

Horizon can handle 13-digit and 10-digit ISBNs in its processes, if you set it up to do so. (For example, you can search on 10 or 13-digit ISBNs to retrieve the correct item. Or, ISBNs on BISAC orders and in a Vendor Integration Protocol request truncate the ISBN to ten digits when necessary.)

To set up Horizon to use 13-digit ISBNs

1 On a Horizon staff client workstation, open the mq_index view in the Table Editor.
2 Choose the ISBN index that you want to set up to support 10-digit and 13-digit ISBNs.

Important: The index you choose must use the “isbn” processor or (if you are using a custom processor) use a custom processor that supports 13-digit ISBNs. If you have a different processor, you should understand why you are using the other processor and decide if you want to use the “isbn” processor instead. If you do not want to change the index to use the “isbn” processor, then skip steps 3-6, and move on to the next ISBN index. If you want to, you can test the results of setting up the index to use the 13-digit ISBN by changing the processor to the “isbn” processor and completing the steps in this task. Then, do searching and other tasks with that index. If you do not want those results, you can change the processor back to the original and reindex that index again.

3 Mark the Add Alternate ISBN box.

Marking this box guarantees that both a 13-digit ISBN and a 10-digit ISBN are in your index. (For example, if an ISBN is entered as a 10-digit ISBN, then Horizon generates the 13-digit version, and vice versa.) However, marking this box does not add the alternate ISBN to the MARC record.

4 In the Processor field, do one of these options:
If you are using the processors delivered with Horizon, be sure the processor is “isbn”.
If you are using a custom processor for ISBN indexes, be sure you are using that processor.

Important: If you have a custom processor for ISBN indexes, you must update the processor to handle the new 13-digit ISBN, or you will not see any of the 13-digit ISBN updates in the software.

5 Save your changes.
6 Make note of the index code for the ISBN index that you set up to handle 13-digit ISBNs.
7 Repeat steps 2 through 6 for each ISBN index listed for Horizon Index Definitions that you want to support 13-digit ISBNs.

Important: Do the following steps when your Horizon system is not being used or when your library has a period of low usage. This is because you must turn off transaction logging in order to reindex.

8 Turn off transaction logging.

If you do not turn off the transaction log, it may get full during reindexing and could lock reindexing and the Horizon system. To turn off transaction logging for both MS SQL and Sybase databases:

a Close the Horizon Client programs on this Horizon client staff workstation.
b Open an MS DOS window.

To open an MS DOS window, choose Start, Run, enter “cmd” and press ENTER.

c Change to the upgrade directory.

The default is C:\horizonupgrade\upgrad74.

For example, enter this command on one line:

cd c:\horizonupgrade\upgrad74\

d Enter this command on one line at the prompt:

setdbopt /sserver /ppassword /uuser /ddatabase /otrunc /ttrue

For example:

setdbopt /shorizon /pnice /usa /dhorizon /otrunc /ttrue

9 Reindex the ISBN indexes that you modified.
a In the MS DOS window, change to the upgrade directory, if you are not already there.

The default is C:\horizonupgrade\upgrad74.

For example, enter this command on one line:

cd c:\horizonupgrade\upgrad74\

b Enter this command on one line at the prompt:

Reindex /sserver /ppassword /uuser /ddatabase /m1 /iindexname,indexname,indexname

For example, using the common index names isbn, isbnb, isbnkw (which represent isbn, isbn alphabetical, isbn key word indexes), you might enter this command on one line:

Reindex /shorizon /pnice /usa /dhorizon /m1 /iisbn,isbnb,isbnkw

The “/m1” indicates that these are bib-based indexes. The server name to use is the same server name as when you log into the Horizon client programs.

c Let this process run until you return to the MS DOS prompt.
10 Turn on transaction logging.
a In the MS DOS window, change to the upgrade directory, if you are not already there.

The default is C:\horizonupgrade\upgrad74.

For example, enter this command on one line:

cd c:\horizonupgrade\upgrad74\

b Enter this command on one line at the prompt:

setdbopt /sserver /ppassword /uuser /ddatabase /otrunc /tfalse

For example:

setdbopt /shorizon /pnice /usa /dhorizon /otrunc /tfalse

11 If your library requires and uses transaction logging, make a full database backup of the database that you just ran reindex against using your normal procedures for making a SQL database backup.

This will allow the transaction backup process to resume again.

 

 


© 1998-2017 Sirsi Corporation