Batch searching

In the Connexion client, under the Batch menu, select Enter Bibliographic Search Keys.
Select Import, and select the text file you’d like to import. A prompt will ask if you want to delete the original import file. Make sure to select No.
Make sure you save the batch.
Under the Batch menu, select Process Batch.
Select the file containing the search keys you entered by clicking the box next to it. [If you save the search keys to your default save file, you will see a red check mark. You do not need to select an authority file.] Select Online Searches in the Process box. Click OK.
When the search is complete, a Batch Search Report will display. You will need to manually search for any titles that come up as errors. This report will also show you if more than one record matched any of your searches. It may be helpful to print this report if you have a lot of errors or searches with multiple matches.
When you open your save file again, these records will be there.
If you want to export a batch of records from OCLC to MARCEdit, you must go into Tools →Options, and change the Destination to File:(Prompt for file name). Then click Edit to name the file and location. Don’t forget to change it back after the files have been exported.

If the vendor provides a list of OCLC numbers in a spreadsheet, you will need to put them in a text file. You can just highlight the column and copy and past into Notepad.
Save the file. I usually name it vendor date, in case I need to find it later.
You will either need to select OCLC number as the default index or insert an asterisk before each number.

If you have a set of MARC records with OCLC numbers included, you can extract a list to batch search using MarcEdit.

File → Select Individual Record(s) To Make → Display Field 035
Select all records that contain an 035 field
Generate Report → Save As .txt (tab delineated)
Open file in Excel
Replace all prefixes [ i.e. \\$a(OCoLC) ] with an asterisk (Ctrl H is the keyboard shortcut in Excel)
Copy column of numbers into a .txt file
Follow the above instructions for the general process

Searching by ISBNs will often retrieve many, many hits, and have at least a few errors. This is because eISBNs appear on records for print editions. Several records may also exist for the electronic version, including records cataloged in a language other than English. You will probably want to limit the search to records cataloged in English.
If you have a spreadsheet with the ISBNs, insert a column before the ISBN column. Fill in this column with ll: (that’s two lowercase Ls). Copy these two columns together, and paste them into Notepad.
In Notepad, you may need to remove any space between the colon and the ISBN, using Find and Replace. You can copy the space between the two, paste the space into the “Find what” and leave the “Replace with” blank. Then click Replace All. This should delete all the spaces.
Save the file. I usually name it [vendor][date], in case I need to find it later.

If the urls are in a spreadsheet, add a column before the urls; fill this column with am:. If you are pulling the urls from a non-OCLC MARC record set, paste them into a spreadsheet and add the am: column. Copy these two columns together, and paste them into Notepad.
In Notepad, you may need to remove any space between the colon and the ISBN, using Find and Replace. You can copy the space between the two, paste the space into the “Find what” and leave the “Replace with” blank. Then click Replace All. This should delete all the spaces.
Save the file. I usually name it [vendor][date], in case I need to find it later.

Library Staff Wiki