[Koha] Merging duplicate authorities - line missing
I am using 3.14.00.000 Koha version. While trying to merge duplicate authority entries as per 3.14 manual I encountered that one line is missing in output. When I searched for the term "Highway Engineering" the result was -- Authority search results Results 1 to 3 of 3 As per manual there should be one line between above two lines giving options of cancel and merge i.e. -- Authority search results Merging with authority: Highway Engineering (205) Cancel merge Results 1 to 3 of 3 Please fix this. Chitralekha M. Chitale -- View this message in context: http://koha.1045719.n5.nabble.com/Merging-duplicate-authorities-line-missing-tp5793105.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report Help
Please try this SQL report. This is sorted by count.
SELECT CONCAT('',biblio.biblionumber,'')
AS biblionumbers,
biblio.author, biblio.title,
COUNT(items.itemnumber) AS ItemCount, ccode, itype
FROM items
LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
GROUP BY items.biblionumber HAVING (COUNT(*)>=1)
ORDER BY ItemCount DESC
On Sat, Apr 5, 2014 at 2:01 PM, manoj382093 [via Koha] <
ml-node+s1045719n5793161...@n5.nabble.com> wrote:
> Dear Friends,
> I am looking for a report which has list of titles(biblio) their number
> of copies(items) by item type and collection code.
>
> --
> If you reply to this email, your message will be added to the discussion
> below:
> http://koha.1045719.n5.nabble.com/Report-Help-tp5793161.html
> To unsubscribe from Koha-general, click
> here
> .
> NAML
>
--
View this message in context:
http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793620.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report Help
Manojji, Your one book has one biblio record say biblionumber 1234. For this record in 942c tag (Koha [default] item type) you have entered / selected item type as BTECHBKS. If all 12 items are attached to this biblionumber the report will show 12 copies to BTECHBKS. Changing 952y item type for 4 attached items to BCABKS is not getting reflected in this report. I am sorry even I am not sure how to make entry of one biblio-record having different itemtypes. I will explore and let you know as soon as I get solution. Thanks and regards. Chitralekha Mahesh Chitale Librarian, Lokmanya Tilak College of Engineering, Navi Mumbai. On Fri, Apr 11, 2014 at 1:17 PM, manoj382093 [via Koha] < ml-node+s1045719n5793704...@n5.nabble.com> wrote: > Dear Chitralekha, > Take this example: > I have one book with 12 copies, 8copies with item type BTECHBKS and 4 > copies with item type BCABKS. When i generate report it shows 12 copies for > itemtype BTECHBKS and none for BCABKS. > > Is there any way of reporting so that i can get the correct report or i > would have to remove 4 copies and save it as different bib record. > > *Regards!* > > *Manoj Kumar Misra* > M.Phil., M.L.I.Sc., B.L.I.Sc., M.Sc.(Phy), B.Sc. (P.C.M.) > Deputy Librarian > SRMGPC > Lucknow > Mob. No.: 09415422579 > Alternate E-mail: [hidden > email]<http://user/SendEmail.jtp?type=node&node=5793704&i=0> > > > -- View this message in context: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5794300.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] On how to create a report
Hello
Paste the following program in reports.
SELECT CONCAT('',biblio.title,'')
AS Title, biblio.author AS Author,
items.barcode AS Barcode
FROM items
LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
WHERE
DATE(items.dateaccessioned) BETWEEN <>
AND <>
I hope this will give the results you expect.
For more reports visit
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Catalog.2FBibliographic_Reports
Mrs. Chitralekha Mahesh Chitale
Librarian, LTCE, Navi Mumbai.
- Original Message -
From: "catarinafrc [via Koha]"
To: "Chitralekha Chitale"
Sent: Friday, October 30, 2015 1:44:43 PM
Subject: On how to create a report
Hey guys,
My question is how can I create a report to know how many books were cataloged
from Jan till now (or any other time period)?
I have tried, but I find that the manual is not clear enough on this. all the
reports I created were not able to give me this info Thanks
[I still have 3.10 version, and NO I can't changed it now, so any help will be
much appreciated]
Thank you,
If you reply to this email, your message will be added to the discussion below:
http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353.html
To start a new topic under Koha-general, email
ml-node+s1045719n3047918...@n5.nabble.com
To unsubscribe from Koha-general, click here .
NAML
--
View this message in context:
http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p5859364.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] On how to create a report
You are most welcome Catarina. Please visit the link I sent. It gives many reports that we normally require. If you check the list item 6.86 and 6.87 are the reports you required. I hope either one will help you provided CataloguingLog to be on (setting in global system preferences, under log tab) Mrs. Chitralekha Mahesh Chitale Librarian, LTCE, Navi Mumbai. - Original Message - From: "catarinafrc [via Koha]" To: "Chitralekha Chitale" Sent: Friday, October 30, 2015 2:23:42 PM Subject: Re: On how to create a report Thank you it worked!! You saved me!! p.s. is there anything I can add so it gives me the information of how many books each librarian cataloged? Thank you so much If you reply to this email, your message will be added to the discussion below: http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p5859367.html To start a new topic under Koha-general, email ml-node+s1045719n3047918...@n5.nabble.com To unsubscribe from Koha-general, click here . NAML -- View this message in context: http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p5859370.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Help to assign one barcode each to 10000+ records in mrc file
Sir, For the first time I purchased e-books from a publisher. They provided me a marc file (.mrc) for all the ebook titles (1+). I can upload it directly to my Koha after adding and editing certain fields in records and add items with subfields having same description. I can do so using marcedit 5.2 as far as all records have same description to be added in that tag / copying from another field. But my problem is adding barcode (accession number in 952$p) to these records as each record will have different barcode. I tried converting marc file in excel. There is one marc tag per column but some of the columns have multiple subfields. I inserted barcode column, item type column, location column, Now I need to convert this excel to .mrc. The issue is I am not able to map them while converting to mrk file as each tag (above 010) must have subfield. I cannot map columns with multiple subfields eg. subject headings. Help me to assign one barcode each to these 1+ records. Mrs. Chitralekha M. Chitale Librarian, Lokmanya Tilak College of Engineering, Navi Mumbai, India ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Help to assign one barcode each to 10000+ records in mrc file
Thank you Fred King. I need to assign barcodes as I want these to be counted (item wise) through a report showing my library collection. Mrs. Chitralekha Mahesh Chitale Librarian, LTCE, Navi Mumbai. - Original Message - From: "Fred King" To: "Mrs. Chitralekha M. Chitale " , koha@lists.katipo.co.nz Sent: Tuesday, October 27, 2015 8:13:01 PM Subject: RE: Help to assign one barcode each to 1+ records in mrc file When I added our e-book collections to Koha, I didn't create item records--just bib records. As long as you have the link to the book in the 856u field, items and barcodes aren't needed. Fred King Medical Librarian, MedStar Washington Hospital Center fred.k...@medstar.net 202-877-6670 ORCID -0001-5266-0279 I'm fifty one years old and I sort of think that the thing I'm supposed to do hasn't happened yet. --Sandi Toksvig -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Mrs. Chitralekha M. Chitale Sent: Monday, October 26, 2015 4:35 AM To: koha@lists.katipo.co.nz Subject: [Koha] Help to assign one barcode each to 1+ records in mrc file Sir, For the first time I purchased e-books from a publisher. They provided me a marc file (.mrc) for all the ebook titles (1+). I can upload it directly to my Koha after adding and editing certain fields in records and add items with subfields having same description. I can do so using marcedit 5.2 as far as all records have same description to be added in that tag / copying from another field. But my problem is adding barcode (accession number in 952$p) to these records as each record will have different barcode. I tried converting marc file in excel. There is one marc tag per column but some of the columns have multiple subfields. I inserted barcode column, item type column, location column, Now I need to convert this excel to .mrc. The issue is I am not able to map them while converting to mrk file as each tag (above 010) must have subfield. I cannot map columns with multiple subfields eg. subject headings. Help me to assign one barcode each to these 1+ records. Mrs. Chitralekha M. Chitale Librarian, Lokmanya Tilak College of Engineering, Navi Mumbai, India ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopaedics, cancer and GI. IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected. Thank you. Help conserve valuable resources - only print this email if necessary. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Error as kohaadmin
Sir / Madam, I have set up koha 3.10 version recently and started setting basic parameters and global setting preferences. When I logged into koha admin I receive following message in a yellow box -- Warning: You're logged in with the database administrator account. This a bad idea, and you are likely to encounter problems. You should create a patron to use when administering Koha and give it superlibrarian permissions. I was not receiving this message till yesterday. What does this mean? Another query is I created second library. When I tried to edit its details I see blank form. When I tried to edit the first library it opened normally with appropriate details. Then I tried to delete the second library as I did not enter any data using this library. I received the message library deleted successfully. Still I see the second library. What may be the problem? How do I resolve it? Mrs. Chitralekha Mahesh Chitale Librarian, LTCE, Navi Mumbai. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha data back-up
Sir / Madam How can I take back-up? I want to transfer all my data (document records (all MARC fields), patron records, circulation status and transaction history, various reports, etc.) to another KOHA platform. How do I do it? Mrs. Chitralekha Mahesh Chitale Librarian, LTCE, Navi Mumbai. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] editing uploaded items in bulk
Hello, I have uploaded book database from excel sheet to koha. While uploading the price of all items (barcode) were missing. Now I have a list of barcodes and their respective prices in excel sheet. How do I merge this with existing data? Mrs. Chitralekha Mahesh Chitale Librarian, LTCE, Navi Mumbai. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] please help, fines settings
I have exactly same query. Please help. Mrs. Chitralekha Mahesh Chitale Librarian, LTCE, Navi Mumbai. - Original Message - From: "Mike D." To: koha@lists.katipo.co.nz Sent: Monday, September 2, 2013 7:27:31 PM Subject: [Koha] please help, fines settings Hello Koha community, our library use this rules for fines and circulation: Circulation periods: books period: 30 days with 2 renewals max journals period: 14 days with 2 renewals max Fines: 1. fine after period, price A 2. fine 30th day after 1. fine, price B 3. fine 14th day after 2. fine, price C (2x price B) 4. fine 14th day after 3. fine, price D (3x price B) 5. next fines we count per day and item. Is possible to set this rules in Koha? I think that standard Koha fines aren't too complex for this setup. Has some library with similar rules? Is here some solution? Thanks for feedback. Mike ___ 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
