I learned from a colleague at another library today that their system (Winnebago) accepts MARC records in text file format. This would be a big time-saver as it would allow catalogers to simply copy & paste records from other systems into a text file, before importing into Koha. How difficult would this be to implement for Koha? A sample record follows below, from the Minuteman Library Network in Massachusetts. Cab Vinton, Director Sanbornton Public Library Sanbornton, NH LEADER 00000cam 2200397Ia 4500 001 233216064 003 OCoLC 005 20081215093140.0 008 080703s2008 nyu d 000 1 eng d 020 9780739494752 020 0739494759 035 (OCoLC)233216064 040 KKV|cKKV|dWIQ|dIUI|dMLN 043 n-us-nj 049 MLNM 050 04 PS3555.V2126|bF43 2008 082 04 813/.54|222 100 1 Evanovich, Janet. 245 10 Fearless fourteen /|cJanet Evanovich. 250 Doubleday large print home library ed. 260 New York :|bSt. Martin's Press,|cc2008. 300 416 p. (large print) ;|c22 cm. 520 Personal vendettas, hidden treasure, and a monkey named Carl will send bounty hunter Stephanie Plum on her most explosive adventure yet. 650 0 Plum, Stephanie (Fictitious character)|vFiction. 650 0 Women bounty hunters|vFiction. 650 0 Bail bond agents|zNew Jersey|zTrenton|vFiction. 650 0 Bank robberies|vFiction. 650 0 Large type books. 650 0 Detective and mystery stories. 650 0 Humorous stories. 651 0 Trenton (N.J.)|vFiction. 856 42 |3Contributor biographical information|uhttp://www.loc.gov /catdir/enhancements/fy0834/2008017664-b.html 856 42 |3Publisher description|uhttp://www.loc.gov/catdir/ enhancements/fy0834/2008017664-d.html
Hi! I think what you are looking for is already available in Koha. Have a look at these two pages from the docs: http://koha.org/documentation/manual/3.0/tools/stage-marc-records-for-import http://koha.org/documentation/manual/3.0/tools/manage-staged-marc-records Regards, Magnus Enger libriotech.no 2009/7/30 Cab Vinton <bibliwho@gmail.com>:
I learned from a colleague at another library today that their system (Winnebago) accepts MARC records in text file format.
This would be a big time-saver as it would allow catalogers to simply copy & paste records from other systems into a text file, before importing into Koha.
How difficult would this be to implement for Koha? A sample record follows below, from the Minuteman Library Network in Massachusetts.
Cab Vinton, Director Sanbornton Public Library Sanbornton, NH
LEADER 00000cam 2200397Ia 4500 001 233216064 003 OCoLC 005 20081215093140.0 008 080703s2008 nyu d 000 1 eng d 020 9780739494752 020 0739494759 035 (OCoLC)233216064 040 KKV|cKKV|dWIQ|dIUI|dMLN 043 n-us-nj 049 MLNM 050 04 PS3555.V2126|bF43 2008 082 04 813/.54|222 100 1 Evanovich, Janet. 245 10 Fearless fourteen /|cJanet Evanovich. 250 Doubleday large print home library ed. 260 New York :|bSt. Martin's Press,|cc2008. 300 416 p. (large print) ;|c22 cm. 520 Personal vendettas, hidden treasure, and a monkey named Carl will send bounty hunter Stephanie Plum on her most explosive adventure yet. 650 0 Plum, Stephanie (Fictitious character)|vFiction. 650 0 Women bounty hunters|vFiction. 650 0 Bail bond agents|zNew Jersey|zTrenton|vFiction. 650 0 Bank robberies|vFiction. 650 0 Large type books. 650 0 Detective and mystery stories. 650 0 Humorous stories. 651 0 Trenton (N.J.)|vFiction. 856 42 |3Contributor biographical information|uhttp://www.loc.gov /catdir/enhancements/fy0834/2008017664-b.html 856 42 |3Publisher description|uhttp://www.loc.gov/catdir/ enhancements/fy0834/2008017664-d.html _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
I think what you are looking for is already available in Koha. Have a look at these two pages from the docs:
http://koha.org/documentation/manual/3.0/tools/stage-marc-records-for-import http://koha.org/documentation/manual/3.0/tools/manage-staged-marc-records
I"ve already tried staging a TXT file for import, but it doesn't work. The staging utility expects a different format; I've imported *.mrc & *.dat files with no problems in the past. Cab Vinton, Director Sanbornton Public Library Sanbornton, NH
Is that a MicroLIF format? I think I might have a script laying around that could help you. Kyle http://www.kylehall.info Information Technology Crawford County Federated Library System ( http://www.ccfls.org ) On Fri, Jul 31, 2009 at 9:45 AM, Cab Vinton<bibliwho@gmail.com> wrote:
I think what you are looking for is already available in Koha. Have a look at these two pages from the docs:
http://koha.org/documentation/manual/3.0/tools/stage-marc-records-for-import http://koha.org/documentation/manual/3.0/tools/manage-staged-marc-records
I"ve already tried staging a TXT file for import, but it doesn't work.
The staging utility expects a different format; I've imported *.mrc & *.dat files with no problems in the past.
Cab Vinton, Director Sanbornton Public Library Sanbornton, NH _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Not exactly sure what format it's in -- I just copy & pasted into a text file from a record in the Minuteman Library Network in Mass: http://library.minlib.net/search/# SirsiDynix catalogs also present options for displaying MARC records that could be copied. One example: http://catalog.dalnet.lib.mi.us/ http://catalog.dalnet.lib.mi.us/ipac20/ipac.jsp?full=3100001~!431721~!1&fullmarc=true But in this instance, some processing would be required as the tags & tag contents end up on separate lines. Cab Vinton, Director Sanbornton Public Library Sanbornton, NH On Fri, Jul 31, 2009 at 9:57 AM, Kyle Hall<kyle.m.hall@gmail.com> wrote:
Is that a MicroLIF format? I think I might have a script laying around that could help you.
Kyle
http://www.kylehall.info Information Technology Crawford County Federated Library System ( http://www.ccfls.org )
Not exactly sure what format it's in -- I just copy & pasted into a text file from a record in the Minuteman Library Network in Mass:
Not really an answer to your question, but... Why not just search for the record using z39.50? -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org
Not really an answer to your question, but... Why not just search for the record using z39.50?
This is for those occasions when z39.50 comes up empty. Our connection to FirstSearch/ OCLC wasn't working recently & it took a while to diagnose. Meanwhile, our backlog of cataloging keeps building up ... My attempts to create additional search points were a bust. I tried using the directory at http://irspy.indexdata.com/, but MELVYL, AMICUS, & few others didn't work. It would be great if there were a central repository of targets + Koha settings that work. Our connections to the New York libraries (NYU, NYPL) have never worked. Cab Vinton, Director Sanbornton Public Library Sanbornton, NH
First, download MarcEdit. Once it is installed: Take the output from Minuteman, changing whatever filename extension is present, if any, to (.mrc). This extension will be recognized by MarcEdit. Double-click the on the file and follow the instructions. I suspect the file is MARC, and if it is, MarcEdit will convert to human-readable text with a new extension (.mrk). Load the .mrc file to Koha if all of the above is true. This procedure is for MarcEdit running under Windows XP. Gary -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Owen Leonard Sent: Friday, July 31, 2009 9:05 AM To: Cab Vinton Cc: Koha list Subject: Re: [Koha] MARC record import
Not exactly sure what format it's in -- I just copy & pasted into a text file from a record in the Minuteman Library Network in Mass:
Not really an answer to your question, but... Why not just search for the record using z39.50? -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ______________________________________________________________________ This inbound email has been scanned by the MessageLabs Email Security System. ______________________________________________________________________ Confidentiality Notice: This e-mail, including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the Sybari - Antigen Email System. Confidentiality Notice: This e-mail,including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review,use,disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the MessageLabs Email Security System.
Hmm ... good idea. The Minuteman catalog doesn't have MARC export functionality, & records can be saved to a list, but no MARC export there either. MarcEditor will accept text files; format should be like this, however: =LDR 04217cgm a2200841Ia 4500 =001 ocn175280415 =003 OCoLC =008 071019s2007\\\\cau181\\\\\\\\\\\\mleng\d =040 \\$aEYB$cEYB$dOCLCQ$dOCLCG$dIUL =041 1\$aeng$afre$aspa$beng$bspa$heng =043 \\$ae-un--- =050 \4$aPN1997$b.F43 2007 =130 0\$aFiddler on the roof (Motion picture) Not this: LEADER 00000cam 2200397Ia 4500 001 233216064 003 OCoLC 008 080703s2008 nyu d 000 1 eng d 020 9780739494752 035 (OCoLC)233216064 040 KKV|cKKV|dWIQ|dIUI|dMLN 050 04 PS3555.V2126|bF43 2008 082 04 813/.54|222 100 1 Evanovich, Janet. 245 10 Fearless fourteen /|cJanet Evanovich. The latter does not compile correctly into MARC. I changed the following manually & the file compiled fine: * change | to $ * add = before each line * change LEADER to LDR Not sure whether any of these changes are optional ... Cab Vinton, Director Sanbornton Public Library Sanbornton, NH On Fri, Jul 31, 2009 at 11:32 AM, Harris, Gary, DCA<Gary.Harris@state.nm.us> wrote:
First, download MarcEdit. Once it is installed:
Take the output from Minuteman, changing whatever filename extension is present, if any, to (.mrc). This extension will be recognized by MarcEdit. Double-click the on the file and follow the instructions. I suspect the file is MARC, and if it is, MarcEdit will convert to human-readable text with a new extension (.mrk). Load the .mrc file to Koha if all of the above is true. This procedure is for MarcEdit running under Windows XP.
Gary
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Owen Leonard Sent: Friday, July 31, 2009 9:05 AM To: Cab Vinton Cc: Koha list Subject: Re: [Koha] MARC record import
Not exactly sure what format it's in -- I just copy & pasted into a text file from a record in the Minuteman Library Network in Mass:
Not really an answer to your question, but... Why not just search for the record using z39.50?
-- Owen
-- Web Developer Athens County Public Libraries http://www.myacpl.org
2009/7/31 Cab Vinton <bibliwho@gmail.com>
Hmm ... good idea.
The Minuteman catalog doesn't have MARC export functionality, & records can be saved to a list, but no MARC export there either.
MarcEditor will accept text files; format should be like this, however:
=LDR 04217cgm a2200841Ia 4500 =001 ocn175280415 =003 OCoLC =008 071019s2007\\\\cau181\\\\\\\\\\\\mleng\d =040 \\$aEYB$cEYB$dOCLCQ$dOCLCG$dIUL =041 1\$aeng$afre$aspa$beng$bspa$heng =043 \\$ae-un--- =050 \4$aPN1997$b.F43 2007 =130 0\$aFiddler on the roof (Motion picture)
Not this: LEADER 00000cam 2200397Ia 4500 001 233216064 003 OCoLC 008 080703s2008 nyu d 000 1 eng d 020 9780739494752 035 (OCoLC)233216064 040 KKV|cKKV|dWIQ|dIUI|dMLN 050 04 PS3555.V2126|bF43 2008 082 04 813/.54|222 100 1 Evanovich, Janet. 245 10 Fearless fourteen /|cJanet Evanovich.
The latter does not compile correctly into MARC. I changed the following manually & the file compiled fine: * change | to $ * add = before each line * change LEADER to LDR
Not sure whether any of these changes are optional ...
Cab Vinton, Director Sanbornton Public Library Sanbornton, NH
On Fri, Jul 31, 2009 at 11:32 AM, Harris, Gary, DCA<Gary.Harris@state.nm.us> wrote:
First, download MarcEdit. Once it is installed:
Take the output from Minuteman, changing whatever filename extension is present, if any, to (.mrc). This extension will be recognized by MarcEdit. Double-click the on the file and follow the instructions. I suspect the file is MARC, and if it is, MarcEdit will convert to human-readable text with a new extension (.mrk). Load the .mrc file to Koha if all of the above is true. This procedure is for MarcEdit running under Windows XP.
Gary
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Owen Leonard Sent: Friday, July 31, 2009 9:05 AM To: Cab Vinton Cc: Koha list Subject: Re: [Koha] MARC record import
Not exactly sure what format it's in -- I just copy & pasted into a text file from a record in the Minuteman Library Network in Mass:
Not really an answer to your question, but... Why not just search for the record using z39.50?
-- Owen
-- Web Developer Athens County Public Libraries http://www.myacpl.org
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
For our library, I created a MARC editor that actually uses a format something like this: 000 00000cam 2200397Ia 4500 003 OCoLC 100 $a Twain, Mark. 245 14 $a The adventures of Huckleberry Finn / $b by Mark Twain. It understands |a and $a. Indicators are optional, but the leading $a is not. You can see a demo at http://jcfld.us.to:8080/cgi-bin/koha/cataloguing/addbiblio-text.pl (login demo/demo). It's got a few problems dealing with hidden subfields and authorities that would make it best suited to an import facility, but it works quite well for us. -- Jesse Weaver
Perhaps some kind of script to parse each line of the text file into MARCXML; it would mostly just be adding XML wrappers around the data, so I doubt it'd be horrible to code up. Ian Walls Systems Integration Librarian NYU Health Sciences Libraries 550 First Ave., New York, NY 10016 (212) 263-8687 -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Cab Vinton Sent: Friday, July 31, 2009 10:54 AM To: Kyle Hall Cc: Koha list Subject: Re: [Koha] MARC record import Not exactly sure what format it's in -- I just copy & pasted into a text file from a record in the Minuteman Library Network in Mass: http://library.minlib.net/search/# SirsiDynix catalogs also present options for displaying MARC records that could be copied. One example: http://catalog.dalnet.lib.mi.us/ http://catalog.dalnet.lib.mi.us/ipac20/ipac.jsp?full=3100001~!431721~!1&fullmarc=true But in this instance, some processing would be required as the tags & tag contents end up on separate lines. Cab Vinton, Director Sanbornton Public Library Sanbornton, NH On Fri, Jul 31, 2009 at 9:57 AM, Kyle Hall<kyle.m.hall@gmail.com> wrote:
Is that a MicroLIF format? I think I might have a script laying around that could help you.
Kyle
http://www.kylehall.info Information Technology Crawford County Federated Library System ( http://www.ccfls.org )
Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------------------------------------ This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain information that is proprietary, confidential, and exempt from disclosure under applicable law. Any unauthorized review, use, disclosure, or distribution is prohibited. If you have received this email in error please notify the sender by return email and delete the original message. Please note, the recipient should check this email and any attachments for the presence of viruses. The organization accepts no liability for any damage caused by any virus transmitted by this email. =================================
2009/7/31 Cab Vinton <bibliwho@gmail.com>:
I"ve already tried staging a TXT file for import, but it doesn't work.
The staging utility expects a different format; I've imported *.mrc & *.dat files with no problems in the past.
Do you get any error messages? What does the content of the files look like? Regards, Magnus Enger libriotech.no
Hi, 2009/7/31 Agnes Rivers-Moore <arm@hanover.ca>:
If there is real interest in building a copy and paste MARC text editor, we still have the Spectrum server available. We also have a consultant who may be interested in developing this functionality.
I think this is a niche requirement, but obviously something that can be very useful indeed if you happen to occupy the niche. I know that at one point Jesse Weaver was working on a text-based bib editor that would have allowed this, but doing it as a full MARC editor replacement has certain gotchas in Koha, mostly having to do with validating a record against a MARC framework. That said, offering this as a special way to import a bib record one at a time make sense to me. If in addition to the particular text format accepted by Spectrum, the MARCMaker/MARCBreaker format [1] was accepted by such a tool, it would be even more useful. [1] http://www.loc.gov/marc/makrbrkr.html Regards, Galen -- Galen Charlton gmcharlt@gmail.com
If in addition to the particular text format accepted by Spectrum, the MARCMaker/MARCBreaker format [1] was accepted by such a tool, it would be even more useful.
It's been a while since I've done anything with it, but a MARC::File:: module for working with this format is available on CPAN: <http://search.cpan.org/~eijabb/MARC-File-MARCMaker-0.05/>. The most recent version is in CVS on Sourceforge: <http://marcpm.cvs.sourceforge.net/viewvc/marcpm/marc-marcmaker/> Thank you for your time, Bryan Baldus bryan.baldus@quality-books.com eijabb@cpan.org http://home.inwave.com/eija
participants (10)
-
Agnes Rivers-Moore -
Bryan Baldus -
Cab Vinton -
Galen Charlton -
Harris, Gary, DCA -
Jesse -
Kyle Hall -
Magnus Enger -
Owen Leonard -
Walls, Ian