Command-line Utilities bugs

  • Blocker
  • Critical
  • Major
  • Normal
  • Minor
  • Trivial
  • Enhancement
  • New Feature

New 131

bulkmarcimport.pl -insert fails to add MARC field 999
Cronjob cleanup_database.pl doesn't delete old jobs either by age or type
Problem with OAI AutoUpdateSets during marc ordering process
koha-create needs options to set up encrypted database connections
fix_invalid_dates.pl missing a --help switch
batchRebuildItemsTables.pl should not rebuild holds queue
printoverdues.sh requires unavailable cli tool xhtml2pdf
koha-create does not default to --create-db
Renewal message is sent twice during auto-renewal
Add help to fix_invalid_dates.pl
Remove kohalib.pl from recall cronjobs
Add logging for uncaught exceptions in autorenewal cron
misc/cronjobs/notice_unprocessed_suggestions.pl should check fund as an owner
koha-restore file-exists
8577
GC
build_holds_queue.pl needs command-line options for help, verbosity, and summary
search_for_data_inconsistencies.pl: Can't call method "get_column"
misc/admin/koha-preferences should have pl extension
UNIMARC_sync_date_created_with_marc_biblio.pl is setting MarcFieldForModifierName to CLI
15121
GC
runreport.pl cronjob ought to let you specify multiple email addresses
bulkmarcimport.pl should ignore MarcFieldFor* sysprefs
cleanup_database does not allow to purge data created today
12719
GC
Fix bulkmarcimport.pl documentation
import_patrons command line script should accept quote_char or document that double quotes are required
Some tables not available to AUTO_RENEW letter
17608
GC
Fix behaviour of bulkmarcimport.pl -insert
14384
MJ
Add option to koha-run-backups, to disable koha instance during backup
8900
GC
link_bibs_to_authorities.pl --test updates auth_header records with AutoAddAuthorites on
koha-zebra doesn't properly stop Zebra
cancel_unfilled_holds.pl should skip cancelled holds
sanitize_records.pl can't find rebuild_zebra.pl
purge_suggestions.pl deletes ongoing suggestions
koha-reset-passwd fails
Don't dump objects in verbose output from import_patrons.pl
Create a script that lists bibliographic records that are not linked to any authority
koha-run-backups deletes old backup files based on number of hours since modification - not date of modification
overdue_notices.pl wrongly reports "terms were not matched and replaced"
Use of uninitialized value $mail{"Subject"} in concatenation (.) or string at /usr/share/perl5/Mail/Sendmail.pm
Add check for invalid holds linked to deleted records to inconsistencies script
Output of export_borrowers with all fields cannot be imported
13317
GC
tools/export.pl should show help when executed with no args, from CLI
10377
GC
fix_unimarc_100 could be improved with 210$d values
Fix POD in search_for_data_inconsistencies.pl
Add POD to audit_database.pl
Add --processes to "man" page for koha-elasticsearch
Fix POD for bulkmarcimport.pl --delete --authorities
16972
GC
./misc/sip_cli_emulator.pl should list mandatory vs. optional command line options in its usage section.
Add --skip-no-sms parameter to borrowers-force-messaging-defaults.pl
bulkmarcimport.pl: Add option to clean deleted* tables when -d is used
bulkmarcimport.pl: When deleting authorities prior to import, reset auto_increment
Make audit_database.pl skip koha_plugin_* tables
Add where parameter to delete_patrons.pl
28740
TCA
Delete old ILL requests with cleanup_database
38629
JD
Update sftp_file.pl to support the new SFTP configurations page
Add ability to anonymize resolved accountlines
Add a command line tool to import many cover images from a zip file
Add --branchcode to writeoff_debts.pl
Make long overdue item type options configurable in interface
automatic item modification needs report function
stockrotation.pl help message is confusing for --send-all parameter
Add option to expire patrons who were updated in the update_patrons.pl cron job
It would be nice to have a command line tool that does bibliographic deduplication with different set parameters
Allow membership_expiry.pl to limit based on patron attribute
delete_patrons.pl to delete all patrons or provide reason why they're not deleted
Add option to exclude certain types of url in check-url-quick.pl
problems with .ris file when when trying to export the material identified as article/analytics
Add option -DAYS to delete_patrons.pl
[Omnibus] Refactor overdue_notices.pl
Let cleanup_database.pl delete discharged patrons after X days
Allow RestrictPatronsWithFailedNotices to take a days variable, set in intranet
Add file option to delete_items.pl
38427
MDR
(38408 follow-up) Additional fixes in rebuild_zebra.pl and koha-rebuild-zebra
restrict_patrons_with_failed_notices.pl cronjob should take a --days parameter
Write off credits automatically
add note to accountline when using writeoff_debts.pl
37648
RB
connexion_import_daemon.pl should set defaults for overlay, nomatch and item action and provide a warning
37095
JD
Add a cli for creating a user that returns the user + an api key
remove_unused_authorities.pl timeout error that's not a timeout error
longoverdue maxdays should be configurable in interface
Add option to log a run of export_records.pl to the Koha cron log
[Omnibus] Rewrite koha-restore
create_analytical_rel.pl doesn't set host biblionumber in 773$0
16063
GC
logic from overdue_notice.pl should be moved into a module
Add a script to export images from the db
koha-restore could use a db-only option
Make koha-restore restore only files, not db
15664
GC
koha-restore: Allow database dump to be restored to another Koha instance
Build in ability to send output of patron import command line job to an email address
koha-preferences improvements
15625
MJ
Add CLI tool to enable/disable public Z39.50 service for a Koha instance
5069
CC
Auto-create authorities for unlinked headings
Add a script to manage plugins from the command line
connexion_import_daemon.pl should flush logs to make them more useful / timely
Add option to use mysqldump parameters with koha-dump
Batch item modification run at the command line (cronned).
Option to add a restriction when running the update patron category cron
bulkmarcimport.pl -d foreign key constraint fails when entries in issues exist
recreateIssueStatistics.pl should (optionally?) ignore the anonymous borrower
Improve link_bibs_to_authorities.pl by including 4xx in matching
It should be possible to extract a MARC file of deleted bibliographic records
Add capitalization checks for branchcodes and categorycodes to inconsistencies script
bulkmarcimport.pl ignore items info when using -update
16533
MJ
Prep koha-preferences script for /usr/sbin
2878
FD
cloud-kw.pl: should use HTML template
15387
GC
check-url.pl script to support cookies
Add verbose option to cronjob purge_suggestions.pl
koha-run-backups can't use option --uploaded_files from koha-dump
14162
TCA
Instance creation information on YAML
Some libraries don't use print notices
longoverdue.pl should not set 'datereturned' when --mark-returned option is used.
serialsUpdate doesn't create all late issues
Add authority records to sitemap
Add a script to automatically deprecate replacement costs based on age
16528
KMH
Add ability to parallel process fines to fines.pl
More options for reconcile_balances.pl
Script to search for data inconsistencies [omnibus]
16375
MJ
Add arg to 'koha-upgrade-schema' to run on a specific 'updatedb.pl' file
23088
MR
Stockrotation full_report should use 'notices'
6381
GC
Add script to populate 856$q field based on contents of 856$u
Data inconsistencies - "Item type" and "item type for older issues" in subscriptions
12996
GC
Tool to bulk export patrons images
Data inconsistencies - records without a MARC subfield mapped with biblio.biblionumber
bulkmarcimport.pl fails with UNIMARC authorities but works with XML
Running of koha-* scripts should be logged
17283
GC
Batch file "upload" script
16879
GC
Use ImportBatch routines in bulkmarcimport
13217
MJ
fix koha-upgrade-schema to work with git/dev installs
16753
GC
/misc/mod_zebraqueue.pl should allow 'recordDelete'
14043
GC
fines.pl does not have perldocs
11871
GC
rebuild_zebra.pl -r requires at least one record to clear index
12919
CC
Automate collecting all records added and deleted from the catalogue
add koha-cronlogaction script, which will call C4/Log::cronlogaction with the remaining command line arguments set as "info" in the logs.

Assigned 9

41260
ET
Running holds reminder cronjob with both triggered and holidays parameter may leave hold reminders unformed
40802
BW
cleanup_database is broken with ChildNeedsGuarantor
Greater/smaller than in DB password is problematic
21487
FS
Add option to disable CataloguingLog syspref in UNIMARC_sync_date_created_with_marc_biblio.pl
31035
FS
Script to update OPACSuppression field depending on hidden items
36311
WW
Add option to koha-run-backups, to only include database dump
32463
FS
Embed analytical items into bibliographic records export
24912
JD
Generate SQL from YAML installer files
20570
MDR
Add script to complete scanned article requests

In discussion 9

koha-email-disable does not disable all emails
36013
FS
update_totalissues.pl should not log
35948
FS
cleanup_database.pl should remove not only finished background jobs
membership_expiry.pl -renew -active should include patrons 0-MembershipExpiryDaysNotice days before expiration
16837
GC
koha-start-zebra should start zebra-indexer too
15088
LR
Notice when koha has been installed with --request-db instead of --create-db
Add --statute-barred-fees option to cleanup_database.pl to purge all fees where the item has been returned and the fee is older than the given number of days.
30326
AA
Cronjob that checks biblios for MARC errors
20543
MJ
Use multi-core compression to speed up Koha backups

Failed QA 23

25183
KMH
cleanup-database.pl --del-exp-selfreg fully deletes borrowers - should go into deleted-borrowers
41147
NC
Counts in bulkmarcimport.pl are incorrect
38893
AF
Longoverdue cronjob gives error when run with "--library" flag and CircControl syspref set to "The library you are logged in at"
23357
NC
overdue_notices.pl can send library doubled emails for patrons with no email/sms if both transports enabled
36504
NC
Run report should have an option to only send the attachment
20377
MJ
Add transaction and skip_merge to 'remove_unused_authorities.pl' script
Inconsistencies in --commit, --confirm for command line scripts
overdue_notices -h does not list all options
40076
HW
Add --skip-no-email parameter to borrowers-force-messaging-defaults.pl
18064
TG
Long overdue cronjob does not follow the library's calendar and skip closed days
11530
NC
Recalculating an item's total issue count with update_totalissues.pl ignores deleted items
Add emails to message queue by longoverdue script options
misc/devel/install_plugins.pl doesn't run the "install" method of plugins.
28011
DC
Add CLI script to update bibs from linked authority records
Print autorenewal notice to console when running in verbose.
7901
KMH
Add option to delete_borrowers.pl for using a file with cardnumbers
20465
GP
misc/export_records.pl add possibility to export by branchcode
15336
AA
Script for merging vendors
6851
RS
A utility that will search out analytics records and set the MARC header appropriately
18000
AA
Add --tablename option to misc/devel/update_dbix_class_files.pl script
12120
MJ
Add --tempdir arg to rebuild_zebra.pl
12099
OK
process_message_queue.pl tells it sends print mails even if it doesn't.
9712
KMH
Add command line script to recalculate existing due dates based on current issuing rules and retroactively update the issues

Patch doesn't apply 4

34027
AA
Add functionality to cleanup_database.pl to purge action logs in batches
26235
MM
Allow to skip records when using bulkmarcimport.pl
14493
JE
export_borrowers.pl - Export patron attributes
14420
VF
bulkmarcimport.pl - Some problems

Needs signoff 10

41353
SA
koha-dump failing on mysqldump PROCESS privileges
37564
MR
bulkmarcimport should not generate real time holds queue updates
21627
I
System preference for recipient emails of gather_print_notices.pl
20551
DG
Add option for including deleted records in export_records.pl
41698
KMH
Add maintenance script to revert found holds for items currently checked out
Add utf8 output to CSV output of overdue_notices.pl
35061
AA
Add support to preserve patron category code when importing patrons with commandline script
21214
HW
cleanup_database.pl --mail should let admin choose which letter codes to keep
19336
HW
Add option to fines.pl to apply maximal fine amount after delay
Add verbose option borrowers-force-messaging-defaults

Signed off 6

40744
JD
Don't give noisy warning when PatronSelfRegistration is turned off
41851
NC
Add logging to EDI cron job
41062
RS
Expand cronjob erm_run_harvester.pl with parameter for providers
40934
MR
process_message_queue.pl add ability to exclude some letter code
32509
FS
Embed see-also-from headings into bibliographic records export
37025
PD
Add CLI tool to generate/delete api keys for a given patron on a Koha instance

Passed QA 2

41316
NC
Using patron-homelibrary option for overdue notices does not change which rules are used
23260
LG
Anonymize (remove) patron data from items_last_borrower

Pushed to main 9

28528
RD
bulkmarcimport delete option doesn't delete biblio_metadata
41315
NC
Using patron-homelibrary option for overdue notices may not send notices to all branches
41097
NC
Deduping authorities script (dedup_authorities.pl) can die on duplicated ids
32736
TCA
koha-worker should be able to restart all queues with a single call
38549
AA
Make create_superlibrarian.pl script accept a name parameter
33308
JD
Add ability to to use SFTP with runreport.pl
37538
RB
Improve documentation printed by connexion_import_daemon.pl --help
40964
TK
koha-elasticsearch is missing --where option
38115
JD
Add FTP support to export_records.pl

Needs documenting 47

38894
AF
Longoverdue cron should follow HomeOrHoldingBranch as well as CircControl when using --library flag
40953
KMH
marc_ordering_process.pl broken due to accidental newline
39694
TCA
`es_indexer_daemon.pl` doesn't use batch_size in DB poll mode
31124
TCA
koha-remove fails to remove long_tasks queue daemon, so koha-create for same <instance> user fails
41490
TCA
Duplicate variable definition warnings in `compare_es_to_db.pl`
41008
KF
bulkmarcimport.pl -d broken for authorities
38760
LK
koha-mysql doesn't work with encrypted database connection
38857
NC
Cronjobs should log their start and command line parameters before processing options
39236
NC
writeoff_debts.pl does not run
37920
NC
writeoff_debts.pl should be logged
39532
KMH
Script debar_patrons_with_fines.pl should not use MANUAL restriction type
39413
NC
Add a check for item fields in bibliographic MARC records
39322
NC
When pseudonymizing don't fetch patron attributes if none are kept
37550
NC
bulkmarcimport.pl dies when adding items throws an exception
35466
NC
bulkmarcimport needs a parameter to skip indexing
37478
NC
bulkmarcimport.pl can die on bad records
37790
NC
Prevent indexing and holds queue updates when running update_localuse_from_statistics.pl
36709
LG
Add --confirm flag to update_localuse_from_statistics.pl script
40785
FS
Cronjob cleanup_database.pl usage is outdated
35700
LS
Holds reminder cronjob --triggered switch does not work as intended if the day to send notice hits concurrent holidays
40144
TCA
`sip_cli_emulator.pl` warnings
39961
TCA
koha-create doesn't start all queues
38104
JD
share_usage_with_koha_community.pl: Check between two runs is not needed
29238
EP
Cataloging cron jobs are not logged
39887
MR
Improve documentation of overdue_notices.pl
36932
MDR
koha-plack: Add parameter for specifically enabling Starman development environment
36977
JK
Google does not read sitemaps with the name sitemapNNNN.xml
39733
FS
Update code comment with a TODO in misc/cronjobs/staticfines.pl
39250
MDR
Add archive_purchase_suggestions.pl to cron.daily commented
23883
TCA
sip_cli_emulator.pl - typo in parameter name
38762
TCA
compare_es_to_db.pl should provide links to the staff interface
36365
TCA
compare_es_to_db.pl should offer a way to reconcile differences
40722
NC
Add logging to reset of elastic mappings files when rebuilding elastic
37181
NC
Add --confirm option switch to pseudonymize_statistics.pl
40545
TCA
Add a CLI script to manually reset 2FA settings
34064
DC
Compare kohastructure.sql against current database using database audit script
38404
AF
Make clear in RestrictPatronsWithFailedNotices syspref description that restrict_patrons_with_failed_notices.pl cronjob has default days setting
38408
MDR
Add parallel exporting of MARC records to Zebra rebuild/reindex
38307
AA
Make overdue_notices.pl quiet if there are no libraries with active overdue rules
9596
MH
Allow longoverdue.pl to be configured per library on the command line
36770
AB
Add a --report_id parameter to export_records.pl
36766
AB
Add command-line utility to SFTP a file to a remote server
33360
MDR
SendQueuedMessages: Improve limit behavior and add domain limits
36068
MDR
Add maintenance script acq_cancel_obsolete_orders.pl
23924
JD
Add a parameter to the script add_date_fields_to_marc_records.pl to specify a date field
36309
TCA
create_superlibrarian.pl output could be more helpful
35653
LG
Allow the patron import script to log it's output to the action_logs cron logging