Re: [CODE4LIB] Help with Catmandu MARC import to CouchDB
Thanks Francis! Here it is. It's probably a Marc-8 file, given that it's output from III. So I should probably run it thru a fix? My first reaction would be to pass it thru MARCEdit. I got the convert to JSON to work after I added the space around the . But that didn't seem to fix the CouchDB issue. Cindy -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Francis Kayiwa Sent: Sunday, January 25, 2015 4:50 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Help with Catmandu MARC import to CouchDB On 1/25/15 4:27 PM, Harper, Cynthia wrote: Hi - I'm trying to use catmandu to build a copy of my III authorities database in CouchDB, queryable by REST. I'm working in Windows 7. I've successfully been able to import MARC bib records (from an ebook set) into my database, but I'm failing when trying with the authority records. I'm assuming that might be because of validation and what fields exist in the authority records. Here's my error message: C:\Perlcatmandu convert MARC to JSON c:\Users\charper\Documents\Authorities\small\msplit.mrc No Perl script found in input Care to share the mrc file to see if I'd get the same results? Also I would think a space between the and c:\ would be needed. Cheers, ./fxk Here's a sample MARC authority converted to MARcEDIT .mrk: (looks like I could have started with a simpler record) =LDR 02738cz 2200517n 45 0 =001 oca00314234\ =003 OCoLC =005 20141107020415.0 =008 790918n|\azannaabn\\|a\aaa\\ =010 \\$an 79081704 $zn 90664944 =040 \\$aDLC$beng$erda$cDLC$dDLC$dDLC$dInU$dUPB$dDLC =046 \\$f1285{tilde}$g1349{tilde}$2edtf =100 0\$aWilliam,$cof Ockham,$dapproximately 1285-approximately 1349 =372 \\$aphilosopher =375 \\$amale =377 \\$alat =400 0\$aGuglielmo,$cdi Ockham,$dapproximately 1285-approximately 1349 =400 0\$aGuglielmo,$cd'Occam,$dapproximately 1285-approximately 1349 =400 0\$aGuilelmus,$cde Occam,$dapproximately 1285-approximately 1349 =400 0\$aGuilhelmus,$cde Ockam,$dapproximately 1285-approximately 1349 =400 0\$aGuillaume,$cd'Occam,$dapproximately 1285-approximately 1349 =400 0\$aGuillelmus,$cde Ockham,$dapproximately 1285-approximately 1349 =400 0\$aGulielmus,$cOcchamus,$dapproximately 1285-approximately 1349 =400 0\$aOccam,$dapproximately 1285-approximately 1349 =400 1\$aOccam, Guillaume d',$dapproximately 1285-approximately 1349 =400 1\$aOccam, William,$dapproximately 1285-approximately 1349 =400 1\$aOccamus, Guilielmus,$dapproximately 1285-approximately 1349 =400 1\$aOcchamus, Gulielmus,$dapproximately 1285-approximately 1349 =400 1\$aOckam, Guilhelmus de,$dapproximately 1285-approximately 1349 =400 1\$aOckham, William,$dapproximately 1285-approximately 1349 =400 1\$aOckham, William,$dd. ca. 1349$wnnaa =400 0\$aOkkam, Uil{softsign}{llig}i{rlig}am,$dapproximately 1285-approximately 1349 =400 1\$aOkk{mllhring}am, William,$dapproximately 1285-approximately 1349 =400 0\$aWilhelm,$cvon Ockham,$dapproximately 1285-approximately 1349 =400 0\$aWilliam,$cof Occam,$dapproximately 1285-approximately 1349 =400 0\$aWilliam,$cof Ockham,$dca. 1285-ca. 1349$wnnea =400 0\$aWilliam Okk{mllhring}am,$dapproximately 1285-approximately 1349 =670 \\$aPak, C.G. William Okk{mllhring}am {breve}ui saengae wa sasang, 1983:$bt.p. (William Okk{mllhring}am) =670 \\$aAicher, O. Wilhelm von Ockham, c1986. =670 \\$aInU/Wing STC files$b(usage: Gulielmi Occhami ...) =670 \\$aHis Expositio in libros Physicorum Aristotelis, 1985:$bt.p. (Guillelmi de Ockham) =670 \\$aThe JFK assassination, 1999:$bt.p. (Occam) p. 4 of cover (William of Ockham; medieval philosopher) =670 \\$aFilosofi{llig}i{rlig}a Uil{softsign}{llig}i{rlig}ama Okkama, 2001. =670 \\$aEpitome et collectorium ex Occamo circa quatuor Sententiarum libros, 1965. =670 \\$aTabule ad diversas huius operis Magistri Guilhelmi de Ockam super quattuor libros Sententiarum annotationes ..., 9-10 Nov. 1495. =907 \\$a.a12671617$b11-07-14$c11-07-14$d-$e-$f- Any help? Thanks in advance. Cindy Harper Electronic Services and Serials Librarian Virginia Theological Seminary 3737 Seminary Road Alexandria VA 22304 703-461-1794 char...@vts.edu -- Mediocrity finds safety in standardization. -- Frederick Crane msplit.mrc Description: msplit.mrc
Re: [CODE4LIB] Help with Catmandu MARC import to CouchDB
Curious. It goes on to a different error (the convert to JSON actually works) when my working directory is c:\Users\charper, but not if my working directory is c:\Perl. But my import to CouchDB of the ebook bibs worked in the c:\Perl directory. -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Francis Kayiwa Sent: Sunday, January 25, 2015 4:50 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Help with Catmandu MARC import to CouchDB On 1/25/15 4:27 PM, Harper, Cynthia wrote: Hi - I'm trying to use catmandu to build a copy of my III authorities database in CouchDB, queryable by REST. I'm working in Windows 7. I've successfully been able to import MARC bib records (from an ebook set) into my database, but I'm failing when trying with the authority records. I'm assuming that might be because of validation and what fields exist in the authority records. Here's my error message: C:\Perlcatmandu convert MARC to JSON c:\Users\charper\Documents\Authorities\small\msplit.mrc No Perl script found in input Care to share the mrc file to see if I'd get the same results? Also I would think a space between the and c:\ would be needed. Cheers, ./fxk Here's a sample MARC authority converted to MARcEDIT .mrk: (looks like I could have started with a simpler record) =LDR 02738cz 2200517n 45 0 =001 oca00314234\ =003 OCoLC =005 20141107020415.0 =008 790918n|\azannaabn\\|a\aaa\\ =010 \\$an 79081704 $zn 90664944 =040 \\$aDLC$beng$erda$cDLC$dDLC$dDLC$dInU$dUPB$dDLC =046 \\$f1285{tilde}$g1349{tilde}$2edtf =100 0\$aWilliam,$cof Ockham,$dapproximately 1285-approximately 1349 =372 \\$aphilosopher =375 \\$amale =377 \\$alat =400 0\$aGuglielmo,$cdi Ockham,$dapproximately 1285-approximately 1349 =400 0\$aGuglielmo,$cd'Occam,$dapproximately 1285-approximately 1349 =400 0\$aGuilelmus,$cde Occam,$dapproximately 1285-approximately 1349 =400 0\$aGuilhelmus,$cde Ockam,$dapproximately 1285-approximately 1349 =400 0\$aGuillaume,$cd'Occam,$dapproximately 1285-approximately 1349 =400 0\$aGuillelmus,$cde Ockham,$dapproximately 1285-approximately 1349 =400 0\$aGulielmus,$cOcchamus,$dapproximately 1285-approximately 1349 =400 0\$aOccam,$dapproximately 1285-approximately 1349 =400 1\$aOccam, Guillaume d',$dapproximately 1285-approximately 1349 =400 1\$aOccam, William,$dapproximately 1285-approximately 1349 =400 1\$aOccamus, Guilielmus,$dapproximately 1285-approximately 1349 =400 1\$aOcchamus, Gulielmus,$dapproximately 1285-approximately 1349 =400 1\$aOckam, Guilhelmus de,$dapproximately 1285-approximately 1349 =400 1\$aOckham, William,$dapproximately 1285-approximately 1349 =400 1\$aOckham, William,$dd. ca. 1349$wnnaa =400 0\$aOkkam, Uil{softsign}{llig}i{rlig}am,$dapproximately 1285-approximately 1349 =400 1\$aOkk{mllhring}am, William,$dapproximately 1285-approximately 1349 =400 0\$aWilhelm,$cvon Ockham,$dapproximately 1285-approximately 1349 =400 0\$aWilliam,$cof Occam,$dapproximately 1285-approximately 1349 =400 0\$aWilliam,$cof Ockham,$dca. 1285-ca. 1349$wnnea =400 0\$aWilliam Okk{mllhring}am,$dapproximately 1285-approximately 1349 =670 \\$aPak, C.G. William Okk{mllhring}am {breve}ui saengae wa sasang, 1983:$bt.p. (William Okk{mllhring}am) =670 \\$aAicher, O. Wilhelm von Ockham, c1986. =670 \\$aInU/Wing STC files$b(usage: Gulielmi Occhami ...) =670 \\$aHis Expositio in libros Physicorum Aristotelis, 1985:$bt.p. (Guillelmi de Ockham) =670 \\$aThe JFK assassination, 1999:$bt.p. (Occam) p. 4 of cover (William of Ockham; medieval philosopher) =670 \\$aFilosofi{llig}i{rlig}a Uil{softsign}{llig}i{rlig}ama Okkama, 2001. =670 \\$aEpitome et collectorium ex Occamo circa quatuor Sententiarum libros, 1965. =670 \\$aTabule ad diversas huius operis Magistri Guilhelmi de Ockam super quattuor libros Sententiarum annotationes ..., 9-10 Nov. 1495. =907 \\$a.a12671617$b11-07-14$c11-07-14$d-$e-$f- Any help? Thanks in advance. Cindy Harper Electronic Services and Serials Librarian Virginia Theological Seminary 3737 Seminary Road Alexandria VA 22304 703-461-1794 char...@vts.edu -- Mediocrity finds safety in standardization. -- Frederick Crane
Re: [CODE4LIB] Help with Catmandu MARC import to CouchDB
On 1/25/15 4:27 PM, Harper, Cynthia wrote: Hi - I'm trying to use catmandu to build a copy of my III authorities database in CouchDB, queryable by REST. I'm working in Windows 7. I've successfully been able to import MARC bib records (from an ebook set) into my database, but I'm failing when trying with the authority records. I'm assuming that might be because of validation and what fields exist in the authority records. Here's my error message: C:\Perlcatmandu convert MARC to JSON c:\Users\charper\Documents\Authorities\small\msplit.mrc No Perl script found in input Care to share the mrc file to see if I'd get the same results? Also I would think a space between the and c:\ would be needed. Cheers, ./fxk Here's a sample MARC authority converted to MARcEDIT .mrk: (looks like I could have started with a simpler record) =LDR 02738cz 2200517n 45 0 =001 oca00314234\ =003 OCoLC =005 20141107020415.0 =008 790918n|\azannaabn\\|a\aaa\\ =010 \\$an 79081704 $zn 90664944 =040 \\$aDLC$beng$erda$cDLC$dDLC$dDLC$dInU$dUPB$dDLC =046 \\$f1285{tilde}$g1349{tilde}$2edtf =100 0\$aWilliam,$cof Ockham,$dapproximately 1285-approximately 1349 =372 \\$aphilosopher =375 \\$amale =377 \\$alat =400 0\$aGuglielmo,$cdi Ockham,$dapproximately 1285-approximately 1349 =400 0\$aGuglielmo,$cd'Occam,$dapproximately 1285-approximately 1349 =400 0\$aGuilelmus,$cde Occam,$dapproximately 1285-approximately 1349 =400 0\$aGuilhelmus,$cde Ockam,$dapproximately 1285-approximately 1349 =400 0\$aGuillaume,$cd'Occam,$dapproximately 1285-approximately 1349 =400 0\$aGuillelmus,$cde Ockham,$dapproximately 1285-approximately 1349 =400 0\$aGulielmus,$cOcchamus,$dapproximately 1285-approximately 1349 =400 0\$aOccam,$dapproximately 1285-approximately 1349 =400 1\$aOccam, Guillaume d',$dapproximately 1285-approximately 1349 =400 1\$aOccam, William,$dapproximately 1285-approximately 1349 =400 1\$aOccamus, Guilielmus,$dapproximately 1285-approximately 1349 =400 1\$aOcchamus, Gulielmus,$dapproximately 1285-approximately 1349 =400 1\$aOckam, Guilhelmus de,$dapproximately 1285-approximately 1349 =400 1\$aOckham, William,$dapproximately 1285-approximately 1349 =400 1\$aOckham, William,$dd. ca. 1349$wnnaa =400 0\$aOkkam, Uil{softsign}{llig}i{rlig}am,$dapproximately 1285-approximately 1349 =400 1\$aOkk{mllhring}am, William,$dapproximately 1285-approximately 1349 =400 0\$aWilhelm,$cvon Ockham,$dapproximately 1285-approximately 1349 =400 0\$aWilliam,$cof Occam,$dapproximately 1285-approximately 1349 =400 0\$aWilliam,$cof Ockham,$dca. 1285-ca. 1349$wnnea =400 0\$aWilliam Okk{mllhring}am,$dapproximately 1285-approximately 1349 =670 \\$aPak, C.G. William Okk{mllhring}am {breve}ui saengae wa sasang, 1983:$bt.p. (William Okk{mllhring}am) =670 \\$aAicher, O. Wilhelm von Ockham, c1986. =670 \\$aInU/Wing STC files$b(usage: Gulielmi Occhami ...) =670 \\$aHis Expositio in libros Physicorum Aristotelis, 1985:$bt.p. (Guillelmi de Ockham) =670 \\$aThe JFK assassination, 1999:$bt.p. (Occam) p. 4 of cover (William of Ockham; medieval philosopher) =670 \\$aFilosofi{llig}i{rlig}a Uil{softsign}{llig}i{rlig}ama Okkama, 2001. =670 \\$aEpitome et collectorium ex Occamo circa quatuor Sententiarum libros, 1965. =670 \\$aTabule ad diversas huius operis Magistri Guilhelmi de Ockam super quattuor libros Sententiarum annotationes ..., 9-10 Nov. 1495. =907 \\$a.a12671617$b11-07-14$c11-07-14$d-$e-$f- Any help? Thanks in advance. Cindy Harper Electronic Services and Serials Librarian Virginia Theological Seminary 3737 Seminary Road Alexandria VA 22304 703-461-1794 char...@vts.edu -- Mediocrity finds safety in standardization. -- Frederick Crane
Re: [CODE4LIB] Help with Catmandu MARC import to CouchDB
Happy New Year. It just worked for me on first pass. I don't have a Windows PC handy but as is oft the case in these situations. Test to make sure that Perl and CouchDB are in your path. Especially since you mention below that convert to JSON worked without a problem. Conversely... the Catmandu guys have a ready made VM which Catmandu installed in it. I'd think it'd be cool for this type of thing. So install virtualbox https://www.virtualbox.org/ Then import this into your Virtualbox. http://lib.ugent.be/download/librecat/Catmandu.ova Cheers, ./fxk On 1/25/15 5:13 PM, Harper, Cynthia wrote: Thanks Francis! Here it is. It's probably a Marc-8 file, given that it's output from III. So I should probably run it thru a fix? My first reaction would be to pass it thru MARCEdit. I got the convert to JSON to work after I added the space around the . But that didn't seem to fix the CouchDB issue. Cindy -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Francis Kayiwa Sent: Sunday, January 25, 2015 4:50 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Help with Catmandu MARC import to CouchDB On 1/25/15 4:27 PM, Harper, Cynthia wrote: Hi - I'm trying to use catmandu to build a copy of my III authorities database in CouchDB, queryable by REST. I'm working in Windows 7. I've successfully been able to import MARC bib records (from an ebook set) into my database, but I'm failing when trying with the authority records. I'm assuming that might be because of validation and what fields exist in the authority records. Here's my error message: C:\Perlcatmandu convert MARC to JSON c:\Users\charper\Documents\Authorities\small\msplit.mrc No Perl script found in input Care to share the mrc file to see if I'd get the same results? Also I would think a space between the and c:\ would be needed. Cheers, ./fxk Here's a sample MARC authority converted to MARcEDIT .mrk: (looks like I could have started with a simpler record) =LDR 02738cz 2200517n 45 0 =001 oca00314234\ =003 OCoLC =005 20141107020415.0 =008 790918n|\azannaabn\\|a\aaa\\ =010 \\$an 79081704 $zn 90664944 =040 \\$aDLC$beng$erda$cDLC$dDLC$dDLC$dInU$dUPB$dDLC =046 \\$f1285{tilde}$g1349{tilde}$2edtf =100 0\$aWilliam,$cof Ockham,$dapproximately 1285-approximately 1349 =372 \\$aphilosopher =375 \\$amale =377 \\$alat =400 0\$aGuglielmo,$cdi Ockham,$dapproximately 1285-approximately 1349 =400 0\$aGuglielmo,$cd'Occam,$dapproximately 1285-approximately 1349 =400 0\$aGuilelmus,$cde Occam,$dapproximately 1285-approximately 1349 =400 0\$aGuilhelmus,$cde Ockam,$dapproximately 1285-approximately 1349 =400 0\$aGuillaume,$cd'Occam,$dapproximately 1285-approximately 1349 =400 0\$aGuillelmus,$cde Ockham,$dapproximately 1285-approximately 1349 =400 0\$aGulielmus,$cOcchamus,$dapproximately 1285-approximately 1349 =400 0\$aOccam,$dapproximately 1285-approximately 1349 =400 1\$aOccam, Guillaume d',$dapproximately 1285-approximately 1349 =400 1\$aOccam, William,$dapproximately 1285-approximately 1349 =400 1\$aOccamus, Guilielmus,$dapproximately 1285-approximately 1349 =400 1\$aOcchamus, Gulielmus,$dapproximately 1285-approximately 1349 =400 1\$aOckam, Guilhelmus de,$dapproximately 1285-approximately 1349 =400 1\$aOckham, William,$dapproximately 1285-approximately 1349 =400 1\$aOckham, William,$dd. ca. 1349$wnnaa =400 0\$aOkkam, Uil{softsign}{llig}i{rlig}am,$dapproximately 1285-approximately 1349 =400 1\$aOkk{mllhring}am, William,$dapproximately 1285-approximately 1349 =400 0\$aWilhelm,$cvon Ockham,$dapproximately 1285-approximately 1349 =400 0\$aWilliam,$cof Occam,$dapproximately 1285-approximately 1349 =400 0\$aWilliam,$cof Ockham,$dca. 1285-ca. 1349$wnnea =400 0\$aWilliam Okk{mllhring}am,$dapproximately 1285-approximately 1349 =670 \\$aPak, C.G. William Okk{mllhring}am {breve}ui saengae wa sasang, 1983:$bt.p. (William Okk{mllhring}am) =670 \\$aAicher, O. Wilhelm von Ockham, c1986. =670 \\$aInU/Wing STC files$b(usage: Gulielmi Occhami ...) =670 \\$aHis Expositio in libros Physicorum Aristotelis, 1985:$bt.p. (Guillelmi de Ockham) =670 \\$aThe JFK assassination, 1999:$bt.p. (Occam) p. 4 of cover (William of Ockham; medieval philosopher) =670 \\$aFilosofi{llig}i{rlig}a Uil{softsign}{llig}i{rlig}ama Okkama, 2001. =670 \\$aEpitome et collectorium ex Occamo circa quatuor Sententiarum libros, 1965. =670 \\$aTabule ad diversas huius operis Magistri Guilhelmi de Ockam super quattuor libros Sententiarum annotationes ..., 9-10 Nov. 1495. =907 \\$a.a12671617$b11-07-14$c11-07-14$d-$e-$f- Any help? Thanks in advance. Cindy Harper Electronic Services and Serials Librarian Virginia Theological Seminary 3737 Seminary Road Alexandria VA 22304 703-461-1794 char...@vts.edu -- Mediocrity finds safety in standardization. -- Frederick Crane -- Mediocrity finds safety in standardization. -- Frederick Crane
Re: [CODE4LIB] Help with Catmandu MARC import to CouchDB
On 1/25/15 5:18 PM, Harper, Cynthia wrote: Curious. It goes on to a different error (the convert to JSON actually works) when my working directory is c:\Users\charper, but not if my working directory is c:\Perl. But my import to CouchDB of the ebook bibs worked in the c:\Perl directory. Increasingly methinks it is a problem with your Path settings and my year with Windows didn't give me enough confidence to push you in a direction to look. I just realized that the VM solution I proposed before isn't that helpful since I don't think it provides CouchDB :-( regards, ./fxk -- Mediocrity finds safety in standardization. -- Frederick Crane