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: [email protected] 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, <[email protected]> wrote: > Send Koha mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > To: Koha <[email protected]> > Subject: [Koha] Report Help - With Rollup > Message-ID: > <CAC0K6VGAaY8tnwTZ4=m7Sq2YRonoe0zEf= > [email protected]> > 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 <[email protected]> > To: Koha <[email protected]> > Subject: [Koha] New patron restrictions data > Message-ID: > < > cac0k6vfuk45oondrst0stdrggj2sdwjpwp6j+6lcprj9nld...@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)" <[email protected]> > To: Nicole Engard <[email protected]> > Cc: Koha <[email protected]> > Subject: Re: [Koha] New patron restrictions data > Message-ID: > < > cabaqf38mgxukdm5+jbjcbsograbsdyga7ddbgohtlmmnmgw...@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 > [email protected] > > "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 <[email protected]> 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 > > [email protected] > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 4 > Date: Thu, 20 Mar 2014 15:51:02 +0100 > From: Jonathan Druart <[email protected]> > To: Nicole Engard <[email protected]> > Cc: Koha <[email protected]> > Subject: Re: [Koha] New patron restrictions data > Message-ID: > < > cajzkny6nio__bqcsnv9u4nhdtfohskf-c9sc5ae9o5lh2n+...@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 <[email protected]>: > > 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 > > [email protected] > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > Message: 5 > Date: Thu, 20 Mar 2014 09:50:51 -0500 > From: Nicole Engard <[email protected]> > To: "Heather Braum (NEKLS)" <[email protected]> > Cc: Koha <[email protected]> > Subject: Re: [Koha] New patron restrictions data > Message-ID: > <CAC0K6VENRsjhmQKNSzo7D3HsuQa35Ku3+0Dc3W-Joh= > [email protected]> > 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) <[email protected]> > 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 > > [email protected] > > > > "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 <[email protected]> > 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 > >> [email protected] > >> http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > ------------------------------ > > Message: 6 > Date: Thu, 20 Mar 2014 09:55:46 -0500 > From: "Heather Braum (NEKLS)" <[email protected]> > To: Jonathan Druart <[email protected]> > Cc: Koha <[email protected]> > Subject: Re: [Koha] New patron restrictions data > Message-ID: > <CABaQF3-iHSVYMofVFHQk5NbBZBTdvpnf_vS6-nC= > [email protected]> > 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 > [email protected] > > "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 < > [email protected]> wrote: > > > Hello Nicole, > > > > It is in the borrower_debarments table. > > > > Regards, > > Jonathan > > > > 2014-03-20 15:00 GMT+01:00 Nicole Engard <[email protected]>: > > > 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 > > > [email protected] > > > http://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ > > Koha mailing list http://koha-community.org > > [email protected] > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 7 > Date: Thu, 20 Mar 2014 20:59:39 +0530 > From: Urmila G <[email protected]> > To: [email protected] > Subject: [Koha] Fwd: [ILOSC.22669] Data migration: from excel to KOHA > Message-ID: > < > cadygyjzhvfjo6mq_kppuamthj63lyg1retaqhv-16ybqm9j...@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > ---------- Forwarded message ---------- > From: baiju joy <[email protected]> > Date: Thu, Mar 20, 2014 at 12:49 PM > Subject: [ILOSC.22669] Data migration: from excel to KOHA > To: [email protected] > > > 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 [email protected]. > To post to this group, send email to [email protected]. > 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" <[email protected]> > To: [email protected] > Subject: [Koha] Need help printing more than 3 digits on the top line > of a spine label in KHOA > Message-ID: > < > cagrqorfy_mef7zbz3cnp2vsvdjbjgbumhmbwwsucv6h1ybq...@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 > [email protected] > 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 ********************** _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
