KOHA
Label Creator: Revision 2

How to make new batch using mysql?

mysql> select '232' as batch_id, itemnumber as item_number, 'SRE', 'Labels' 
into outfile '/tmp/zpm-label-batch.txt' from items where homebranch = 'ZPM' 
and enumchron is null order by copynumber + 0;

mysql> load data local infile '/tmp/zpm-label-batch.txt' into table 
creator_batches (batch_id, item_number, branch_code, creator);