[Koha] Fwd: Help with MarcEdit Delimited Text Translator

Thu Aug 25 16:41:47 NZST 2011

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 & Regards
Ashok

********

System preferences admin
all preferences
 Preference Explanation Value Edit Delete
*NoZebra<http://192.168.0.9:8090/cgi-bin/koha/admin/systempreferences.pl?op=add_form&searchfield=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
<http://192.168.0.9:8090/cgi-bin/koha/admin/systempreferences.pl?op=add_form&searchfield=NoZebra>
Delete<http://192.168.0.9:8090/cgi-bin/koha/admin/systempreferences.pl?op=delete_confirm&searchfield=NoZebra>
*NoZebraIndexes<http://192.168.0.9:8090/cgi-bin/koha/admin/systempreferences.pl?op=add_form&searchfield=NoZebraIndexes>
* Enter a specific hash for NoZebra indexes. Enter : 'indexname' =>
'100a,245a,500*','index2' => '...'  Click to
Edit<http://192.168.0.9:8090/cgi-bin/koha/admin/systempreferences.pl#>
 Edit
<http://192.168.0.9:8090/cgi-bin/koha/admin/systempreferences.pl?op=add_form&searchfield=NoZebraIndexes>
Delete<http://192.168.0.9:8090/cgi-bin/koha/admin/systempreferences.pl?op=delete_confirm&searchfield=NoZebraIndexes>

*************
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 Regards
> Ashok
>
>
> 2011/8/6 Olugbenga Adara <gbengaadara at yahoo.com<http://mc/compose?to=gbengaadara@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-migrationand
> 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<http://mc/compose?to=cothitis@telus.net>
> >* wrote:
>
>
> From: Christine Othitis <cothitis at telus.net<http://mc/compose?to=cothitis@telus.net>
> >
> Subject: [Koha] Help with MarcEdit Delimited Text Translator
> To: koha at lists.katipo.co.nz <http://mc/compose?to=koha@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:
>
>
>
> Flag
>
> Title/Description
>
> Author(s)/Editor/Curator
>
> Artists Involved
>
> Pub. Year
>
> Gallery
>
> Category
>
> Location
>
> Notes
>
> Borrowed
>
>
>
> 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://mc/compose?to=Koha@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://mc/compose?to=Koha@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://mc/compose?to=Koha@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/20110824/a324c92e/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: KOHA ITEM MARC VIEW.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 12661 bytes
Desc: not available
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20110824/a324c92e/attachment-0001.xlsx>