Re: XML to Postgres conversion

This is just to demonstrate how XSLT can come to your rescue (You will
obviously have to adapt the approach).
The following stylesheet will generate a series of SQL inserts.

I use the sablotron XSLT transformer but really any suitable program
should work.

Regards,

MArk

<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="text"/>

<!--
Assumes the XML file has a series of Operating_system tags
-->
<xsl:template match="/">
   <xsl:apply-templates select="//Operating_system"/>
</xsl:template>

<!--
Generate a SQL INSERT for each "Operating_system" tag
-->
<xsl:template match="Operating_system">
   INSERT INTO computers (
     Name,
     Major_version,
     Minor_version,
     Build_number,
     Platform_ID,
     Additional_information,
     User_name,
     Boot_time,
     Registered_to,
     Registration_code
   VALUES (
     '<xsl:value-of select="Name"/>',
     '<xsl:value-of select="Major_version"/>',
     '<xsl:value-of select="Minor_version"/>',
     '<xsl:value-of select="Build_number"/>',
     '<xsl:value-of select="Platform_ID"/>',
     '<xsl:value-of select="Additional_information"/>',
     '<xsl:value-of select="User_name"/>',
     '<xsl:value-of select="Boot_time"/>',
     '<xsl:value-of select="Registered_to"/>',
     '<xsl:value-of select="Registration_code"/>');
</xsl:template>

</xsl:stylesheet>


Nathan Hill wrote:

> Here is a snippit of code from one of the xml files:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <Computer>
>   <Created_on>2002/07/09 11:09:41</Created_on>
>   <Client_version>1.8.9</Client_version>


>   <General_info>


Please note that this tag is not closed!!!!


>     <Operating_system>
>       <Name>Microsoft Windows XP</Name>
>       <Major_version>5</Major_version>
>       <Minor_version>1</Minor_version>
>       <Build_number>2600</Build_number>
>       <Platform_ID>2</Platform_ID>
>
> <Additional_information></Additional_information>
>       <User_name>someone</User_name>
>       <Boot_time>07/09/2002 09:04:21</Boot_time>
>       <Registered_to>registered</Registered_to>
>
> <Registration_code>534574-345-7467453-74538</Registration_code>
>     </Operating_system>
> </Computer>
>