Re: XML to Postgres conversion

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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>