[Koha] Step by Step guide for generating barcodes in Koha 2.2.9 Windows Version

[Scott Owen]

here is the process I've come up with....


*********************************************
Barcodes & labels

Free barcode 39 font    http://www.squaregear.net/fonts/free3of9.shtml

Free (for non-profit and edu) label making/design software 
http://www.idautomation.com/labelsoftware/free/

 

On the server use MySQLAdmin (GUI) > Query Browser > select (double 
click) on "items" (the query should pop-up in the query window) (SELECT 
* FROM items I;)

use a multi-table MySQL query to pull all of the data from both the 
biblio and items tables into a single "outputable" table, then export to 
CSV.

http://www.daniweb.com/forums/thread22066.html

http://www.informit.com/articles/article.aspx?p=377068&seqNum=7 
<http://www.informit.com/articles/article.aspx?p=377068&seqNum=7>

 

the SQL query :

SELECT biblio.biblionumber, biblio.title, items.barcode, 
items.itemcallnumber FROM biblio, items WHERE biblio.biblionumber = 
items.biblionumber;

 

Will produce (in my case) a CSV like

biblionumber

	

title

	

barcode

	

itemcallnumber

1

	

Novell's ZENworks administrator's handbook /

	

1

	

 

2

	

The New York Public Library desk reference.

	

30525

	

031 new

3

	

Picture perfect /

	

36003

	

FIC PIC

6

	

Just listen :

	

30431

	

FIC DES

5

	

The lovely bones :

	

30319

	

FIC SEB

8

	

Unexplained /

	

109541

	

001.94 ALL

9

	

Whatever happened to Janie? /

	

109542

	

 

10

	

The bad beginning /

	

50000

	

F SNI

11

	

The field guide /

	

50003

	

F DIT

12

	

The clique :

	

109528

	

F HAR

(note: As you get into larger and larger biblionumbers you may want to 
add a > to the query:

SELECT biblio.biblionumber, biblio.title, items.barcode, 
items.itemcallnumber FROM biblio, items WHERE biblio.biblionumber>4 = 
items.biblionumber;

The >4 causes the query to only show rows where the biblionumber is 
(greater than)> 4)

 
 From this point, it's just a few quick steps to have the CSV ready to 
print labels.

1. Delete the biblionumber column.

2. Add a column for our School name

3. Install the free barcode 39 font (unzip and drag the 2 font files to 
your c:\windows\fonts folder)

4. Create your labels with the label making/design software

5. Link your CSV to the label software and......print labels.

6. or......Purchase a Brother QL-500 (comes with it's own software that 
works almost exactly like the free stuff)



Rob Weir wrote:
> Hi Mitali,
> The barcode support in koha 2.2.9 is not great. It would probably be 
> better to use a separate application to print your barcode labels, or 
> purchase pre-printed labels.
>
> Here are a couple links for free or low-cost barcode solutions for the 
> windows platform:
> http://barcode4j.sourceforge.net  (java based)
> http://www.idautomation.com/labelsoftware/free/
> http://www.protonbarcode.com/
>
> You can also find a variety of free barcode fonts for windows that can 
> be used for labels. I have collected quite a few of these. Contact me 
> off-list if you are interested.
>
> Rob
>
>
> Mitali Phatarpekar wrote:
>> Could anyone guide me through generation of barcodes using Koha 
>> 2.2.9-Windows version.
>>  
>> Mitali
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Koha mailing list
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>   

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20080911/395d5634/attachment-0001.htm