[Koha] Koha live dvd 3.14.08
So this is second live dvd for version 3.14. Sorry all, i was so busy with my work and can't make live dvd more frequently. You can download from here, don't forget download koha-3.14.08_readme. koha-latest - Browse Files at SourceForge.net koha-latest - Browse Files at SourceForge.net No description View on sourceforge.net Preview by Yahoo Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn http://vietnamlib.net ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Digest, Vol 101, Issue 6
I have a question about customizing searching results. I have made a MARC field (300_6) clickable with link to download ebook. How to display this field on the searching results page? And more, how can i create a new tab on opac-detail page (near tabs HOLDING and COMMENTS) to display 300_6 field above with download link. I saw in my library OPAC detail, there is a tab Title notices show 521b field. Thanks all! Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn http://vietnamlib.net On Tuesday, March 4, 2014 3:00 AM, koha-requ...@lists.katipo.co.nz koha-requ...@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-requ...@lists.katipo.co.nz You can reach the person managing the list at koha-ow...@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. Re: number of bibliographic records (Karam Qubsi) 2. Re: number of bibliographic records (Nisreen Qabbani) 3. Re: using javascript functions with koha (Owen Leonard) 4. Vendor number in serials records (Elaine Bradtke) 5. AllowOfflineCirculation question (Nicole Engard) 6. Re: Vendor number in serials records (Bernardo Gonzalez Kriegel) -- Message: 1 Date: Mon, 3 Mar 2014 17:13:57 +0800 From: Karam Qubsi karamqu...@gmail.com To: Nisreen Qabbani nisreenqabb...@gmail.com Cc: koha koha Koha@lists.katipo.co.nz Subject: Re: [Koha] number of bibliographic records Message-ID: CAML=htYvPoVi4d57eqwgL=81qlk7qacxy_hysbat8ta_3qt...@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1 hi you should put the user id no. not the username . it's something like : (1 , 2 , 3 ... ) you can check the userid from the user record . Best regards On Mon, Mar 3, 2014 at 2:53 PM, Nisreen Qabbani nisreenqabb...@gmail.comwrote: Have tried that But there was a problem After placing SELECT l.action, count(l.timestamp) AS 'bibs' FROM action_logs l LEFT JOIN borrowers p ON (p.borrowernumber=l.user) WHERE module='CATALOGUING' AND date(l.timestamp) BETWEEN Between (-mm-dd) AND and (-mm-dd) AND l.info!='item' AND user=user no. GROUP BY l.action The origin of the SQL reports And specify the date and name Does not show results, but shows the same instructions What is the problem On Wed, Feb 19, 2014 at 5:34 AM, Karam Qubsi karamqu...@gmail.com wrote: Hi , in my library I'm using this report , and I think this is the same report you want : SELECT l.action, count(l.timestamp) AS 'bibs' FROM action_logs l LEFT JOIN borrowers p ON (p.borrowernumber=l.user) WHERE module='CATALOGUING' AND date(l.timestamp) BETWEEN Between (-mm-dd) AND and (-mm-dd) AND l.info!='item' AND user=user no. GROUP BY l.action this report will ask you for date range and cataloger no . then the results would be something like this : action bibs ADD 193 DELETE 10 MODIFY 1010 Note : the above report is modified by me the source is here : http://wiki.koha-community.org/wiki/SQL_Reports_Library where the report name there is : - 5.83 Bib records added/deleted in time frame http://wiki.koha-community.org/wiki/SQL_Reports_Library#Bib_records_added.2Fdeleted_in_time_frame developed by Nicole C. Engard, ByWater Solutions - Best wishes . On Thu, Feb 13, 2014 at 11:21 PM, Nisreen Qabbani nisreenqabb...@gmail.com wrote: Hello Can you help me how to know the number of bibliographic records for each employee account Thank you very much ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- *Karam Qubsi* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- *Karam Qubsi* -- Message: 2 Date: Mon, 3 Mar 2014 13:04:01 +0300 From: Nisreen Qabbani nisreenqabb...@gmail.com To: Karam Qubsi karamqu...@gmail.com Cc: koha koha Koha@lists.katipo.co.nz Subject: Re: [Koha] number of bibliographic records Message-ID: CAM8WtzzYMshWOwP9U==znerf--zpr-00pbja57joyybpn+g...@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1 Oak Iam Going to try it Thanks Karam On Mon, Mar 3, 2014 at 12:13 PM, Karam Qubsi karamqu...@gmail.com wrote: hi you should put the user id no. not the username . it's something like : (1 , 2 , 3 ... ) you can check the userid from the user record . Best regards On Mon, Mar 3, 2014 at 2:53 PM, Nisreen Qabbani nisreenqabb...@gmail.comwrote
[Koha] Koha live dvd 3.14.00
So finally, my first live DVD has been released. I asked some people about live dvd, and i agree about using live DVD for testing and for education, not for production (the biggest reason, i think, is security). So i left everything as default, no more modification and no more feature. http://sourceforge.net/projects/koha-latest/ If anyone has any ideas or requires, please tell me. And from now, i will make an live dvd for each Koha version 3.14.x. Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn http://vietnamlib.net ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Building Live DVD
There's no ague about how people will use Koha live DVD. I also apologize about slowly making koha live dvd, because i was waiting for koha packages. And i and Vinod, we are friend, and i appreciate him for making live dvd and sharing! As you mention, should i make a live DVD for ubuntu server? Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn http://vietnamlib.net Phone: +79525768182 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha and Microsoft Exchange?
I don't know about Microsoft exchange, but if you want to send mail or notices to patrons, you can use google mail. It's quite easy with program Postfix on debian (or Ubuntu). More information about use google mail server is here: http://kohageek.pbworks.com/w/page/58731341/Configure%20gmail%20with%20postfix%20to%20send%20notices%20from%20Koha Thank Vimal for finding and sharing this guide! Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn http://vietnamlib.net Phone: +79525768182 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Please advice how to improve our search issue
I am using ubuntu 12.04 and koha 3.8.7. I have about 1000-2000 books. My search about 2s. your problem is, maybe, large database, next ram is low (check it with free -m), then check %cpu is working! Make sure zebra is working ps aux | grep zebrasrv and is enabled in Koha! Best regards! Nguyen Quoc Uy ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha themes CCSR and PROG
Did you make some change or import another css code? My opaccredit and opacheader work fine with prog, but with ccsr, it doesn't. Can you send me your link or images for cheking? Thanks! Best regards! Nguyen Quoc Uy On 30.03.2013, at 11:10, Josef Moravec josef.mora...@gmail.com wrote: Hello Ngueyn, we are runnig Koha 3.10.4 and the CCSR theme in OPAC and both header and footer work fine for us. Just to be sure that we all think about the same thing - we use opaccredits and opacheader system preferences. Josef Moravec On Sat, Mar 30, 2013 at 5:13 AM, Quoc Uy nguyenquocuy_1...@yahoo.com wrote: I'm checking Opac Koha 3.10 and 3.12 beta2. I found out that, if we use theme CCSR (mobile theme, i think), we can't include header and footer (it has some CSS error- need fix). So if we want to have header and footer in Opac, we must use PROG theme, right? Did anyone try to bring header and footer to CCSR theme? Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn http://vietnamlib.net Phone: +79525768182 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Josef Moravec josef.mora...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] problem with installing Koha-3.12.00-beta1
I'm installing Koha-3.12.00-beta1 tarball. Everything looks right, untill i met web install struction: Kohaweb installerstep 1,2 00 - Ok KohaWeb installerstep 3- error with this message Web installer › Step 3 The following error occurred while importing the database structure: ERROR 1064 (42000) at line 1004: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`reservesallowed` smallint(6) NOT NULL default 0, `branchcode` varchar(10) ' at line 20 Please contact your system administrator Anyone, who did install it, show me why, please? Do i have problem with my mysql server? Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn http://vietnamlib.net Phone: +79525768182 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] problem with installing Koha-3.12.00-beta1
Ok, i will try it tonight! Thanks for fast replying! Best regards! Nguyen Quoc Uy On 29.03.2013, at 20:27, Jared Camins-Esakov jcam...@cpbibliography.com wrote: There was a syntax error in beta1, and it looks like I forgot to upload a revised tarball after pushing the fix. Sorry! I will prepare a beta2, and upload that now. I have uploaded beta2. Please give it a spin and let us know how it goes. Regards, Jared -- Jared Camins-Esakov Bibliographer, C P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha themes CCSR and PROG
I'm checking Opac Koha 3.10 and 3.12 beta2. I found out that, if we use theme CCSR (mobile theme, i think), we can't include header and footer (it has some CSS error- need fix). So if we want to have header and footer in Opac, we must use PROG theme, right? Did anyone try to bring header and footer to CCSR theme? Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn http://vietnamlib.net Phone: +79525768182 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] authority search in koha 3.8.8
I think the problem is $100a is a authority record, which mean that you can't import new value to. You just only can pick its values. So i think if you want to import from file, go to Marc framework, change the $100a to normal value, so you can import values from your file. Hope this help! Best regards! Nguyen Quoc Uy ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] New interface for Koha- OPAC
I found that interface OPAC in http://catalog.bywatersolutions.com/ is really nice! Anyone can show me how to get it? I installed koha-3.10.02 but still got old opac-interface ( You can check it in http://library1.dreamlib.vn). I remembered it got that interface (with very big search-part) firstime when i tried koha-3.10.0 (2 moths ago), but now, it does not appear! Thanks! Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn http://vietnamlib.net Phone: +79525768182 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Which Koha version to use
Each 6 months, a new version of Koha (3.4, 3.6, 3.8, 3.10...) released. And then, people will support more to make update once a month (for example 3.x.x). There are lot of problems with update upgrade Koha earch version. Koha 3.6 was old-stable, but it is still supported, for someone who does not want to upgrade to Koha 3.8. Now koha 3.8 is stable version and 3.10 is new freeze version. Of course 3.10 has lots of bug fixed, better features, but has some new error, too. So if you did work with Koha before, i encourage you to use 3.10 (now newest is 3.10.2) and if not, use 3.8.9 is much easier. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Digest, Vol 87, Issue 38
Dear All Koha Users, Is it possible to operate 100 libraries centrally having data of 2million books? ==With one installation of Koha: You can create 100 branches libraries with one shared database with 2 million books. or you can create 100 libraries with 100 different databases (but with 200 millions books- i think not good for your server...) Is it possible to issue and return books off line when internet is not available? == Yes, tool works in Firefox Is it possible to give user only few rights i.e. cataloging and circulation? == Yes, create some staff, give them few permission (for example work with circulation, cataloging, not work with system-preferences ) Is it possible to make two data bases at a time i.e one for client and one for main server in case more than 100 libraries in one system? == i answered before, not 2 database, but 100... or you need make one more installation in another server Can I change MARC fields for my users i.e. limited fields only == Not very clearly what you want, but you can change MARC fields as you want Can pre printed bar code lables be pasted on books while using Koha i.e. (I want to take a detail, let say we have a bar code # 1 i.e. pre printed and we want to add this # 1 in our koha, is this possible? == YOu can pre-print barcode labels and pasted on books. Then you can use a barcode scan to add it into Koha. Only one thing, it must be original. Koha accept 1 barcode for 1 item. Koha has a tools, which help you to print out barcode of books, which you imported. I would really be thankful to you for your guidance, ==You're welcome! ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] About word-phrase-utf.chr file
I'm trying to search for my language, using English alphabet. For example, when i type a, Koha can search for â, ă, á, ạ, ả (these are some alphabet in my language) I'm now watching this file: /etc/koha/zebradb/etc/word-phrase-utf.chr I tried to edit this file, add some word to map some alphabet in my language some english alphabet but it didn't work. Am i doing right thing? And can someone show me how to edit this file? I'm using Ubuntu 12.04. Thanks so much! ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Problem with Zebra Index - Koha v3.08.001
First take a look at all preferences with keyword zebra, make sure zebra is enabled. Next, look at the cronjob in koha. Try with this command (for Debian) $sudo ps aux | grep zebrasrv (or something like that) to check zebra index server is working on your server. Then look that the koha-common file in /etc/cron.d/koha-common ( you can search with command $locate koha-common) and check for right command crontab. (I'm using Koha packages installed on Ubuntu). If Zebra is not working, you can search for barcode with search the cataloge, but now with the title or name... Hope this can help! ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Help to search another language with English
When i imported a book with title in my language ( unicode ), i can't use English to search it. I have to search with exactly keyword in my language. For example, can't search for Tây Sơn with Tay Son. Anyone can show me how to do this? Do i need to change some Admin system preferences or search.pl? Thanks for help! ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Zebra index for koha
I installed Koha by using http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages From beginning, it worked amazing, i created some instances. Now after restart system (reboot), zebraindex doesn't work. I used command koha-rebuild-zebra -v -f {instance} rebuild, but after this, how can i make zebra index works for all instances now and then automatic like it did before? Anyone got problem like this? i checked /etc/cron.d/koha-common SHELL=/bin/sh PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin */5 * * * * root test -x /usr/sbin/koha-rebuild-zebra koha-rebuild-zebra $(koha-list --enabled) */15 * * * * root koha-foreach --enabled --email /usr/share/koha/bin/cronjobs/process_message_queue.pl and used sudo /etc/init.d/koha-zebra-daemon start but it didn't work One more question, how can i search with unicode? Now my koha doesn't support this (3.8.7) Thanks all! ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Question about instances and VPS
I install Koha on a VPS. I create instances for my student and other librarians to test and learn about Koha. I have some questions: 1. How many instances can i create? (it's subdomain www.xxx.mylibrary.com) 2. And for example, 100-200 instances, is that problem with my VPS when they all work together? Do i have to care about my VPS's RAM, chipset, HDD, internet bandwidth, or something like that? Thanks! ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Apache bad username
What OS are you using? Debian or centos...? I think your problem is because of wrong configuration apache before. You should remove apache and all its configurations then install a fresh apache2. If u are using debian, ubuntu, you can check for koha packages install on ubuntu, it's an easies way, i think. Here is some command if u can't reinstall your Os. $ Sudo apt-get remove - -purge apache2 apache2.2-common This will remove all configurations file, maybe remove koha , and mail server. Be warning about this. Next $ sudo apt-get autoremove This clear all another dependence program and their config files. Next try reinstall apache again. Hope this help! And should not install as root, just add user and give him full admin privileges. But even with root, it should work! Best regards! Nguyen Quoc Uy ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Help with search in Koha
I'm vietnamese. when i create abook with name hình bóng, i can't search it with keywork hinh bong. One is Unicode-vietnamese, one is Latin- enlish. Any one can help? Best regards! Nguyen Quoc Uy ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] OPAC interface fail with Koha3.10.000 on ubuntu 12.04
I installed Koha-packages on ubuntu12.04. You can check this in OPAC http://test.dreamlib.org Intranet http://test-admin.dreamlib.org (user/pass: test/test) Can you tell me why i got fail interface on OPAC? I think OPAC.css is failed? I did reinstalled, still got this. Please help. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problem in importing Patron Records
First, i have problem with this, too. I downloaded original file patron_import.csv, opened it with Libreoffice Calc, watched table borrowers in database by Phpmyadmin. Then i tried to fill all file with the similar values as what i did before (add patron manual). Next i saved file as .csv file, and tried import patron. I failed with message: Line 2 Critical field surname missing (borrowernumber: UNDEF; surname: UNDEF)... Next i tried to change fomats all fields in their fomats (text, number, date), esspecially date YYY-MM-DD. Then i saved file as .csv file, and tried import patron. I failed with message: Line 2 Critical field surname missing (borrowernumber: UNDEF; surname: UNDEF)... (same error) I saved .csv file as .ods file, and tried import, once more time fail. Last time, maybe i was lucky, i use that.ods file, saved as .csv file, then i received a message: Export text file... field delimiter , text delimiter I press Ok, then saved. And i imported patrons without error. I don't understand it very clear, but just wanna share experience. Hope it can help someone else. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Prolem with setting 1.2.3.2 IndependantBranches
I'm trying to install Koha for sharing for 20 branches libraries in my province. I Prevent staff (but not superlibrarians) from modifying objects (holds, items, patrons, etc.) belonging to other libraries. Now a staff can't check out, check in for patrons or items belongs to another library. It works great. But when a staff (not superlibrarians )search in catalog, he still can see results belong to another branches libraries and can edit item, change item's status (lost, damaged). I don't know it's a bug or i forgot somethings? In relations with this setting, i have changed some system preferences 1.5.3.6 Don't allow patron hold or check out from other branches. 1.11.1.6 Add a choice branches on search opac (really nice, when patrons can search only in their library ) 1.11.3.10 Limit patron search on their own branch 1.11.3.11 Alow hold on only their branch. I'm wondering, shoult we put a preference, limit staff search on their own branch. So they can't see items belong to another branches libraries and can't edit it. Thanks for reading. Best regardes! NguyenQuocUy ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha