[MCN-L] MARC record conversion into Excel or CSV?
He Perian, Without knowing much about MARC, or knowing the structure of the records as held in Word, I'm not sure if this is any good, but recently when trying to get some tabulated Word content into XML I cut-n-pasted the table into Excel and then mapped the columns onto a schema of my choice (via Data: XML: XML map properties). It's perhaps limited, but just might work for you...if the Word documents at least hold the MARC info in tables. Cheers, Jeremy Jeremy Ottevanger Web Developer, Museum Systems Team Museum of London Group 46 Eagle Wharf Road London. N1 7ED Tel: 020 7410 2207 Fax: 020 7600 1058 Email: jottevanger at museumoflondon.org.uk www.museumoflondon.org.uk Museum of London is changing; our lower galleries will be closed while they undergo a major new development. Visit www.museumoflondon.org.uk to find out more. London's Burning - explore how the Great Fire of London shaped the city we see today www.museumoflondon.org.uk/londonsburning -Original Message- From: mcn-l-bounces at mcn.edu [mailto:mcn-l-boun...@mcn.edu] On Behalf Of Perian Sully Sent: 21 March 2007 20:13 To: 'Museum Computer Network Listserv' Subject: [MCN-L] MARC record conversion into Excel or CSV? Hi all: So the pressure is on to import a bunch of MARC records (in Word) into our shiny new CMS (EMu). I need to convert the MARC Word document into some format that I can then use to recode the MARC tags into EMu-speak. I've done this with our old records using Excel, and would like to use Excel again to work with the MARC records (yes, I recognize that this may mean that I'll have potentially 1000 or so columns to deal with). And our archivist is quite against Excel, and says that he can only get the MARC records in Word. I don't know if this is true or not, but I'm pressuring the powers that be to see if I can at least get the records in CSV or delimited text. However, I'm working with the assumption that Word is what I've got to work with. Unfortunately, all of our MARC records are in Word, and I can't get Word to break out the columns correctly (it wants to create a lot of rows instead of columns). I did find this older program, which makes me hopeful that this process won't be as complicated as I anticipate: MARC RTP http://rossjohnson.homemail.com.au/MARCRTP/ But I'm wondering if anyone else here has had to deal with this problem and what you did to solve it. Did you have a software package that helped you? Thanks in advance everyone! Perian Sully Collection Database Records Administrator Judah L. Magnes Museum 2911 Russell St. Berkeley, CA 94705 510-549-6950 x 335 http://www.magnes.org Contributor, http://www.musematic.org
[MCN-L] MARC record conversion into Excel or CSV?
Hi all: So the pressure is on to import a bunch of MARC records (in Word) into our shiny new CMS (EMu). I need to convert the MARC Word document into some format that I can then use to recode the MARC tags into EMu-speak. I've done this with our old records using Excel, and would like to use Excel again to work with the MARC records (yes, I recognize that this may mean that I'll have potentially 1000 or so columns to deal with). And our archivist is quite against Excel, and says that he can only get the MARC records in Word. I don't know if this is true or not, but I'm pressuring the powers that be to see if I can at least get the records in CSV or delimited text. However, I'm working with the assumption that Word is what I've got to work with. Unfortunately, all of our MARC records are in Word, and I can't get Word to break out the columns correctly (it wants to create a lot of rows instead of columns). I did find this older program, which makes me hopeful that this process won't be as complicated as I anticipate: MARC RTP http://rossjohnson.homemail.com.au/MARCRTP/ But I'm wondering if anyone else here has had to deal with this problem and what you did to solve it. Did you have a software package that helped you? Thanks in advance everyone! Perian Sully Collection Database Records Administrator Judah L. Magnes Museum 2911 Russell St. Berkeley, CA 94705 510-549-6950 x 335 http://www.magnes.org Contributor, http://www.musematic.org
[MCN-L] MARC record conversion into Excel or CSV?
Have you ever worked with MarcEdit? I can't swear that it will do what you need, but we use the tool a lot to convert records back and forth between MARC and other formats. http://oregonstate.edu/~reeset/marcedit/html/index.php Terry Reese is a very responsive guy, and always seems glad to answer questions and add features. At 04:13 PM 3/21/2007, Perian Sully wrote: Hi all: So the pressure is on to import a bunch of MARC records (in Word) into our shiny new CMS (EMu). I need to convert the MARC Word document into some format that I can then use to recode the MARC tags into EMu-speak. I've done this with our old records using Excel, and would like to use Excel again to work with the MARC records (yes, I recognize that this may mean that I'll have potentially 1000 or so columns to deal with). And our archivist is quite against Excel, and says that he can only get the MARC records in Word. I don't know if this is true or not, but I'm pressuring the powers that be to see if I can at least get the records in CSV or delimited text. However, I'm working with the assumption that Word is what I've got to work with. Unfortunately, all of our MARC records are in Word, and I can't get Word to break out the columns correctly (it wants to create a lot of rows instead of columns). I did find this older program, which makes me hopeful that this process won't be as complicated as I anticipate: MARC RTP http://rossjohnson.homemail.com.au/MARCRTP/ But I'm wondering if anyone else here has had to deal with this problem and what you did to solve it. Did you have a software package that helped you? Thanks in advance everyone! Perian Sully Collection Database Records Administrator Judah L. Magnes Museum 2911 Russell St. Berkeley, CA 94705 510-549-6950 x 335 http://www.magnes.org Contributor, http://www.musematic.org ___ You are currently subscribed to mcn-l, the listserv of the Museum Computer Network (http://www.mcn.edu) To post to this list, send messages to: mcn-l at mcn.edu To unsubscribe or change mcn-l delivery options visit: http://toronto.mediatrope.com/mailman/listinfo/mcn-l Leslie Johnston Head, Digital Access Services University of Virginia Library http://lib.virginia.edu/digital/ http://lib.virginia.edu/digital/das/ johnston at virginia.edu
[MCN-L] MARC record conversion into Excel or CSV?
We have done this using MARConvert when we needed to import records for our archival and special collections into TMS. The application is configurable to allow you to parse or suppress subfields in different ways so that the resulting data is much easier to work with. If your source format is Word, I'm not quite sure how/if the records could be ingested without first transforming them somehow, but Stephen Toney at Systems Planning might have some ideas for you. http://www.systemsplanning.com/marconvert/ Good luck, Deb Deborah Lenert Digital Projects Specialist Getty Research Institute Standards Digital Resource Mgt. Dept. phone: (310) 440-7351/ fax: (310) 440-7780 dlenert at getty.edu Perian Sully psully at magnes.org 3/21/2007 1:13 PM Hi all: So the pressure is on to import a bunch of MARC records (in Word) into our shiny new CMS (EMu). I need to convert the MARC Word document into some format that I can then use to recode the MARC tags into EMu-speak. I've done this with our old records using Excel, and would like to use Excel again to work with the MARC records (yes, I recognize that this may mean that I'll have potentially 1000 or so columns to deal with). And our archivist is quite against Excel, and says that he can only get the MARC records in Word. I don't know if this is true or not, but I'm pressuring the powers that be to see if I can at least get the records in CSV or delimited text. However, I'm working with the assumption that Word is what I've got to work with. Unfortunately, all of our MARC records are in Word, and I can't get Word to break out the columns correctly (it wants to create a lot of rows instead of columns). I did find this older program, which makes me hopeful that this process won't be as complicated as I anticipate: MARC RTP http://rossjohnson.homemail.com.au/MARCRTP/ But I'm wondering if anyone else here has had to deal with this problem and what you did to solve it. Did you have a software package that helped you? Thanks in advance everyone! Perian Sully Collection Database Records Administrator Judah L. Magnes Museum 2911 Russell St. Berkeley, CA 94705 510-549-6950 x 335 http://www.magnes.org Contributor, http://www.musematic.org ___ You are currently subscribed to mcn-l, the listserv of the Museum Computer Network (http://www.mcn.edu) To post to this list, send messages to: mcn-l at mcn.edu To unsubscribe or change mcn-l delivery options visit: http://toronto.mediatrope.com/mailman/listinfo/mcn-l
[MCN-L] MARC record conversion into Excel or CSV?
P, Do you know what application these are coming from? MARC is Word? That's...that's just crazy talk. To take the best advantage of things like MARCEdit, try to get the most basic form of the records if possible - preferably plain text. Especially if they can be exported with MARC headers intact. These include byte counts for the record and some tools use them to parse out fields, etc. Certain cataloging tools like Connexion will allow you to download binary formats of records, but they are hard to use outside of library systems. If you know any PERL there is a nice MARC module at CPAN.org http://rpm2html.osmirror.nl/CPAN_MARC.html This module was the heart of the MARC - mySQL scripts we ran at CDP. They now have a XML module if EMus eat XML. It didn't require a thousand columns because it just went and selected out the appropriate MARC fields that would be translated into our 15 Dublin Core fields, leaving everything else behind. This module does require the headers to be intact however. Note that there are theoretical limits to the numbers of rows in an Excel table (which I've run up against doing the sort of thing you'll be trying). I'm tempted to ask for a sample of MARC in Word just to see it. Richard Urban rjurban at uiuc.edu On Mar 21, 2007, at 3:13 PM, Perian Sully wrote: Hi all: So the pressure is on to import a bunch of MARC records (in Word) into our shiny new CMS (EMu). I need to convert the MARC Word document into some format that I can then use to recode the MARC tags into EMu-speak. I've done this with our old records using Excel, and would like to use Excel again to work with the MARC records (yes, I recognize that this may mean that I'll have potentially 1000 or so columns to deal with). And our archivist is quite against Excel, and says that he can only get the MARC records in Word. I don't know if this is true or not, but I'm pressuring the powers that be to see if I can at least get the records in CSV or delimited text. However, I'm working with the assumption that Word is what I've got to work with. Unfortunately, all of our MARC records are in Word, and I can't get Word to break out the columns correctly (it wants to create a lot of rows instead of columns). I did find this older program, which makes me hopeful that this process won't be as complicated as I anticipate: MARC RTP http://rossjohnson.homemail.com.au/MARCRTP/ But I'm wondering if anyone else here has had to deal with this problem and what you did to solve it. Did you have a software package that helped you? Thanks in advance everyone! Perian Sully Collection Database Records Administrator Judah L. Magnes Museum 2911 Russell St. Berkeley, CA 94705 510-549-6950 x 335 http://www.magnes.org Contributor, http://www.musematic.org ___ You are currently subscribed to mcn-l, the listserv of the Museum Computer Network (http://www.mcn.edu) To post to this list, send messages to: mcn-l at mcn.edu To unsubscribe or change mcn-l delivery options visit: http://toronto.mediatrope.com/mailman/listinfo/mcn-l
[MCN-L] MARC record conversion into Excel or CSV?
Whoops. To quick on the google finger there... MARC Perl Module http://search.cpan.org/~bbirth/MARC-1.07/MARC.pm P.S. this was also a handy tool from time to time. MarcMaker/MarcBreaker http://www.loc.gov/marc/makrbrkr.html Richard rjurabn at uiuc.edu On Mar 21, 2007, at 4:21 PM, Richard Urban wrote: P, Do you know what application these are coming from? MARC is Word? That's...that's just crazy talk. To take the best advantage of things like MARCEdit, try to get the most basic form of the records if possible - preferably plain text. Especially if they can be exported with MARC headers intact. These include byte counts for the record and some tools use them to parse out fields, etc. Certain cataloging tools like Connexion will allow you to download binary formats of records, but they are hard to use outside of library systems. If you know any PERL there is a nice MARC module at CPAN.org http://rpm2html.osmirror.nl/CPAN_MARC.html This module was the heart of the MARC - mySQL scripts we ran at CDP. They now have a XML module if EMus eat XML. It didn't require a thousand columns because it just went and selected out the appropriate MARC fields that would be translated into our 15 Dublin Core fields, leaving everything else behind. This module does require the headers to be intact however. Note that there are theoretical limits to the numbers of rows in an Excel table (which I've run up against doing the sort of thing you'll be trying). I'm tempted to ask for a sample of MARC in Word just to see it. Richard Urban rjurban at uiuc.edu On Mar 21, 2007, at 3:13 PM, Perian Sully wrote: Hi all: So the pressure is on to import a bunch of MARC records (in Word) into our shiny new CMS (EMu). I need to convert the MARC Word document into some format that I can then use to recode the MARC tags into EMu-speak. I've done this with our old records using Excel, and would like to use Excel again to work with the MARC records (yes, I recognize that this may mean that I'll have potentially 1000 or so columns to deal with). And our archivist is quite against Excel, and says that he can only get the MARC records in Word. I don't know if this is true or not, but I'm pressuring the powers that be to see if I can at least get the records in CSV or delimited text. However, I'm working with the assumption that Word is what I've got to work with. Unfortunately, all of our MARC records are in Word, and I can't get Word to break out the columns correctly (it wants to create a lot of rows instead of columns). I did find this older program, which makes me hopeful that this process won't be as complicated as I anticipate: MARC RTP http://rossjohnson.homemail.com.au/MARCRTP/ But I'm wondering if anyone else here has had to deal with this problem and what you did to solve it. Did you have a software package that helped you? Thanks in advance everyone! Perian Sully Collection Database Records Administrator Judah L. Magnes Museum 2911 Russell St. Berkeley, CA 94705 510-549-6950 x 335 http://www.magnes.org Contributor, http://www.musematic.org ___ You are currently subscribed to mcn-l, the listserv of the Museum Computer Network (http://www.mcn.edu) To post to this list, send messages to: mcn-l at mcn.edu To unsubscribe or change mcn-l delivery options visit: http://toronto.mediatrope.com/mailman/listinfo/mcn-l ___ You are currently subscribed to mcn-l, the listserv of the Museum Computer Network (http://www.mcn.edu) To post to this list, send messages to: mcn-l at mcn.edu To unsubscribe or change mcn-l delivery options visit: http://toronto.mediatrope.com/mailman/listinfo/mcn-l