Re: [Koha] Item batch modifications using custom SQL or Perl?

2018-07-09 Thread Joy Nelson
Paul, Using perl is a better way to get at the data. Using ModBiblio will also update the cn_sort values (for browse feature) in the database as well as place the biblio into the zebraqueue for updating. Shouldn't be a need to reindex the site to incorporate your changes. -Joy On Mon, Jul 9,

Re: [Koha] Item batch modifications using custom SQL or Perl?

2018-07-09 Thread Alvaro Cornejo
Hi Paul I'm not expert in koha, but as I can see, in both cases you are accessing directly the DB; therefore the result will be the same. Doing it with perl, has the advantage that it will let you extract -if needed- some extra error/debug info if something went wrong. In any case, you I

[Koha] Item batch modifications using custom SQL or Perl?

2018-07-09 Thread Paul Hoffman
I've been asked to modify a batch of item call numbers, substituting "PYA" for "PZ100" whenever the latter occurs at the beginning of the call number. This doesn't seem possible using the existing Batch Item Modification tool (batchMod.pl). I would love to do this using SQL only, like so: