 |
 |
Hi Edward, Like Mike, I have some existing tools that do this in perl - though very hack-ish. Basically, I set the Windows default field separator to pipe (because I hate comma separated data) and save the spreadsheet as .csv, though a pipe delimited one. My perl then reads that in, and maps columns to DC elements and OAI-header elements and spits out an XML file per row of the spreadsheet. I'd be happy to pop a version of one of these into git-hub if you're interested. -corey On 3/1/2011 3:59 PM, Edward M. Corrado wrote: > Hi Mike, > > Yes, by Dublin Core, I mean OAI Dublin Core XML. > > Edward > > On Tue, Mar 1, 2011 at 3:34 PM, Michael J. Giarlo > <[log in to unmask]> wrote: >> Edward, >> >> Because I already have some code lying around that does more or less >> the same thing, I'd probably sling some Python using the xlrd library >> (N.B. works on xls files but not xlsx files). �It'd look similar to >> this method, perhaps a little simpler, though this method doesn't >> write out a DC file: >> >> � � https://github.com/MaxFisher/caps/blob/master/pilot/views.py#L87 >> >> By "Dublin Core," I assume you mean OAI Dublin Core XML? >> >> -Mike >> >> >> On Tue, Mar 1, 2011 at 14:53, Edward M. Corrado<[log in to unmask]> wrote: >>> Hello all, >>> >>> I have an excel file that I need to map to Dublin Core. I can think of >>> a number of ways to do this, but was wondering if anyone else who has >>> done it has a suggestion before I dust off my old sed/awk skills or >>> otherwise reinvent the wheel. I looked at Terry Reese's MarcEdit and I >>> probably can use that, but it looks like I'd have to intermediately >>> convert it to MARC. Either a windows-based program or *nix tool is >>> fine. >>> >>> Edward >>> >> -- Corey A Harper Metadata Services Librarian New York University Libraries 20 Cooper Square, 3rd Floor New York, NY 10003-7112 212.998.2479 [log in to unmask]