Re: XML to Postgres conversion

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

Here is a snippit from the database setup script:

create table computers
(
    computer_name varchar(50) primary key,
    operating_system_name varchar(50),
    operating_system_version varchar(50),
    operating_system_additional_info varchar(50),

    processor_name varchar(50),
    processor_manufacturer varchar(50),
    processor_count numeric,
    processor_speed numeric,
    processor_family varchar(50),
    processor_model varchar(50),
    processor_stepping varchar(50),

    memory_physical numeric,
    memory_virtual numeric,
    memory_page_file_size numeric,

    video_bios_date varchar(50),
    video_bios_version varchar(50),
    display_name varchar(50),
    display_manufacturer varchar(50),
    display_hor_res numeric,
    display_ver_res numeric,
    display_color_depth numeric,
    display_refresh_rate numeric,

    winsock_domain_name varchar(50),
    winsock_description varchar(50),
    winsock_status varchar(50),
    winsock_version varchar(50),
    winsock_name varchar(50)
);

All the xml files will have the same format.  A
Windows program called Alchemy Network Inventory is
used to generate the xml files.  I want to populate
the tables in Postgres with the data in the XML files.
 The software that generates the xml files was
actually designed for use with MS Access and has built
in ODBC capabilities.  I actually designed the
Postgres database off a template for Access.  Where
I'm running into issues is I'm using Postgre on Linux
instead of Access on Windows.  Yes, I can use the ODBC
connection with the Postgres odbc drivers and export
the files from a Windows machine to the database
manually.  There lies the other issue: I would like to
automate the process.  I want to try to keep as much
as I possibly can on the linux box because it is much
easier to script and automate than if I were try it
from a Windows machine.  If you (or anyone) would like
to look at an entire xml or .sql file, I would be more
than happy to forward them or if I'm still lacking
information, please let me know.

Thanks.


__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com