Library management system support

Some CCM Tools users have kindly shared tips, workflows, and scripts to help you extract data from different library management systems for use with the Tools.

We would like to develop this page with more information of this kind. If you have any information which you would like to share with other CCM users, please contact us.


To produce a list of ISBNs from Alma Analytics which can be used to run a batch search in CCM Tools:

  1. In Alma Analytics run required stock list, including ISBNs
  2. Name and save file in Analytics
  3. Click on Export tab at top of page, then Data and CSV format
  4. Open in Excel and save to a specific location (i.e. desktop) with a specific file name as a CSV file
  5. Edit out any material/columns not required in document, leaving ISBNs to import
  6. Save
  7. Log in to the CCM Tools search area and select Batch Search
  8. Select 'Choose File' and browse to your saved file
  9. Select other limiters and run search

[With thanks to the University of York]

Innovative Millennium/Sierra

This is a very simple way of formatting data extracted from Innovative Millennium/Sierra systems so that it can be uploaded to CCM Tools. It uses just a single line of PERL to reformat data exported from a Millennium/Sierra review file (whether bib record numbers or ISBNs).

You may need to speak to your local systems people to find out what you need to do to get it to run on your PC, but it is well worth the effort – here at Leeds, it is saving us about 10 minutes each time we process a file.

The PERL command needs to be inserted into a “command file” (i.e. a file with file type .cmd) and can then be launched via the Windows “Run” command:

  1. Copy this line of PERL into a file named ccm-prepare.cmd so that windows can recogise it: c:\Perl\bin\perl.exe -ne “if ($.>1 && m/^\x22?(\w+)/i) { print $1.’,'; }” %1 > %2
  2. Using Create Lists, set up a review file of the bib records to be searched in CCM Tools
  3. Use the Millennium/Sierra “Export” command to create a text file containing just record numbers or ISBNs (020|a). For ISBNs, this file will contain a lot of superfluous data, and will have more than one ISBN per title. That is fine
  4. Using Windows “Run” (available from the Start Button), issue the command: “ccm-prepare <export filename> <output filename>” where <export filename> is the name of the file you have just exported from your review file
  5. The output file is now ready for batch searching in CCM Tools

You will probably need your own systems people to modify the command to reflect where PERL has been installed on your PC. They can also help to modify the command file to catch basic errors such as the input file not existing.

[With thanks to the University of Leeds]


A custom report to generate ISBN lists relating to particular subject areas defined by call number ranges. The required call numbers can be entered when you run the script.

The following has to be run in the ADM library and assumes that short bibliographic records (z13) have been set up there. It takes the ISBN from the short bibliographic record and removes from the display all characters except 0123456789 and X. This should remove extraneous data such as “(pbk)”. It does not resolve the issue of multiple ISBNs which may need to be sorted out manually in a spreadsheet.

set linesize 50
set pagesize 5000
set pause off
distinct(translate(z13_isbn_issn,’ABCDEFGHIJKLMNOPQRSTUVWYZabcdefghijklmnopqrstuvwyz/\!@#$%^&*().:-’,’ ‘)) ISBN
from z13,z30
where z13_rec_key=substr(z30_rec_key,1,9)
and z13_isbn_issn is not null
and z30_sub_library = ‘x’
and z30_collection = ‘xx’
and z30_call_no between ‘xxx’ and ‘xxxx’;

‘x’, ‘xx’, ‘xxx’ and ‘xxxx’ represent the parameters that need to be entered.

You need to capture the results, e.g. by using the Logging facility in PuTTY, and then copy them into an Excel spreadsheet.

[With thanks to the University of York]

Haven't found what you're looking for here?

Check our Support section and Help pages, or get in touch.