Re: XML to Postgres conversion - Mailing list pgsql-general

Did you think about perl ?

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>
>     <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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>