[Koha] Improving the advanced search form (Mason James)

Sunil Kumar sunil.kumar at ecoleglobal.com
Fri Oct 26 01:07:43 NZDT 2012


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 at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of
koha-request at lists.katipo.co.nz
Sent: 25 October 2012 17:31
To: koha at lists.katipo.co.nz
Subject: Koha Digest, Vol 84, Issue 48

Send Koha mailing list submissions to
	koha at 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 at lists.katipo.co.nz

You can reach the person managing the list at
	koha-owner at 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 at 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 at hotmail.com <mh_zalabany at hotmail.com>
To: karamqubsi at gmail.com, "Koha" <Koha at lists.katipo.co.nz>,
	Koha-devel at lists.koha-community.org
Subject: Re: [Koha] need help in zebra indexing for Arabic words
Message-ID: <BLU0-SMTP3851383E7C326B28479E844977F0 at 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 at gmail.com>
To: "Koha" <Koha at lists.katipo.co.nz>, <Koha-devel at 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 at gmail.com>
Date: Thu, Oct 25, 2012 at 4:20 AM
Subject: need help in transliterate rule
To: zebralist at 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 at 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 at foundations.edu>
To: koha at lists.katipo.co.nz
Subject: [Koha] Fwd: Koha Database Migration
Message-ID:
	<CAP3yOomSLJTvDboaguJghre3L2rO=CF6csE7C7w4bVzfba8eGQ at 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 at saiacs.org>
Date: Thu, Oct 25, 2012 at 1:58 AM
Subject: Koha Database Migration
To: paul.a at aandc.org
Cc: cnighswonger at 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 at saiacs.org or yesans at 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 at gmail.com>
To: "mh_zalabany at hotmail.com" <mh_zalabany at hotmail.com>
Cc: Koha <Koha at lists.katipo.co.nz>,
	Koha-devel at lists.koha-community.org
Subject: Re: [Koha] need help in zebra indexing for Arabic words
Message-ID:
	<CAML=htZ+EQBrfLtrvkSac9oJXw9G97d1j_a286EpkToyFLhKow at 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 at hotmail.com <
mh_zalabany at 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 at gmail.com>
> To: "Koha" <Koha at lists.katipo.co.nz>, 
> <Koha-devel at 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 at gmail.com>
> Date: Thu, Oct 25, 2012 at 4:20 AM
> Subject: need help in transliterate rule
> To: zebralist at 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 at 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 at 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 at kohaaloha.com>
To: sunil.kumar at ecoleglobal.com
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Improving the advanced search form
Message-ID: <6A656B61-2350-4882-9E09-EEFFBEA910A5 at 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 at lists.katipo.co.nz
> [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of
> koha-request at lists.katipo.co.nz
> Sent: 25 October 2012 09:53
> To: koha at lists.katipo.co.nz
> Subject: Koha Digest, Vol 84, Issue 46
> 
> Send Koha mailing list submissions to
> 	koha at 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 at lists.katipo.co.nz
> 
> You can reach the person managing the list at
> 	koha-owner at 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 at catalyst.net.nz>
> To: koha at lists.katipo.co.nz
> Subject: [Koha] Improving the advanced search form
> Message-ID: <50889C13.9080505 at 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
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.
> 
> Looking forward to your comments/feedback.
> 
> Srikanth
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Thu, 25 Oct 2012 15:03:21 +1300
> From: Chris Cormack <chris at bigballofwax.co.nz>
> To: Srikanth Dhondi <srikanth at catalyst.net.nz>
> Cc: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Improving the advanced search form
> Message-ID:
> 	<CA+95qVR9P0U4Wynn2p0PWP3Wb37J+7SSiMu1xjvZs1kbq=9=nw at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
> 
> On 25 October 2012 14:55, Srikanth Dhondi <srikanth at 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 at auckland.ac.nz>
> To: 'Chris Cormack' <chris at bigballofwax.co.nz>, Srikanth Dhondi
> 	<srikanth at catalyst.net.nz>
> Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Improving the advanced search form
> Message-ID:
> 	
> <AB44DEB8CF4F784F90EBCDBBD9B817376D7E2714 at 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 at lists.katipo.co.nz
> [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Chris Cormack
> Sent: Thursday, 25 October 2012 3:03 p.m.
> To: Srikanth Dhondi
> Cc: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Improving the advanced search form
> 
> On 25 October 2012 14:55, Srikanth Dhondi <srikanth at 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 at 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 at ecoleglobal.com>
> To: <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Data Migration (Dennis Njuguna)
> Message-ID: <000301cdb268$57b958c0$072c0a40$@kumar at 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
mainly
> 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
the
> file into marc format and upload the same to koha, as the standard
process. 
> 
> Thanks and Regards
> 
> R Sunil Kumar
> Library Technologist
> 
> 
> 
> -----Original Message-----
> From: koha-bounces at lists.katipo.co.nz
> [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of
> koha-request at lists.katipo.co.nz
> Sent: 25 October 2012 03:21
> To: koha at lists.katipo.co.nz
> Subject: Koha Digest, Vol 84, Issue 45
> 
> Send Koha mailing list submissions to
> 	koha at 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 at lists.katipo.co.nz
> 
> You can reach the person managing the list at
> 	koha-owner at 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 at hotmail.com)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Wed, 24 Oct 2012 12:17:39 +0300
> From: Dennis Njuguna <cknjuguna at gmail.com>
> To: Mohamed zalabany <mh_zalabany at hotmail.com>
> Cc: koha list <koha at lists.katipo.co.nz>,	"manny_tamayao at sil.org"
> 	<manny_tamayao at sil.org>
> Subject: Re: [Koha] Data Migration
> Message-ID:
> 	<CAH0M1x-AbcrEvvzfvOL9oJ4nE7NMD0o4-UytqTUa0LfGxyOyAA at 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 at 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 at hotmail.com
>> Mobile: 0111291444
>> 
>> **
>> 
>> 
>> ------------------------------
>> Date: Tue, 23 Oct 2012 17:08:09 +0300
>> Subject: Re: [Koha] Data Migration
>> From: cknjuguna at gmail.com
>> To: mh_zalabany at hotmail.com
>> CC: manny_tamayao at sil.org; koha at 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 at 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 at hotmail.com
>> Mobile: 202-0111291444
>> 
>> 
>> 
>>> From: manny_tamayao at sil.org
>>> To: koha at 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 at lists.katipo.co.nz 
>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>> 
>> _______________________________________________
>> Koha mailing list  http://koha-community.org Koha at 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 at hotmail.com>
> To: <cknjuguna at gmail.com>
> Cc: koha list <koha at lists.katipo.co.nz>,	"manny_tamayao at sil.org"
> 	<manny_tamayao at sil.org>
> Subject: Re: [Koha] Data Migration
> Message-ID: <BLU165-W49D11BF288626BB715E85597780 at 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 at hotmail.com
> Mobile: 0111291444
> 
> 
> 
> Date: Wed, 24 Oct 2012 12:17:39 +0300
> Subject: Re: [Koha] Data Migration
> From: cknjuguna at gmail.com
> To: mh_zalabany at hotmail.com
> CC: manny_tamayao at sil.org; koha at 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
<mh_zalabany at 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 at hotmail.com
> Mobile: 0111291444
> 
> 
> 
> 
> Date: Tue, 23 Oct 2012 17:08:09 +0300
> Subject: Re: [Koha] Data Migration
> From: cknjuguna at gmail.com
> To: mh_zalabany at hotmail.com
> 
> CC: manny_tamayao at sil.org; koha at 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 at 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 at hotmail.com
> 
> Mobile: 202-0111291444
> 
> 
> 
> 
> 
> 
> 
>> From: manny_tamayao at sil.org
> 
>> To: koha at 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 at lists.katipo.co.nz
> 
>> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 
> 
> _______________________________________________
> 
> Koha mailing list  http://koha-community.org
> 
> Koha at 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 at westnet.com.au>
> To: koha at lists.katipo.co.nz
> Subject: [Koha] Problems upgrading to 3.8
> Message-ID: <96D8A573-0DC3-478B-BA5C-CBD5FD9974A5 at 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 at orex.es>
> To: Ramon Andi?ach <custard at westnet.com.au>
> Cc: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Problems upgrading to 3.8
> Message-ID:
> 	<CADT_QRTsaDrrye_Ux-To_JkjQZk=eT3QN_b1UEoEPSg1N_k64Q at 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 at 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 at 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 at 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 at yahoo.com>
> To: Koha community <koha at lists.katipo.co.nz>
> Subject: [Koha] Email.
> Message-ID:
> 	<1351098678.37956.YahooMailNeo at 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 at efdss.org>
> To: koha <koha at lists.katipo.co.nz>
> Subject: [Koha] Help needed with report - how to extract subtitle and
> 	edition?
> Message-ID:
> 	<CAPdfUux1_GHutDqzKJrr-F+3DPU0fwCH8LYrfKiGmwtbEM5DHw at 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 at hotmail.com <mh_zalabany at hotmail.com>
> To: eb at efdss.org,"koha" <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Help needed with report - how to extract subtitle
> 	and	edition?
> Message-ID: <BLU0-SMTP34294835DD8881E4738D9DE97780 at 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 at efdss.org>
> To: "koha" <koha at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 
> ------------------------------
> 
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 
> End of Koha Digest, Vol 84, Issue 45
> ************************************
> 
> 
> 
> ------------------------------
> 
> _______________________________________________
> Koha mailing list
> Koha at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha



------------------------------

_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


End of Koha Digest, Vol 84, Issue 48
************************************



More information about the Koha mailing list