[Koha] SQL Report help

.surname ASC I need to also add to the above: SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code="c"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml, '//datafield[@tag="020"]/subfield[@code="c"]'

Re: [Koha] SQL Report help

ber) WHERE c.branchcode = <> AND (TO_DAYS(curdate())-TO_DAYS( date_due)) >= <> AND h.code="HOMEROOM" ORDER BY g.attribute, h.attribute, p.surname ASC -- Regards, Jeramey Valley Network Manager, Bullock Creek Schools vall...@bcreek.org > On Apr 24, 2015, at 2:04 PM,

[Koha] Advice on barcode replacement/central catalog

Koha? All thoughts much appreciated. -- Regards, Jeramey Valley Network Manager, Bullock Creek Schools vall...@bcreek.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Migrating from Spectrum

oha 3.16.04.000 In between tests I am removing the Koha install, deleting the database and running the zebra reset procedures to try and keep things "clean". Any pointers or suggestions appreciated. -- Regards, Jeramey Valley Network Manager, Bullock Creek S

Re: [Koha] Migrating from Spectrum

50 \7$aAfrican Americans$xFiction.$2sears =852 1\$c$hFIC Dra$p50057$9p10.84usd$820020103$a =961 wl$t2 -- Regards, Jeramey Valley Network Manager, Bullock Creek Schools vall...@bcreek.org On Oct 6, 2014, at 4:01 PM, SCOTT OWEN wrote: > Jeramy, > > What does the holding inf

Re: [Koha] Migrating from Spectrum

01033nam 2200301 a -- Regards, Jeramey Valley Network Manager, Bullock Creek Schools vall...@bcreek.org On Oct 7, 2014, at 12:13 PM, vikram zadgaonkar wrote: > Do you get text or csv data file for biblio data from Spectrum ? > > On 07-Oct-2014 1:15 AM, "Jeramey Valley

Re: [Koha] Migrating from Spectrum

fields 852 and 961 to 952 and remap several subfields into suitable locations. Marcedit was used for this conversion process. We have 4 more buildings to convert, hopefully things continue to smooth out. I'm sure I'll have more questions. -- Regards, Jeramey Valley Network Manage

[Koha] Parsing barcodes

ill researching our older bar code readers to see if they do have that ability (finding the manuals for the old ones is a bit trickier). Any suggestions would be greatly appreciated. -- Regards, Jeramey Valley Network Manager, Bullock Creek Schools vall...@bcreek.org

Re: [Koha] Parsing barcodes

p and modify in Koha. We don't know until a material is physically examined if it has a regular or modified bar code. The rough guess is that about half of the materials have different bar code formatting. -- Regards, Jeramey Valley Network Manager, Bullock Creek Schools vall...@bcreek.org

[Koha] Unique Barcodes across branches

e the same barcode in use at multiple branches, each for a different item. As in: Library 400 Book A, barcode 2001 Library 500 Book B, barcode 2001 I was looking forward to having one install with a shared catalog, patron database and other "one stop management" functions. -- Regar

Re: [Koha] Unique Barcodes across branches

I agree with this solution, but we are not willing to physically re-barcode all of our items at every branch (50,000+ items). -- Regards, Jeramey Valley Network Manager, Bullock Creek Schools vall...@bcreek.org On Oct 21, 2014, at 11:29 AM, vikram zadgaonkar wrote: > Hi, > Y

Re: [Koha] Unique Barcodes across branches

nd plan to roll over to branch-unique barcodes in the future. Appreciate all the suggestions! -- Regards, Jeramey Valley Network Manager, Bullock Creek Schools vall...@bcreek.org On Oct 21, 2014, at 4:35 PM, Jason Robb wrote: > There's some magic in bug 7676 > <http://bugs.