[Koha] Koha Digest, Vol 101, Issue 43
DP Tripathi
dptkvs at gmail.com
Fri Mar 21 05:40:20 NZDT 2014
Dear Sir/Madam,
Please visit the link given below to know the data migration procedure from
excel to Koha.
http://koha.librarianguide.in/?page_id=971
http://koha.librarianguide.in/?page_id=973
Hope this will solve your problem.
Thanks with kind regards,
DP Tripathi
Subject: [ILOSC.22669] Data migration: from excel to KOHA
To: ilosc at googlegroups.com
Dear Professionals,
I have 50 number of bound volumes of a Journal in excel sheet. I need to
import the data as one biblio (record) and add all 50 number as item
(attachment) in to KOHA. How it is possible.
Sincerely
Baiju Joy
Senior Research Fellow
Central Library
Kerala Agricultural University
On Thu, Mar 20, 2014 at 9:21 PM, <koha-request at lists.katipo.co.nz> wrote:
> Send Koha mailing list submissions to
> koha at lists.katipo.co.nz
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.katipo.co.nz/mailman/listinfo/koha
> or, via email, send a message with subject or body 'help' to
> koha-request at lists.katipo.co.nz
>
> You can reach the person managing the list at
> koha-owner at lists.katipo.co.nz
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Koha digest..."
>
>
> Today's Topics:
>
> 1. Report Help - With Rollup (Nicole Engard)
> 2. New patron restrictions data (Nicole Engard)
> 3. Re: New patron restrictions data (Heather Braum (NEKLS))
> 4. Re: New patron restrictions data (Jonathan Druart)
> 5. Re: New patron restrictions data (Nicole Engard)
> 6. Re: New patron restrictions data (Heather Braum (NEKLS))
> 7. Fwd: [ILOSC.22669] Data migration: from excel to KOHA (Urmila G)
> 8. Need help printing more than 3 digits on the top line of a
> spine label in KHOA (Carlock, Ruth)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 20 Mar 2014 08:11:15 -0500
> From: Nicole Engard <nengard at gmail.com>
> To: Koha <Koha at lists.katipo.co.nz>
> Subject: [Koha] Report Help - With Rollup
> Message-ID:
> <CAC0K6VGAaY8tnwTZ4=m7Sq2YRonoe0zEf=
> 4cft7Qa6mvGbo6HA at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Hi all,
>
> I need some help with a report that has With RollUp in it. I have
> used this before and had no problem, but for this report it keeps
> showing the last value 2 times at the bottom instead of 'grand total'.
>
> So here's how I started:
>
> select IFNULL(a.lib,'*GRAND TOTAL*') as location, count(s.datetime) as
> circs from statistics s left join items i using (itemnumber) left join
> borrowers p using (borrowernumber) LEFT JOIN authorised_values a ON
> (i.location=a.authorised_value) where s.type in ('issue','renew') and
> p.categorycode != 'LIBRARYUSE' and s.branch=<<Check out/renewal
> branch|branches>> and a.category='LOC' and s.datetime between
> <<Checked out or renewed between (yyyy-mm-dd)|date>> and <<and
> (yyyy-mm-dd)|date>> group by i.location with rollup
>
> This runs and is right, but at the end it repeats the last shelving
> location instead of showing 'Grand Total'. Next I tried:
>
> select if(i.location is null, '*GRAND TOTAL*', a.lib) as location,
> count(s.datetime) as circs
> from statistics s
> left join items i using (itemnumber)
> left join borrowers p using (borrowernumber)
> LEFT JOIN authorised_values a ON (i.location=a.authorised_value)
> where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE'
> and s.branch='BAILEYCOVE'
> and a.category='LOC' and s.datetime between '2014-03-19'
> and '2014-03-20'
> group by i.location with rollup
>
>
> This repeated the same location over and over. So then I tried this:
>
> select ifnull(i.location, 'GRAND TOTAL') as code, a.lib as location,
> count(s.datetime) as circs
> from statistics s
> left join items i using (itemnumber)
> left join borrowers p using (borrowernumber)
> LEFT JOIN authorised_values a ON (i.location=a.authorised_value)
> where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE'
> and s.branch=<<Check out/renewal branch|branches>>
> and a.category='LOC' and s.datetime between <<Checked out or
> renewed between (yyyy-mm-dd)|date>>
> and <<and (yyyy-mm-dd)|date>>
> group by i.location with rollup
>
> Which shows grand total, but still repeats the darn location name again.
>
> And this which shows only one location over and over:
>
> select case a.location when null 'grand total' else a.lib as location,
> count(s.datetime) as circs
> from statistics s
> left join items i using (itemnumber)
> left join borrowers p using (borrowernumber)
> LEFT JOIN authorised_values a ON (i.location=a.authorised_value)
> where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE'
> and s.branch=<<Check out/renewal branch|branches>>
> and a.category='LOC' and s.datetime between <<Checked out or
> renewed between (yyyy-mm-dd)|date>>
> and <<and (yyyy-mm-dd)|date>>
> group by i.location with rollup
>
>
> I'm up for any suggestion that gets me to have the final line just
> have the total and not a false location name.
>
>
> ------------------------------
>
> Message: 2
> Date: Thu, 20 Mar 2014 09:00:58 -0500
> From: Nicole Engard <nengard at gmail.com>
> To: Koha <Koha at lists.katipo.co.nz>
> Subject: [Koha] New patron restrictions data
> Message-ID:
> <
> CAC0K6VFUk45OONdrSt0STdRgGj2SdwjpWP6J+6LCpRJ9nLddKg at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Hi all,
>
> I'm wondering where in the DB the new restrictions data is stored for
> patrons. I have a patron with 2 restrictions on her account and when
> I look at borrowers.debarred I only see 1 of them. The other shows
> when I view the record in the staff client so the data has to be
> somewhere ... where is it? :)
>
> Thanks
> Nicole
>
>
> ------------------------------
>
> Message: 3
> Date: Thu, 20 Mar 2014 09:49:03 -0500
> From: "Heather Braum (NEKLS)" <hbraum at nekls.org>
> To: Nicole Engard <nengard at gmail.com>
> Cc: Koha <Koha at lists.katipo.co.nz>
> Subject: Re: [Koha] New patron restrictions data
> Message-ID:
> <
> CABaQF38MgXukDM5+jbjCbSOgRabSDYGa7DdBgOhtLMMNmGwi5Q at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> If it's the old restrictions data (from before the library upgraded to
> 3.14) the data is located in the borrowers table, in the borrowers.debarred
> and borrowers.debarred comment fields.
>
> Heather Braum
> NExpress Coordinator
> Resource Sharing Librarian
> Northeast Kansas Library System
> hbraum at nekls.org
>
> "The illiterate of the 21st century will not be those cannot read
> and write, but those who cannot learn, unlearn, and relearn." ~Alvin
> Toffler, *Rethinking the Future*
>
>
>
>
>
> On Thu, Mar 20, 2014 at 9:00 AM, Nicole Engard <nengard at gmail.com> wrote:
>
> > Hi all,
> >
> > I'm wondering where in the DB the new restrictions data is stored for
> > patrons. I have a patron with 2 restrictions on her account and when
> > I look at borrowers.debarred I only see 1 of them. The other shows
> > when I view the record in the staff client so the data has to be
> > somewhere ... where is it? :)
> >
> > Thanks
> > Nicole
> > _______________________________________________
> > Koha mailing list http://koha-community.org
> > Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
> ------------------------------
>
> Message: 4
> Date: Thu, 20 Mar 2014 15:51:02 +0100
> From: Jonathan Druart <jonathan.druart at biblibre.com>
> To: Nicole Engard <nengard at gmail.com>
> Cc: Koha <Koha at lists.katipo.co.nz>
> Subject: Re: [Koha] New patron restrictions data
> Message-ID:
> <
> CAJzKNY6Nio__BQCsNV9u4nhdtFOHSkF-C9SC5aE9o5Lh2n+QpQ at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hello Nicole,
>
> It is in the borrower_debarments table.
>
> Regards,
> Jonathan
>
> 2014-03-20 15:00 GMT+01:00 Nicole Engard <nengard at gmail.com>:
> > Hi all,
> >
> > I'm wondering where in the DB the new restrictions data is stored for
> > patrons. I have a patron with 2 restrictions on her account and when
> > I look at borrowers.debarred I only see 1 of them. The other shows
> > when I view the record in the staff client so the data has to be
> > somewhere ... where is it? :)
> >
> > Thanks
> > Nicole
> > _______________________________________________
> > Koha mailing list http://koha-community.org
> > Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> ------------------------------
>
> Message: 5
> Date: Thu, 20 Mar 2014 09:50:51 -0500
> From: Nicole Engard <nengard at gmail.com>
> To: "Heather Braum (NEKLS)" <hbraum at nekls.org>
> Cc: Koha <Koha at lists.katipo.co.nz>
> Subject: Re: [Koha] New patron restrictions data
> Message-ID:
> <CAC0K6VENRsjhmQKNSzo7D3HsuQa35Ku3+0Dc3W-Joh=
> 4RA4FRQ at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Yup, and 1 of the restrictions is stored there, but I have 2
> restrictions on the patron record and the other isn't anywhere in the
> borrowers table that I can see.
>
> Nicole
>
> On Thu, Mar 20, 2014 at 9:49 AM, Heather Braum (NEKLS) <hbraum at nekls.org>
> wrote:
> > If it's the old restrictions data (from before the library upgraded to
> 3.14)
> > the data is located in the borrowers table, in the borrowers.debarred and
> > borrowers.debarred comment fields.
> >
> > Heather Braum
> > NExpress Coordinator
> > Resource Sharing Librarian
> > Northeast Kansas Library System
> > hbraum at nekls.org
> >
> > "The illiterate of the 21st century will not be those cannot read and
> write,
> > but those who cannot learn, unlearn, and relearn." ~Alvin Toffler,
> > *Rethinking the Future*
> >
> >
> >
> >
> >
> > On Thu, Mar 20, 2014 at 9:00 AM, Nicole Engard <nengard at gmail.com>
> wrote:
> >>
> >> Hi all,
> >>
> >> I'm wondering where in the DB the new restrictions data is stored for
> >> patrons. I have a patron with 2 restrictions on her account and when
> >> I look at borrowers.debarred I only see 1 of them. The other shows
> >> when I view the record in the staff client so the data has to be
> >> somewhere ... where is it? :)
> >>
> >> Thanks
> >> Nicole
> >> _______________________________________________
> >> Koha mailing list http://koha-community.org
> >> Koha at lists.katipo.co.nz
> >> http://lists.katipo.co.nz/mailman/listinfo/koha
> >
> >
>
>
> ------------------------------
>
> Message: 6
> Date: Thu, 20 Mar 2014 09:55:46 -0500
> From: "Heather Braum (NEKLS)" <hbraum at nekls.org>
> To: Jonathan Druart <jonathan.druart at biblibre.com>
> Cc: Koha <Koha at lists.katipo.co.nz>
> Subject: Re: [Koha] New patron restrictions data
> Message-ID:
> <CABaQF3-iHSVYMofVFHQk5NbBZBTdvpnf_vS6-nC=
> Vs63Lpdvyg at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Thank you Jonathan for correcting me. I completely misread Nicole's
> question as the data she had was in the borrower_debarments table and she
> was asking where was the other data was. :) I need much more coffee this
> morning!
>
> Heather Braum
> NExpress Coordinator
> Resource Sharing Librarian
> Northeast Kansas Library System
> hbraum at nekls.org
>
> "The illiterate of the 21st century will not be those cannot read
> and write, but those who cannot learn, unlearn, and relearn." ~Alvin
> Toffler, *Rethinking the Future*
>
>
>
>
>
> On Thu, Mar 20, 2014 at 9:51 AM, Jonathan Druart <
> jonathan.druart at biblibre.com> wrote:
>
> > Hello Nicole,
> >
> > It is in the borrower_debarments table.
> >
> > Regards,
> > Jonathan
> >
> > 2014-03-20 15:00 GMT+01:00 Nicole Engard <nengard at gmail.com>:
> > > Hi all,
> > >
> > > I'm wondering where in the DB the new restrictions data is stored for
> > > patrons. I have a patron with 2 restrictions on her account and when
> > > I look at borrowers.debarred I only see 1 of them. The other shows
> > > when I view the record in the staff client so the data has to be
> > > somewhere ... where is it? :)
> > >
> > > Thanks
> > > Nicole
> > > _______________________________________________
> > > Koha mailing list http://koha-community.org
> > > Koha at lists.katipo.co.nz
> > > http://lists.katipo.co.nz/mailman/listinfo/koha
> > _______________________________________________
> > Koha mailing list http://koha-community.org
> > Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
> ------------------------------
>
> Message: 7
> Date: Thu, 20 Mar 2014 20:59:39 +0530
> From: Urmila G <urmila57 at gmail.com>
> To: koha at lists.katipo.co.nz
> Subject: [Koha] Fwd: [ILOSC.22669] Data migration: from excel to KOHA
> Message-ID:
> <
> CADYGYjZHVFJO6mQ_KppuaMThJ63LYg1RETAQHv-16YBQm9jszQ at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> ---------- Forwarded message ----------
> From: baiju joy <baijujoy80 at gmail.com>
> Date: Thu, Mar 20, 2014 at 12:49 PM
> Subject: [ILOSC.22669] Data migration: from excel to KOHA
> To: ilosc at googlegroups.com
>
>
> Dear Professionals,
>
> I have 50 number of bound volumes of a Journal in excel sheet. I need to
> import the data as one biblio (record) and add all 50 number as item
> (attachment) in to KOHA. How it is possible.
>
> Sincerely
>
> Baiju Joy
>
> Senior Research Fellow
>
> Central Library
>
> Kerala Agricultural University
>
> --
> You received this message because you are subscribed to the Google Groups
> "Indian Librarians Online Study Circle" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to ilosc+unsubscribe at googlegroups.com.
> To post to this group, send email to ilosc at googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
> --
> Thanks & Regards
> Urmila Ghadge
>
>
> ------------------------------
>
> Message: 8
> Date: Thu, 20 Mar 2014 10:51:09 -0500
> From: "Carlock, Ruth" <rmcarlock at york.edu>
> To: koha at lists.katipo.co.nz
> Subject: [Koha] Need help printing more than 3 digits on the top line
> of a spine label in KHOA
> Message-ID:
> <
> CAGrQoRfY_MEf7zbz3cnp2VsVdJbJgBumhMBwwSUcV6H1YbqnJw at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Our IT person installed KOHA last fall and I am still not able to print out
> spine labels I can print barcode labels. We have finally got the spine
> labels we purchased lined up so they will print. But my problem is that we
> use QUARTO for items 25-30 cm. tall and FOLIO for items over 30 cm. tall.
> For some reason the first line of our spine label will not print more than
> 3 letters. We use Library of Congress classification and I know the top
> line of an LC # would not be more than 3 letters. So I don't know if this
> has something to do with information on Library of Congress, or something
> to do with the way the printer is set up. But when I try to print out a
> label with QUARTO at the top, I get
>
> QUA
>
> R
>
> .T
>
> O
>
> QA
>
> 76.76
>
> .H94
>
> L44
>
> 2003
>
> Instead of
>
> QUARTO
>
> QA
>
> 76.76
>
> .H94
>
> L44
>
> 2003
>
>
>
> I have communicated with another librarian at an academic library who is
> using KOHA and she is able to print out the above call number like it
> should print out. So I know there is a problem with a setting somewhere.
>
>
>
> Can you help me?
>
>
>
> Ruth
>
>
>
> Ruth M. Carlock
> Library Director
> Levitt Library
> York College,
> York, NE 68467
> 402-363-5703 | www.york.edu
>
> The mission of York College is to transform lives through Christ-centered
> education and to equip students for lifelong service to God, family, and
> society.
>
> Please consider the environment before printing this e-mail
>
> Follow us!
> facebook: York College Online
> twitter: @YCOnline
>
>
> ------------------------------
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> End of Koha Digest, Vol 101, Issue 43
> *************************************
>
--
*********************
D. P. Tripathi
Assistant Librarian
Biju Patnaik Central Library
NIT Rourkela
Odisha - 769008
www.librarianguide.in
**********************
More information about the Koha
mailing list