Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

3. Make a separate subset of this list for CLR only records with Bib Loc=main(Item location code starts with C).

34. Go to Millennium StatisticsStatisics. Edit the save query called "YTD code check"Call no analysis of titles used last year" so that it analyzes your the current list. The purpose of this check to look for coding errors.

Run and print statistical reports for the Moellering lists.

Panel

S>Create STATISTICAL reports
B>Use BOOLEAN review file
O>Data based on OTHER fields (Do not split multi records)
Print location report
Print code report

C>Data based on call numbers. (Call no. in item record has priority.)

Panel

Print report. (Route report to Librarians)

3. Run and print statistical report for the entire lists.
S>Create STATISTICAL reports

Panel

B>Use BOOLEAN review file
O>Data based on OTHER fields (Split multi records)
Print location report.

4. Once reports are printed, return to main menu. Select:
D>DATABASE maintenance

...

Save the query before using it in case you want to rerun it on the same list.

5. Export the Call number report to G:\Moe\Collection Development\Item use reports. Name the file SCAT Items Used year. Delete the price column from the report because it is meaningless. Export the Itype similarly. (In future the status report may be of interest to Circulation.)

6. Once the reports are exported and saved,open up telnet access to Galileo. From the main menu, sdelect:

Panel

D>DATABASE maintenance
R>RAPID updating
I>ITEM records
Galileo will ask, "Do you want to maintain YTDCIRC …"
Select y (yes) then C (continue)
Galileo will ask, "Zero the YTDCIRC totals?"
Select y (yes).
Then select
R>REPLACE 2YRCIRC with number in YTDCIRC
Galileo will ask, "Do you want to use a Boolean review file?"
Select y (yes).
Make sure you chose the file for all the records , not just Moellering's records.

...


Then select U>Update

7. Once rollover has been completed, return to lists and delete the two review files.

...