How to format this xml output?

sen has asked for the wisdom of the Perl Monks concerning the following question:

Hi,

I am new to perl. I tried lot. I have some xml file. I have to parse the xml file and insert the fields into database. I use XML::Simple to parse the data. It's working fine. I am getting output like this

one => 1,
two => [
         { x => 1,
           y => [ { a => 1,
                    b => 2
                  },
                  { a => 2,
                    b => 3}
                ]
          }
       ]
[download]

But, I need to insert into my database like this below. Please give me some ideas.

one => 1,
two => [ { x => 1,
           y_a => 1,
           y_b => 2,
         },
         { x => 1,
           y_a => 2,
           y_b => 3
         }
        ]
[download]

Comment on How to format this xml output? Select or Download Code

Replies are listed 'Best First'.
Re: How to format this xml output? by glasswalk3r (Friar) on Jan 23, 2006 at 12:20 UTC
It would be better if you provide a sample of your XML and the database table that you want to insert data. In both cases, this has nothing to do with format XML output (I thought it was something related to XSL). Once you have the data in array ref, you just need to extract the data that you want dereferencing it. Looks like the XML file that you have doesn't have the same structure of the database table, so you will need to do some data transformation. Take a good look at the `perldoc perlref` document to see how to do that. Alceu Rodrigues de Freitas Junior --------------------------------- "You have enemies? Good. That means you've stood up for something, sometime in your life." - Sir Winston Churchill	[reply] [d/l]
Re: How to format this xml output? by planetscape (Chancellor) on Jan 24, 2006 at 06:58 UTC
Ideally, as glasswalk3r said, you'd provide us more information about the XML with which you want to work and the database you are using. You may also wish to consider, however, whether XML::Simple is adequate for your needs. I, and others here, really like XML::Twig; a great deal of information is available on The XML::Twig Homepage. Stepping up from XML::Simple to XML::LibXML, appropriately enough, discusses migrating from XML::Simple to XML::LibXML. The point is, make sure the module is a good fit for your requirements before becoming locked in. HTH, planetscape	[reply]