[Koha] Fwd: Help with MarcEdit Delimited Text Translator

Olugbenga Adara gbengaadara at yahoo.com
Fri Aug 26 10:49:18 NZST 2011


Hi Ashok,

If I understand your post well, you mean in some instances you see items while in other instances in the same batch, you see no items.

I would advice you check your marc records very well. You may also try the command line bulkmarcimport tool or try upgrading to 3.2.10 and try again.

Olugbenga Adara





--- On Thu, 8/25/11, Ashok Gangurde <ashokg9696 at gmail.com> wrote:

From: Ashok Gangurde <ashokg9696 at gmail.com>
Subject: Re: [Koha] Fwd: Help with MarcEdit Delimited Text Translator
To: "Olugbenga Adara" <gbengaadara at yahoo.com>
Cc: koha at lists.katipo.co.nz
Date: Thursday, August 25, 2011, 6:41 AM

 Dear Sir Please find the attached file of MARC VIEW of both title from OPAC 1) display ITEM available 2) NO ITEM AVAILABLE 
both title import in koha same excel file. We are mapping all required field in 950 tag 
 WE ARE USEING KOHA VERSION (LINUX) 3.0006010  
Please guide me in this matter Thanks & RegardsAshok ******** System preferences admin
    all preferences
    
    
    
        Preference
        Explanation
        Value
        Edit
        Delete
    
    
    
    
    
    

        NoZebra
 If ON, Zebra indexing is turned off, simpler setup, but slower 
searches. WARNING: using NoZebra on even modest sized collections is 
very slow.
        
        
        
            

                
                
                
                

                
                    
                        
                    ON
                    
                    
                    OFF
                
                
                
                
                
                
                
            
        

        Edit 
        Delete
    

        NoZebraIndexes Enter a specific hash for NoZebra indexes. Enter : 'indexname' => '100a,245a,500*','index2' => '...'

        
        
        
            

                
                
                Click to Edit
                
                
                
                

                
                
                
                
                
                
                
            
        

        Edit 
        Delete

 *************MARC VIEW IN OPAC Ships Visual Encyclopedia (Record no. 5421)

	
        
        000 -LEADER
        
                
                    fixed length control field
                    00699nam a2200205Ia 4500
                
            
        
        003  - CONTROL NUMBER IDENTIFIER
        
                
                    control field
                    OSt
                
            
        
        005  - DATE AND TIME OF LATEST TRANSACTION
        
                
                    control field
                    20110824154150
                
            
        
        008  - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
        
                
                    fixed length control field
                    110824s9999    xx            000 0 und d
                
            
        
        020 ## - INTERNATIONAL STANDARD BOOK NUMBER
        
                
                    International Standard Book Number
                    9781907446269
                
            
        
        040 ## - CATALOGING SOURCE
        
                
                    Transcribing agency
                    ENG
                
            
        
        082 ## - DEWEY DECIMAL CLASSIFICATION NUMBER
        
                
                    Item number
                    1228
                
            
                
                    Classification number
                    G.11
                
            
        
        
        100 ## - MAIN ENTRY--PERSONAL NAME
        
                
                    Personal name
                    David Ross
                
            
        

        
        245 ## - TITLE STATEMENT
        
                
                    Title
                    Ships Visual Encyclopedia
                
            
        
        260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)
        
                
                    Place of publication, distribution, etc
                    London
                
            
                
                    Name of publisher, distributor, etc
                    Amber Books Ltd
                
            
                
                    Date of publication, distribution, etc
                    2010
                
            
        

        
        300 ## - PHYSICAL DESCRIPTION
        
                
                    Extent
                    448
                
            
        

        

        
        530 ## - ADDITIONAL PHYSICAL FORM AVAILABLE NOTE
        
                
                    Availability source
                    HONG KONG
                
            
        

        
        650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM
        
                
                    Topical term or geographic name as entry element
                    General
                
            
        

        

        

        
        942 ## - ADDED ENTRY ELEMENTS (KOHA)
        
                
                    Koha item type
                    BOOKS
                
            
        
    

        No copies available.
On Wed, Aug 24, 2011 at 1:07 PM, Olugbenga Adara <gbengaadara at yahoo.com> wrote:


Hi Ashok,

What version of Koha are you running? What you described has happened to me with 3.4 versions. 


You may click one of the records in the OPAC search results and download the marc format. Using marcedit again, cross check that you have your marc tags right, especially the 952 fields.

And please also make sure that zebraqueue daemon is not running. I don't think it is compatible with 3.4 It recently messed up the index on two of my installs recently.


Olugbenga Adara




--- On Wed, 8/24/11, Ashok Gangurde <ashokg9696 at gmail.com> wrote:


From: Ashok Gangurde <ashokg9696 at gmail.com>
Subject: [Koha] Fwd:  Help with MarcEdit Delimited Text Translator
To: koha at lists.katipo.co.nz

Date: Wednesday, August 24, 2011, 1:35 PM

Dear Sir I have same query about imort data in koha from excel file. I had follow the Marc edit method, 
after stage MARC RECORD in koha the result was disply all record import.

While in searching in OPAC there were some problem " NO ITEM" only title appear but no item found is display in opac


 What to do in this regards? Please guide me Thanks and RegardsAshok
 2011/8/6 Olugbenga Adara <gbengaadara at yahoo.com>





Hello Christine,

Apart from mapping the fields you have in your excel file, you also need to create some other fields like permanent location, holding branch, itemtype and barcode if you need to circulate the items. Also note that the branch code, location, itemtype has to match what you have in Koha.




You may create this fields in excel before converting using marcedit or add them in Marcedit after conversion.

In addition to the link Nicole sent you, you can also read

http://manual.koha-community.org/3.4/en/implementation.html#imp-migration and



http://manual.koha-community.org/3.4/en/catguides.html#itemcatguide


Olugbenga Adara



Mobile: 234 (0) 8033220288

Home: 234 (2) 8721720

Skype: gbengaadara

Blog: http://gbengaadara.blogspot.com

Twitter: http://twitter.com/gbengaadara

Profile: http://www.linkedin.com/in/gbengaadara

--- On Sat, 8/6/11, Christine Othitis <cothitis at telus.net> wrote:




From: Christine Othitis <cothitis at telus.net>



Subject: [Koha] Help with MarcEdit Delimited Text Translator
To: koha at lists.katipo.co.nz
Date: Saturday, August 6, 2011, 5:45 AM



Hi group,  I am volunteering with a non-profit organization who has decided to use Koha to catalogue their collection. It exists as an Excel spreadsheet.  Nicole, on this list, pointed me to these instructions for translating the Excel file:


  http://manual.koha-community.org/3.4/en/marceditexcel.html  I thought I made the MARC file correctly, but when I tried to import it into Koha, I received an error that said something to the effect of 0 records
 were imported, records don’t exist.   I am looking at the tutorial again and I don’t think I mapped the fields correctly as demonstrated in the tutorial.  The spreadsheet contains these fields:


  FlagTitle/DescriptionAuthor(s)/Editor/CuratorArtists InvolvedPub. YearGalleryCategoryLocationNotesBorrowed  Do I need to change the column headings to something else? And if so, what would the map to text be? I went to the LOC website, but I can’t understand it :\


  Thanks,Christine
-----Inline Attachment Follows-----

_______________________________________________
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







-----Inline Attachment Follows-----

_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz

http://lists.katipo.co.nz/mailman/listinfo/koha



-----Inline Attachment Follows-----

_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20110825/a4136c54/attachment-0001.html>


More information about the Koha mailing list