- Koha - lists.katipo.co.nz

koha-US Users Group invite: August 8, 2018
by koha-US Secretary 07 Aug '18

07 Aug '18

Date: Wednesday, August 8th, 2018 (Tomorrow!) Time: 10:30 AM - 11:30 AM CDT (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+August+ge…> ) Location: https://kslib.zoom.us/j/450230564 <https://kslib.zoom.us/j/450230564%E2%80%8B> Agenda: *https://docs.google.com/document/d/1cINICRAlN4thlO6PGITT-SK9o_00TR4lBl12663yqno/edit?usp=sharing <https://docs.google.com/document/d/1cINICRAlN4thlO6PGITT-SK9o_00TR4lBl12663…>* Topics this month include a discussion about the bylaws, our proposed workflow for funding and handling developments, and as always, plenty of time to discuss bugs and issues. If you have specific topics for the agenda, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam are recommended for optimal participation, but not required. These meetings are free and open to any and all. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

Patron I-Card Settings
by Rajesh Shelar 07 Aug '18

07 Aug '18

Please send me patron I-Card setting in koha. -- *Thanks & Regards* *Mr. Rajesh R.Shelar* *Sadhu Vaswani Institute Of Management Studies For Girl's ( MBA )* *Koregaon Road,Pune* *Mob.No.8380941380* *Save Water......Conserve Life.............*

3 2

Re: [Koha] spine label fields
by Ingrid Schiessl 07 Aug '18

07 Aug '18

Hi Hira! You can choose the field you want to print in : More > Tools > Catalog > Label Creator. You have to create a new Layout and edit the 'List Fields', you can specify MARC subfields as a 4-character tag-subfield string: (ie. 254a for the title field). You can also enclose a whitespace-separated list of fields to concatenate on one line in double quotes. (ie. "099a 099b" or "itemcallnumber barcode"). Other option is to set the system preference SpineLabelFormat. Em ter, 7 de ago de 2018 às 02:58, Hira Akram <hira.akram(a)almusnet.com> escreveu: > > Hi All, > I am trying to print ddc number , barcode, year and author cutter on my > spine label. > I have added <itemcallnumber><barcode><year> in spine label preferences. > But only barcode and sometimes ddc number is printing on label. Can anyone > please explain how can How can I print year and author mark on label? > > Thanks. > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- *Ingrid Schiessl* Bibliotecária (CRB 1/3084) "Ela acreditava em anjos, e porque acreditava, eles existiam" (Lispector, 1977)

1 0

Re: [Koha] Field 003 of Marc21
by Ingrid Schiessl 07 Aug '18

07 Aug '18

Hi Hira! You can choose the field you want to print in : More > Tools > Catalog > Label Creator. You have to create a new Layout and edit the 'List Fields', you can specify MARC subfields as a 4-character tag-subfield string: (ie. 254a for the title field). You can also enclose a whitespace-separated list of fields to concatenate on one line in double quotes. (ie. "099a 099b" or "itemcallnumber barcode"). Em ter, 7 de ago de 2018 às 02:33, Hira Akram <hira.akram(a)almusnet.com> escreveu: > > Hi, > Where are you saving your author cutter? Because I am trying to save > author cutter and print it on spine label. But I am not sure where to save > it. I found on internet that Cutter-Sanborn Three-Figure Author Table may > conform to Library of Congress item number practice so I am saving it in > 050$b. but I am unable to print it in spine label. Which name should I use > in spine label preferences to print it there?? Also, I want to print year > in spine label which is saved in 260$c and I am using <year> in spine label > system preference but it is not getting printed there. > What should I do to print them?? > > From: King, Fred > Sent: Monday, August 6, 2018 6:26 PM > To: Hira Akram > Cc: koha(a)lists.katipo.co.nz > Subject: RE: [Koha] Field 003 of Marc21 > > Real catalogers are going to turn pale and have to sit down when they read > this, but if you're in a small library, a lot of this doesn't matter as > much as one might think. The library where I work has maybe 5000 books--I > have more books at home.* If your library users can find the books on the > shelves, it doesn't matter that the 060b field (NLM classification system, > Cutter number) isn't perfect, or the 082 (Dewey) number doesn't go to all > thirty five decimals. > > My general rule of thumb: if you're part of the cataloging department, you > need to be fairly careful. If you ARE the cataloging department (and the > systems department, and half the reference department, and...), you can let > a few things slide. > > *And yes, someday I'm going to move the catalog from the MS Access 97 > database to Koha. > > Fred King > Medical Librarian, MedStar Washington Hospital Center > fred.king(a)medstar.net > 202-877-6670 > ORCID 0000-0001-5266-0279 > MedStar Authors Catalog: http://medstarauthors.org > > I'll be more enthusiastic about encouraging thinking outside the box when > there's evidence of any thinking going on inside it. > --Terry Pratchett > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- *Ingrid Schiessl* Bibliotecária (CRB 1/3084) "Ela acreditava em anjos, e porque acreditava, eles existiam" (Lispector, 1977)

1 0

How to import thesaurus data into a KOHA instance?
by hartmann 07 Aug '18

07 Aug '18

Hi, I am part of a team that tries to get a KOHA instance configured for an existing library. Among other things we want to import a thesaurus of keywords and authors to be used later when we add the actual books to the catalogue. I do have the keyword/author data in electronically processable form. I am a software developer and I will be able to convert them to any format that KOHA might need. But I dont know what KOHA needs and how to actually import those data into KOHA. So my question basically is how to do that. * Is there any step-by-step guide how to import thesausus data into KOHA? The standard web interface does not seem to have this capability and right now I have access to KOHA only via the standard web interface / intranet, no access to the computer on which KOHA is actually installed. * What format will I have to convert these data to for a successful import into KOHA? Is there a specification for this, maybe an XML schema or something similar? Thanks in advance to the experts, AH :) -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

2 1

Report help
by David Hughes 07 Aug '18

07 Aug '18

Hi, I want to create a report that gives a grand total of records with various combinations of two different patron attributes. I have two different borrower_attributes.code values "CC" and "CD" and I want to output the grand totals of records with all permutations of borrower_attributes.attribute that have these codes. So if borrower_attributes.code CC has values 1, 2, 3 etc and borrower_attributes.code CD has values A, B C I'd want to output the grand totals of all records having CC value "1" CD value "A" CC value "1" CD value "B" CC value "1" CD value "C" ...... CC value "2" CD value "A" CC value "2" CD value "B" etc This is outwith the scope of my very limited SQL, so I'd appreciate any help that the community would be able to offer. Thanks. Kind regards David Hughes Systems Librarian Dublin Business School 13-14 Aungier St. Dublin 2 Ireland 00 353 1 417 8744 david.hughes(a)dbs.ie *http://library.dbs.ie <http://library.dbs-students.com/>* -- *Data Protection: *The protection of your data is important to us. Please see our Privacy Notice <https://www.dbs.ie/privacy-policy> for more information on how we handle your data.

2 2

Re: [Koha] MARC Field Mapping
by Arshad Iqbal 07 Aug '18

07 Aug '18

Yes, On Tue, Aug 7, 2018 at 11:04 AM Hira Akram <hira.akram(a)almusnet.com> wrote: > Hi, > > Thank you for correcting these. ISBN and binding both are on field 020$a?? > > > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows 10 > > > > *From: *Arshad Iqbal <arshadsanwal(a)gmail.com> > *Sent: *Tuesday, August 7, 2018 11:00 AM > *To: *hira.akram(a)almusnet.com > *Cc: *bob(a)calyx.net.au; Koha list <koha(a)lists.katipo.co.nz> > *Subject: *Re: [Koha] MARC Field Mapping > > > > check this marc mapping > > title -- 245a > subtitle -- 245 b > type -- 942c > author -- 100a > subauthor -- 100q > entry day -- 952d > ddc no -- 082a > author mark(cutter)-- 082b > publisher -- 260b > place --260a > year -- 260c > edition -- 250a > volume -- 952h > pages --300a > series -490a > language -- 546a > ISBN-- 020a > binding -- 020a (pbk, hbk) > keywords 650a > subject 650 v > barcode -- 952p > > > > On Tue, Aug 7, 2018 at 10:54 AM Hira Akram <hira.akram(a)almusnet.com> > wrote: > > > Hi All, > I am supposed to import data in KOHA from excel sheet for which I need > fields mapping. I have tried and found these mappings. > > > title -- 245a > subtitle -- 245 b > type -- 942c > author -- 100a > subauthor -- 100q > accession no--541e > entry day -- 952d > ddc no -- 082a > author mark(cutter)-- ?? > publisher -- 260b > place --260a > year -- 260c > edition -- 082-2 > volume -- 490v > pages --300a > series -490a > language -- 130l / 630 > ISBN-- 020a > binding -- 563a > keywords 650a > subject 650 v > barcode -- 952p > > Can anyone please see this and confirm me that these are right mappings?? > > Thanks. > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > -- > > [image: > https://mail.google.com/mail/u/0/?ui=2&ik=5f73e1d4bf&view=fimg&th=160540c76…] > > > > *Muhammad Arshad Iqbal* > > Assistant Librarian at Academic Directorate, > > National University of Science and Technology (NUST) Islamabad. > > Phone number:051-90851371 > > Cell no.+923444900809 > > > -- *Muhammad Arshad Iqbal* Assistant Librarian at Academic Directorate, National University of Science and Technology (NUST) Islamabad. Phone number:051-90851371 Cell no.+923444900809

1 0

Re: [Koha] MARC Field Mapping
by Arshad Iqbal 07 Aug '18

07 Aug '18

check this marc mapping title -- 245a subtitle -- 245 b type -- 942c author -- 100a subauthor -- 100q entry day -- 952d ddc no -- 082a author mark(cutter)-- 082b publisher -- 260b place --260a year -- 260c edition -- 250a volume -- 952h pages --300a series -490a language -- 546a ISBN-- 020a binding -- 020a (pbk, hbk) keywords 650a subject 650 v barcode -- 952p On Tue, Aug 7, 2018 at 10:54 AM Hira Akram <hira.akram(a)almusnet.com> wrote: > > Hi All, > I am supposed to import data in KOHA from excel sheet for which I need > fields mapping. I have tried and found these mappings. > > > title -- 245a > subtitle -- 245 b > type -- 942c > author -- 100a > subauthor -- 100q > accession no--541e > entry day -- 952d > ddc no -- 082a > author mark(cutter)-- ?? > publisher -- 260b > place --260a > year -- 260c > edition -- 082-2 > volume -- 490v > pages --300a > series -490a > language -- 130l / 630 > ISBN-- 020a > binding -- 563a > keywords 650a > subject 650 v > barcode -- 952p > > Can anyone please see this and confirm me that these are right mappings?? > > Thanks. > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- *Muhammad Arshad Iqbal* Assistant Librarian at Academic Directorate, National University of Science and Technology (NUST) Islamabad. Phone number:051-90851371 Cell no.+923444900809

2 1

spine label fields
by Hira Akram 07 Aug '18

07 Aug '18

Hi All, I am trying to print ddc number , barcode, year and author cutter on my spine label. I have added <itemcallnumber><barcode><year> in spine label preferences. But only barcode and sometimes ddc number is printing on label. Can anyone please explain how can How can I print year and author mark on label? Thanks.

1 0

MARC Field Mapping
by Hira Akram 07 Aug '18

07 Aug '18

Hi All, I am supposed to import data in KOHA from excel sheet for which I need fields mapping. I have tried and found these mappings. title -- 245a subtitle -- 245 b type -- 942c author -- 100a subauthor -- 100q accession no--541e entry day -- 952d ddc no -- 082a author mark(cutter)-- ?? publisher -- 260b place --260a year -- 260c edition -- 082-2 volume -- 490v pages --300a series -490a language -- 130l / 630 ISBN-- 020a binding -- 563a keywords 650a subject 650 v barcode -- 952p Can anyone please see this and confirm me that these are right mappings?? Thanks.

1 0