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@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@lists.katipo.co.nz> wrote:

Send Koha mailing list submissions to koha@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@lists.katipo.co.nz

You can reach the person managing the list at koha-owner@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@gmail.com> To: Koha <Koha@lists.katipo.co.nz> Subject: [Koha] Report Help - With Rollup Message-ID: <CAC0K6VGAaY8tnwTZ4=m7Sq2YRonoe0zEf= 4cft7Qa6mvGbo6HA@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@gmail.com> To: Koha <Koha@lists.katipo.co.nz> Subject: [Koha] New patron restrictions data Message-ID: < CAC0K6VFUk45OONdrSt0STdRgGj2SdwjpWP6J+6LCpRJ9nLddKg@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@nekls.org> To: Nicole Engard <nengard@gmail.com> Cc: Koha <Koha@lists.katipo.co.nz> Subject: Re: [Koha] New patron restrictions data Message-ID: < CABaQF38MgXukDM5+jbjCbSOgRabSDYGa7DdBgOhtLMMNmGwi5Q@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@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@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@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@biblibre.com> To: Nicole Engard <nengard@gmail.com> Cc: Koha <Koha@lists.katipo.co.nz> Subject: Re: [Koha] New patron restrictions data Message-ID: < CAJzKNY6Nio__BQCsNV9u4nhdtFOHSkF-C9SC5aE9o5Lh2n+QpQ@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@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@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@gmail.com> To: "Heather Braum (NEKLS)" <hbraum@nekls.org> Cc: Koha <Koha@lists.katipo.co.nz> Subject: Re: [Koha] New patron restrictions data Message-ID: <CAC0K6VENRsjhmQKNSzo7D3HsuQa35Ku3+0Dc3W-Joh= 4RA4FRQ@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@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@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@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@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@nekls.org> To: Jonathan Druart <jonathan.druart@biblibre.com> Cc: Koha <Koha@lists.katipo.co.nz> Subject: Re: [Koha] New patron restrictions data Message-ID: <CABaQF3-iHSVYMofVFHQk5NbBZBTdvpnf_vS6-nC= Vs63Lpdvyg@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@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@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

---

Koha mailing list http://koha-community.org Koha@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@gmail.com> To: koha@lists.katipo.co.nz Subject: [Koha] Fwd: [ILOSC.22669] Data migration: from excel to KOHA Message-ID: < CADYGYjZHVFJO6mQ_KppuaMThJ63LYg1RETAQHv-16YBQm9jszQ@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1

---------- Forwarded message ---------- From: baiju joy <baijujoy80@gmail.com> Date: Thu, Mar 20, 2014 at 12:49 PM Subject: [ILOSC.22669] Data migration: from excel to KOHA To: ilosc@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@googlegroups.com. To post to this group, send email to ilosc@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@york.edu> To: koha@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@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@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 **********************