XML import suggestions

Hello,

I know somewhat this isn't doable but just want to do it somehow if there is some other way round.

Lets say I want to import multiple feeds into a table

My table is just simply Name, Email and Photo.

Now my first feed is in this format:

<item>
<name>John</name>
<email>john@example.com</email>
<photo>http://www.example.com/photo.jpg</photo>
</item>


My second feed is in this format:

<item>
<Fullname>John</Fullname>
<Email>john@example.com</Email>
<Pic>http://www.example.com/photo.jpg</Pic>
</item>

My third feed is in this format:

<item>
<ID>1</ID>
<Name>John</Name>
<Email>john@example.com</Email>
<Photo>http://www.example.com/photo.jpg</Photo>
</item>

So is there anyway that I can import this into my table. What steps should be done so that proper data is only fetched and inserted into the tables. If something else is there then it can be skipped. But how to fetch the nodes if there is no proper format known in advance.

Moreover the above examples are simple the Item Nodes can be an array of RSS or Channel etc.

Thanks.

 

its a basic example of xml and good thanks for sharing this example..