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 mjor...@sfu.ca ----- "Jane W Jacobs" <jane.w.jac...@queenslibrary.org> 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: jane.w.jac...@queenslibrary.org > 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.