Re: Exporting to XML

On Tue, 22 Mar 2005 11:44:00 +0000, Charlotte Pollock
<c(dot)pollock(at)bangor(dot)ac(dot)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(at)gmail(dot)com
GPLS -- PINES Development
Database Developer
http://open-ils.org