 |
 |
You might take a look at GoogleRefine (FreeBase GridWorks). It has a Templating Export feature that's pretty slick. It outputs JSON by default, but it's flexible and could do XML-ish stuff pretty easily. Here's Google's docs for outputting YAML instead that you adapt: https://code.google.com/p/google-refine/wiki/ExportAsYAML -- Scott On 3/1/11 2:59 PM, "Edward M. Corrado" <[log in to unmask]> 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 >>> >>