Re: Exporting to XML

On Tue, 22 Mar 2005 11:44:00 +0000, Charlotte Pollock
<c.pollock@bangor.ac.uk> wrote:
> Hi all
>
> I want to export data from my postgres database.
>
> I want to output, for each record, a folder containing an XML file eg
>         <dublin_core>
>                 <dcvalue element="contributor"
> qualifier="author">Pollock, Charlotte</dcvalue>
>                 <dcvalue element="identifier"
> qualifier="isbn">asdasdasdasd</dcvalue>
>                 <dcvalue element="title" qualifier="none">Our
> Publication</dcvalue>
>                <dcvalue element="type" qualifier="none">Book</dcvalue>
>           </dublin_core>
>
> each folder (and the xml file contained within it) will contain data
> for only one record from the database.

Bibliographic(esqe) data, eh?  See my sig. :)

>
> Any suggestions on what might be a good way to tackle this problem,
> gratefully recieved
>

It depends on how the data is structured in the DB (I'm storing
MARCXML, myself) but I would suggest using a perl script with a
Template Toolkit template if you are normalizing the DC-type data on
input.

--
Mike Rylander
mrylander@gmail.com
GPLS -- PINES Development
Database Developer
http://open-ils.org