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
>>>
>>
|