@@ -, +, @@ --------- is not a text file. -- a horrible lack of validation and spamminess ensues. a) One containing valid barcodes on each line -- this file should trigger no errors. b) A copy of the first with an extra line of >20 characters (e.g. The Quick Red Fox Jumped Over The Brown Fence^A^B^C) -- this file should trigger the singular error message case. ^A^B^C are actually CTRL-A,CTRL-B,CTRL-C, and it is left as an exercise to the reader to add them to the line. c) A copy of the second with the last line duplicated -- this file should trigger the plural error message case. --- .../prog/en/modules/tools/inventory.tt | 4 +++ tools/inventory.pl | 26 ++++++++++++++++++++ 2 files changed, 30 insertions(+) --- a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/inventory.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/inventory.tt @@ -96,6 +96,10 @@ $(document).ready(function(){

Inventory/Stocktaking

[% IF (moddatecount) %]
[% moddatecount %] items modified : datelastseen set to [% date | $KohaDates %]
[% END %] [% IF (errorfile) %]
[% errorfile %] can't be opened
[% END %] + [% IF (err_length && err_length==1) %]
There was 1 barcode that was too long.
[% END %] + [% IF (err_length && err_length>1) %]
There were [% err_length %] barcodes that were too long.
[% END %] + [% IF (err_data && err_data==1) %]
There was 1 barcode that contained at least one unprintable character.
[% END %] + [% IF (err_data && err_data>1) %]
There were [% err_data %] barcodes that contained at least one unprintable character.
[% END %] [% FOREACH error IN errorloop %]
[% error.barcode %] --- a/tools/inventory.pl +++ a/tools/inventory.pl @@ -160,9 +160,35 @@ if ( $uploadbarcodes && length($uploadbarcodes) > 0 ) { my $count = 0; + my @barcodes; + + my $sth = $dbh->column_info(undef,undef,"items","barcode"); + my $barcode_def = $sth->fetchall_hashref('COLUMN_NAME'); + my $barcode_size = $barcode_def->{barcode}->{COLUMN_SIZE}; + my $err_length=0; + my $err_data=0; while (my $barcode=<$uploadbarcodes>){ $barcode =~ s/\r?\n$//; next unless $barcode; + if (length($barcode)>$barcode_size) { + $err_length += 1; + } + if ($barcode =~ /[^[:print:]]/) { # Only printable characters allowed. + $err_data += 1; + } + next if length($barcode)>$barcode_size; + next if ( $barcode =~ /[^[:print:]]/ ); + push @barcodes,$barcode; + } + if (! @barcodes) { + push @errorloop, {'barcode'=>'No valid barcodes!'}; + $op=''; # force the initial inventory screen again. + } + else { + $template->param( err_length => $err_length, + err_data => $err_data ); + } + foreach my $barcode (@barcodes) { if ( $qwithdrawn->execute($barcode) && $qwithdrawn->rows ) { push @errorloop, { 'barcode' => $barcode, 'ERR_WTHDRAWN' => 1 }; } else { --