Re: [Koha] Merge records (was add only item info for duplicate records)

2013-01-22 Thread Elaine Bradtke
On Fri, Jan 18, 2013 at 2:56 AM, soulemane moumie moumi...@yahoo.fr wrote:

 Hi Elaine !
 I must admit that you are a life saver, I have regained the hope to
 complete my project.
 I just do as you mention and every thing went smoothly. What about This
 is why it may be quicker to combine the records offline before uploading
 them.

Doing the work on the records before you upload them may take fewer steps
than merging records in Koha. It depends on how many duplicates you have in
your collection.  In our case there are a lot of duplicates - we sometimes
have a dozen copies of the same thing, but they were each given individual
records in our old system. They were in a database that allowed me to match
up duplicates and combine all the item information and put it into one
record without too much trouble. We have location, provenance and
collection information for specific items, so these codes had to be linked
to the items. Once I had all this in order, our technical person wrote some
code that took our database fields and added MARC tagging.
  What you do depends on what software you use, and how much item
information you have.   If it is only a few duplicates, then you may find
it easier to do it in Koha after they are uploaded.

 How can I achieve this offline operation ?
 I am very much grateful for your support in my eager desire to explore
 koha.
 Thanks.



 *Moumi*é* Soul*é*mane
 Assistant Programmer, OCP, MCTS, JCP
 Department of Computer Science Engineering
 Islamic University of Technology(IUT)
 Board Bazar, Gazipur-1704, Bangladesh.
 Cellular: +880192-1628880,+8801921628880*


 --- En date de : *Jeu 17.1.13, Elaine Bradtke e...@efdss.org* a écrit :


 De: Elaine Bradtke e...@efdss.org
 Objet: Re: [Koha] Merge records (was add only item info for duplicate
 records)
 À: soulemane moumie moumi...@yahoo.fr
 Cc: koha koha@lists.katipo.co.nz
 Date: Jeudi 17 janvier 2013, 19h47





 On Thu, Jan 17, 2013 at 8:31 AM, soulemane moumie 
 moumi...@yahoo.frhttp://mc/compose?to=moumi...@yahoo.fr
  wrote:

 Hi Elaine!
 Thanks for taking your precious time to answer my questions.
 Please what you meant by Once in Koha you can merge biblios, to get all
 the items into one record, . Are saying that there is an option in koha
 for merging identical record ?
 Or doing it manually ?
  I really appreciate your help. I am new to koha and I am going to
 implement/customize it for our  library.


 Yes, you can merge records in Koha. This combines the information
 (including item records) into one biblio.  To do this:
 Search for the title.
 Select the items you wish to merge and save them to a list.
 Go to the list and again select the titles you wish to merge
 Click on the button (at the bottom of the list ) Merge selected records
 You will be asked to choose a reference record - think of this as the base
 record into which any other information will be added (so if one record is
 more complete than the other, choose that one).
 Click the Next button
 The merging records are displayed under tabs on the left with the
 reference record on top and the final version on the right under
 Destination record.
  Look at the other tabs and compare them with the destination record,
 click on any fields you wish to add to the destination record.
 When you have finished adding fields to the destination record, click
 Merge
 It will automatically move any items from the old records over to the new
 record.

 As you can see, it takes some time and effort to do this. This is why it
 may be quicker to combine the records offline before uploading them.

   Still, sometimes my colleagues forget to search our catalogue before
 adding another record, and when I find the duplicates I merge them.

 I hope this helps
 Elaine


 Regards.




 *Moumi*é* Soul*é*mane
 Assistant Programmer, OCP, MCTS, JCP
 Department of Computer Science Engineering
 Islamic University of Technology(IUT)
 Board Bazar, Gazipur-1704, Bangladesh.
 Cellular: +880192-1628880,+8801921628880*


 --- En date de : *Mer 16.1.13, Elaine Bradtke 
 e...@efdss.orghttp://mc/compose?to=e...@efdss.org
 * a écrit :


 De: Elaine Bradtke e...@efdss.org http://mc/compose?to=e...@efdss.org
 Objet: Re: [Koha] add only item info for duplicate records
 À: soulemane moumie 
 moumi...@yahoo.frhttp://mc/compose?to=moumi...@yahoo.fr
 
 Date: Mercredi 16 janvier 2013, 22h36


 We moved all the item info to a single book record before importing. Our
 old database allows us to run a de-duplication script and then I manually
 combined the duplicate records.  Yes, it's a pain. Once in Koha you can
 merge biblios, to get all the items into one record, but I wouldn't want to
 do this for a large number of things.
 It would be nice if there were an easier way, I just don't know what it is.
 Elaine
 On Wed, Jan 16, 2013 at 6:45 AM, soulemane moumie 
 moumi...@yahoo.frhttp://mc/compose?to=moumi...@yahoo.fr
  wrote:

 Hi!
 I want to import my newly created marc file into koha.
 Everything is imported

Re: [Koha] Merge records (was add only item info for duplicate records)

2013-01-17 Thread Elaine Bradtke
On Thu, Jan 17, 2013 at 8:31 AM, soulemane moumie moumi...@yahoo.fr wrote:

 Hi Elaine!
 Thanks for taking your precious time to answer my questions.
 Please what you meant by Once in Koha you can merge biblios, to get all
 the items into one record, . Are saying that there is an option in koha
 for merging identical record ?
 Or doing it manually ?
  I really appreciate your help. I am new to koha and I am going to
 implement/customize it for our  library.


Yes, you can merge records in Koha. This combines the information
(including item records) into one biblio.  To do this:
Search for the title.
Select the items you wish to merge and save them to a list.
Go to the list and again select the titles you wish to merge
Click on the button (at the bottom of the list ) Merge selected records
You will be asked to choose a reference record - think of this as the base
record into which any other information will be added (so if one record is
more complete than the other, choose that one).
Click the Next button
The merging records are displayed under tabs on the left with the reference
record on top and the final version on the right under Destination record.
 Look at the other tabs and compare them with the destination record, click
on any fields you wish to add to the destination record.
When you have finished adding fields to the destination record, click
Merge
It will automatically move any items from the old records over to the new
record.

As you can see, it takes some time and effort to do this. This is why it
may be quicker to combine the records offline before uploading them.

  Still, sometimes my colleagues forget to search our catalogue before
adding another record, and when I find the duplicates I merge them.

I hope this helps
Elaine


Regards.




 *Moumi*é* Soul*é*mane
 Assistant Programmer, OCP, MCTS, JCP
 Department of Computer Science Engineering
 Islamic University of Technology(IUT)
 Board Bazar, Gazipur-1704, Bangladesh.
 Cellular: +880192-1628880,+8801921628880*


 --- En date de : *Mer 16.1.13, Elaine Bradtke e...@efdss.org* a écrit :


 De: Elaine Bradtke e...@efdss.org
 Objet: Re: [Koha] add only item info for duplicate records
 À: soulemane moumie moumi...@yahoo.fr
 Date: Mercredi 16 janvier 2013, 22h36


 We moved all the item info to a single book record before importing. Our
 old database allows us to run a de-duplication script and then I manually
 combined the duplicate records.  Yes, it's a pain. Once in Koha you can
 merge biblios, to get all the items into one record, but I wouldn't want to
 do this for a large number of things.
 It would be nice if there were an easier way, I just don't know what it is.
 Elaine
 On Wed, Jan 16, 2013 at 6:45 AM, soulemane moumie 
 moumi...@yahoo.frhttp://mc/compose?to=moumi...@yahoo.fr
  wrote:

 Hi!
 I want to import my newly created marc file into koha.
 Everything is imported successfully in the koha empty database and
 re-indexed.
 The problem is that I have duplicated titles.
 e.g:
 book1: introduction to koha  nber of item: 1
 book2: introduction to koha  nber of item: 1
 book3: introduction to koha  nber of item: 1

 but I want to have :
 book: introduction to koha  nber of item: 3

 If I set a matching rule, the import stalls after staging.

 Matching rule:
 Matching rule code : TITLE
 Description: 245$a
 Match threshold: 100

 Match point:
 Search index: Title
 Score: 101

 Matching component:
 Tag: 245
 subfields: a
 offset: 0
 length: 0
 Normalization rule: TITLE

 Question:
 Is it possible to do this in koha ?
 for each duplicate marc record :
 Koha does not add it but instead add the item info under existing record
 increase the number of item under the duplicate record.
 Should I add only record info and add items info manually ? But with more
 than 40 000 books it will be a nightmare
 Thanks for helping !






 Moumié Soulémane
 Assistant Programmer, OCP, MCTS, JCP
 Department of Computer Science Engineering
 Islamic University of Technology(IUT)
 Board Bazar, Gazipur-1704, Bangladesh.
 Cellular: +880192-1628880,+8801921628880
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz http://mc/compose?to=Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha




 --
 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.