Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

Re: parsing XML structure

by temporal (Pilgrim)
on Mar 30, 2012 at 15:25 UTC ( #962635=note: print w/replies, xml ) Need Help??

in reply to parsing XML structure

It looks like you've already parsed the XML file using XML::Simple, which returns a hash.

However, it has been saved using Excel (or something), which probably adds a bunch of metadata to the file. That's all the crap you're seeing there.

You'll want to open the actual XML data of the file which is hidden away in the 'propertyData' field. Split between 2 of them for some reason. Odd.

From your debug - a hash, containing an array, containing another hash. lol.

$actualXML0 = $data->{ecfc_ECFC_ModuleUserSetting}->[0]->{propertyData +}; $actualXML1 = $data->{ecfc_ECFC_ModuleUserSetting}->[1]->{propertyData +}; $actualData0 = XMLin($actualXML0); $actualData1 = XMLin($actualXML1);

As for accessing the data from there... XML::Simple

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://962635]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (5)
As of 2020-01-29 11:48 GMT
Find Nodes?
    Voting Booth?