<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>><i> Is it possible to print both barcodes and spine labels on the same<o:p></o:p></i></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>><i> sheet? I see Gaylord has a label set, Gaylord LSL04 for both barcode and<o:p></o:p></i></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>><i> spine labels. If so, does someone have a template for this or similar? <o:p></o:p></i></span></p><p class=MsoNormal><i><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></i></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>Since Koha uses MySQL as a backend for the data, one can use any number of programs that have open database connectivity to access the data and print custom reports and labels.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>I am most familiar with MS Access as a good front end for making nice reports and labels. I have also set up LibreOffice/OpenOffice Base as a front end to the data to make custom reports and labels. This is how we do patron cards. One of these days I’ll post my database frontend on the wiki with a how to. Once the open database connectors are installed, it is simply a matter of connecting to the database with the right password. I give only read privileges to this database so as not to mess up any of the MySQL data.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>It is some learning to become familiar with database front ends, but once you get the basics down, you can customize to your heart’s content without needing to know any code. Knowing this key skill will also enable you to do lots of customized letters to the patrons or bulk email notifications.<o:p></o:p></span></p><p class=MsoNormal><i><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></i></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>