CCM Tools Project: Library Management System help

CCM users have shared tips, workflows, and scripts to help you use CCM.

If you have any information which you would like to share with other CCM users, please contact contribute.copac@jisc.ac.uk

Alma

Producing a list from Alma Analytics which can then be imported to the CCM for comparison of stock holdings:

  • In Alma Analytics run required stock list, including ISBNs.
  • Name and save file in Analytics
  • Click on Export tab at top of page, then Data and CSV format.
  • Open in Excel and save to a specific location (i.e. desktop) with a specific file name as a CSV file.
  • Edit out any material/columns not required in document, leaving ISBNs to import.
  • Save
  • Open CCM tool and select Batch Search
  • Browse “Upload File Name” for specific file.
  • Select other limiters and run search.

[Thanks to the University of York]

Innovative Millennium/Sierra

A very simple way of formatting data extracted from Innovative Millennium/Sierra systems so that it can be uploaded to the CCM Tool. 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. That file can be called what you wish; but let’s say that you call it ccm-prepare.cmd, then this is how you would create a file to upload to the CCM Tool.

  • 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
  • Using Create Lists, set up a review file of the bib records to be searched in the CCM Tool.
  • 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.
  • 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.
  • The output file is now ready for batch searching in the CCM Tool.

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.

[Thanks to the University of Leeds]

Aleph

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
select
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.

[Thanks to the University of York]