Look-Up Tool
The Look-Up tool allows you to search for information in the SFX database. It is most commonly used to look up an object’s corresponding ISSN, LCCN, or ISBN, since SFX uses these values to activate and deactivate object portfolios in the database.
The following are the elements that can be used in the Look-Up tool:
- ISSN
- eISSN
- ISBN
- LCCN
- TITLE
- OBJECT number
- LOCAL
- OCLC number
To start the Look-Up tool, from the Additional KB Tools section of the Setup and Administration area, click Look-Up Tool. The following window opens:
Look-Up Tool
To look up data using the Look-Up tool:
- Prepare the input file as a tab-delimited .txt file in Microsoft Excel. Place the values to be looked up in the first column.
- Specify the input file by clicking the Browse button and selecting the input file. You can also manually place the file in the SFX scratch directory.
- From the Input File Contains drop-down list, select the type of information in the input file.
- From the Look Up Corresponding drop-down list, select the type of information you want to look up.
- Click Submit to start the look-up process. If you selected a file in the Specify Input File field, the file is copied to the SFX scratch directory at the following location:
|
exlibris/sfx_ver/sfx4_1/<sfx_instance>/dbs/scratch |
The following window opens after the look-up is completed.
Look-Up Tool Report
An output file and a report file are generated. You can open them using Excel, Word, or a text editor. You can also choose to save them to your hard disk for later use. When saving the files, make sure the extension of the filename is .txt, to make it easier to open the file later.
The following is an example of an output file:
|
Transition |
0041-1191 |
|
Victorian Studies |
0042-5222 |
|
Theatre Topics |
|
|
Theatre Journal |
0192-2882,0003-0007 |
|
The Catholic Historical Review |
|
The output file contains the first column that was included in the original input file and a second column with the information found in the SFX database. In this example, the input file contained title information, and SFX looked up the corresponding ISSNs.
If no ISSN is found in the database, the second column remains blank. If more than one ISSN is found, the different ISSNs are listed, separated by a comma.
The following is an example of a report file:
|
The Catholic Historical Review |
no ISSN found |
|
Theatre Topics |
no ISSN found |
|
Theatre Journal |
multiple hits on ISSN |
The report file contains information about items in the input file for which no corresponding value could be found in the SFX database (or for which multiple hits were found).