Bug 42051

Summary: serialsMod.pl, a command-line script to change serials status
Product: Koha Reporter: Matthias Meusburger <matthias.meusburger>
Component: Command-line UtilitiesAssignee: Matthias Meusburger <matthias.meusburger>
Status: Needs Signoff --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: robin
Version: unspecified   
Hardware: All   
OS: All   
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Crowdfunding committed: 0
Crowdfunding contact: Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Attachments: Bug 42051: serialsMod.pl, a command-line script to change serials status

Description Matthias Meusburger 2026-03-10 13:28:21 UTC

    
Comment 1 Matthias Meusburger 2026-03-10 13:29:29 UTC
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