underdues script

Brian Crampton — Wed, 3 Oct 2007 10:19:20 +0100

I haven't heard of any problems with the script (yet).

The preselect of the script selects current loans that have a DUE_DATE between two dates. These dates are calculated based on the current date and number of days specified in the pre_days parameter.

Assuming this parameter was set to 7 and the current date time is 03/10/07 9:13 then the SQL condition would be

where CURRENT_LOAN= 'T'
and DUE_DATE < '11/10/07 9:13'
and DUE_DATE > '03/10/07 9:13'

The date in the future is actually the current date time + the pre_days value + 1 e.g. 8. I think the logic of adding 1 to the pre_days value is to insure that all the values for the last day are picked up.

In my example the time is 9:13. If I add 7 days to the current date time that would be 10/10/07 9:13 and this would mean that any items due on the 10th but after 9:13 would not be picked up. Adding a day ensures that all items due on the 10th will be selected by the preselect for further processing.

It is not possible to say in your case without more details but depending on the run time of the script and the time of the renewals (given that they could be renewals although the day and night in theory e.g. Prism or Talis Message) that extra day might be why you are picking up renewals.

The script does not distinguish between whether a current LOAN row is a issue or a renewal.

If you think the adding of one to the pre_days value is the problem then either reduce the value by one in the parameter file or remove the + 1 from the main.pl line below:

$query .= "and (DUE_DATE < dateadd(dd, " . ($pre_days + 1) . ", getdate())";

If you want to know what dates have been used in a run then add

print REPORT "Query:\n$query \n";

before the following line in the main.pl:

(@preselect_data) = &sql ($d, $query);

This will display the preselect SQL query in the script report (.rep) file.

Thanks

Brian Crampton
Developer, Talis

underdue letters

Bernadette Ryan — Tue, 2 Oct 2007 18:31:49 +0100

Hello All,
We have just started running the underdue letters script -daily. Thought all was ok but we seem to be generating underdue letters for those items which have been renewed in the past few days. Has anyone else used this and had any similar outcomes. Parameters seem correct any ideas?

Talis Developer Network - underdue letters - Comments

underdues script

underdue letters