[Koha] Paid Support Enquiry (was Re: Koha Digest, Vol 103, Issue 41)
On 29/05/14 01:01, Ilesanmi S. Olawale wrote: Hiya !. Please, we would like to know how much does it cost to install koha / Opac ?. Thanks Hi Ilesanmi, Rather than replying to the digest, its better to start a new thread. Koha is free software that you can download from http://koha-community.org/download-koha/ . The recommended method of installation is from Debian packages. You can ask questions on this list. Koha is also an enterprise-class LMS, so you may save a lot of time by purchasing commercial support. A partial list of companies that can help you is here: http://koha-community.org/support/paid-support/continent/ ProjektLink Konsult Limited is in Nigeria: http://www.projektlinkkonsult.com There is no standard price for Koha services. Approach support companies directly. I hope this helps, Bob Birchall Calyx ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Subject breakdown in Koha
On 29/05/14 01:14, make...@msu.ac.zw wrote: Dear all I am trying to get a breakdown of SUBJECTS from my Koha installation and have no clue as to how to do it. For example can it show me the number of holdings and their subjects? Thanks in advance. There might be some reports under Cataloguing (section 5) here that may help you: http://wiki.koha-community.org/wiki/SQL_Reports_Library Bob Birchall Calyx ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Restrict checkout beyond current check out allowed
Dear Owen, Thank you for a quick reply. Our AllowRenewalLimitOverride is Dont Allow. This setting for Renewal Limit. We need a separate setting restrict checout limit override. I have submitted a suggestion in Koha bugzilla. Regards, -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://moovandan.blogspot.in --- I forget what I was taught. I only remember what I have learnt -Patrick White ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Technical help with Frameworks
Hi to all, Il 29/05/2014 01:14, Elaine Bradtke ha scritto: I have edited frameworks this way before 3.14. I'd be interested to know if anyone has edited a framework exported from 3.14 and had it import successfully. Has something changed in the import / export process that is causing it to fail? in my experience, the best format to use to work offline with Frameworks is .sql. I work on windows with Notepad++ I create new frameworks starting from FA framework, adding fiels and subfields from Default with cut-and-paste. To do massise change on sam values is use SQL. I import Framework in a specific db with command line, I do the change, I export with command line also. On command line for MySQL I suggest to google it. Bye Zeno Tajoli -- Dr. Zeno Tajoli Dipartimento STAF - Automazione Biblioteche z.taj...@cineca.it fax +39 02 2135520 CINECA - Sede operativa di Segrate ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Special character in itemcallnumber does not display in spine label
Dear Friends, I have notices that special character like / does not display in spine label. Librarians assigns special character between call number and item number. Any solution to display special characters in spine label? Regards, -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://moovandan.blogspot.in --- I forget what I was taught. I only remember what I have learnt -Patrick White ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Big problem in Staff Client, Koha 3.14.5
Hello to everyone I found the problems and I fixed it. I think it can be useful for everyone to know what was the problem and how I could fix it. Maybe someone else one day could go into same trubles :-) Following what Zeno Tajoli suggested me, I investigated the page source of the webpage that appeared almost all white and I found out that there was some wrong html: wrong html tags such as HTML/. I would like to cut and paste some of that bad formatted html but maybe it would also make unreadable some parts of this email. If someone is interested I can send some screenshot. (later I try to send an email with the html wrong code). Due to the blank page, I couldn't access to the staff client and investigate in the Global System Preferences. Due also to the terrible internet connection of the server (in Eritrea) I couldn't use a normal browser MySQL iterface to access the database and search for that code - I had to work during the night to have a little bit better connection ! So I made a mysqldump of the whole database, I used the grep to see if there was the bad html line and... succes !! It was there. I deleted the bad html tags and reload the dump into the database (of course I previously made a backup). Magically I could access again to the staff client (I admit I was lucky) and see everything. There were still some not well working items, for example it was impossible to see the patrons' information (the page was keeping going on loading loading loading...) Keeping investigatind the dump of the database, I found out that there were many html bad tags in many global system preferences (especially in the field where the library-opac manager can put some html code, for example opacheader and so on.). Fixing this bad formatted fields in the staff-client Global System Preferences, everything worked again ! So, a suggestion for new or not expert Koha users: pay a lot of attention when you put some html formatted code !!! If you are not more than sure about your html (but I would suggest always) make a backup of the database before adding html to your opac throught the staff client! Otherwise you risk to go out without the key and close the door behind you :-) Claudio K. P.S. I'll send also a mail with the bad html code to show how simple was the problem, I hope you can read it At 18.08 30/04/2014 +0200, Claudio Kutufà wrote: Hi again I got a screenshot from the guys/girls of the staff Actually over the koha logo it is possible to see the small menu words Circulation Patrons Search Cart and more but, as they say: 1st) the other part of the page is completely white, there are not the usual bottons 2nd) when clicking, all the menus - except the search - don't bring any result thanks a lot again claudio At 17.04 30/04/2014 +0200, Claudio Kutufà wrote: hello all I have a big problem in the staff client. The Koha version is 3.14.5 installed on april the 15th. Unfortunately I cannot access to the server because it is in Eritrea (they have an extremely slow connection to internet) and I'm in Italy now. So I should suggest something to the people who are in charge of the koha server nowdays. We installed Koha 3.14 and it was working perfectly. We catalogued about 50 books/eBooks and I left it perfectly working. Yesterday the staff peole mailed me telling that they are not able to do anything anymore in the staff client. I'll try to explain better: The opac is pefectly working, but when they try to access to the Staff Cleint (on port 8080) they aalway see an almost complete white page ! They see (and they sent me a screenshot) just the Koha logo on the left top. No other menu voices are available !! This happens whichever are the us/pwd they use. Also if they use the embedded us/pw (the credentials that you can find in /etc7koha.conf) they get just the white page. They swear that they didn't do anything on that server, but all this make me think that it is a server problem and not a koha configuration problem. Do you have any idea about this strange thing ? Can you suggest me something to check ? Thanks a lot in advance !! Claudio K. ___ Ing. Claudio Kutufa' e-mail ufficio: claud...@nexusfi.it e-mail personale:claudio.kut...@gmail.com Via Vamba Luigi Bertelli, 16 50135 Firenze - Italy Cell.:+39 335 5859567 Tel.abitazione: +39 055 400743 ___ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha - Nessun virus nel messaggio. Controllato da AVG - www.avg.com Versione: 2014.0.4570 / Database dei virus: 3931/7419 - Data di rilascio: 30/04/2014 ___ Ing. Claudio Kutufa' e-mail ufficio: claud...@nexusfi.it e-mail personale:
Re: [Koha] Big problem in Staff Client, Koha 3.14.5
Here is some of the bad html code: this is what I told to the people who are in charge for that library: (...) you will see the html page source, you will see that there is something wrong in the html code. After HTMLtitleMOJ DIGITAL LIBRARYtitle/HTML/ the html is all grey and the browser doesn't see it as html code. I think that someone changed the Global Sysytem Preferences (that it is not in the snapshot) writing HTMLtitleMOJ DIGITAL LIBRARYtitle/HTML/ inside the database (throught staff-client) (...) of course the tags HTMLHTML/ titletitle/ are wrong and they were enough to make the staff client not working ! Of course nobody admitted that someone wrote something... but this is the life :-) Thanks again to Zeno who suggested me the write way to investigate the problem Claudio K. At 11.26 29/05/2014 +0200, Claudio Kutufà wrote: Hello to everyone I found the problems and I fixed it. I think it can be useful for everyone to know what was the problem and how I could fix it. Maybe someone else one day could go into same trubles :-) Following what Zeno Tajoli suggested me, I investigated the page source of the webpage that appeared almost all white and I found out that there was some wrong html: wrong html tags such as HTML/. I would like to cut and paste some of that bad formatted html but maybe it would also make unreadable some parts of this email. If someone is interested I can send some screenshot. (later I try to send an email with the html wrong code). Due to the blank page, I couldn't access to the staff client and investigate in the Global System Preferences. Due also to the terrible internet connection of the server (in Eritrea) I couldn't use a normal browser MySQL iterface to access the database and search for that code - I had to work during the night to have a little bit better connection ! So I made a mysqldump of the whole database, I used the grep to see if there was the bad html line and... succes !! It was there. I deleted the bad html tags and reload the dump into the database (of course I previously made a backup). Magically I could access again to the staff client (I admit I was lucky) and see everything. There were still some not well working items, for example it was impossible to see the patrons' information (the page was keeping going on loading loading loading...) Keeping investigatind the dump of the database, I found out that there were many html bad tags in many global system preferences (especially in the field where the library-opac manager can put some html code, for example opacheader and so on.). Fixing this bad formatted fields in the staff-client Global System Preferences, everything worked again ! So, a suggestion for new or not expert Koha users: pay a lot of attention when you put some html formatted code !!! If you are not more than sure about your html (but I would suggest always) make a backup of the database before adding html to your opac throught the staff client! Otherwise you risk to go out without the key and close the door behind you :-) Claudio K. P.S. I'll send also a mail with the bad html code to show how simple was the problem, I hope you can read it At 18.08 30/04/2014 +0200, Claudio Kutufà wrote: Hi again I got a screenshot from the guys/girls of the staff Actually over the koha logo it is possible to see the small menu words Circulation Patrons Search Cart and more but, as they say: 1st) the other part of the page is completely white, there are not the usual bottons 2nd) when clicking, all the menus - except the search - don't bring any result thanks a lot again claudio At 17.04 30/04/2014 +0200, Claudio Kutufà wrote: hello all I have a big problem in the staff client. The Koha version is 3.14.5 installed on april the 15th. Unfortunately I cannot access to the server because it is in Eritrea (they have an extremely slow connection to internet) and I'm in Italy now. So I should suggest something to the people who are in charge of the koha server nowdays. We installed Koha 3.14 and it was working perfectly. We catalogued about 50 books/eBooks and I left it perfectly working. Yesterday the staff peole mailed me telling that they are not able to do anything anymore in the staff client. I'll try to explain better: The opac is pefectly working, but when they try to access to the Staff Cleint (on port 8080) they aalway see an almost complete white page ! They see (and they sent me a screenshot) just the Koha logo on the left top. No other menu voices are available !! This happens whichever are the us/pwd they use. Also if they use the embedded us/pw (the credentials that you can find in /etc7koha.conf) they get just the white page. They swear that they didn't do anything on that server, but all this make me think that it is a server problem and not a koha configuration problem. Do you have any idea about this strange thing ? Can you suggest me something to
Re: [Koha] Big problem in Staff Client, Koha 3.14.5
Here is some of the bad html code: this is what I told to the people who are in charge for that library: (...) you will see the html page source, you will see that there is something wrong in the html code. After HTMLtitleMOJ DIGITAL LIBRARYtitle/HTML/ the html is all grey and the browser doesn't see it as html code. I think that someone changed the Global Sysytem Preferences (that it is not in the snapshot) writing HTMLtitleMOJ DIGITAL LIBRARYtitle/HTML/ inside the database (throught staff-client) (...) of course the tags HTMLHTML/ titletitle/ are wrong and they were enough to make the staff client not working ! Nobody admitted that someone wrote something... but this is the life :-) Thanks again to Zeno who suggested me the write way to investigate the problem Claudio K. At 11.26 29/05/2014 +0200, Claudio Kutufà wrote: Hello to everyone I found the problems and I fixed it. I think it can be useful for everyone to know what was the problem and how I could fix it. Maybe someone else one day could go into same trubles :-) Following what Zeno Tajoli suggested me, I investigated the page source of the webpage that appeared almost all white and I found out that there was some wrong html: wrong html tags such as HTML/. I would like to cut and paste some of that bad formatted html but maybe it would also make unreadable some parts of this email. If someone is interested I can send some screenshot. (later I try to send an email with the html wrong code). Due to the blank page, I couldn't access to the staff client and investigate in the Global System Preferences. Due also to the terrible internet connection of the server (in Eritrea) I couldn't use a normal browser MySQL iterface to access the database and search for that code - I had to work during the night to have a little bit better connection ! So I made a mysqldump of the whole database, I used the grep to see if there was the bad html line and... succes !! It was there. I deleted the bad html tags and reload the dump into the database (of course I previously made a backup). Magically I could access again to the staff client (I admit I was lucky) and see everything. There were still some not well working items, for example it was impossible to see the patrons' information (the page was keeping going on loading loading loading...) Keeping investigatind the dump of the database, I found out that there were many html bad tags in many global system preferences (especially in the field where the library-opac manager can put some html code, for example opacheader and so on.). Fixing this bad formatted fields in the staff-client Global System Preferences, everything worked again ! So, a suggestion for new or not expert Koha users: pay a lot of attention when you put some html formatted code !!! If you are not more than sure about your html (but I would suggest always) make a backup of the database before adding html to your opac throught the staff client! Otherwise you risk to go out without the key and close the door behind you :-) Claudio K. P.S. I'll send also a mail with the bad html code to show how simple was the problem, I hope you can read it At 18.08 30/04/2014 +0200, Claudio Kutufà wrote: Hi again I got a screenshot from the guys/girls of the staff Actually over the koha logo it is possible to see the small menu words Circulation Patrons Search Cart and more but, as they say: 1st) the other part of the page is completely white, there are not the usual bottons 2nd) when clicking, all the menus - except the search - don't bring any result thanks a lot again claudio At 17.04 30/04/2014 +0200, Claudio Kutufà wrote: hello all I have a big problem in the staff client. The Koha version is 3.14.5 installed on april the 15th. Unfortunately I cannot access to the server because it is in Eritrea (they have an extremely slow connection to internet) and I'm in Italy now. So I should suggest something to the people who are in charge of the koha server nowdays. We installed Koha 3.14 and it was working perfectly. We catalogued about 50 books/eBooks and I left it perfectly working. Yesterday the staff peole mailed me telling that they are not able to do anything anymore in the staff client. I'll try to explain better: The opac is pefectly working, but when they try to access to the Staff Cleint (on port 8080) they aalway see an almost complete white page ! They see (and they sent me a screenshot) just the Koha logo on the left top. No other menu voices are available !! This happens whichever are the us/pwd they use. Also if they use the embedded us/pw (the credentials that you can find in /etc7koha.conf) they get just the white page. They swear that they didn't do anything on that server, but all this make me think that it is a server problem and not a koha configuration problem. Do you have any idea about this strange thing ? Can you suggest me something to check ?
[Koha] Unimarc Indicators
Hi everybody, Do I have to fill indicators in when cataloguing? or Is there a way to pre-set them on Koha for selecting when cataloguing? or yet Are they really needed, once Koha not strictly follows what Unimarc manuals recommed? Searching Koha foruns, I could verify that many people have approached this subject on several occasions, but I wasn't able to find a definitive answer and I would like to be sure before starting the records migration process. I can be wrong, but it seems to me that indicators have less relevance in Authorities than in Biblio as they can generate notes (block 4xx) for example, unless Koha comes already set for these and other indicators functions by default. Many thanks in advance and best regards from Júlio ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Technical help with Frameworks
Well I found this error in /var/log/koha/library/intranet-error.log: [Wed May 28 10:51:48 2014] [error] [client 10.168.3.45] [Wed May 28 10:51:48 2014] import_export_framework.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/koha/lib/C4/ImportExportFramework.pm line 284., referer: http://10.168.50.99:8080/cgi-bin/koha/admin/biblio_framework.pl This error does not always correspond with when I am trying to import a framework though. Am I barking up the wrong tree looking at this? Or have I missed a special syntax for the CSV to import? -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Elaine Bradtke Sent: 29 May 2014 00:15 To: Ian Bays Cc: koha Subject: Re: [Koha] Technical help with Frameworks Theoretically, you can edit the visibility offline in the spreadsheet. Column M in the MARC subfield structure sheet. Easier to do than individually in Koha itself. However, I've tried .ods, and I've tried xls and all I get are import errors. I have edited frameworks this way before 3.14. I'd be interested to know if anyone has edited a framework exported from 3.14 and had it import successfully. Has something changed in the import / export process that is causing it to fail? All I want to do is set up a very simple framework to use with an in-house template that doesn't take me a day's work to hide and unhide all the subfields one at a time. On Wed, May 28, 2014 at 5:43 PM, Ian Bays ian.b...@ptfs-europe.com wrote: Hi Tim, We find that the safest way of trimming frameworks to a more minimalist set is to hide the subfields. This can be quite laborious through the staff interface as you have to select each subfield and look in Advanced constraints then Visibility. If you have access at the sql level you can probably set the field hidden in table marc_subfield_structure to value -6 for those tags you do not want to appear (within your chosen framework). You might also want to change the tab for display to all be the same (eg 0) if you only have 18 tags. That just makes it clearer on the screen. Not every field has or needs to have a koha to marc mapping, but a few of the koha fields must be mapped to marc subfields. The Administration tool MARC bibliographic framework test and other tools in the same area should help fine tune it. We try to avoid removing fields (tags) and subfields from frameworks as you could lose bibliographic data if you switch between frameworks while editing and save the record. It depends what your longer-term plans might be for use of the system as to whether this might be a consideration. If you stray too far from the MARC standard tags you may find that searching for records becomes unreliable as the search indexes are fed from the fields and subfields according to the MARC21 (or UNIMARC) standard. Good luck. Ian On 28/05/2014 15:09, Alexander Tim wrote: Not sure if this is the correct list to email but if not hoping someone can send me in the right direction! So, I am not a Librarian but work as a sys admin for my company. We have a small Company Library that is used to publish various technical publications for our users to look through. We are looking to move to Koha but I find I am struggling with the initial steps of trimming down the MARC Framework. The list of fields I have been passed by our Librarian is for only 18 or so fields. I am therefore finding cutting down the default framework very laborious. I have looked to Import a cut down version of the framework, from an amended export to CSV, but this fails with Error Importing the Framework. I was then hoping that there is something on the SQL side I could do to amend the framework but this has not exactly yielded any useful results. Is there anywhere I can check for an error on the framework import? If not is there any guidance on cutting a framework down to just the required fields? I am also concerned that not every field we have in the proposed framework would have a corresponding Koha to MARC mapping. Would this be required or are these there for simplicity rather than a necessity? Regards Tim Tindall Riley Marine (UK) Limited Authorised and regulated in the UK by the Financial Conduct Authority. Registered Office: Regis House, 45 King William Street, London EC4R 9AN Company No: 8451968. V.A.T. No.: 174 7460 86 Tel: +44 (0)20 7407 3588 Fax: +44 (0)20 7403 3942 This email (and any attachments) is confidential and may be privileged. It may be read, copied and used only by the addressee. If you have received this in error, please contact us immediately. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Ian Bays Director of Projects, PTFS Europe Limited Content Management and Library Solutions +44 (0) 800 756 6803 (phone) +44 (0)
[Koha] Database problem and upgrade
Whenever I try to mysqldump Koha (3.0), the dump fails on line 35431 with an error 2013, lost connection to the MySQL server. To resolve this issue I've tried the following: 1. Changing the my.cnf setting to give a longer time out for the connection, reads and writes - Did not resolve the issue. 2. Ran mysqlcheck to fix the database and also the table. - Table comes back OK but the dump still fails. 3. Do a select on the item using limit to see which record is causing the problem - I get a 2013 error when trying this. If anyone has any suggestion on how to delete this row and dump the database, please let me know. I've exhausted days working on this issue. Thanks, Phillip ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Problem in Koha item types
Dear Sir, Sorry to bring a question to the list, but we're facing a problem in KOHA under item type location and I need some advice and help. My Koha problem is, it's show *[Type: Book] *every items like i.e. Journals, CD (Audio/Visual), proceeding etc. In this connection, herewith attached screen shot for your information. In this regards,we are request to you, please kindly provide help to me, how can edit, remove item types accordingly book, journal, etc. Please do the needful. *With Regards,* *Ashish Kumar * *9717864664* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Technical help with Frameworks
Tim, I am not sure if this is what you might want but find here [ https://dl.dropboxusercontent.com/u/7725309/export_FAST%20%281%29.csv] our custom framework that you can enhance or use as it is (exported as CSV spreadsheet) if you want it in any of the other 2 formats let me know. EVAN NJOROGE *•*+254721375981 *•*+254721375981 *•*about.me/uhusiano *•*adlsn.org * Facilitating access to African digital content * On Thu, May 29, 2014 at 2:14 AM, Elaine Bradtke e...@efdss.org wrote: Theoretically, you can edit the visibility offline in the spreadsheet. Column M in the MARC subfield structure sheet. Easier to do than individually in Koha itself. However, I've tried .ods, and I've tried xls and all I get are import errors. I have edited frameworks this way before 3.14. I'd be interested to know if anyone has edited a framework exported from 3.14 and had it import successfully. Has something changed in the import / export process that is causing it to fail? All I want to do is set up a very simple framework to use with an in-house template that doesn't take me a day's work to hide and unhide all the subfields one at a time. On Wed, May 28, 2014 at 5:43 PM, Ian Bays ian.b...@ptfs-europe.com wrote: Hi Tim, We find that the safest way of trimming frameworks to a more minimalist set is to hide the subfields. This can be quite laborious through the staff interface as you have to select each subfield and look in Advanced constraints then Visibility. If you have access at the sql level you can probably set the field hidden in table marc_subfield_structure to value -6 for those tags you do not want to appear (within your chosen framework). You might also want to change the tab for display to all be the same (eg 0) if you only have 18 tags. That just makes it clearer on the screen. Not every field has or needs to have a koha to marc mapping, but a few of the koha fields must be mapped to marc subfields. The Administration tool MARC bibliographic framework test and other tools in the same area should help fine tune it. We try to avoid removing fields (tags) and subfields from frameworks as you could lose bibliographic data if you switch between frameworks while editing and save the record. It depends what your longer-term plans might be for use of the system as to whether this might be a consideration. If you stray too far from the MARC standard tags you may find that searching for records becomes unreliable as the search indexes are fed from the fields and subfields according to the MARC21 (or UNIMARC) standard. Good luck. Ian On 28/05/2014 15:09, Alexander Tim wrote: Not sure if this is the correct list to email but if not hoping someone can send me in the right direction! So, I am not a Librarian but work as a sys admin for my company. We have a small Company Library that is used to publish various technical publications for our users to look through. We are looking to move to Koha but I find I am struggling with the initial steps of trimming down the MARC Framework. The list of fields I have been passed by our Librarian is for only 18 or so fields. I am therefore finding cutting down the default framework very laborious. I have looked to Import a cut down version of the framework, from an amended export to CSV, but this fails with Error Importing the Framework. I was then hoping that there is something on the SQL side I could do to amend the framework but this has not exactly yielded any useful results. Is there anywhere I can check for an error on the framework import? If not is there any guidance on cutting a framework down to just the required fields? I am also concerned that not every field we have in the proposed framework would have a corresponding Koha to MARC mapping. Would this be required or are these there for simplicity rather than a necessity? Regards Tim Tindall Riley Marine (UK) Limited Authorised and regulated in the UK by the Financial Conduct Authority. Registered Office: Regis House, 45 King William Street, London EC4R 9AN Company No: 8451968. V.A.T. No.: 174 7460 86 Tel: +44 (0)20 7407 3588 Fax: +44 (0)20 7403 3942 This email (and any attachments) is confidential and may be privileged. It may be read, copied and used only by the addressee. If you have received this in error, please contact us immediately. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Ian Bays Director of Projects, PTFS Europe Limited Content Management and Library Solutions +44 (0) 800 756 6803 (phone) +44 (0) 7774 995297 (mobile) +44 (0) 800 756 6384 (fax) skype: ian.bays email: ian.b...@ptfs-europe.com ___ Koha mailing list
Re: [Koha] Technical help with Frameworks
Hi Alexander, to build a new fw using sql, you need to insert values on 3 tables, and there are some fields needed by Koha, 942, 952 and 999 (for MARC21) You can look at http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=27056action=diff (right panel, 3 first inserts) as an example of creating a framework using SQL Regards, Bernardo -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Wed, May 28, 2014 at 11:09 AM, Alexander Tim talexan...@triley.co.ukwrote: Not sure if this is the correct list to email but if not hoping someone can send me in the right direction! So, I am not a Librarian but work as a sys admin for my company. We have a small Company Library that is used to publish various technical publications for our users to look through. We are looking to move to Koha but I find I am struggling with the initial steps of trimming down the MARC Framework. The list of fields I have been passed by our Librarian is for only 18 or so fields. I am therefore finding cutting down the default framework very laborious. I have looked to Import a cut down version of the framework, from an amended export to CSV, but this fails with Error Importing the Framework. I was then hoping that there is something on the SQL side I could do to amend the framework but this has not exactly yielded any useful results. Is there anywhere I can check for an error on the framework import? If not is there any guidance on cutting a framework down to just the required fields? I am also concerned that not every field we have in the proposed framework would have a corresponding Koha to MARC mapping. Would this be required or are these there for simplicity rather than a necessity? Regards Tim Tindall Riley Marine (UK) Limited Authorised and regulated in the UK by the Financial Conduct Authority. Registered Office: Regis House, 45 King William Street, London EC4R 9AN Company No: 8451968. V.A.T. No.: 174 7460 86 Tel: +44 (0)20 7407 3588 Fax: +44 (0)20 7403 3942 This email (and any attachments) is confidential and may be privileged. It may be read, copied and used only by the addressee. If you have received this in error, please contact us immediately. ___ 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
Re: [Koha] Problem in Koha item types
Hi, Sorry to bring a question to the list, but we're facing a problem in KOHA under item type location and I need some advice and help. No problem, the list is for questions :) My Koha problem is, it's show *[Type: Book] *every items like i.e. Journals, CD (Audio/Visual), proceeding etc. In this connection, herewith attached screen shot for your information. Attachments are not allowed on the list, but you can paste a screen capture somewhere and send a link Regards, Bernardo ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Using serials in the budgeting module. 3.14
Good morning Could anyone send me a link to a more detailed explanation (than the manual) on how receiving serials in Acquisitions works. For instance, do I load the price of the subscription or the price of each individual item. When receiving serials do I click on renew when the serial rolls over (I just did that and have appeared to have renewed it twice???). I'm loving the fact that I can enter serials into the budget, but am a little confused as to the procedure. Regards Ann Murphy Librarian Katikati College Beach Road, Katikati, 3129 New Zealand 0064 7 5492647 amur...@katikaticollege.school.nz ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problem in Koha item types
If the problem is in the first part oh the bibliographic record you need to modify some of the 6,7 and 8 fixed Marc fields. If your problem is in the ITEMS part, your problem is in the ITEM type you select in the add item part of the cataloging process. Saludos, FAOA Biblioteca Loyola http://clavius.tij.uia.mx Ibero Tijuana This message was sent using IMP, the Internet Messaging Program. -- Este correo electronico puede contener informacion confidencial y privilegiada, por lo que se prohibe el uso, reproduccion, retransmision o divulgacion no autorizada, parcial o total, de su contenido. Si usted no es el destinatario del presente correo, por favor notifiquelo al remitente mediante reenvio a su correo electronico y borrelo de inmediato. Para conocer el aviso de privacidad le pedimos acceder a la siguiente liga: http://www.iberotijuana.edu.mx/?doc=/avisoprivacidad/index.html -- Los acentos han sido removidos intencionalmente para facilitar la lectura del mensaje independiente a la codificacion del mismo. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Database problem and upgrade
Phillip Ponchot schreef op do 29-05-2014 om 15:50 [+]: 3. Do a select on the item using limit to see which record is causing the problem - I get a 2013 error when trying this. If anyone has any suggestion on how to delete this row and dump the database, please let me know. I've exhausted days working on this issue. I haven't seen this myself, but have you tried writing a script that selects the rows one-by-one until it fails, so you find out what record it is that is causing the problem, and then just deleting that record? However, it sound more like this is a MySQL specific issue that you'd have a greater chance of success by taking to MySQL forums. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Perl module ReadOnly::XS
Dear Fridolin, Thanks for your help. Here are copies of the output. Date: Tue, 27 May 2014 09:41:01 +0200 From: Fridolin SOMERS fridolin.som...@biblibre.com What does koha_perl_deps.pl -n return ? koha_perl_deps.pl -m (-n returned help) Installed Required Module is Module Name Version Version Required Readonly::XS 0 * 1.02 No Total modules reported: 1 * Module is missing or requires an upgrade. Run also : dpkg -l 'libreadonly*' dpkg -l 'libreadonly*' Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/ trig-aWait/Trig-pend |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) ||/ NameVersion Description +++-===- ===- == ii libreadonly-perl1.03-3 facility for creating read-only scalars, arrays and hashes ii libreadonly-xs-perl 1.04-2build2Faster Readonly implementation ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha