Re: Excel or CSV to METS or MODS

Jane,

I have a PHP command-line script that does Excel to MODS in an OAI wrapper, but it's hard coded to the MODS elements we are using (i.e., I did it up for a specific, never-ever-ever-to-change Excel template). I don't mind sharing it if you think it would be useful.

Mark

Mark Jordan
Head of Library Systems
W.A.C. Bennett Library, Simon Fraser University
Burnaby, British Columbia, V5A 1S6, Canada
Voice: 778.782.5753 / Fax: 778.782.3023
[email protected]

----- "Jane W Jacobs" <[email protected]> wrote:

> Hi Folks,
> 
>  
> 
> My New Year's resolution includes trying to wrap my mind around METS
> and/or MODS.  We recently discussed converting Excel/CSV to MARC,
> which
> I've done.  I know there's a schema that will take you from MARC to
> MODS
> and/or MADS (http://www.loc.gov/standards/mods/v3/mods-3-3.xsd)
> although
> I'm fuzzy as to the specifics of implementation.  However, that would
> mean Excel -> CSV -> MARC -> MODS, YUCK!  
> 
>  
> 
> Has anyone done any Excel to METS or MODS?  If yes, would you be
> willing
> to share some code?  
> 
>  
> 
> Thanks.
> 
> JJ
> 
>  
> 
>  
> 
> **Views expressed by the author do not necessarily represent those of
> the Queens Library.**
> 
> Jane Jacobs
> Asst. Coord., Catalog Division
> Queens Borough Public Library
> 89-11 Merrick Blvd.
> Jamaica, NY 11432
> tel.: (718) 990-0804
> e-mail: [email protected]
> FAX. (718) 990-8566
> 
>  
> 
> 
> 
> The information contained in this message may be privileged and
> confidential and protected from disclosure. If the reader of this
> message is not the intended recipient, or an employee or agent
> responsible for delivering this message to the intended recipient, you
> are hereby notified that any dissemination, distribution or copying of
> this communication is strictly prohibited. If you have received this
> communication in error, please notify us immediately by replying to
> the message and deleting it from your computer.