[Koha] Display question
Is there an easy way to get the biblionumber of a record to display somewhere on the "normal" view for a record in the staff interface? Or would it require an actual programming change? As it is, it displays in the URL in the browser navigation window, but I would like to be able to print out a record with it showing on the printout. Thanks, Tim Timothy Skeers | Cataloger | Iowa Library Services/State Library of Iowa | 1112 E. Grand Avenue | Des Moines, Iowa | 50319 | tim.ske...@lib.state.ia.us | (515) 725-0605 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Display question
Hi Tim You could edit either the .tt file or make a custom XSLT file to do that. But please do not make the mistake that was made with MARC and give a machine used value any human significance. The biblionumber is the primary key on a database row to allow Koha to identify a biblio. It should not be given any human significance, accession numbers, control numbers etc play that role for humans. Hope this helps Chris On 30 October 2015 7:05:55 am NZDT, Tim Skeerswrote: > >Is there an easy way to get the biblionumber of a record to display >somewhere on the "normal" view for a record in the staff interface? Or >would it require an actual programming change? > >As it is, it displays in the URL in the browser navigation window, but >I would like to be able to print out a record with it showing on the >printout. > >Thanks, > >Tim > > >Timothy Skeers | Cataloger | Iowa Library Services/State Library of >Iowa | 1112 E. Grand Avenue | Des Moines, Iowa | 50319 | >tim.ske...@lib.state.ia.us | (515) 725-0605 > > > > > >___ >Koha mailing list http://koha-community.org >Koha@lists.katipo.co.nz >https://lists.katipo.co.nz/mailman/listinfo/koha -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problems restoring a backup to a new server
How dis you create the backup? Did you use mysqldump or did you use the koha commands? For the .gz file try using gzip -d {path_to_backup_file}/koha_library.sql.gz then you'll get a koha_library.sql file which you can use to restore the database Boulier, Jack wrote > I am attempting to setup a new server and trying to restore the file > koha_library.sql.gz to the new server. I assume that the gz is a > compressed file. Using the command in the terminal "mysql -uroot -p > koha_library < koha_library.sql fails with the error file not found. I > attempt to tar the file with tar -zxfv and get an error that it is not a > valid tar file. Running Ubuntu precise1 and koha version 3.18.11.000. All > help is appreciated. > > > Jack Boulier, > LRC Director > 5221 Madison Ave. > Sacramento, CA 95841 > (916) 339-4370 Direct > (916) 339-0305 FAX > (916) 339-1500 Main > jboulier@ > > ___ > Koha mailing list http://koha-community.org > Koha@.co > https://lists.katipo.co.nz/mailman/listinfo/koha -- View this message in context: http://koha.1045719.n5.nabble.com/Problems-restoring-a-backup-to-a-new-server-tp5859297p5859299.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] Problems restoring a backup to a new server
Hi Jack > I am attempting to setup a new server and trying to restore the file > koha_library.sql.gz to the new server. I assume that the gz is a > compressed file. Using the command in the terminal "mysql -uroot -p > koha_library < koha_library.sql fails with the error file not found. > I attempt to tar the file with tar -zxfv and get an error that it is > not a valid tar file. Running Ubuntu precise1 and koha version > 3.18.11.000. All help is appreciated. Assuming you copied the file "koha_library.sql.gz" into directory "/tmp"... Change to /tmp: $ cd /tmp Decompress the file (this will result in file "koha_library.sql"): $ tar xzf koha_library.sql.gz Sorry, this is of course wrong! Instead decompress the file like (this will result in file "koha_library.sql"): $ gzip -d koha_library.sql.gz Then continue like I described: Now load the file: $ mysql -uroot -p koha_library < koha_library.sql Be sure you call this command while being in the directory where "koha_library.sql" resides. Of course also giving the absolute path is possible: $ mysql -uroot -p koha_library < /tmp/koha_library.sql Good luck, Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problems restoring a backup to a new server
Hi Jack > I am attempting to setup a new server and trying to restore the file > koha_library.sql.gz to the new server. I assume that the gz is a > compressed file. Using the command in the terminal "mysql -uroot -p > koha_library < koha_library.sql fails with the error file not found. > I attempt to tar the file with tar -zxfv and get an error that it is > not a valid tar file. Running Ubuntu precise1 and koha version > 3.18.11.000. All help is appreciated. Assuming you copied the file "koha_library.sql.gz" into directory "/tmp"... Change to /tmp: $ cd /tmp Decompress the file (this will result in file "koha_library.sql"): $ tar xzf koha_library.sql.gz Now load the file: $ mysql -uroot -p koha_library < koha_library.sql Be sure you call this command while being in the directory where "koha_library.sql" resides. Of course also giving the absolute path is possible: $ mysql -uroot -p koha_library < /tmp/koha_library.sql Hope this helps Kind regards, Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Display question
What kind of problems? Steve On 10/29/2015 3:23 PM, Katrin Fischer wrote: The biblionumber is the unique database assigned key for Koha, but as Chris has pointed out it is useless in another context and outside of Koha. I'd argue that reusing a deleted biblionumber like how you described sounds like a bug - it should not be possible to do that. One of the reasons being that then you'd have the same biblionumber in biblio and deletedbiblio and that would create problems. Katrin Am 29.10.2015 um 19:52 schrieb Steve: The biblionumber can be used to match on if reloading records. I have exported MARC records, made some mass changes, and then reloaded the changed records by matching on the biblionumber. (Match points 10, if points > 5 then go.) Worked well. I have even loaded new records by assigning a biblionumber that I know had been deleted in Koha. They loaded fine and assumed the biblionumber that I assigned. Steve SowderSystems Librarian sow...@andrews.edu Andrews University On 10/29/2015 2:15 PM, Chris Cormack wrote: Hi Tim You could edit either the .tt file or make a custom XSLT file to do that. But please do not make the mistake that was made with MARC and give a machine used value any human significance. The biblionumber is the primary key on a database row to allow Koha to identify a biblio. It should not be given any human significance, accession numbers, control numbers etc play that role for humans. Hope this helps Chris On 30 October 2015 7:05:55 am NZDT, Tim Skeerswrote: Is there an easy way to get the biblionumber of a record to display somewhere on the "normal" view for a record in the staff interface? Or would it require an actual programming change? As it is, it displays in the URL in the browser navigation window, but I would like to be able to print out a record with it showing on the printout. Thanks, Tim Timothy Skeers | Cataloger | Iowa Library Services/State Library of Iowa | 1112 E. Grand Avenue | Des Moines, Iowa | 50319 | tim.ske...@lib.state.ia.us | (515) 725-0605 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Problems restoring a backup to a new server
I am attempting to setup a new server and trying to restore the file koha_library.sql.gz to the new server. I assume that the gz is a compressed file. Using the command in the terminal "mysql -uroot -p koha_library < koha_library.sql fails with the error file not found. I attempt to tar the file with tar -zxfv and get an error that it is not a valid tar file. Running Ubuntu precise1 and koha version 3.18.11.000. All help is appreciated. Jack Boulier, LRC Director 5221 Madison Ave. Sacramento, CA 95841 (916) 339-4370 Direct (916) 339-0305 FAX (916) 339-1500 Main jboul...@mticollege.edu ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Display question
The biblionumber can be used to match on if reloading records. I have exported MARC records, made some mass changes, and then reloaded the changed records by matching on the biblionumber. (Match points 10, if points > 5 then go.) Worked well. I have even loaded new records by assigning a biblionumber that I know had been deleted in Koha. They loaded fine and assumed the biblionumber that I assigned. Steve SowderSystems Librarian sow...@andrews.edu Andrews University On 10/29/2015 2:15 PM, Chris Cormack wrote: Hi Tim You could edit either the .tt file or make a custom XSLT file to do that. But please do not make the mistake that was made with MARC and give a machine used value any human significance. The biblionumber is the primary key on a database row to allow Koha to identify a biblio. It should not be given any human significance, accession numbers, control numbers etc play that role for humans. Hope this helps Chris On 30 October 2015 7:05:55 am NZDT, Tim Skeerswrote: Is there an easy way to get the biblionumber of a record to display somewhere on the "normal" view for a record in the staff interface? Or would it require an actual programming change? As it is, it displays in the URL in the browser navigation window, but I would like to be able to print out a record with it showing on the printout. Thanks, Tim Timothy Skeers | Cataloger | Iowa Library Services/State Library of Iowa | 1112 E. Grand Avenue | Des Moines, Iowa | 50319 | tim.ske...@lib.state.ia.us | (515) 725-0605 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Display question
Hi, Tim-- It's not the normal view of the staff client, but a couple of times I really wanted a printout of a record with everything, including the biblionumber (for later overlaying from OCLC), so I printed the MARC view from the public OPAC--it gives me the MARC record (with the record no. prominently) and the item(s), too. Hope this helps! --h2 ~~ Heather Hernandez Technical Services Librarian San Francisco Maritime National Historical Park Research Center 415-561-7032, heather_hernan...@nps.gov http://www.nps.gov/safr/learn/historyculture/museum-collections.htm "The sailor does not pray for wind, he learns to sail."--Gustaf Lindborg ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problems restoring a backup to a new server
How dis you create the backup? Did you use mysqldump or did you use the koha commands? For the .gz file try using gzip -d {path_to_backup_file}/koha_library.sql.gz then you'll get a koha_library.sql file which you can use to restore the database -- View this message in context: http://koha.1045719.n5.nabble.com/Problems-restoring-a-backup-to-a-new-server-tp5859297p5859298.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] Display question
Off hand, I would say that you would run into errors if and when you deleted the bib record a second time... Koha will want to copy the data from biblio to deleted_biblio then remove the bib record, but it will get a referential integrity check if it tries. My guess is that you would have to remove the record via the database. On Oct 29, 2015 3:41 PM, "Steve Sowder"wrote: > What kind of problems? > > Steve > > On 10/29/2015 3:23 PM, Katrin Fischer wrote: > >> The biblionumber is the unique database assigned key for Koha, but as >> Chris has pointed out it is useless in another context and outside of >> Koha. >> >> I'd argue that reusing a deleted biblionumber like how you described >> sounds like a bug - it should not be possible to do that. One of the >> reasons being that then you'd have the same biblionumber in biblio and >> deletedbiblio and that would create problems. >> >> Katrin >> >> Am 29.10.2015 um 19:52 schrieb Steve: >> >>> The biblionumber can be used to match on if reloading records. I have >>> exported MARC records, made some mass changes, and then reloaded the >>> changed records by matching on the biblionumber. (Match points 10, if >>> points > 5 then go.) Worked well. >>> >>> I have even loaded new records by assigning a biblionumber that I know >>> had been deleted in Koha. >>> They loaded fine and assumed the biblionumber that I assigned. >>> >>> >>> Steve SowderSystems Librarian >>> sow...@andrews.edu Andrews University >>> >>> >>> On 10/29/2015 2:15 PM, Chris Cormack wrote: >>> Hi Tim You could edit either the .tt file or make a custom XSLT file to do that. But please do not make the mistake that was made with MARC and give a machine used value any human significance. The biblionumber is the primary key on a database row to allow Koha to identify a biblio. It should not be given any human significance, accession numbers, control numbers etc play that role for humans. Hope this helps Chris On 30 October 2015 7:05:55 am NZDT, Tim Skeers wrote: > Is there an easy way to get the biblionumber of a record to display > somewhere on the "normal" view for a record in the staff interface? Or > would it require an actual programming change? > > As it is, it displays in the URL in the browser navigation window, but > I would like to be able to print out a record with it showing on the > printout. > > Thanks, > > Tim > > > Timothy Skeers | Cataloger | Iowa Library Services/State Library of > Iowa | 1112 E. Grand Avenue | Des Moines, Iowa | 50319 | > tim.ske...@lib.state.ia.us | (515) 725-0605 > > > > > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ >>> Koha mailing list http://koha-community.org >>> Koha@lists.katipo.co.nz >>> https://lists.katipo.co.nz/mailman/listinfo/koha >>> >> ___ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Difficulty filling out accounting info
Good morning Ever since we were upgraded to 3.20.4 I have had difficulty filling out the accounting information for each item. I have found a work around for the books as I can can fill them out using the Uncertain Prices page then edit each item later, but I cannot do this for the subscriptions. Basically as soon as I enter the vendor price the rest of the price fields change to NaN (have no idea what this means) but the Budgeted cost and total cost fields are not editable. Then I cannot save because I get the error message -Total must be a number. Could anyone give me a hint as to what is wrong so I can tell our tech support where to look. Gratefully Ann Murphy Katikati College ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Z39.50 Bug -> marcxml_old on import_records table
See all bug 13526 and the discussion on bug 5366 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13523 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5366 2015-10-29 8:16 GMT+00:00 Jonathan Druart: > Hello Pedro, > > You should not use MySQL 5.6, some bugs are known: bug 13669 and bug > 14637, and certainly some others. > Until now nobody has shown a special interest for these issues. > > Regards, > Jonathan > > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14637 > > 2015-10-28 16:17 GMT+00:00 Pedro Amorim : >> Also, some other thing to note: >> >> The mysql I'm running is 5.6.25. >> >> 2015-10-28 15:14 GMT-01:00 Pedro Amorim : >> >>> Hello, >>> >>> Version: Koha 3.2002000 >>> >>> My name is Pedro Amorim and I've been implementing Koha for the first time >>> for the past couple of days now. >>> >>> This is a fresh package install. >>> >>> This is a bug (I think) I stumbled upon and this is how I solved it: >>> When performing a Z39.50 search I kept getting no records found despite >>> the fact that I knew there were records (doing a yaz-client search and >>> using the online demo returned results, so why didn't it return in my >>> installation?). >>> >>> So I found out that the records should've been inserted in the >>> import_records table but they weren't. Because marcxml_old wasn't being >>> defined and it expected some value (NULL = NO), so I went in and changed >>> the database structure to NULL = YES and everything is now working as >>> expected. >>> >>> I think this also has something to do with mysql STRICT_TRANS_TABLES but I >>> would like some confirmation on that. >>> >>> I'm new in the whole Koha scene and don't yet know how to submit bugs. >>> I'm sending this mail in the hopes that someone confirms that this is >>> indeed a bug and document the given solution. >>> >>> Cheers >>> >> ___ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Z39.50 Bug -> marcxml_old on import_records table
Hello Pedro, You should not use MySQL 5.6, some bugs are known: bug 13669 and bug 14637, and certainly some others. Until now nobody has shown a special interest for these issues. Regards, Jonathan http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14637 2015-10-28 16:17 GMT+00:00 Pedro Amorim: > Also, some other thing to note: > > The mysql I'm running is 5.6.25. > > 2015-10-28 15:14 GMT-01:00 Pedro Amorim : > >> Hello, >> >> Version: Koha 3.2002000 >> >> My name is Pedro Amorim and I've been implementing Koha for the first time >> for the past couple of days now. >> >> This is a fresh package install. >> >> This is a bug (I think) I stumbled upon and this is how I solved it: >> When performing a Z39.50 search I kept getting no records found despite >> the fact that I knew there were records (doing a yaz-client search and >> using the online demo returned results, so why didn't it return in my >> installation?). >> >> So I found out that the records should've been inserted in the >> import_records table but they weren't. Because marcxml_old wasn't being >> defined and it expected some value (NULL = NO), so I went in and changed >> the database structure to NULL = YES and everything is now working as >> expected. >> >> I think this also has something to do with mysql STRICT_TRANS_TABLES but I >> would like some confirmation on that. >> >> I'm new in the whole Koha scene and don't yet know how to submit bugs. >> I'm sending this mail in the hopes that someone confirms that this is >> indeed a bug and document the given solution. >> >> Cheers >> > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 3.20.03 - koha-opac-error_log
Hi all, I have 2 errors at koha-opac-error_log at below: [Thu Oct 29 13:41:00 2015] opac-search.pl: C4::Context->userenv not defined! at /usr/share/koha/lib/C4/Items.pm line 1355. [Thu Oct 29 13:53:31 2015] opac-detail.pl: C4::Context->userenv not defined! at /usr/share/koha/lib/C4/Items.pm line 1355., referer: https://www.google.com.tr/ I searched these errors but I didn't found about it. What does these means? How can I solve these errors? Thanks to all helps... Regards, Özkan ÖZMEN CENTER OF LIBRARY BALIKESİR UNIVERSITY - TURKEY YASAL UYARI: Bu elektronik posta ve onunla iletilen butun dosyalar kisiye ozeldir ve sadece gondericisi tarafindan almasi amaclanan yetkili gercek ya da tuzel kisinin kullanimi icindir. Eger soz konusu yetkili alici siz degilseniz bu elektronik postanin icerigini aciklamaniz, kopyalamaniz, yonlendirmeniz ve kullanmaniz kesinlikle yasaktir. Bu mesajin gonderilmek istendigi kisi degilseniz (ya da bu e-posta'yi yanlislikla aldiysaniz), lutfen yollayan kisiyi haberdar ediniz ve mesaji sisteminizden derhal siliniz. Kurumumuz, bu mesajin icerdigi bilgilerin dogrulugu veya eksiksiz oldugu konusunda herhangi bir garanti vermemektedir. Bu nedenle bu epostanin ne sekilde olursa olsun iceriginden, iletilmesinden, alinmasindan ve saklanmasindan kurumumuz sorumlu degildir. Bu mesajdaki gorusler yalnizca gonderen kisiye ait olup, her zaman kurumumuzun goruslerini yansitmayabilir. Bu e-posta, bilinen butun bilgisayar viruslerine karsi anti-virus sistemimiz tarafindan taranmistir. Ancak yollayici, bu e-posta mesajinin virus icermedigini garanti etmez ve meydana gelebilecek zararlardan dogacak hukuki ve mali hic bir sorumlulugu kabul etmez. DISCLAIMER: This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any dissemination, forwarding, copying or use of any of the information is strictly prohibited. If you are not the intended recipient (or have received this e-mail by mistake), please notify the sender and delete it from your system immediately. Our university makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained therein or for the information transmission, reception, storage or use of such in any way whatsoever. The opinions expressed in this message may belong to sender alone and may not necessarily reflect the opinions of our university. This e-mail has been scanned by our anti-virus system for all known computer viruses. In doing so, however, sender cannot guarantee that virus or other forms of data corruption may not be present and do not take any legal or financial responsibility in any occurrance. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha