ill_memo_overdue_v2

The ill_memo_overdue_v2 script generates overdue loan letters for requesters.

It is a replacement, released with Alto 5.4, for the original ill_memo_overdue script.

Criteria on which this script will select are:

Usage

The script's source code is located in /usr/opt/blcmp/talis/mis/ill_memo_overdue_v2. To run in the script log on as report or talis and enter the following command:

report -pill_memo_overdue_v2 -n<start processing> -b<begin date> -e<end date> -o<output file> -r<report directory> -d<database> -a<filename> -s<data directory>  

Standard script arguments are described here. The remaining arguments for this script are described in the following table.

Argument

Description

-n

This argument states the start point of the run in terms of an ILL_ID. Its purpose is to prevent unnecessary processing of ILL_IDs which are "lower" in the table. It could become an important argument if the main Interloan table becomes large. For example, after running Interloans for 3 years you may decide to always run using -n100000 where ILL_ID 10,000 represents the end of the first year. That is, all reports should bypass the first year of data.

Specifying a starting point for processing may be done in one of two ways:

  • An integer, indicating that the script should start processing at a specific Interloan request ID or Report ID.

  • The word "LAST", indicating that the script will effectively process only the records added since the last time it was run

The use of "-nLAST" should be adopted with caution. Its use is particularly suited to memos which produce outputs based on the chronological receipt of Report Codes

-b

The argument "-b" is used to specify the start date to be used for an inclusive date range. This is used with the "-e" argument . If not given, processing will start at the beginning (i.e. at the Interloan request with the earliest date on the database).

-e

The argument "-e" specifies the end date in an inclusive date range. This is used with the "-b" argument. If not given, processing will end when all Interloan requests have been processed up until (and including) those on the current date.

Parameter file

The parameter file is held in the /usr/opt/blcmp/talis/mis/param directory. The following additional parameters are included:

Parameter

Description

required_codes

This parameter lists report codes which must have been added to the request in order for the script to select the request for processing.  Report codes should be entered in uppercase and separated by commas with no spaces.  The codes must exist in the ILL_REPORT_CODES table.