Created attachment 195079 [details] [review] Bug 42051: serialsMod.pl, a command-line script to change serials status Usage: serialsMod.pl Changes the status of serials Options: --h --help -? Help message --verbose -v Verbose mode --confirm -c Confirm: without this option, the script will report on affected serial issues without modifying database --where -w Adds "WHERE" SQL condition --from_status -f Serial status (repeatable). See list below. --to_status -t Change issue to given status. --biblionumber -b Consider the given biblio --subscriptionid -s Consider the given subscription Status list: EXPECTED => 1, ARRIVED => 2, LATE => 3, MISSING => 4, MISSING_NEVER_RECIEVED => 41, MISSING_SOLD_OUT => 42, MISSING_DAMAGED => 43, MISSING_LOST => 44, NOT_ISSUED => 5, DELETED => 6, CLAIMED => 7, STOPPED => 8, Examples: perl misc/cronjobs/serialsMod.pl -v --from_status 2 --from_status 1 --to_status=6 --confirm perl misc/cronjobs/serialsMod.pl -v --where="planneddate >= NOW()" --to_status=3 --confirm