This might help get you going. I took out the file stuff, you'll have to adjust. If this is something you actually need for work, you might consider posting it as a one-off job to jobs.perl.org or something.

use strict; # Don't leave out!
use warnings; # Don't leave out!
use XML::LibXML;

my $parser = XML::LibXML->new();
my $doc = $parser->parse_fh(\*DATA);
my @product = $doc->getElementsByTagName('product');

for my $kid ( @product ){
    print
        join("\t",
             $kid->getElementsByTagName('name')->[0]->textContent,
             $kid->getElementsByTagName('imageURL_med')->[0]->textCont
+ent,
             $kid->getAttribute('category_id'),
             $kid->getAttribute('id'),
             $kid->getElementsByTagName('desc_short')->[0]->textConten
+t,
             ),
        "\n";
}

# print $doc->serialize();

__END__
<root>
  <product category_id="13296" id="675936193" catalog="false" row="1">
    <name>Children's Hand Rake</name>
    <imageURL_med></imageURL_med>
    <desc_short>Mini gardeners can dig, rake and scoop out their own p
+lot with this children's hand rake, complete with contoured handles a
+nd durable metal heads.</desc_short>
  </product>
  <product category_id="13296" id="675936193" catalog="false" row="1">
    <name>Bag of Broken Glass</name>
    <imageURL_med>http://moocow.co.uk.jp/something/something/bg.jpg</i
+mageURL_med>
    <desc_short>Fun for all ages!</desc_short>
  </product>
</root>

[download]

In reply to Re: XML::LibXML- Escape Empty Tags by Your Mother
in thread XML::LibXML- Escape Empty Tags by khalistoo

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.