Dear James, Thanks for the input, but what about 3.6 version. Is there any solution for the same. Thanks and Regards R Sunil Kumar Library Technologist -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request@lists.katipo.co.nz Sent: 25 October 2012 17:31 To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 84, Issue 48 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-request@lists.katipo.co.nz You can reach the person managing the list at koha-owner@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: need help in zebra indexing for Arabic words (mh_zalabany@hotmail.com) 2. Fwd: Koha Database Migration (Chris Nighswonger) 3. Re: need help in zebra indexing for Arabic words (Karam Qubsi) 4. Re: Improving the advanced search form (Mason James) ---------------------------------------------------------------------- Message: 1 Date: Thu, 25 Oct 2012 11:39:25 +0200 From: mh_zalabany@hotmail.com <mh_zalabany@hotmail.com> To: karamqubsi@gmail.com, "Koha" <Koha@lists.katipo.co.nz>, Koha-devel@lists.koha-community.org Subject: Re: [Koha] need help in zebra indexing for Arabic words Message-ID: <BLU0-SMTP3851383E7C326B28479E844977F0@phx.gbl> Content-Type: text/plain; charset="utf-8" Hi karam I think this issue is very important to all users who use Arabic language We need to know what the important modifications in Zebra index And koha files to index the arabic words without suffix and prifex or searsh with root word using zebra I will give you example We need to search for word (al-madrasah) this mean school We have tow parts (al) mean (the)and (madrasah ) and the last caracter (h) may have tow forms( ? ? ) we need when we search for madrasa get madrasah and al-madrasah with all its forms Sent from my HTC ----- Reply message ----- From: "Karam Qubsi" <karamqubsi@gmail.com> To: "Koha" <Koha@lists.katipo.co.nz>, <Koha-devel@lists.koha-community.org> Subject: [Koha] need help in zebra indexing for Arabic words Date: Thu, Oct 25, 2012 11:12 am Hi All I sent this email to the zebra mailing list I wish that koha will support suffix and prefix in the arabic search by default in the future I wish if you have any Idea about the solution for this Best regards Karam. ---------- Forwarded message ---------- From: Karam Qubsi <karamqubsi@gmail.com> Date: Thu, Oct 25, 2012 at 4:20 AM Subject: need help in transliterate rule To: zebralist@lists.indexdata.dk Hi all , I'm new to zebra , and using it in "koha" ILS in the Arabic language there is some letter come before the words or after them these letters we don't need to index in our index I will give you an example : in English we can say : the car... in Arabic the same is : ??????? if you note that the letter in Red is "the" and it's ignored in English search but in Arabic search we need the zebra to find every record that have " the word " or just "word" ?????? or ???? so how to define that to zebra thanks a lot _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ Message: 2 Date: Thu, 25 Oct 2012 06:13:28 -0400 From: Chris Nighswonger <cnighswonger@foundations.edu> To: koha@lists.katipo.co.nz Subject: [Koha] Fwd: Koha Database Migration Message-ID: <CAP3yOomSLJTvDboaguJghre3L2rO=CF6csE7C7w4bVzfba8eGQ@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Yesan, Please send your support requests to the Koha User's list. You will have a much greater chance of getting a response that way. You should be able to do an "in place" upgrade. After taking a backup of your current database, just install the new version of Koha and browse to the staff interface to run the installer. There is also at least one script you will need to run from the command line to remove the items from the bibs. Probably the best way is to move to the packages. I believe there is a way when installing from the packages to import your existing database. Check out koha-create for more on that. Also, I think the packages will run all of the necessary back-end scripts. Someone else will correct me if I'm wrong. Read more here: http://wiki.koha-community.org/wiki/Debian Kind Regards, Chris ---------- Forwarded message ---------- From: Chief Librarian, SAIACS <library@saiacs.org> Date: Thu, Oct 25, 2012 at 1:58 AM Subject: Koha Database Migration To: paul.a@aandc.org Cc: cnighswonger@foundations.edu Dear friends, I would like to know if you have got a solution to migrate my KOHA database 3.6 to 3.8. I know marc records export and import. But I would like to know if we can migrate the database itself. Thanks ______________________________________ Yesan Sellan, B.Com., MLISc., PGDLAN Chief Librarian South Asia Institute of Advanced Christian Studies (SAIACS) 363 Dodda Gubbi Cross Road, Kothanur Post Office, Bangalore -560077, INDIA Phone : 91 80 2846 5235/5344/ 5649, Fax : 91 80 28465412, Mobile : 91-9972348251 Website : www.saiacs.org Alternative Email: yesan.sellan@saiacs.org or yesans@gmail.com ______________________________________ IMPORTANT : This message is intended only for the addressee. It may contain confidential information. Any unauthorized disclosure is strictly prohibited. If you have received this message in error, please notify us immediately so that we may correct our internal records. Please then delete the original message. Thank you. P Please consider the environment before printing this email. ------------------------------ Message: 3 Date: Thu, 25 Oct 2012 06:17:52 -0400 From: Karam Qubsi <karamqubsi@gmail.com> To: "mh_zalabany@hotmail.com" <mh_zalabany@hotmail.com> Cc: Koha <Koha@lists.katipo.co.nz>, Koha-devel@lists.koha-community.org Subject: Re: [Koha] need help in zebra indexing for Arabic words Message-ID: <CAML=htZ+EQBrfLtrvkSac9oJXw9G97d1j_a286EpkToyFLhKow@mail.gmail.com> Content-Type: text/plain; charset=windows-1256 Thanks Mohamed for give more description about our same problem I wish we can find a solution for this problem for all the users of koha in the Arab world while I'm searching i find something about the " ? ? ?" letters to considers them all as "? " and I find something about the suffix " ? ? " the solution is to edit the words-icu.xml file and add these lines : for ? ? ? : <transliterate rule=" [\u0623 \u0625 \u0622] > \u0627 " /> and for the ? ? suffix add : <transliterate rule="? > ?"/> and for the ? ? suffix add : <transliterate rule=" ? > ? "/> I didn't try this I wish you try and tell me but about ignoring the ??? letters in words i didn't find how to do this I wish someone can help us about this best regards On Thu, Oct 25, 2012 at 5:39 AM, mh_zalabany@hotmail.com < mh_zalabany@hotmail.com> wrote:
Hi karam I think this issue is very important to all users who use Arabic language We need to know what the important modifications in Zebra index And koha files to index the arabic words without suffix and prifex or searsh with root word using zebra
I will give you example We need to search for word (al-madrasah) this mean school We have tow parts (al) mean (the)and (madrasah ) and the last caracter (h) may have tow forms( ? ? ) we need when we search for madrasa get madrasah and al-madrasah with all its forms Sent from my HTC
----- Reply message ----- From: "Karam Qubsi" <karamqubsi@gmail.com> To: "Koha" <Koha@lists.katipo.co.nz>, <Koha-devel@lists.koha-community.org
Subject: [Koha] need help in zebra indexing for Arabic words Date: Thu, Oct 25, 2012 11:12 am
Hi All
I sent this email to the zebra mailing list
I wish that koha will support suffix and prefix in the arabic search by default in the future
I wish if you have any Idea about the solution for this
Best regards Karam.
---------- Forwarded message ---------- From: Karam Qubsi <karamqubsi@gmail.com> Date: Thu, Oct 25, 2012 at 4:20 AM Subject: need help in transliterate rule To: zebralist@lists.indexdata.dk
Hi all , I'm new to zebra , and using it in "koha" ILS
in the Arabic language there is some letter come before the words or after them these letters we don't need to index in our index I will give you an example : in English we can say : the car... in Arabic the same is : ??????? if you note that the letter in Red is "the" and it's ignored in English search but in Arabic search we need the zebra to find every record that have " the word " or just "word" ?????? or ????
so how to define that to zebra
thanks a lot _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- *Karam Qubsi* Arabic Koha Support Team The founder of Wikibrary (The Arabic Libraries And Information Science Encyclopedia ) *Email: karamqubsi@gmail.com* *Skype : karam.qubsi* *Mobile: +963 991 264 020* *Viber <http://viber.com/> / Tango <http://www.tango.me/> : +963 991 264 020 * *Wikibrary website : http://wikibrary.org* *Wiki and forum for Arabic Koha : http://koha.wikibrary.org<http://wikibrary.org/> * *??? ????.* ???? ?????? ? ???? ????? ???? ?????????? ( ???????? ??????? ???????? ?????????? ) ------------------------------ Message: 4 Date: Fri, 26 Oct 2012 01:00:31 +1300 From: Mason James <mtj@kohaaloha.com> To: sunil.kumar@ecoleglobal.com Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Improving the advanced search form Message-ID: <6A656B61-2350-4882-9E09-EEFFBEA910A5@kohaaloha.com> Content-Type: text/plain; charset=us-ascii On 2012-10-25, at 5:27 PM, Sunil Kumar wrote:
Dear All,
I agree with the same, I always had problem in advance search especially for the barcode based search.
Even if I select the barcode as search option and enter the specific barcode number, Koha opac always show all the titles wherever that specific number is entered. But other that the barcode number.
hmm, i just tested this on Koha 3.8.5 it works fine for me... ps: edit your email, before replying to digest messages
Is there any solution for the same?
Thanks and Regards
R Sunil Kumar Library Technologist
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request@lists.katipo.co.nz Sent: 25 October 2012 09:53 To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 84, Issue 46
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-request@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@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. Improving the advanced search form (Srikanth Dhondi) 2. Re: Improving the advanced search form (Chris Cormack) 3. Re: Improving the advanced search form (Gay Richards) 4. Re: Data Migration (Dennis Njuguna) (Sunil Kumar)
----------------------------------------------------------------------
Message: 1 Date: Thu, 25 Oct 2012 14:55:31 +1300 From: Srikanth Dhondi <srikanth@catalyst.net.nz> To: koha@lists.katipo.co.nz Subject: [Koha] Improving the advanced search form Message-ID: <50889C13.9080505@catalyst.net.nz> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hi there,
I am currently working on improving accessibility of koha opac site with
accessibility expert. One of the things we noticed is that the advanced search option is not only confusing for blind users but also even for normal users.
I have noticed the following issues with it:
1) By default the Fewer Options option is selected, which is not obvious to the normal users until they click on More Options.
2) The layout could be a lot better, in particular the Fewer Options search form is quite abstract in what it does.
For example, the default boolean operator is AND which is not obvious to even normal user.
In my opinion, layout similar to the one http://kea.massey.ac.nz/search/X, is better.
Looking forward to your comments/feedback.
Srikanth
------------------------------
Message: 2 Date: Thu, 25 Oct 2012 15:03:21 +1300 From: Chris Cormack <chris@bigballofwax.co.nz> To: Srikanth Dhondi <srikanth@catalyst.net.nz> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Improving the advanced search form Message-ID: <CA+95qVR9P0U4Wynn2p0PWP3Wb37J+7SSiMu1xjvZs1kbq=9=nw@mail.gmail.com> Content-Type: text/plain; charset=UTF-8
On 25 October 2012 14:55, Srikanth Dhondi <srikanth@catalyst.net.nz> wrote:
Hi there,
I am currently working on improving accessibility of koha opac site with our accessibility expert. One of the things we noticed is that the advanced search option is not only confusing for blind users but also even for normal users.
I have noticed the following issues with it:
1) By default the Fewer Options option is selected, which is not obvious to the normal users until they click on More Options.
2) The layout could be a lot better, in particular the Fewer Options search form is quite abstract in what it does.
For example, the default boolean operator is AND which is not obvious to even normal user.
In my opinion, layout similar to the one http://kea.massey.ac.nz/search/X, is better.
I'm going to disagree and say that site is horrid :)
Maybe others will have different opinions though.
Chris
------------------------------
Message: 3 Date: Thu, 25 Oct 2012 02:45:24 +0000 From: Gay Richards <g.richards@auckland.ac.nz> To: 'Chris Cormack' <chris@bigballofwax.co.nz>, Srikanth Dhondi <srikanth@catalyst.net.nz> Cc: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Subject: Re: [Koha] Improving the advanced search form Message-ID:
<AB44DEB8CF4F784F90EBCDBBD9B817376D7E2714@uxcn10-5.UoA.auckland.ac.nz> Content-Type: text/plain; charset="us-ascii"
Agree advanced search could and should be improved, but don't like example suggested.
I generallly like the "look: of the Koha advanced search page. The problem (apart from any accessibility issues) is that some functions don't work as one might expect - as outlined below. Also:
We would like to turn off or limit languages to onees that are actually available in our catalog.
The Search for additional content types is really misleading as it relies on codes from marc field 008 which may or may not have been used. I'm sure I have other issues with this screen and I would be keen to discuss any improvements further. We support anything that makes it more accessible too. Gay
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Chris Cormack Sent: Thursday, 25 October 2012 3:03 p.m. To: Srikanth Dhondi Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Improving the advanced search form
On 25 October 2012 14:55, Srikanth Dhondi <srikanth@catalyst.net.nz> wrote:
Hi there,
I am currently working on improving accessibility of koha opac site with our accessibility expert. One of the things we noticed is that the advanced search option is not only confusing for blind users but also even for normal users.
I have noticed the following issues with it:
1) By default the Fewer Options option is selected, which is not obvious to the normal users until they click on More Options.
2) The layout could be a lot better, in particular the Fewer Options search form is quite abstract in what it does.
For example, the default boolean operator is AND which is not obvious to even normal user.
In my opinion, layout similar to the one http://kea.massey.ac.nz/search/X, is better.
I'm going to disagree and say that site is horrid :)
Maybe others will have different opinions though.
Chris _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
Message: 4 Date: Thu, 25 Oct 2012 09:52:23 +0530 From: "Sunil Kumar" <sunil.kumar@ecoleglobal.com> To: <koha@lists.katipo.co.nz> Subject: Re: [Koha] Data Migration (Dennis Njuguna) Message-ID: <000301cdb268$57b958c0$072c0a40$@kumar@ecoleglobal.com> Content-Type: text/plain; charset="us-ascii"
Dear Dennis,
I believe you are missing MARC tag 952 series, 952 is the local tags which contain all the information about the holding. For example.
952$8$9$a$b$c$g$h$p$y $8 is for collection code $9 is for biblio number $a is for permanent location $b is for current location $c is for shelf location $g is for purchase price (you can include the vendor name, location and invoice details also here) $h is for volume details of the resources
it is used for the journal/magazine/periodicals $p is for the barcode $y is for the item type
Once you have all the required information in 952 series you can convert
file into marc format and upload the same to koha, as the standard
our mainly the process.
Thanks and Regards
R Sunil Kumar Library Technologist
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request@lists.katipo.co.nz Sent: 25 October 2012 03:21 To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 84, Issue 45
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-request@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@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: Data Migration (Dennis Njuguna) 2. Re: Data Migration (Mohamed zalabany) 3. Problems upgrading to 3.8 (Ramon Andi?ach) 4. Re: Problems upgrading to 3.8 (Hugo Agud) 5. Email. (Estel Porras) 6. Help needed with report - how to extract subtitle and edition? (Elaine Bradtke) 7. Re: Help needed with report - how to extract subtitle and edition? (mh_zalabany@hotmail.com)
----------------------------------------------------------------------
Message: 1 Date: Wed, 24 Oct 2012 12:17:39 +0300 From: Dennis Njuguna <cknjuguna@gmail.com> To: Mohamed zalabany <mh_zalabany@hotmail.com> Cc: koha list <koha@lists.katipo.co.nz>, "manny_tamayao@sil.org" <manny_tamayao@sil.org> Subject: Re: [Koha] Data Migration Message-ID: <CAH0M1x-AbcrEvvzfvOL9oJ4nE7NMD0o4-UytqTUa0LfGxyOyAA@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1
it is marc compliant, but when I take it to marcedit i view the file but I cannot see/view the barcode, if I import the marc into koha I can only import the biblios records, no holdings.
On Tue, Oct 23, 2012 at 7:02 PM, Mohamed zalabany <mh_zalabany@hotmail.com>wrote:
Hello conversion from mandarin M3 will be easy if your version is supporting Marc 21 for holding you need to know what is the local field that the system uses to put the items information and edit the record by MARC edit to change the tag of the item field to (952) koha local field for item information
* *
* *
*Mohamed El Zalabaitny* ** *Integrated library systems consultant*
Zalabany Knowledge Systems Team? For Libraries and Information systems Development and support mh_zalabany@hotmail.com Mobile: 0111291444
**
------------------------------ Date: Tue, 23 Oct 2012 17:08:09 +0300 Subject: Re: [Koha] Data Migration From: cknjuguna@gmail.com To: mh_zalabany@hotmail.com CC: manny_tamayao@sil.org; koha@lists.katipo.co.nz
Hello Mohamed what about data migration from mandarin M3 especially the holdings?
On Tue, Oct 23, 2012 at 2:51 PM, Mohamed zalabany <mh_zalabany@hotmail.com
wrote:
i have a big experience in data conversion but unfortunately i don't know MAELISA library systemso could you tell us is the data is MARC format i what format and send me a sample of data
Mohamed El ZalabanyIntegrated library systems consultant
Zalabany Knowledge Systems Team? For Libraries and Information systems Development and support mh_zalabany@hotmail.com Mobile: 202-0111291444
From: manny_tamayao@sil.org To: koha@lists.katipo.co.nz Date: Tue, 23 Oct 2012 10:21:40 +0800 Subject: [Koha] Data Migration
Good day to all,
I'm Manny from Manila and in the process of data migration of the library from "MAELISA" to KOHA.
Is there anyone who had done this process or has a script that may help?
Salamat
Manny Tamayao
Librarian/Archivist
SIL Philippines
skype: mannytamayao
mobile: 09152822329
_______________________________________________ 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
--
Dennis K. Njuguna
--
Dennis K. Njuguna
------------------------------
Message: 2 Date: Wed, 24 Oct 2012 09:38:15 +0000 From: Mohamed zalabany <mh_zalabany@hotmail.com> To: <cknjuguna@gmail.com> Cc: koha list <koha@lists.katipo.co.nz>, "manny_tamayao@sil.org" <manny_tamayao@sil.org> Subject: Re: [Koha] Data Migration Message-ID: <BLU165-W49D11BF288626BB715E85597780@phx.gbl> Content-Type: text/plain; charset="iso-8859-1"
I think there is option to export item data with MARC record
Mohamed El ZalabanyIntegrated library systems consultant
Zalabany Knowledge Systems Team? For Libraries and Information systems Development and support mh_zalabany@hotmail.com Mobile: 0111291444
Date: Wed, 24 Oct 2012 12:17:39 +0300 Subject: Re: [Koha] Data Migration From: cknjuguna@gmail.com To: mh_zalabany@hotmail.com CC: manny_tamayao@sil.org; koha@lists.katipo.co.nz
it is marc compliant, but when I take it to marcedit i view the file but I cannot see/view the barcode, if I import the marc into koha I can only import the biblios records, no holdings.
On Tue, Oct 23, 2012 at 7:02 PM, Mohamed zalabany
wrote:
Hello conversion from mandarin M3 will be easy if your version is supporting Marc 21 for holding you need to know what is the local field that the system uses to put the items information and edit the record by MARC edit to change
<mh_zalabany@hotmail.com> the
tag of the item field to (952) koha local field for item information
Mohamed El Zalabaitny Integrated library systems consultant
Zalabany Knowledge Systems Team? For Libraries and Information systems Development and support
mh_zalabany@hotmail.com Mobile: 0111291444
Date: Tue, 23 Oct 2012 17:08:09 +0300 Subject: Re: [Koha] Data Migration From: cknjuguna@gmail.com To: mh_zalabany@hotmail.com
CC: manny_tamayao@sil.org; koha@lists.katipo.co.nz
Hello Mohamed what about data migration from mandarin M3 especially the holdings?
On Tue, Oct 23, 2012 at 2:51 PM, Mohamed zalabany <mh_zalabany@hotmail.com> wrote:
i have a big experience in data conversion but unfortunately i don't know MAELISA library systemso could you tell us is the data is MARC format i what format and send me a sample of data
Mohamed El ZalabanyIntegrated library systems consultant
Zalabany Knowledge Systems Team?
For Libraries and Information systems Development and support
mh_zalabany@hotmail.com
Mobile: 202-0111291444
From: manny_tamayao@sil.org
To: koha@lists.katipo.co.nz
Date: Tue, 23 Oct 2012 10:21:40 +0800
Subject: [Koha] Data Migration
Good day to all,
I'm Manny from Manila and in the process of data migration of the library
from "MAELISA" to KOHA.
Is there anyone who had done this process or has a script that may help?
Salamat
Manny Tamayao
Librarian/Archivist
SIL Philippines
skype: mannytamayao
mobile: 09152822329
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
--
Dennis K. Njuguna
--
Dennis K. Njuguna
------------------------------
Message: 3 Date: Wed, 24 Oct 2012 23:46:00 +0800 From: Ramon Andi?ach <custard@westnet.com.au> To: koha@lists.katipo.co.nz Subject: [Koha] Problems upgrading to 3.8 Message-ID: <96D8A573-0DC3-478B-BA5C-CBD5FD9974A5@westnet.com.au> Content-Type: text/plain; charset=us-ascii
Hi,
This is going sound pathetic, and stupid, but I'm in need of some guidance. It has been quite some time since I've tried to use koha.
I've been upgrading my koha from 3.00 towards 3.8 via the tarball method.
I was attempting to be good, and going in smallish steps so 3.00 to 3.02 to 3.04 to 3.06 and then to 3.8.
In between each upgrade I was trying a few searches to make sure that the books end of the db was intact and then backing up the DB.
After the 3.06 step it seemed to be working.
But, after the 3.8 step suddenly most of the books seem to have vanished.
I'd put it down to noticing in the upgrade notes some extra steps that I didn't see in the 3.6 or 3.4 notes (the ones about removing the duplicated item details). So I dropped the DB and reloaded the backup from the 3.6 step and tried without these steps.
I've also now tried the original backup too, without success.
I'm not sure at this point if it's the items that have vanished or the records too. Yes, I have run rebuild_zebra -b -r as the koha user (several times no luck).
So I suppose I'm looking for guidance on a) working out what is going on. b) how to get normality back again.
-ramon.
------------------------------
Message: 4 Date: Wed, 24 Oct 2012 18:01:53 +0200 From: Hugo Agud <hagud@orex.es> To: Ramon Andi?ach <custard@westnet.com.au> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Problems upgrading to 3.8 Message-ID: <CADT_QRTsaDrrye_Ux-To_JkjQZk=eT3QN_b1UEoEPSg1N_k64Q@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1
Hi Ramon
Do not worry it happens to a lot of people ... take a look on this
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8665
Kindest Regards
2012/10/24 Ramon Andi?ach <custard@westnet.com.au>
Hi,
This is going sound pathetic, and stupid, but I'm in need of some guidance. It has been quite some time since I've tried to use koha.
I've been upgrading my koha from 3.00 towards 3.8 via the tarball method.
I was attempting to be good, and going in smallish steps so 3.00 to 3.02 to 3.04 to 3.06 and then to 3.8.
In between each upgrade I was trying a few searches to make sure that the books end of the db was intact and then backing up the DB.
After the 3.06 step it seemed to be working.
But, after the 3.8 step suddenly most of the books seem to have vanished.
I'd put it down to noticing in the upgrade notes some extra steps that I didn't see in the 3.6 or 3.4 notes (the ones about removing the duplicated item details). So I dropped the DB and reloaded the backup from the 3.6 step and tried without these steps.
I've also now tried the original backup too, without success.
I'm not sure at this point if it's the items that have vanished or the records too. Yes, I have run rebuild_zebra -b -r as the koha user (several times no luck).
So I suppose I'm looking for guidance on a) working out what is going on. b) how to get normality back again.
-ramon. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
--
*Hugo Agud - Orex Digital *
*www.orex.es*
* *
Director
Avenida Sarri? 29 ? 08029 Barcelona <http://twitter.com/OrexDigital> :<http://orexsl.blogspot.com>hugoaguda - Tel: 93 539 40 70 Fax: 93 539 33 30 hagud@orex.es ? http://www.orex.es/
No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 ?rboles y el consumo de 250.000 litros de agua.
Aviso de confidencialidad Este mensaje contiene informaci?n que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni est? autorizado a recibirlo por el remitente), no est? autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notif?quenoslo inmediatamente y b?rrelo de su sistema.
------------------------------
Message: 5 Date: Wed, 24 Oct 2012 10:11:18 -0700 (PDT) From: Estel Porras <orlib@yahoo.com> To: Koha community <koha@lists.katipo.co.nz> Subject: [Koha] Email. Message-ID: <1351098678.37956.YahooMailNeo@web125305.mail.ne1.yahoo.com> Content-Type: text/plain; charset=iso-8859-1
Just wanted to thank all the very helpful folks here. You guys rock!
? ?Have a great day, ~Estel~ Orland Free Library 333 Mill St. Orland CA. 95963 [530]865-1640
------------------------------
Message: 6 Date: Wed, 24 Oct 2012 22:23:41 +0100 From: Elaine Bradtke <eb@efdss.org> To: koha <koha@lists.katipo.co.nz> Subject: [Koha] Help needed with report - how to extract subtitle and edition? Message-ID: <CAPdfUux1_GHutDqzKJrr-F+3DPU0fwCH8LYrfKiGmwtbEM5DHw@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1
I'm trying to catch duplicate items in data before I upload it (ISBN won't help in this case). In order to do that I've written a report to list the books currently in Koha, and will compare them with my external files. However, if I can't include the subtitle (MARC 245 b) I will get too many false positives (we have lots of things with the same title, but different subtitles) It would also help if I could also have the 250 a (edition)
This is what I have: SELECT
biblio.biblionumber,biblio.author,biblio.title,biblio.copyrightdate,biblioit
ems.place,biblioitems.publishercode,biblioitems.isbn FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype='BK' AND items.holdingbranch='VWML' ORDER BY biblio.author asc
This works fine, but doesn't include the 245 b or the 250 a Can anyone help? -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999
---------------------------------------------------------------------------
"Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
------------------------------
Message: 7 Date: Wed, 24 Oct 2012 23:51:10 +0200 From: mh_zalabany@hotmail.com <mh_zalabany@hotmail.com> To: eb@efdss.org,"koha" <koha@lists.katipo.co.nz> Subject: Re: [Koha] Help needed with report - how to extract subtitle and edition? Message-ID: <BLU0-SMTP34294835DD8881E4738D9DE97780@phx.gbl> Content-Type: text/plain; charset="utf-8"
I think in this case you need to make the report using the xml field in biblio items table because the rest of sub fields you will find there
Sent from my HTC
----- Reply message ----- From: "Elaine Bradtke" <eb@efdss.org> To: "koha" <koha@lists.katipo.co.nz> Subject: [Koha] Help needed with report - how to extract subtitle and edition? Date: Wed, Oct 24, 2012 11:23 pm
I'm trying to catch duplicate items in data before I upload it (ISBN won't help in this case). In order to do that I've written a report to list the books currently in Koha, and will compare them with my external files. However, if I can't include the subtitle (MARC 245 b) I will get too many false positives (we have lots of things with the same title, but different subtitles) It would also help if I could also have the 250 a (edition)
This is what I have: SELECT
biblio.biblionumber,biblio.author,biblio.title,biblio.copyrightdate,biblioit
ems.place,biblioitems.publishercode,biblioitems.isbn FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype='BK' AND items.holdingbranch='VWML' ORDER BY biblio.author asc
This works fine, but doesn't include the 245 b or the 250 a Can anyone help? -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999
---------------------------------------------------------------------------
"Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
End of Koha Digest, Vol 84, Issue 45 ************************************
------------------------------
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
End of Koha Digest, Vol 84, Issue 46 ************************************
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------ _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 84, Issue 48 ************************************