Sorry, still not enough details. Why do you only include 1 record in the output, when there are 2 properties "TABLE" in the input? Also the code you wrote does not output XML, but a list of property name/values, so your expected result should be at least consistent with that.

Plus (going back to rant mode) why did you truncate the usersql content? I would appreciate not having to track it down in the input to cut and paste it.

That said, the input XML seems incredibly clumsy. Faced with something like this, my first instinct would be to turn all those Subrecords that include a single property defined by 2 Property elements into a single element, named after the property name, with the value of the property as content. Once that's done it should be much easier to work with the data.

The code below does just that.

#!/usr/bin/perl

use strict;
use warnings;

use XML::Twig;

my $t= XML::Twig->new( twig_roots => { 'Collection[@Type="CustomProper
+ty"]' => \&collection},
                       twig_print_outside_roots => 1,   
                     );
$t->parsefile( $ARG[0]);

exit;

sub collection
  { my ($t, $collection)= @_;
    foreach my $sub_record ($collection->children( 'SubRecord'))
      { my $name  = $sub_record->field( 'Property[@Name="Name"]');
        my $value = $sub_record->field( 'Property[@Name="Value"]');
        # we want to keep thæ attributes (except Name of course)
        my $atts  = $sub_record->first_child( 'Property[@Name="Value"]
+')->atts;
        delete $atts->{Name};
        my $property= XML::Twig::Elt->new( $name, $atts, $value);
        $property->replace( $sub_record);
      }
     $collection->print;
  }

[download]

In reply to Re^3: XML::Twig usage incomprehension by mirod
in thread XML::Twig usage incomprehension by Jerome

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.